Database Authorization MCQ (Multiple Choice Questions) PDF - 210

MCQ 1046: The SQL references privilege is granted on specific attributes in a manner like that for the

1. Execute privilege
2. Update privilege
3. Select privilege
4. Insert privilege

MCQ 1047: The algorithm used to compute natural joins and equi-joins are called

1. Join algorithms
2. Split-join algorithms
3. Merge-join algorithms
4. Union-join algorithms

MCQ 1048: The interface that provides a way to find metadata about the database, is known as

1. DatabaseData
2. MetaDatabase
3. DatabaseMetaData
4. MetaDataDatabase

MCQ 1049: A state in which the system no longer rejects a real state of the world is termed as

1. Unreliable state
2. Nondurable state
3. Inconsistent state
4. Non-atomic state

MCQ 1050: The database state is restored to what it was before the first statement of the transaction was executed, in the

1. Transmit work
2. Trace work
3. Commit work
4. Rollback work