Quiz

A sparse index and a dense index are the same thing.

The file system uses the disk management subsystem.

Even though main memory is faster that secondary storage, its volatility makes it less suitable for database storage

If records are 1000 bytes, an 8k page can store exactly 8 records

Which of the following is not a file access method

To design security mechanisms for the database as specified by the users during requirements is the objective of which step in physical design

To decide how to represent any derived data present in the logical data model in the target DBMS is the objective of which step in physical database design

To design user views that were identified in requirements is the objective of which step of physical design

To estimate the amount of disk space that will be required by the database is the objective of which step in physical design