Author Question: SQL statements used to construct views cannot contain the WHERE clause. Indicate whether the ... (Read 74 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?

Bacteria have been found alive in a lake buried one half mile under ice in Antarctica.

Did you know?

Dogs have been used in studies to detect various cancers in human subjects. They have been trained to sniff breath samples from humans that were collected by having them breathe into special tubes. These people included 55 lung cancer patients, 31 breast cancer patients, and 83 cancer-free patients. The dogs detected 54 of the 55 lung cancer patients as having cancer, detected 28 of the 31 breast cancer patients, and gave only three false-positive results (detecting cancer in people who didn't have it).

Did you know?

ACTH levels are normally highest in the early morning (between 6 and 8 A.M.) and lowest in the evening (between 6 and 11 P.M.). Therefore, a doctor who suspects abnormal levels looks for low ACTH in the morning and high ACTH in the evening.

Did you know?

Your heart beats over 36 million times a year.

Did you know?

The first oncogene was discovered in 1970 and was termed SRC (pronounced "SARK").

For a complete list of videos, visit our video library