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

Author Question: A surrogate key may be appropriate under which of the following circumstances? A) The available ... (Read 54 times)

naturalchemist

  • Hero Member
  • *****
  • Posts: 542
A surrogate key may be appropriate under which of the following circumstances?
 
  A) The available candidate keys would produce a lot of data duplication when representing relationships.
  B) The primary key is numeric.
  C) The available candidate keys would be prone to typographical errors.
  D) The available candidate keys have little meaning to the users.
  E) Both A and C

Question 2

Which of the following is not an SQL trigger?
 
  A) BEFORE UPDATE
  B) INSTEAD OF UPDATE
  C) BEFORE INSERT
  D) INSTEAD OF CONSTRAINT
  E) AFTER DELETE



Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
Marked as best answer by a Subject Expert

amy.lauersdorf90

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

E

Answer to Question 2

D




naturalchemist

  • Member
  • Posts: 542
Reply 2 on: Jul 7, 2018
Gracias!


kilada

  • Member
  • Posts: 311
Reply 3 on: Yesterday
Wow, this really help

 

Did you know?

Blastomycosis is often misdiagnosed, resulting in tragic outcomes. It is caused by a fungus living in moist soil, in wooded areas of the United States and Canada. If inhaled, the fungus can cause mild breathing problems that may worsen and cause serious illness and even death.

Did you know?

GI conditions that will keep you out of the U.S. armed services include ulcers, varices, fistulas, esophagitis, gastritis, congenital abnormalities, inflammatory bowel disease, enteritis, colitis, proctitis, duodenal diverticula, malabsorption syndromes, hepatitis, cirrhosis, cysts, abscesses, pancreatitis, polyps, certain hemorrhoids, splenomegaly, hernias, recent abdominal surgery, GI bypass or stomach stapling, and artificial GI openings.

Did you know?

Patients who cannot swallow may receive nutrition via a parenteral route—usually, a catheter is inserted through the chest into a large vein going into the heart.

Did you know?

About 80% of major fungal systemic infections are due to Candida albicans. Another form, Candida peritonitis, occurs most often in postoperative patients. A rare disease, Candida meningitis, may follow leukemia, kidney transplant, other immunosuppressed factors, or when suffering from Candida septicemia.

Did you know?

Opium has influenced much of the world's most popular literature. The following authors were all opium users, of varying degrees: Lewis Carroll, Charles, Dickens, Arthur Conan Doyle, and Oscar Wilde.

For a complete list of videos, visit our video library