Author Question: SQL statements used to construct views cannot contain the WHERE clause. Indicate whether the ... (Read 17 times)

notis

  • Hero Member
  • *****
  • Posts: 596
SQL statements used to construct views cannot contain the WHERE clause.
 
  Indicate whether the statement is true or false

Question 2

To create a 1:1 relationship between two tables in Microsoft Access:
 
  A) the Indexed property of the foreign key column must be set to No.
  B) the Indexed property of the foreign key column must be set to Yes (Duplicates OK).
  C) the Indexed property of the foreign key column must be set to Yes (No Duplicates).
  D) the Data Type of the foreign key column must be set to AutoNumber.
  E) the Smart Tag property of the foreign key column must be set to Foreign Key.



makaylafy

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

FALSE

Answer to Question 2

C



Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question


 

Did you know?

Always store hazardous household chemicals in their original containers out of reach of children. These include bleach, paint, strippers and products containing turpentine, garden chemicals, oven cleaners, fondue fuels, nail polish, and nail polish remover.

Did you know?

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

Did you know?

The term bacteria was devised in the 19th century by German biologist Ferdinand Cohn. He based it on the Greek word "bakterion" meaning a small rod or staff. Cohn is considered to be the father of modern bacteriology.

Did you know?

Bisphosphonates were first developed in the nineteenth century. They were first investigated for use in disorders of bone metabolism in the 1960s. They are now used clinically for the treatment of osteoporosis, Paget's disease, bone metastasis, multiple myeloma, and other conditions that feature bone fragility.

Did you know?

The Food and Drug Administration has approved Risperdal, an adult antipsychotic drug, for the symptomatic treatment of irritability in children and adolescents with autism. The approval is the first for the use of a drug to treat behaviors associated with autism in children. These behaviors are included under the general heading of irritability and include aggression, deliberate self-injury, and temper tantrums.

For a complete list of videos, visit our video library