View of Data MCQs (Multiple Choice Questions) PDF Download - 126

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

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

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

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

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

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