Quiz for GRANT

Q1: What does the GRANT statement do in SQL?

A. Deletes a user B. Modifies table structure C. Assigns privileges D. Creates a new table

Q2: Which of the following is a valid privilege that can be granted?

A. INSERT B. LOCK C. MODIFY D. REPLACE

Q3: Which SQL command allows you to assign SELECT permission on a table?

A. ASSIGN SELECT TO B. GRANT SELECT ON table_name TO user_name C. SET SELECT ON table_name D. AUTHORIZE SELECT TO

Q4: What does the WITH GRANT OPTION allow?

A. Revoke privileges B. Update tables automatically C. Grant privileges to others D. Create users

Q5: Can you grant privileges to a role in SQL?

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

Q6: Which command revokes privileges previously granted?

A. REMOVE B. CANCEL C. REVOKE D. DENY

Q7: Which privilege allows modifying rows in a table?

A. SELECT B. UPDATE C. EXECUTE D. CREATE

Q8: What privilege is needed to create new tables?

A. MODIFY B. CREATE C. INSERT D. ALTER

Q9: Can GRANT be used to assign privileges on views?

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

Q10: What happens if you omit WITH GRANT OPTION?

A. The user can’t use the privilege B. The user can’t pass the privilege on C. The privilege becomes read-only D. The privilege is revoked automatically

Q11: Which of the following is NOT a common privilege in SQL?

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

Q12: To grant EXECUTE on a stored procedure, which syntax is correct?

A. GRANT EXECUTE ON proc_name TO user_name; B. GRANT PROCEDURE TO user_name; C. GRANT RUN ON proc_name TO user_name; D. EXECUTE GRANT proc_name TO user_name;

Q13: Can GRANT be used in a transaction block?

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

Q14: What is required to use GRANT?

A. You must be an administrator B. You must have the privilege WITH GRANT OPTION C. You must own the database D. You must be the DBA

Q15: What is the default behavior if you GRANT the same privilege multiple times?

A. It’s counted multiple times B. It causes an error C. It has no additional effect D. It replaces the existing privilege

Q16: Which of the following can be granted?

A. Database access B. Schema name C. Tablespace D. Privileges

Q17: In MySQL, what keyword is used to give all privileges?

A. ALL PRIVILEGES B. GRANT ALL C. PRIVILEGES ALL D. ALLOW ALL

Q18: Who can grant system privileges?

A. Any user B. Only DBA or admin C. Only root user D. Only the user itself

Q19: What does GRANT SELECT, INSERT ON emp TO scott mean?

A. Scott can only view emp B. Scott can modify emp structure C. Scott can read and insert into emp D. Scott has admin rights

Q20: What object types can you GRANT privileges on?

A. Tables only B. Only users C. Tables, views, procedures, sequences D. Only databases