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 42 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 :)

Liddy

  • Member
  • Posts: 342
Reply 3 on: Yesterday
Excellent

« previous next »
 

Did you know?

There are more bacteria in your mouth than there are people in the world.

Did you know?

Asthma-like symptoms were first recorded about 3,500 years ago in Egypt. The first manuscript specifically written about asthma was in the year 1190, describing a condition characterized by sudden breathlessness. The treatments listed in this manuscript include chicken soup, herbs, and sexual abstinence.

Did you know?

Human neurons are so small that they require a microscope in order to be seen. However, some neurons can be up to 3 feet long, such as those that extend from the spinal cord to the toes.

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?

Critical care patients are twice as likely to receive the wrong medication. Of these errors, 20% are life-threatening, and 42% require additional life-sustaining treatments.

Muscles of the right upper extremity supine view Muscles of the right upper extremity supine view
How to integrate trigonometric functions containing even powers (Question 2) How to integrate trigonometric functions containing even powers (Question 2)
How to integrate using inverse trigonometric substitution (Question 2) How to integrate using inverse trigonometric substitution (Question 2)
Linear dose-response curve Linear dose-response curve
Dermatomes of body, posterior view Dermatomes of body, posterior view
Video: Bulk flow - Factors that influence bulk flow

For a complete list of videos, visit our video library