Author Question: __________ operation retrieves a subset of rows. Fill in the blanks with correct ... (Read 76 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 first successful kidney transplant was performed in 1954 and occurred in Boston. A kidney from an identical twin was transplanted into his dying brother's body and was not rejected because it did not appear foreign to his body.

Did you know?

Approximately 500,000 babies are born each year in the United States to teenage mothers.

Did you know?

When blood is deoxygenated and flowing back to the heart through the veins, it is dark reddish-blue in color. Blood in the arteries that is oxygenated and flowing out to the body is bright red. Whereas arterial blood comes out in spurts, venous blood flows.

Did you know?

Medications that are definitely not safe to take when breastfeeding include radioactive drugs, antimetabolites, some cancer (chemotherapy) agents, bromocriptine, ergotamine, methotrexate, and cyclosporine.

Did you know?

Patients who have undergone chemotherapy for the treatment of cancer often complain of a lack of mental focus; memory loss; and a general diminution in abilities such as multitasking, attention span, and general mental agility.

For a complete list of videos, visit our video library