MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 11 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 the statement used to select a default database? |
| A. | USE |
| B. | CREATE |
| C. | DROP |
| D. | SCHEMA |
| Answer» B. CREATE | |
| 2. |
What is the synonym for CHARACTER SET? |
| A. | CSET |
| B. | CHSET |
| C. | CHARSET |
| D. | CHCSET |
| Answer» D. CHCSET | |
| 3. |
The option that executes all SQL statements in a SQL script irrespective of the number of errors is ______________ |
| A. | –ensure |
| B. | –force |
| C. | –violent |
| D. | –run |
| Answer» C. –violent | |
| 4. |
WHAT_IS_THE_MAXIMUM_COLLATIONS_A_CHARACTER_SET_CAN_HAVE??$ |
| A. | 0 |
| B. | 1 |
| C. | 2 |
| D. | more than 1 |
| Answer» D. more than 1 | |
| 5. |
What_is_the_synonym_for_CHARACTER_SET?$ |
| A. | CSET |
| B. | CHSET |
| C. | CHARSET |
| D. | CHCSET |
| Answer» B. CHSET | |
| 6. |
The option that executes all SQL statements in a SQL script irrespective of the number of errors is _____________? |
| A. | –ensure |
| B. | –force |
| C. | –violent |
| D. | –run |
| Answer» E. | |
| 7. |
mysql_next_result() does not return. |
| A. | True |
| B. | False |
| Answer» C. | |
| 8. |
The data directory subdirectory that corresponds to the nbdinfo database is ______________ |
| A. | mysql |
| B. | performance_schema |
| C. | sys |
| D. | nbdinfo |
| Answer» C. sys | |
| 9. |
What is the maximum number of characters allowed for a database name to have? |
| A. | 16 |
| B. | 32 |
| C. | 64 |
| D. | 128 |
| Answer» D. 128 | |
| 10. |
In the database directory of the database each view and trigger object is associated with how many files? |
| A. | 0 |
| B. | 1 |
| C. | 2 |
| D. | 3 |
| Answer» C. 2 | |
| 11. |
Each database has a data directory located under database directory. |
| A. | True |
| B. | False |
| Answer» C. | |