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

Over time, chronic hepatitis B virus and hepatitis C virus infections can progress to advanced liver disease, liver failure, and hepatocellular carcinoma. Unlike other forms, more than 80% of hepatitis C infections become chronic and lead to liver disease. When combined with hepatitis B, hepatitis C now accounts for 75% percent of all cases of liver disease around the world. Liver failure caused by hepatitis C is now leading cause of liver transplants in the United States.

Did you know?

People who have myopia, or nearsightedness, are not able to see objects at a distance but only up close. It occurs when the cornea is either curved too steeply, the eye is too long, or both. This condition is progressive and worsens with time. More than 100 million people in the United States are nearsighted, but only 20% of those are born with the condition. Diet, eye exercise, drug therapy, and corrective lenses can all help manage nearsightedness.

Did you know?

Colchicine is a highly poisonous alkaloid originally extracted from a type of saffron plant that is used mainly to treat gout.

Did you know?

When Gabriel Fahrenheit invented the first mercury thermometer, he called "zero degrees" the lowest temperature he was able to attain with a mixture of ice and salt. For the upper point of his scale, he used 96°, which he measured as normal human body temperature (we know it to be 98.6° today because of more accurate thermometers).

Did you know?

The newest statin drug, rosuvastatin, has been called a superstatin because it appears to reduce LDL cholesterol to a greater degree than the other approved statin drugs.

For a complete list of videos, visit our video library