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 122 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
Gracias!


elyse44

  • Member
  • Posts: 319
Reply 3 on: Yesterday
:D TYSM

 

Did you know?

Your skin wrinkles if you stay in the bathtub a long time because the outermost layer of skin (which consists of dead keratin) swells when it absorbs water. It is tightly attached to the skin below it, so it compensates for the increased area by wrinkling. This happens to the hands and feet because they have the thickest layer of dead keratin cells.

Did you know?

Every flu season is different, and even healthy people can get extremely sick from the flu, as well as spread it to others. The flu season can begin as early as October and last as late as May. Every person over six months of age should get an annual flu vaccine. The vaccine cannot cause you to get influenza, but in some seasons, may not be completely able to prevent you from acquiring influenza due to changes in causative viruses. The viruses in the flu shot are killed—there is no way they can give you the flu. Minor side effects include soreness, redness, or swelling where the shot was given. It is possible to develop a slight fever, and body aches, but these are simply signs that the body is responding to the vaccine and making itself ready to fight off the influenza virus should you come in contact with it.

Did you know?

ACTH levels are normally highest in the early morning (between 6 and 8 A.M.) and lowest in the evening (between 6 and 11 P.M.). Therefore, a doctor who suspects abnormal levels looks for low ACTH in the morning and high ACTH in the evening.

Did you know?

Immunoglobulin injections may give short-term protection against, or reduce severity of certain diseases. They help people who have an inherited problem making their own antibodies, or those who are having certain types of cancer treatments.

Did you know?

Interferon was scarce and expensive until 1980, when the interferon gene was inserted into bacteria using recombinant DNA technology, allowing for mass cultivation and purification from bacterial cultures.

For a complete list of videos, visit our video library