Database Buffer Quiz Questions and Answers PDF - 297

MCQ 1481: A good database system should minimize the number of transferring

1. Sectors
2. Blocks
3. Tracks
4. Segments

MCQ 1482: The clause that allows us to select only those rows in the result relation, is

1. Select clause
2. Define clause
3. From clause
4. Where clause

MCQ 1483: Scalar subqueries may also be defined without

1. Variables
2. Instances
3. Aggregates
4. Where clause

MCQ 1484: The state in transaction when the final statement has been executed is called

1. Active
2. Committed
3. Partially committed
4. Initial

MCQ 1485: In the authorization graph, a user has an authorization if and only if there is a path from the

1. Leaf node
2. Neighboring node
3. Child node
4. Root node