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 29 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

shailee

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

« previous next »
 

Did you know?

Women are two-thirds more likely than men to develop irritable bowel syndrome. This may be attributable to hormonal changes related to their menstrual cycles.

Did you know?

Human stomach acid is strong enough to dissolve small pieces of metal such as razor blades or staples.

Did you know?

Though “Krazy Glue” or “Super Glue” has the ability to seal small wounds, it is not recommended for this purpose since it contains many substances that should not enter the body through the skin, and may be harmful.

Did you know?

Blastomycosis is often misdiagnosed, resulting in tragic outcomes. It is caused by a fungus living in moist soil, in wooded areas of the United States and Canada. If inhaled, the fungus can cause mild breathing problems that may worsen and cause serious illness and even death.

Did you know?

Chronic marijuana use can damage the white blood cells and reduce the immune system's ability to respond to disease by as much as 40%. Without a strong immune system, the body is vulnerable to all kinds of degenerative and infectious diseases.

lateral view skull lateral view skull
Skull Right Lateral View Labeled Skull Right Lateral View Labeled
How to solve a word problem involving trigonometric models (Question 2) How to solve a word problem involving trigonometric models (Question 2)
How to calculate monthly payments at varying amortization periods (Question 3) How to calculate monthly payments at varying amortization periods (Question 3)
economic question economic question
economic question economic question
Video: Deglutition

For a complete list of videos, visit our video library