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 110 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
Excellent


helenmarkerine

  • Member
  • Posts: 324
Reply 3 on: Yesterday
Thanks for the timely response, appreciate it

 

Did you know?

The toxic levels for lithium carbonate are close to the therapeutic levels. Signs of toxicity include fine hand tremor, polyuria, mild thirst, nausea, general discomfort, diarrhea, vomiting, drowsiness, muscular weakness, lack of coordination, ataxia, giddiness, tinnitus, and blurred vision.

Did you know?

According to the FDA, adverse drug events harmed or killed approximately 1,200,000 people in the United States in the year 2015.

Did you know?

One way to reduce acid reflux is to lose two or three pounds. Most people lose weight in the belly area first when they increase exercise, meaning that heartburn can be reduced quickly by this method.

Did you know?

If all the neurons in the human body were lined up, they would stretch more than 600 miles.

Did you know?

In the United States, there is a birth every 8 seconds, according to the U.S. Census Bureau's Population Clock.

For a complete list of videos, visit our video library