MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 12 Mcqs, each offering curated multiple-choice questions to sharpen your Structured Query Language (SQL) knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
The collations this statement lists are ______________ |
| A. | names beginning with utf8 |
| B. | names ending with utf8 |
| C. | names containing utf8% anywhere |
| D. | names ending in utf8%View Answer |
| Answer» B. names ending with utf8 | |
| 2. |
The statement used to find out which character sets are available is ______________ |
| A. | SHOW CHARACTER SET |
| B. | SHOW COLLATION |
| C. | SHOW CHARACTER SETS |
| D. | SHOW COLLATIONS |
| Answer» B. SHOW COLLATION | |
| 3. |
The clause that can be used to sort string values according to a specific collation is ______________ |
| A. | SORT |
| B. | GROUP |
| C. | FILTER |
| D. | COLLATE |
| Answer» E. | |
| 4. |
The statement used to find out which character sets are available is _____________? |
| A. | SHOW CHARACTER SET |
| B. | SHOW COLLATION |
| C. | SHOW CHARACTER SETS |
| D. | SHOW COLLATIONS |
| Answer» B. SHOW COLLATION | |
| 5. |
The clause that can be used to sort string values according to a specific collation is _____________? |
| A. | SORT |
| B. | GROUP |
| C. | FILTER |
| D. | COLLATE |
| Answer» E. | |
| 6. |
The variable used to set table alias names as non case sensitive is ______________ |
| A. | lower_case_table_names |
| B. | lower_case_all |
| C. | lower_case_alias |
| D. | lower_case_aliases |
| Answer» B. lower_case_all | |
| 7. |
The case sensitive among these is ______________ |
| A. | Stored function name |
| B. | Stored procedure name |
| C. | Trigger name |
| D. | Event name |
| Answer» D. Event name | |
| 8. |
What does the default case sensitivity of database and table names depend on? |
| A. | SQL server |
| B. | Server SQL mode |
| C. | Operating system of machine |
| D. | Does not depend on anything |
| Answer» D. Does not depend on anything | |
| 9. |
For REVOKE statements, the server automatically rereads the grant tables. |
| A. | True |
| B. | False |
| Answer» B. False | |
| 10. |
Anonymous accounts have user name ______________ |
| A. | root |
| B. | blank |
| C. | super |
| D. | prime |
| Answer» C. super | |
| 11. |
Which script initializes the data directory during installation? |
| A. | mysql_install_db |
| B. | mysql_install_dbm |
| C. | mysql_init_db |
| D. | mysql_init_dbm |
| Answer» B. mysql_install_dbm | |
| 12. |
The superuser account of the grant tables in the mysql database is called ______________ |
| A. | super |
| B. | prime |
| C. | root |
| D. | leaf |
| Answer» D. leaf | |