Author Question: __________ operation retrieves a subset of rows. Fill in the blanks with correct ... (Read 56 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?

Adults are resistant to the bacterium that causes Botulism. These bacteria thrive in honey – therefore, honey should never be given to infants since their immune systems are not yet resistant.

Did you know?

The term pharmacology is derived from the Greek words pharmakon("claim, medicine, poison, or remedy") and logos ("study").

Did you know?

Though the United States has largely rejected the metric system, it is used for currency, as in 100 pennies = 1 dollar. Previously, the British currency system was used, with measurements such as 12 pence to the shilling, and 20 shillings to the pound.

Did you know?

There are approximately 3 million unintended pregnancies in the United States each year.

Did you know?

Alzheimer's disease affects only about 10% of people older than 65 years of age. Most forms of decreased mental function and dementia are caused by disuse (letting the mind get lazy).

For a complete list of videos, visit our video library