Author Question: __________ operation retrieves a subset of rows. Fill in the blanks with correct ... (Read 69 times)

Jipu 123

  • Hero Member
  • *****
  • Posts: 569
__________ operation retrieves a subset of rows.
 
  Fill in the blanks with correct word

Question 2

In Oracle, the statement used to display employees' social security numbers and names that
  don't have any jobs assigned to them, would be which of the following?
 
  A) Select employee.ssn, employee.name From job Where employee.ssn Not In (Select Distinct
  job.ssn From job)
  B) Select employee.ssn, employee.name From job Where employee.ssn Not In (Select Distinct
  Employee.ssn From employee)
  C) Select employee.ssn, employee.name From employee Where employee.ssn In (Select
  Distinct job.ssn From job)
  D) Select employee.ssn, employee.name From employee Where employee.ssn Not In (Select
  Distinct job.ssn From job)



millet

  • Sr. Member
  • ****
  • Posts: 354
Answer to Question 1

Selection

Answer to Question 2

B



Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
 

Did you know?

Between 1999 and 2012, American adults with high total cholesterol decreased from 18.3% to 12.9%

Did you know?

In the United States, an estimated 50 million unnecessary antibiotics are prescribed for viral respiratory infections.

Did you know?

An identified risk factor for osteoporosis is the intake of excessive amounts of vitamin A. Dietary intake of approximately double the recommended daily amount of vitamin A, by women, has been shown to reduce bone mineral density and increase the chances for hip fractures compared with women who consumed the recommended daily amount (or less) of vitamin A.

Did you know?

Blood in the urine can be a sign of a kidney stone, glomerulonephritis, or other kidney problems.

Did you know?

Cancer has been around as long as humankind, but only in the second half of the twentieth century did the number of cancer cases explode.

For a complete list of videos, visit our video library