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 14 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
Excellent

EAN94

  • Member
  • Posts: 307
Reply 3 on: Yesterday
Gracias!

« previous next »
 

Did you know?

The Centers for Disease Control and Prevention (CDC) was originally known as the Communicable Disease Center, which was formed to fight malaria. It was originally headquartered in Atlanta, Georgia, since the Southern states faced the worst threat from malaria.

Did you know?

Between 1999 and 2012, American adults with high total cholesterol decreased from 18.3% to 12.9%

Did you know?

The calories found in one piece of cherry cheesecake could light a 60-watt light bulb for 1.5 hours.

Did you know?

Asthma occurs in one in 11 children and in one in 12 adults. African Americans and Latinos have a higher risk for developing asthma than other groups.

Did you know?

Children with strabismus (crossed eyes) can be treated. They are not able to outgrow this condition on their own, but with help, it can be more easily corrected at a younger age. It is important for infants to have eye examinations as early as possible in their development and then another at age 2 years.

Lungs: RUL = Right Upper Lobe, RML = Right Middle Lobe, RLL = Right Lower Lobe, LUL = Left Upper Lob Lungs: RUL = Right Upper Lobe, RML = Right Middle Lobe, RLL = Right Lower Lobe, LUL = Left Upper Lob
microscope view of an onion root tip microscope view of an onion root tip
Linear dose-response curve Linear dose-response curve
Advertising Break-even Question Advertising Break-even Question
economic question economic question
The CRISPR/Cas system mediates an adaptive immune response in prokaryotes The CRISPR/Cas system mediates an adaptive immune response in prokaryotes
Video: Pressure volume relationships - Normal inspiration and expiration

For a complete list of videos, visit our video library