Multiple Choice
Working with data in the data cache is many times faster than working with data in the data files because ____.
A) there is no network access involved
B) the DBMS doesn't have to wait for the hard disk to retrieve the data
C) the DBMS can optimize queries against the cache
D) the data cache contains only a few records from each table
Correct Answer:
Verified
Correct Answer:
Verified
Q6: Concurrency control is important for which of
Q7: The DBMS processes queries in three phases;
Q8: Which of the following is the preferred
Q9: Generally, what will provide the best database
Q10: Which of the following is not a
Q12: Who developed QBE?<br>A)C.J. Date<br>B)E.F. Codd<br>C)M.M. Zloof<br>D)None of
Q13: Which of the following is IBM's first
Q14: Database statistics are stored in the system
Q15: Who developed Structured English Query Language?<br>A)E.F. Codd<br>B)D.
Q16: To optimize queries, use simple columns or