Quiz for User Privileges and Roles

Q1: Which SQL command is used to grant privileges to a user?

A. GRANT B. REVOKE C. ALLOW D. PERMIT

Q2: Which keyword is used to allow a user to give privileges to others?

A. WITH OPTION B. WITH GRANT OPTION C. ALLOW PRIVILEGE D. INHERIT PERMISSION

Q3: Which system privilege allows creating tables?

A. CREATE USER B. CREATE TABLE C. CREATE INDEX D. CREATE VIEW

Q4: What is a role in SQL?

A. A database schema B. A set of privileges grouped together C. A query execution plan D. A table constraint

Q5: Which SQL command is used to create a new role?

A. NEW ROLE B. ADD ROLE C. CREATE ROLE D. DEFINE ROLE

Q6: To assign a role to a user, which command is used?

A. GIVE ROLE B. SET ROLE C. GRANT ROLE D. ASSIGN ROLE

Q7: Which of the following is NOT a valid SQL privilege?

A. SELECT B. INSERT C. MODIFY D. DELETE

Q8: What privilege is required to create a view?

A. CREATE VIEW B. CREATE USER C. GRANT SELECT D. REVOKE

Q9: What is the purpose of the SHOW GRANTS command?

A. To view current privileges B. To modify privileges C. To delete user access D. To list all users

Q10: Can you grant a role to another role in SQL?

A. Yes B. No C. Only with permission D. Depends on DBMS

Q11: Which SQL privilege allows reading data from a table?

A. INSERT B. UPDATE C. DELETE D. SELECT

Q12: What happens if you revoke a role from a user?

A. User gets new privileges B. User loses access associated with that role C. User data is deleted D. No change

Q13: How are privileges stored in MySQL?

A. In user_priv table B. In access_log C. In information_schema D. In the mysql database

Q14: What type of privilege is EXECUTE?

A. Object privilege B. System privilege C. User privilege D. Temporary privilege

Q15: Which keyword is used to remove a user role?

A. DROP ROLE B. DELETE ROLE C. REMOVE ROLE D. UNSET ROLE

Q16: Which clause is required to revoke a privilege granted with WITH GRANT OPTION?

A. REVOKE WITH CASCADE B. REVOKE RECURSIVE C. REVOKE OPTION FOR D. REVOKE ON CASCADE

Q17: Can a user have multiple roles in SQL?

A. No B. Yes C. Only one active role D. Depends on DB engine

Q18: What is the function of the SET ROLE statement?

A. Grant a privilege B. Activate a role C. Remove a role D. Create a role

Q19: Which SQL statement would show all defined roles?

A. SHOW USERS B. LIST ROLES C. SELECT * FROM roles D. SELECT * FROM dba_roles