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.

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: