Top 20 MCQ Questions on MySQL Access Privilege

This set of MCQ questions on MySQL access privilege system includes the collections of the top 20 multiple-choice questions on MySQL’s privilege system. It includes objective type questions on the different tables installed by default on the MySQL database for the privilege verification system along with the overview of user table, db table, host table, tables_priv table, columns_priv table, and procs_priv table. It also includes multiple-choice questions on the GRANT and REVOKE commands used on the MySQL database.

Read Also: Top 20 MCQ Questions on MySQL Data Types

1) MySQL’s privilege’s verification information is stored in the MySQL database, which of the following table are installed by default.
i. user           ii. database
iii. host          iv. tables_priv
A. i, ii and iii only
B. ii, ii and iv only
C. i, iii and iv only
D. All i, ii, iii and iv

2) … table is an extension of db table, offering additional hostnames from which a user can connect to the database server.
A. user
B. host
C. tables_priv
D. procs_priv

3) … table determines which user can access specific columns of a particular table.
A. column_priv
B. host
C. tables_priv
D. procs_priv

4) Which of the following is/are the columns included in the user table stored in mysql database.
i. user           ii. password
iii. host          iv. update_priv
A. i, ii and iii only
B. ii, ii and iv only
C. i, iii and iv only
D. All i, ii, iii and iv

5) The process_priv column determines whether the user can view the process of other users via the … command.
A. PROCESSLIST
B. VIEW PROCESSLIST
C. SHOW PROCESSLIST
D. USER PROCESSLIST

6) The … column is the user table that determines whether the user can execute stored procedures.
A. Super_priv
B. Execute_priv
C. Grant_priv
D. Active_priv

7) The … column is the user table that determines whether the user can read the binary logging files used to maintain a replicated database environment.
A. Repl_slave_priv
B. Repl_client_priv
C. Show_view_priv
D. Find_slave_priv

8) The … column is the user table that determines whether the user can see a view or learn more information about views.
A. Repl_slave_priv
B. Repl_client_priv
C. Show_view_priv
D. Find_slave_priv

9) The … stored in the mysql database is used to assign privileges to a user on a per-database basis.
A. user table
B. host table
C. db table
D. tables_priv table

10) State whether the following statements about the host table stored in the mysql database are TRUE or FALSE.
i. The host table comes into play only if the db table’s host field is left blank.
ii. Wildcards, represented by the % and _ characters, may be used in both the host and db columns, but not in the user column.
A. i-True, ii-True
B. i-True, ii-False
C. i-False, ii-True
D. i-False, ii-False

11) Which of the following is/are the columns included in the tables_priv table stored in mysql database.
i. user                        ii. row_priv
iii. timestamp             iv. column_priv
A. i, ii and iii only
B. ii, ii and iv only
C. i, iii and iv only
D. All i, ii, iii and iv

12) The column … in the tables_priv table stored in mysql database determines which table wide permissions are available to the user.
A. Grantor
B. Timestamp
C. Column_priv
D. Table_priv

13) Which of the following is/are the columns included in the process_priv table stored in mysql database.
i. Grantor                        ii. Routine_name
iii. Timestamp             iv. Proc_priv
A. i, ii and iii only
B. ii, ii and iv only
C. i, iii and iv only
D. All i, ii, iii and iv

14) The … privilege managed by GRANT and REVOKE command in MySQL affects the user’s ability to query for the location of slaves and masters.
A. REPLICATION SLAVE
B. REPLICATION CLIENT
C. EXECUTE
D. REPLICATION LOCATION

15) The … privilege managed by GRANT and REVOKE command in MySQL affects the use of administrator-level commands such as CHANGE MASTER, PURGE MASTER LOGS, SET GLOBAL etc.
A. SUPER
B. ADMIN
C. UPDATE
D. USAGE

16) State whether the following statements about the privileges managed by GRANT and REVOKE command in MySQL are TRUE or FALSE.
i. The privilege of ALL PRIVILEGES affects all privileges along with GRANT OPTION.
ii. The privilege GRANT OPTION affects the user’s ability to delegate privileges.
A. i-True, ii-True
B. i-True, ii-False
C. i-False, ii-True
D. i-False, ii-False

17) State whether the following statements about the GRANT and REVOKE commands in MySQL are TRUE.
i. You can grant privileges for a database that doesn’t yet exist.
ii. If the user identified by the GRANT command does not exist, it will be created.
iii. If you create a user without including the IDENTIFIED by clause, no password will be required for login.
A. i, and ii only
B. ii and iii only
C. i and iii only
D. All i, ii and iii

18) State whether the following statements about the GRANT and REVOKE commands in MySQL are TRUE.
i. INSERT                ii. UPDATE
iii. SELECT             iv. ALTER
A. i, ii and iii only
B. ii, ii and iv only
C. i, iii and iv only
D. All i, ii, iii and iv

19) The table_level GRANT only supports which of the following privilege types.
i. INSERT               ii. UPDATE
iii. INDEX             iv. CREATE
A. i, ii and iii only
B. ii, ii and iv only
C. i, iii and iv only
D. All i, ii, iii and iv

20) Which of the following are the privileges concerning the use of resources that exist in the MySQL database.
i. max_connections            ii. min_connections
iii. max_questions             iv. max_updates
A. i, ii and iii only
B. ii, ii and iv only
C. i, iii and iv only
D. All i, ii, iii and iv

Answers:

1. C. i, iii and iv only
2. B. host
3. A. column_priv
4. D. All i, ii, iii and iv
5. C. SHOW PROCESSLIST
6. B. Execute_priv
7. A. Repl_slave_priv
8. C. Show_view_priv
9. C. db table
10. A. i-True, ii-True
11. C. i, iii and iv only
12. D. Table_priv
13. D. All i, ii, iii and iv
14. B. REPLICATION CLIENT
15. A. SUPER
16. C. i-False, ii-True
17. D. All i, ii and iii
18. A. i, ii and iii only
19. D. All i, ii, iii and iv
20. C. i, iii and iv only