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 106 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
Thanks for the timely response, appreciate it


recede

  • Member
  • Posts: 315
Reply 3 on: Yesterday
Gracias!

 

Did you know?

Methicillin-resistant Staphylococcus aureus or MRSA was discovered in 1961 in the United Kingdom. It if often referred to as a superbug. MRSA infections cause more deaths in the United States every year than AIDS.

Methicilli ...
Did you know?

Your chance of developing a kidney stone is 1 in 10. In recent years, approximately 3.7 million people in the United States were diagnosed with a kidney disease.

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?

Symptoms of kidney problems include a loss of appetite, back pain (which may be sudden and intense), chills, abdominal pain, fluid retention, nausea, the urge to urinate, vomiting, and fever.

Did you know?

Glaucoma is a leading cause of blindness. As of yet, there is no cure. Everyone is at risk, and there may be no warning signs. It is six to eight times more common in African Americans than in whites. The best and most effective way to detect glaucoma is to receive a dilated eye examination.

For a complete list of videos, visit our video library