DBMS Design Process Quiz PDF: Questions and Answers - 147

MCQ 731: The physical schema of a database is

1. Changeable
2. Fixed
3. Hard to carry out
4. Static

MCQ 732: Relations are also used for the representation of

1. Hierarchies
2. Domains
3. Structures
4. Modules

MCQ 733: For the same database, the system can provide us

1. 1 view only
2. No view
3. 2 views only
4. Many views

MCQ 734: SQL authorization mechanism grants privileges on

1. Entire relation
2. Specified attributes
3. Both A and B
4. Specified tuples

MCQ 735: The most critical part of the database system is managed by the component manager known as

1. Transaction manager
2. Authorization and integrity manager
3. File manager
4. Buffer manager