MySQL Mock Test 7 - Sanfoundry

10%

Question 1 of 10

1. The statement used to find out which character sets are available is ______________

SHOW COLLATION

SHOW COLLATIONS

SHOW CHARACTER SET

SHOW CHARACTER SETS

Question 1 of 10

Question 2 of 10

2. Which system variable determines the number of rows from INSERT DELAYED statements that can be queued per table?

general_queue_size

slow_queue_size

fast_queue_size

delayed_queue_size

Question 2 of 10

Question 3 of 10

3. In which table of INFORMATION_SCHEMA is the information about table index characteristics stored?

SCHEMATA

VIEWS

STATISTICS

FILES

Question 3 of 10

Question 4 of 10

4. Which script initializes the data directory during installation?

mysql_install_db

mysql_install_dbm

mysql_init_db

mysql_init_dbm

Question 4 of 10

Question 5 of 10

5. Which upgrade involves shutting down the old MySQL version and replacing the old binaries?

system

logical

inplace

illogical

Question 5 of 10

Question 6 of 10

6. The system variable 'system_time_zone' can be reset at runtime.

False

True

Question 6 of 10

Question 7 of 10

7. The option which finds the startup options supported by the server through mysqld is ______________

--startup

--verbose

--shutdown

--vertex

Question 7 of 10

Question 8 of 10

8. abc in the following MySQL statement is ____________

CREATE VIEW xyz (abc) AS SELECT a FROM t;

database

column name

row name

view

Question 8 of 10

Question 9 of 10

9. The LOCAL capability for LOAD DATA does not need to be enabled explicitly.

True

False

Question 9 of 10

Question 10 of 10

10. The superuser account of the grant tables in the mysql database is called ______________

root

leaf

super

prime

Question 10 of 10