Privileges Quiz

Let us see how much you understand about MySQL privileges by answering these questions.

1. What does the USAGE privilege allow an user to do?
   1. Flush privileges.
   2. Load data from a file.
   3. Only to log in.
   4. Pass on privileges to another user.
   5. Use shortcuts.

2. What does the GRANT OPTION privilege allow an user to do?
   1. Flush privileges.
   2. Load data from a file.
   3. Only to log in.
   4. Pass on privileges to another user.
   5. Use shortcuts.

3. What does the RELOAD privilege allow an user to do?
   1. Flush privileges.
   2. Load data from a file.
   3. Only to log in.
   4. Pass on privileges to another user.
   5. Use shortcuts.

4. What does the FILE privilege allow an user to do?
   1. Flush privileges.
   2. Load data from a file.
   3. Only to log in.
   4. Pass on privileges to another user.
   5. Use shortcuts.

5. What does an entry in the tables_priv.table_priv column do?
   1. Lists the privileges an user has on this table as a set.
   2. Records a single privilege a user has on this table.
   3. Records whether an user has access to this table.
   4. Records whether there is an entry in the column_name table for this table.
   5. Records whether there is an entry in the column_priv table for this table.

6. What statement is false?
   1. DROP USER requires the CREATE USER privilege or the DELETE privilege for the MySQL database.
   2. GRANT requires the CREATE USER privilege and have the privileges that are being granted.
   3. RENAME USER requires the CREATE USER privilege or the UPDATE privilege for the MySQL database.
   4. REVOKE ALL PRIVILEGES requires the CREATE USERprivilege or the UPDATE privilege for the MySQL database.
   5. REVOKE without ALL PRIVILEGES requires the GRANT OPTIONprivilege and have the privileges that are being revoked.