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

The types of cancer that alpha interferons are used to treat include hairy cell leukemia, melanoma, follicular non-Hodgkin's lymphoma, and AIDS-related Kaposi's sarcoma.

Did you know?

When intravenous medications are involved in adverse drug events, their harmful effects may occur more rapidly, and be more severe than errors with oral medications. This is due to the direct administration into the bloodstream.

Did you know?

Women are 50% to 75% more likely than men to experience an adverse drug reaction.

Did you know?

Symptoms of kidney problems include a loss of appetite, back pain (which may be sudden and intense), chills, abdominal pain, fluid retention, nausea, the urge to urinate, vomiting, and fever.

Did you know?

Malaria mortality rates are falling. Increased malaria prevention and control measures have greatly improved these rates. Since 2000, malaria mortality rates have fallen globally by 60% among all age groups, and by 65% among children under age 5.

For a complete list of videos, visit our video library