MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 15 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. |
What is generally used as a synonym for CHARACTER SET? |
| A. | CSET |
| B. | CHSET |
| C. | CHARSET |
| D. | CHCSET |
| Answer» D. CHCSET | |
| 2. |
Post MySQL 6.0, utf8 was ___________ |
| A. | 3 bytes |
| B. | 4 bytes |
| C. | 5 bytes |
| D. | 6 bytes |
| Answer» C. 5 bytes | |
| 3. |
Prior to MySQL 6.0, utf8 was ___________ |
| A. | 3 bytes |
| B. | 4 bytes |
| C. | 8 bytes |
| D. | 9 bytes |
| Answer» B. 4 bytes | |
| 4. |
Which statement is used to show the server’s current character set and collation settings? |
| A. | SHOW CONSTANTS |
| B. | SHOW CONSTRAINTS |
| C. | SHOW VARIABLES |
| D. | DISP VARIABLES |
| Answer» D. DISP VARIABLES | |
| 5. |
Which collations does this MySQL statement list? |
| 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 | |
| 6. |
Which MySQL statement is used to find out which character sets are available? |
| A. | SHOW CHARACTER SET |
| B. | SHOW COLLATION |
| C. | SHOW CHARACTER SETS |
| D. | SHOW COLLATIONS |
| Answer» B. SHOW COLLATION | |
| 7. |
PRIOR_TO_MYSQL_6.0,_UTF8_WAS____________?$ |
| A. | 3 bytes |
| B. | 4 bytes |
| C. | 8 bytes |
| D. | 9 bytes |
| Answer» C. 8 bytes | |
| 8. |
Post_MySQL_6.0,_utf8_was____________$ |
| A. | 3 bytes |
| B. | 4 bytes |
| C. | 5 bytes |
| D. | 6 bytes |
| Answer» D. 6 bytes | |
| 9. |
What does UTF stand for int utf8? |
| A. | Universal Transformation Format |
| B. | Unicode Transformation Format |
| C. | Universal Transformation Formula |
| D. | Unicode Transformation Formula |
| Answer» B. Unicode Transformation Format | |
| 10. |
Which statement is used to show the server’s current character set and collation settings?$ |
| A. | SHOW CONSTANTS |
| B. | SHOW CONSTRAINTS |
| C. | SHOW VARIABLES |
| D. | DISP VARIABLES |
| Answer» C. SHOW VARIABLES | |
| 11. |
names beginning with utf8 |
| A. | names ending with utf8 |
| B. | names containing utf8% anywhere |
| C. | names ending in utf8% |
| Answer» D. | |
| 12. |
Which statement is used to find out which character sets are available? |
| A. | SHOW CHARACTER SET |
| B. | SHOW COLLATION |
| C. | SHOW CHARACTER SETS |
| D. | SHOW COLLATIONS |
| Answer» B. SHOW COLLATION | |
| 13. |
Which clause can be used to sort string values according to a specific collation? |
| A. | SORT |
| B. | GROUP |
| C. | FILTER |
| D. | COLLATE |
| Answer» E. | |
| 14. |
Unicode support is provided in MySQL. |
| A. | True |
| B. | False |
| Answer» B. False | |
| 15. |
What is the maximum collations a character set can have? |
| A. | 0 |
| B. | 1 |
| C. | 2 |
| D. | more than 1 |
| Answer» E. | |