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

cam1229

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

« previous next »
 

Did you know?

Complications of influenza include: bacterial pneumonia, ear and sinus infections, dehydration, and worsening of chronic conditions such as asthma, congestive heart failure, or diabetes.

Did you know?

More than 30% of American adults, and about 12% of children utilize health care approaches that were developed outside of conventional medicine.

Did you know?

Human kidneys will clean about 1 million gallons of blood in an average lifetime.

Did you know?

Ether was used widely for surgeries but became less popular because of its flammability and its tendency to cause vomiting. In England, it was quickly replaced by chloroform, but this agent caused many deaths and lost popularity.

Did you know?

There used to be a metric calendar, as well as metric clocks. The metric calendar, or "French Republican Calendar" divided the year into 12 months, but each month was divided into three 10-day weeks. Each day had 10 decimal hours. Each hour had 100 decimal minutes. Due to lack of popularity, the metric clocks and calendars were ended in 1795, three years after they had been first marketed.

Gray squirrel with brownish color - taken in Cincinnati, OH Gray squirrel with brownish color - taken in Cincinnati, OH
Muscles of the right upper extremity upper view Muscles of the right upper extremity upper view
Replication fork regression as a likely response to a blocking DNA lesion Replication fork regression as a likely response to a blocking DNA lesion
The Stress Response The Stress Response
economic question economic question
Anatomy of the Spinal Cord: Three-Dimensional Anterior View of the Spinal Cord and the Meningeal Cov Anatomy of the Spinal Cord: Three-Dimensional Anterior View of the Spinal Cord and the Meningeal Cov
Video: Digestion Animation

For a complete list of videos, visit our video library