Which of the following is an advantage of stored procedures? A) Data integrity improves when ...

Author Question: Which of the following is an advantage of stored procedures? A) Data integrity improves when ... (Read 31 times)

james9437

Hero Member
Posts: 568

on: Jul 7, 2018

Which of the following is an advantage of stored procedures?

A) Data integrity improves when fewer applications access the procedure.
B) The layers get cleaner.
C) Stored procedures result in fatter clients.
D) Performance improves for compiled SQL statements.

Question 2

A ________ view is materialized when referenced.

A) virtual
B) dynamic
C) materialized
D) base

tandmlomax84

Sr. Member
Posts: 323

Reply #1 on: Jul 7, 2018

Answer to Question 1

D

Answer to Question 2

B

Need homework help now?

Ask unlimited questions for free

Ask a Question

« previous next »

Did you know?

There are immediate benefits of chiropractic adjustments that are visible via magnetic resonance imaging (MRI). It shows that spinal manipulation therapy is effective in decreasing pain and increasing the gaps between the vertebrae, reducing pressure that leads to pain.

Did you know?

Nearly all drugs pass into human breast milk. How often a drug is taken influences the amount of drug that will pass into the milk. Medications taken 30 to 60 minutes before breastfeeding are likely to be at peak blood levels when the baby is nursing.

Did you know?

Pope Sylvester II tried to introduce Arabic numbers into Europe between the years 999 and 1003, but their use did not catch on for a few more centuries, and Roman numerals continued to be the primary number system.

Did you know?

The liver is the only organ that has the ability to regenerate itself after certain types of damage. As much as 25% of the liver can be removed, and it will still regenerate back to its original shape and size. However, the liver cannot regenerate after severe damage caused by alcohol.

Did you know?

About 80% of major fungal systemic infections are due to Candida albicans. Another form, Candida peritonitis, occurs most often in postoperative patients. A rare disease, Candida meningitis, may follow leukemia, kidney transplant, other immunosuppressed factors, or when suffering from Candida septicemia.