MySQL - User Management and Privileges MCQ

MySQL – User Management and Privileges MCQ

1 / 25

1. What is the primary purpose of user management in MySQL?

Query optimization

Database security

Data encryption

Database backups

2 / 25

2. How do you create a new user account in MySQL?

CREATE USER

ADD USER

INSERT INTO

CREATE ACCOUNT

3 / 25

3. What is the significance of the ‘hostname’ in a MySQL user account?

It determines from which host the user can connect

It defines the user's password

It sets the user's privileges

It specifies the user's full name

4 / 25

4. Which SQL statement is used to assign privileges to a user in MySQL?

GRANT PERMISSIONS

ASSIGN PERMISSIONS

GRANT PRIVILEGES

SET PRIVILEGES

5 / 25

5. What is the primary purpose of using the GRANT statement in MySQL?

To create new user accounts

To assign privileges to user accounts

To delete user accounts

To list user accounts

6 / 25

6. What type of privileges can be assigned to a user in MySQL?

All of the above

SELECT and INSERT

CREATE and DROP

DELETE and UPDATE

7 / 25

7. What does the ‘REVOKE’ statement do in MySQL?

Grants privileges

Lists user accounts

Creates user accounts

Removes privileges from a user

8 / 25

8. Which SQL statement is used to list the privileges assigned to a user in MySQL?

SHOW PRIVILEGES

DISPLAY PRIVILEGES

LIST PRIVILEGES

DESCRIBE PRIVILEGES

9 / 25

9. What is the principle of least privilege in MySQL user management?

Assign privileges only to administrators

Grant users only the privileges they need

Assign maximum privileges to all users

Remove all privileges from users

10 / 25

10. What is the purpose of enforcing strong passwords for user accounts in MySQL?

To simplify user management

To enable SSL/TLS encryption

To prevent unauthorized access

To improve query performance

11 / 25

11. What is the significance of the ‘hostname’ in MySQL user account creation?

It specifies the user's name

It sets the user's password

It defines the host from which the user can connect

It determines the user's default database

12 / 25

12. How can you view the privileges assigned to a specific user in MySQL?

SHOW PRIVILEGES FOR 'username'

LIST USER PRIVILEGES

DESCRIBE USER PRIVILEGES

SHOW GRANTS FOR 'username'

13 / 25

13. What happens when you execute the REVOKE statement in MySQL?

It creates user accounts

It lists user accounts

It grants privileges

It removes privileges from a user

14 / 25

14. Which of the following is a valid MySQL privilege keyword?

ALLOW

DELETE

INSERT

EXECUTE

15 / 25

15. What is the primary role of the GRANT statement in MySQL user management?

To list user accounts

To assign privileges to user accounts

To create new user accounts

To delete user accounts

16 / 25

16. What is the benefit of regularly reviewing and auditing user accounts and privileges in MySQL?

Ensured data integrity

Enhanced data encryption

Strengthened database security

Improved query performance

17 / 25

17. What is the role of the REVOKE statement in MySQL user management?

To grant privileges

To create new user accounts

To list user accounts

To remove privileges from a user

18 / 25

18. What privileges can be assigned to a MySQL user account?

All of the above

SELECT and INSERT

DROP and TRUNCATE

SHOW and DESCRIBE

19 / 25

19. What is the primary purpose of using strong passwords for user accounts in MySQL?

Preventing unauthorized access

Database backups

Data compression

Query optimization

20 / 25

20. What is the best practice for MySQL user management regarding the ‘root’ user account?

Share the 'root' password with all users

Avoid using 'root' for routine tasks

Use 'root' for all database tasks

Delete the 'root' user account

21 / 25

21. What is the ‘hostname’ in MySQL user account creation used for?

It defines the host from which the user can connect

It determines the user's default database

It sets the user's password

It specifies the user's name

22 / 25

22. Which keyword is used to assign privileges to a user account in MySQL?

ASSIGN PRIVILEGES

ADD PRIVILEGES

SET PRIVILEGES

GRANT PRIVILEGES

23 / 25

23. What is the primary benefit of the ‘REVOKE’ statement in MySQL?

To remove privileges from a user

To list user accounts

To create new user accounts

To grant privileges

24 / 25

24. What is the primary purpose of the ‘SHOW GRANTS’ statement in MySQL?

To create user accounts

To display the privileges granted to a user

To list user accounts

To assign privileges to user accounts

25 / 25

25. Which MySQL user management best practice promotes security?

Assign maximum privileges to all users

Use weak passwords for user accounts

Share 'root' user credentials with all users

Follow the principle of least privilege

Your score is