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

Alyson.hiatt@yahoo.com

  • Member
  • Posts: 354
Reply 3 on: Yesterday
YES! Correct, THANKS for helping me on my review

« previous next »
 

Did you know?

Pink eye is a term that refers to conjunctivitis, which is inflammation of the thin, clear membrane (conjunctiva) over the white part of the eye (sclera). It may be triggered by a virus, bacteria, or foreign body in the eye. Antibiotic eye drops alleviate bacterial conjunctivitis, and antihistamine allergy pills or eye drops help control allergic conjunctivitis symptoms.

Did you know?

The most common childhood diseases include croup, chickenpox, ear infections, flu, pneumonia, ringworm, respiratory syncytial virus, scabies, head lice, and asthma.

Did you know?

Not getting enough sleep can greatly weaken the immune system. Lack of sleep makes you more likely to catch a cold, or more difficult to fight off an infection.

Did you know?

Although not all of the following muscle groups are commonly used, intramuscular injections may be given into the abdominals, biceps, calves, deltoids, gluteals, laterals, pectorals, quadriceps, trapezoids, and triceps.

Did you know?

All adverse reactions are commonly charted in red ink in the patient's record and usually are noted on the front of the chart. Failure to follow correct documentation procedures may result in malpractice lawsuits.

Mountain View Cur Mountain View Cur
Eye Color Is a Sex-Linked Trait in Drosophila (Part 4) Eye Color Is a Sex-Linked Trait in Drosophila (Part 4)
Close-up view of Pluto's mountains, frozen plains and hazes Close-up view of Pluto's mountains, frozen plains and hazes
Lateral view of spine Lateral view of spine
economic question economic question
Video: Inflammation

For a complete list of videos, visit our video library