DBMS Authentication Multiple Choice Questions (MCQ) PDF Download

MCQ 1: The short form for all the allowable privileges, is said to be

1. All privileges
2. All grant
3. All access
4. All authorize

MCQ 2: A user who creates a new relation is given all privileges on that relation

1. Explicitly
2. Specifically
3. Not generally
4. Automatically

MCQ 3: The statement that is used to confer authorization, is known as

1. Access
2. Grant
3. Provide
4. Contain

MCQ 4: The SQL standard includes the privileges

1. Insert and select
2. Update and delete
3. Both A and B
4. Granting and ungranting

MCQ 5: The SQL data-definition language includes commands to grant and

1. Transfer privileges
2. Transmit privileges
3. Revoke privileges
4. Authorize