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 45 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
:D TYSM

mcarey591

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

« previous next »
 

Did you know?

Eating carrots will improve your eyesight. Carrots are high in vitamin A (retinol), which is essential for good vision. It can also be found in milk, cheese, egg yolks, and liver.

Did you know?

To combat osteoporosis, changes in lifestyle and diet are recommended. At-risk patients should include 1,200 to 1,500 mg of calcium daily either via dietary means or with supplements.

Did you know?

Long-term mental and physical effects from substance abuse include: paranoia, psychosis, immune deficiencies, and organ damage.

Did you know?

Patients who cannot swallow may receive nutrition via a parenteral route—usually, a catheter is inserted through the chest into a large vein going into the heart.

Did you know?

The ratio of hydrogen atoms to oxygen in water (H2O) is 2:1.

Aerial View Of The Sanctuary Of Apollo, Delphi Aerial View Of The Sanctuary Of Apollo, Delphi
Right lateral view of several articulated thoracic vertebrae Right lateral view of several articulated thoracic vertebrae
Hardy-Weinberg Question P3 Hardy-Weinberg Question P3
The phenotypic distribution in a cross with two traits: seed color and seed shape. Plants in the F2 The phenotypic distribution in a cross with two traits: seed color and seed shape. Plants in the F2
Gray Eye Color Gray Eye Color
A three-gene additive model for wheat kernel color A three-gene additive model for wheat kernel color
Video: Lipid catabolism - lipolysis and beta oxidation and oxidation of fatty acids

For a complete list of videos, visit our video library