Quiz for REVOKE

Q1: What does the REVOKE command do in SQL?

A. Grants permissions B. Removes permissions C. Modifies table data D. Deletes a table

Q2: Which SQL command is used to take back privileges granted to a user?

A. GRANT B. REVOKE C. DENY D. ROLLBACK

Q3: After executing REVOKE, what happens to the user access?

A. Access is enhanced B. Access remains the same C. Access is removed D. User is deleted

Q4: Which of the following is a valid syntax for REVOKE?

A. REVOKE SELECT FROM user_name; B. REVOKE ON SELECT user_name; C. REVOKE user_name FROM SELECT; D. REVOKE GRANT user_name;

Q5: Can REVOKE remove privileges given with the GRANT OPTION?

A. Yes B. No C. Only if admin D. Only if not used

Q6: Which clause is mandatory in a REVOKE statement?

A. ON B. TO C. USING D. WHERE

Q7: What happens if you REVOKE a privilege not granted?

A. Error B. Warning C. Silently ignored D. Privilege granted again

Q8: Is it possible to REVOKE multiple privileges in one command?

A. No B. Yes C. Only two D. Only SELECT and INSERT

Q9: What privilege can be revoked using REVOKE?

A. SELECT B. UPDATE C. INSERT D. All of the above

Q10: What keyword is used to specify the user in REVOKE?

A. TO B. WITH C. FROM D. GRANT

Q11: Can REVOKE be used to revoke EXECUTE privilege on stored procedures?

A. Yes B. No C. Only in MySQL D. Only in SQL Server

Q12: Does REVOKE affect roles assigned to a user?

A. No B. Yes, indirectly C. Only SELECT roles D. Only admin roles

Q13: In MySQL, which syntax is valid for REVOKE?

A. REVOKE SELECT ON db.table FROM user; B. REVOKE db.table SELECT FROM user; C. REVOKE FROM user SELECT ON db.table; D. REVOKE user SELECT ON db.table;

Q14: Can you revoke privileges from multiple users at once?

A. No B. Yes C. Only in PostgreSQL D. Only in Oracle

Q15: What database object is typically used in REVOKE?

A. View B. Function C. Table D. All of the above

Q16: REVOKE can be used by which type of user?

A. Any user B. Only DBAs C. Only the user who granted D. Only root user

Q17: Does REVOKE automatically delete the user?

A. Yes B. No C. Only in MySQL D. Only if no other privileges

Q18: Can REVOKE affect dependent views?

A. No B. Yes C. Sometimes D. Only if WITH GRANT OPTION was used

Q19: REVOKE SELECT, INSERT ON Employees FROM Bob; means?

A. Bob can access Employees B. Bob is denied access C. Bob loses SELECT and INSERT access D. Bob is removed from DB

Q20: Which statement is true about REVOKE?

A. It’s irreversible B. It removes privileges C. It grants access D. It’s same as GRANT