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 108 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


duy1981999

  • Member
  • Posts: 341
Reply 3 on: Yesterday
YES! Correct, THANKS for helping me on my review

 

Did you know?

The Babylonians wrote numbers in a system that used 60 as the base value rather than the number 10. They did not have a symbol for "zero."

Did you know?

More than nineteen million Americans carry the factor V gene that causes blood clots, pulmonary embolism, and heart disease.

Did you know?

Approximately 70% of expectant mothers report experiencing some symptoms of morning sickness during the first trimester of pregnancy.

Did you know?

Approximately one in four people diagnosed with diabetes will develop foot problems. Of these, about one-third will require lower extremity amputation.

Did you know?

When blood is deoxygenated and flowing back to the heart through the veins, it is dark reddish-blue in color. Blood in the arteries that is oxygenated and flowing out to the body is bright red. Whereas arterial blood comes out in spurts, venous blood flows.

For a complete list of videos, visit our video library