View of Data Multiple Choice Questions and Answers PDF – Test 126

MCQ 626: Database administrators, who must decide what information to keep in the database, uses the:

1. Physical level of abstraction
2. Logical level of abstraction
3. View level of abstraction
4. Virtual level of abstraction

MCQ 627: The concurrency-control manager and the recovery managers are part of:

1. Authorization manager
2. Transaction manager
3. Integrity manager
4. File manager

MCQ 628: Revocation of a privilege from a user/role may cause other users/roles also to lose that privilege, this behavior is called:

1. Granting revocation
2. Cascading revocation
3. Assigning revocation
4. Restricted revocation

MCQ 629: The term that says values appearing in specified attributes of any tuple in the referencing relation also appear in specified attributes of at least one tuple in the referenced relation, is called:

1. Constant Integrity constraint
2. Variable Integrity constraint
3. Referential Integrity constraint
4. Attribute Integrity constraint

MCQ 630: The process that defines how to group the attributes to form the various tables, is known as:

1. Execution design
2. Controlling design
3. Conceptual design
4. Initial Planning