Author Question: __________ operation retrieves a subset of rows. Fill in the blanks with correct ... (Read 45 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 cure for trichomoniasis is easy as long as the patient does not drink alcoholic beverages for 24 hours. Just a single dose of medication is needed to rid the body of the disease. However, without proper precautions, an individual may contract the disease repeatedly. In fact, most people develop trichomoniasis again within three months of their last treatment.

Did you know?

Each year in the United States, there are approximately six million pregnancies. This means that at any one time, about 4% of women in the United States are pregnant.

Did you know?

Drug abusers experience the following scenario: The pleasure given by their drug (or drugs) of choice is so strong that it is difficult to eradicate even after years of staying away from the substances involved. Certain triggers may cause a drug abuser to relapse. Research shows that long-term drug abuse results in significant changes in brain function that persist long after an individual stops using drugs. It is most important to realize that the same is true of not just illegal substances but alcohol and tobacco as well.

Did you know?

It is widely believed that giving a daily oral dose of aspirin to heart attack patients improves their chances of survival because the aspirin blocks the formation of new blood clots.

For a complete list of videos, visit our video library