Author Question: The SQL INSERT statement can be used to populate normalized tables. Indicate whether the ... (Read 99 times)

Davideckstein7

  • Hero Member
  • *****
  • Posts: 555
The SQL INSERT statement can be used to populate normalized tables.
 
  Indicate whether the statement is true or false

Question 2

When dropping a primary key column from a table, which of the following steps is included in the process? (The order of the steps listed below is not relevant, only the steps themselves.)
 
  A) Drop all constraints from the table
  B) Drop the foreign keys from the table
  C) Drop the foreign keys in other tables based on the primary key column
  D) Drop the primary key(s) of any table(s) to which this one is related



alvinum

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

TRUE

Answer to Question 2

C



Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
 

Did you know?

There can actually be a 25-hour time difference between certain locations in the world. The International Date Line passes between the islands of Samoa and American Samoa. It is not a straight line, but "zig-zags" around various island chains. Therefore, Samoa and nearby islands have one date, while American Samoa and nearby islands are one day behind. Daylight saving time is used in some islands, but not in others—further shifting the hours out of sync with natural time.

Did you know?

Though the United States has largely rejected the metric system, it is used for currency, as in 100 pennies = 1 dollar. Previously, the British currency system was used, with measurements such as 12 pence to the shilling, and 20 shillings to the pound.

Did you know?

For pediatric patients, intravenous fluids are the most commonly cited products involved in medication errors that are reported to the USP.

Did you know?

The tallest man ever known was Robert Wadlow, an American, who reached the height of 8 feet 11 inches. He died at age 26 years from an infection caused by the immense weight of his body (491 pounds) and the stress on his leg bones and muscles.

Did you know?

The oldest recorded age was 122. Madame Jeanne Calment was born in France in 1875 and died in 1997. She was a vegetarian and loved olive oil, port wine, and chocolate.

For a complete list of videos, visit our video library