Data Control Language (DCL) MCQs in DBMS

1. Which SQL statement is used to grant privileges to users in a database?

(A) GRANT

(B) ALLOW

(C) PERMIT

(D) AUTHORIZE

2. Which SQL statement is used to revoke privileges from users in a database?

(A) REMOVE

(B) DELETE

(C) REVOKE

(D) WITHDRAW

3. Which SQL statement would you use to provide a user with permission to select data from a table?

(A) GRANT SELECT ON table_name TO user_name;

(B) GRANT ALL ON table_name TO user_name;

(C) ALLOW SELECT ON table_name TO user_name;

(D) PERMIT SELECT ON table_name TO user_name;

4. What does the REVOKE statement do in SQL?

(A) It grants new permissions to users.

(B) It removes previously granted permissions from users.

(C) It creates new tables.

(D) It deletes existing tables.

5. Which SQL statement is used to assign a user role to another user?

(A) GRANT ROLE

(B) ASSIGN ROLE

(C) ROLE GRANT

(D) GRANT … TO user_name;

6. What is the purpose of the REVOKE command?

(A) To provide access to database objects

(B) To remove access rights from database users

(C) To update user information

(D) To create a new user

7. Which SQL statement would you use to provide a user with all available privileges on a table?

(A) GRANT ALL PRIVILEGES ON table_name TO user_name;

(B) GRANT FULL ACCESS ON table_name TO user_name;

(C) PERMIT ALL ON table_name TO user_name;

(D) AUTHORIZE ALL ON table_name TO user_name;

8. What does the GRANT statement do in SQL?

(A) It creates a new database user.

(B) It modifies the structure of a database object.

(C) It provides specific access rights to users on database objects.

(D) It removes data from a table.

9. Which of the following statements will revoke the ability of a user to delete records from a table?

(A) REVOKE DELETE ON table_name FROM user_name;

(B) GRANT DELETE ON table_name TO user_name;

(C) REMOVE DELETE FROM table_name BY user_name;

(D) DELETE ACCESS ON table_name FROM user_name;

10. Which SQL command is used to provide the ability to insert data into a table?

(A) GRANT INSERT ON table_name TO user_name;

(B) GRANT DATA INSERT ON table_name TO user_name;

(C) PERMIT INSERT ON table_name TO user_name;

(D) AUTHORIZE INSERT INTO table_name FOR user_name;

11. Which SQL command can be used to specify that a user can create new tables within a database?

(A) GRANT CREATE ON database_name TO user_name;

(B) GRANT TABLE CREATE ON database_name TO user_name;

(C) ALLOW CREATE TABLE ON database_name TO user_name;

(D) PERMIT CREATE TABLE IN database_name FOR user_name;

12. Which DCL command would you use to change a user’s access privileges?

(A) UPDATE ACCESS

(B) MODIFY PRIVILEGES

(C) GRANT and REVOKE

(D) CHANGE PERMISSIONS

13. What is the effect of using the GRANT command with WITH GRANT OPTION?

(A) The user can pass on the granted privileges to other users.

(B) The user can only use the granted privileges but not transfer them.

(C) The user can modify the database structure.

(D) The user can delete other users’ privileges.

14. Which SQL command is used to create a new user in the database?

(A) CREATE USER

(B) ADD USER

(C) NEW USER

(D) REGISTER USER

15. What does the REVOKE command do if executed without specifying a user?

(A) It removes all privileges from all users on the specified object.

(B) It removes the specified privileges from all users.

(C) It deletes the specified table.

(D) It creates a new table.