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 17 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
Gracias!

hramirez205

  • Member
  • Posts: 345
Reply 3 on: Yesterday
Wow, this really help

« previous next »
 

Did you know?

It is believed that humans initially contracted crabs from gorillas about 3 million years ago from either sleeping in gorilla nests or eating the apes.

Did you know?

The first documented use of surgical anesthesia in the United States was in Connecticut in 1844.

Did you know?

Many of the drugs used by neuroscientists are derived from toxic plants and venomous animals (such as snakes, spiders, snails, and puffer fish).

Did you know?

Illicit drug use costs the United States approximately $181 billion every year.

Did you know?

When blood is exposed to air, it clots. Heparin allows the blood to come in direct contact with air without clotting.

Structures of the Abdomen: Posterior View Structures of the Abdomen: Posterior View
Receptive Fields of Color-Sensitive Ganglion Cells Receptive Fields of Color-Sensitive Ganglion Cells
Dermatomes of body, anterior view Dermatomes of body, anterior view
Inferior view of distal ends of radius and ulna Inferior view of distal ends of radius and ulna
economic question economic question
Anterior View of the Spinal Column Showing Anterior and Posterior Longitudinal Ligaments Anterior View of the Spinal Column Showing Anterior and Posterior Longitudinal Ligaments
Video: TRH/TSH/Thyroid hormone

For a complete list of videos, visit our video library