1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
Trava [24]
4 years ago
12

Given table R(A,B,C) and S(C,D,E), which of the following SQL statements would find the record(s) with null values on the column

C in table R?
a. select * from R, S where R.C = S.C (+); (R left outer join S)

b. select * from R, S where S.C = R.C (+); (R right outer join S)

c. either a. or b.

d. neither a. nor b.
Computers and Technology
1 answer:
sashaice [31]4 years ago
4 0

Answer:

a. select * from R, S where R.C = S.C (+); (R left outer join S)

Explanation:

In SQL, left outer join of two tables R and S joined on a common column C means that all rows of R are included in the result including those rows for which value of R.C is null. On the contrary, right outer join of two tables R and S joined on a common column C means that all rows of S are included in the result including those rows for which value of S.C is null. As per the question our requirement is the former. So option a is correct.

You might be interested in
The ____ area on the status bar includes six commands as well as the result of the associated calculation on the right side of t
Natali [406]
The answer is "Autocalculate Area"

In Microsoft Office, especially in Excel, the autocalculate area can be found on the status bar. It has six commands namely: average, count, numerical count, minimum, maximum, and sum. The six commands are the result of the associated calculation.
8 0
3 years ago
Write a for loop that displays your name and student number 12 times.
d1i1m1o1n [39]

Answer:

// here is code in java.

import java.util.*;

// class definition

class Solution

{

// main method of the class

public static void main (String[] args) throws java.lang.Exception

{

   try{

    // scanner object

       Scanner s=new Scanner(System.in);

        // variables

      String s_name;

      int s_num;

      System.out.print("Please enter the name:");

       // read the student name

      s_name=s.nextLine();

      System.out.print("Please enter the number:");

       // read the student number

      s_num=s.nextInt();

       // print name and number 12 times

      for(int i=0;i<12;i++)

      {

          System.out.println(s_name+"----"+s_num);

      }

   }catch(Exception ex){

       return;}

}

}

Explanation:

Create a scanner class object to read input from user.Read the student name and the number from user and assign them to variable "s_name" and "s_num".Print the student name and number 12 times with the help of for loop.

Output:

Please enter the name:Mary Kaur

Please enter the number:123456

Mary Kaur----123456

Mary Kaur----123456

Mary Kaur----123456

Mary Kaur----123456

Mary Kaur----123456

Mary Kaur----123456

Mary Kaur----123456

Mary Kaur----123456

Mary Kaur----123456

Mary Kaur----123456

Mary Kaur----123456

Mary Kaur----123456

5 0
4 years ago
Which of the following is a good question to ask during an informational interview
Dmitrij [34]
The answer is:

What was your education/training path? It is related to education and information
8 0
4 years ago
Automatic weights are assigned based on which of the following?
svetlana [45]

Answer:

Im 90% sure it's D

Explanation:

3 0
4 years ago
Which of the following statements about personality are true? Check all of the boxes that apply.
kupik [55]

Answer:

- personallity is an individual's unique combination of attitudes, behaviors, and characteristics.

-(maybe)Being aware of personality characteristics helps people identify their natural abilities and determine  potential careers.

Explanation:

hope helped

7 0
4 years ago
Other questions:
  • Write a program that asks how many tickets for each class of seats were sold, then displays the amount of income generated from
    10·1 answer
  • Select the correct answer. Which sentence best describe an effective management strategy? A. Conceal game-related clippings prio
    12·2 answers
  • Tony is interviewing with the hiring manager for an IT job.
    11·1 answer
  • Hey can you help we with this thanks
    5·1 answer
  • Implement the function fileSum. fileSum is passed in a name of a file. This function should open the file, sum all of the intege
    11·1 answer
  • 2 A_______<br> uses graphics or pictures to help the user navigate and<br> access programs
    14·1 answer
  • Hiding data within pictures, audio, or video files can be difficult to detect and find. What can be done to reduce this?
    9·1 answer
  • What is different between a pc mouse and a real mouse
    12·2 answers
  • What are the 3 dimensions referenced when we say 3D?
    10·1 answer
  • When you start a new, blank document, you usually end up changing the font to arial 11. 5 point. How can you make these settings
    8·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!