This topic contains a solution. Click here to go to the answer

Author Question: In Microsoft Access, the statement used to display employees' social security numbers and names ... (Read 104 times)

fahad

  • Hero Member
  • *****
  • Posts: 570
In Microsoft Access, 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 Employee Where Employee.SSN Not In
  (Select Distinct Job.SSN From Job)
  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 Job Where Employee.SSN Not In (Select
  Distinct Employee.SSN From Employee)

Question 2

Data dictionaries restrict business rules.
 
  Indicate whether the statement is true or false



Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
Marked as best answer by a Subject Expert

vseab

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

D

Answer to Question 2

FALSE





 

Did you know?

Many people have small pouches in their colons that bulge outward through weak spots. Each pouch is called a diverticulum. About 10% of Americans older than age 40 years have diverticulosis, which, when the pouches become infected or inflamed, is called diverticulitis. The main cause of diverticular disease is a low-fiber diet.

Did you know?

Though Candida and Aspergillus species are the most common fungal pathogens causing invasive fungal disease in the immunocompromised, infections due to previously uncommon hyaline and dematiaceous filamentous fungi are occurring more often today. Rare fungal infections, once accurately diagnosed, may require surgical debridement, immunotherapy, and newer antifungals used singly or in combination with older antifungals, on a case-by-case basis.

Did you know?

Though newer “smart” infusion pumps are increasingly becoming more sophisticated, they cannot prevent all programming and administration errors. Health care professionals that use smart infusion pumps must still practice the rights of medication administration and have other professionals double-check all high-risk infusions.

Did you know?

Blood is approximately twice as thick as water because of the cells and other components found in it.

Did you know?

Approximately one in three babies in the United States is now delivered by cesarean section. The number of cesarean sections in the United States has risen 46% since 1996.

For a complete list of videos, visit our video library