This topic contains a solution. Click here to go to the answer

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

sjones

  • Hero Member
  • *****
  • Posts: 520
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
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
Excellent


daiying98

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

 

Did you know?

Tobacco depletes the body of vitamins A, C, and E, which can result in any of the following: dry hair, dry skin, dry eyes, poor growth, night blindness, abscesses, insomnia, fatigue, reproductive system problems, sinusitis, pneumonia, frequent respiratory problems, skin disorders, weight loss, rickets, osteomalacia, nervousness, muscle spasms, leg cramps, extremity numbness, bone malformations, decayed teeth, difficulty in walking, irritability, restlessness, profuse sweating, increased uric acid (gout), joint damage, damaged red blood cells, destruction of nerves, infertility, miscarriage, and many types of cancer.

Did you know?

After 5 years of being diagnosed with rheumatoid arthritis, one every three patients will no longer be able to work.

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?

Approximately one in four people diagnosed with diabetes will develop foot problems. Of these, about one-third will require lower extremity amputation.

Did you know?

Although the Roman numeral for the number 4 has always been taught to have been "IV," according to historians, the ancient Romans probably used "IIII" most of the time. This is partially backed up by the fact that early grandfather clocks displayed IIII for the number 4 instead of IV. Early clockmakers apparently thought that the IIII balanced out the VIII (used for the number 8) on the clock face and that it just looked better.

For a complete list of videos, visit our video library