Data Control Language (DCL) MCQs in DBMS

MCQs on Data Control Language (DCL) in DBMS

Which SQL statement is used to grant privileges to users in a database?
- a) GRANT
- b) ALLOW
- c) PERMIT
- d) AUTHORIZE
Answer: a) GRANT
Which SQL statement is used to revoke privileges from users in a database?
- a) REMOVE
- b) DELETE
- c) REVOKE
- d) WITHDRAW
Answer: c) REVOKE
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;
Answer: a) GRANT SELECT ON table_name TO user_name;
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.
Answer: b) It removes previously granted permissions from users.
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;
Answer: d) GRANT … TO user_name;
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
Answer: b) To remove access rights from database users
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;
Answer: a) GRANT ALL PRIVILEGES ON table_name TO user_name;
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.
Answer: c) It provides specific access rights to users on database objects.
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;
Answer: a) REVOKE DELETE ON table_name FROM user_name;
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;
Answer: a) GRANT INSERT ON table_name TO user_name;
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;
Answer: a) GRANT CREATE ON database_name TO user_name;
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
Answer: c) GRANT and REVOKE
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.
Answer: a) The user can pass on the granted privileges to other users.
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
Answer: a) CREATE USER
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.
Answer: b) It removes the specified privileges from all users.

More MCQs Of Database Systems

SET 1: database design mcqs (database design mcqs )
SET 2: database mcqs with answers pdf (database mcqs with answers pdf )
SET 3: modern database management 12th edition mcqs (modern database management 12th edition mcqs)
SET 4: database systems mcqs (database systems mcqs)
SET 5: dbms mcqs (dbms mcqs )
SET 6: dbms mcqs with answers (dbms mcqs with answers)
SET 7: solved mcqs of dbms (solved mcqs of dbms)
SET 8: dbms mcqs with answers pdf(dbms mcqs with answers pdf)
SET 9: relational database management system mcqs(relational database management system mcqs)
SET 10: solved mcqs of database management system(solved mcqs of database management system)
SET 11: basic database mcqs pdf (basic database mcqs pdf)
SET 12: relational database management system mcqs (relational database management system mcqs )
SET 13: database mcqs online test (database mcqs online test)
SET 14: database interview questions mcqs (database interview questions mcqs)
SET 15: database developer mcqs (database developer mcqs)
SET 16: database Repeated mcqs (database Repeated mcqs)
SET 17: Database mcqs PPSC (Database mcqs PPSC)
SET 18: Database mcqs FPSC (Database mcqs FPSC)
SET 19: DBMS mcqs FPSC (DBMS mcqs FPSC)

New Arrival

Database interview questions

Data Control Language (DCL) MCQs in DBMS
By: Prof. Dr. Fazal Rehman Shamil | Last updated: September 23, 2024

MCQs on Data Control Language (DCL) in DBMS

More MCQs Of Database Systems

Related Posts: