Which of the following data administration facilities continually maintain statistics concerning how the DBMS engine physically accesses information?
A)Security management facilities
B)Query optimization facilities
C)Reorganization facilities
D)Concurrency control facilities

Question

Quizplus · Accepted Answer

Reorganization facilities-continually maintain statistics concerning how the DBMS engine physically accesses information and reorganizes how information is physically stored.For example,if you frequently access a file by a specific order,the reorganization facilities may maintain the file in that presorted order by creating an index that maintains the sorted order in that file.

Which of the Following Data Administration Facilities Continually Maintain Statistics