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

Author Question: SQL views are always updatable when ________. A) the view is based on a single table with no ... (Read 38 times)

FButt

  • Hero Member
  • *****
  • Posts: 519
SQL views are always updatable when ________.
 
  A) the view is based on a single table with no computed columns, and all non-null columns are present in the view
  B) the view is based on any number of tables, with or without computed columns, and the INSTEAD OF trigger is defined for the view
  C) the view is based on multiple tables, the update is being done on the most subordinate table, and the rows of that table can be uniquely identified
  D) Both A and B are correct

Question 2

Rollforward and reprocessing are two different names for the same technique.
 
  Indicate whether the statement is true or false



Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
Marked as best answer by a Subject Expert

mathjasmine

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

D

Answer to Question 2

FALSE




FButt

  • Member
  • Posts: 519
Reply 2 on: Jul 7, 2018
:D TYSM


adf223

  • Member
  • Posts: 304
Reply 3 on: Yesterday
Excellent

 

Did you know?

The types of cancer that alpha interferons are used to treat include hairy cell leukemia, melanoma, follicular non-Hodgkin's lymphoma, and AIDS-related Kaposi's sarcoma.

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.

Did you know?

The horizontal fraction bar was introduced by the Arabs.

Did you know?

People often find it difficult to accept the idea that bacteria can be beneficial and improve health. Lactic acid bacteria are good, and when eaten, these bacteria improve health and increase longevity. These bacteria included in foods such as yogurt.

Did you know?

Atropine was named after the Greek goddess Atropos, the oldest and ugliest of the three sisters known as the Fates, who controlled the destiny of men.

For a complete list of videos, visit our video library