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

ASDFGJLO

  • Member
  • Posts: 335
Reply 3 on: Yesterday
Great answer, keep it coming :)

« previous next »
 

Did you know?

Oxytocin is recommended only for pregnancies that have a medical reason for inducing labor (such as eclampsia) and is not recommended for elective procedures or for making the birthing process more convenient.

Did you know?

Throughout history, plants containing cardiac steroids have been used as heart drugs and as poisons (e.g., in arrows used in combat), emetics, and diuretics.

Did you know?

More than 2,500 barbiturates have been synthesized. At the height of their popularity, about 50 were marketed for human use.

Did you know?

According to the CDC, approximately 31.7% of the U.S. population has high low-density lipoprotein (LDL) or "bad cholesterol" levels.

Did you know?

In most cases, kidneys can recover from almost complete loss of function, such as in acute kidney (renal) failure.

A theoretical photosynthetic response curve. A theoretical photosynthetic response curve.
Eye Color Is a Sex-Linked Trait in Drosophila (Part 4) Eye Color Is a Sex-Linked Trait in Drosophila (Part 4)
Right lateral view of skull Right lateral view of skull
Inferior view of distal ends of radius and ulna Inferior view of distal ends of radius and ulna
economic question economic question
economic question (having trouble) economic question (having trouble)
Video: Role of ATP in muscle movement

For a complete list of videos, visit our video library