This topic contains a solution. Click here to go to the answer
« previous next »

Author Question: What is view materialization? What will be an ideal response?[br][br][b][color=#151B54]Question ... (Read 44 times)

sjones

  • Hero Member
  • *****
  • Posts: 520
on: Jul 7, 2018
What is view materialization?
 
  What will be an ideal response?

Question 2

Describe the delete restrict option (for implementing a referential integrity constraint).
 
  What will be an ideal response?


Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
Marked as best answer by a Subject Expert

jordangronback

  • Sr. Member
  • ****
  • Posts: 339
Reply #1 on: Jul 7, 2018
Answer to Question 1

View materialization refers to saving a view as an actual physical table. Such a view is referred to as a materialized view. The idea behind view materialization is to improve the performance of queries on frequently used views.

Answer to Question 2

The delete restrict option does not allow a record to be deleted if its primary key value is referred to by a foreign key value.


sjones

  • Member
  • Posts: 520
Reply 2 on: Jul 7, 2018
Great answer, keep it coming :)

isabelt_18

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

« previous next »
 

Did you know?

Serum cholesterol testing in adults is recommended every 1 to 5 years. People with diabetes and a family history of high cholesterol should be tested even more frequently.

Did you know?

Vaccines prevent between 2.5 and 4 million deaths every year.

Did you know?

Never take aspirin without food because it is likely to irritate your stomach. Never give aspirin to children under age 12. Overdoses of aspirin have the potential to cause deafness.

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.

Did you know?

The B-complex vitamins and vitamin C are not stored in the body and must be replaced each day.

Facility Emergency Response Plans. Courtesy of Chris Weber, Dr. Hazmat, Inc. Facility Emergency Response Plans. Courtesy of Chris Weber, Dr. Hazmat, Inc.
How to calculate monthly mortgage payments at varying amortization periods (Question 1) How to calculate monthly mortgage payments at varying amortization periods (Question 1)
Answer to Vector Question Pt. 1 Answer to Vector Question Pt. 1
Remainder Question Remainder Question
Eye Color Variation Eye Color Variation
Coat color in mice Coat color in mice
Video: Electromagnetic Spectrum, Chlorophyll and Pigment & Light

For a complete list of videos, visit our video library