MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 13 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. |
Which clause is used to sort query elements? |
| A. | GROUP |
| B. | GROUP BY |
| C. | ORDER |
| D. | ORDER BY |
| Answer» E. | |
| 2. |
What does comparing a known value with NULL result into? |
| A. | zero |
| B. | a positive value |
| C. | a negative value |
| D. | null |
| Answer» E. | |
| 3. |
The NULL value also means ___________ |
| A. | value equal to zero |
| B. | unknown value |
| C. | negative values |
| D. | a large value |
| Answer» C. negative values | |
| 4. |
Which operator is used to perform integer divisions in MySQL? |
| A. | / |
| B. | \ |
| C. | DIV |
| D. | // |
| Answer» D. // | |
| 5. |
What is ‘xyz’ in the following SQL statement? |
| A. | row name |
| B. | column name |
| C. | table name |
| D. | database nameView Answer |
| Answer» D. database nameView Answer | |
| 6. |
Identify the table name in the following SQL statement. |
| A. | Student |
| B. | Values |
| C. | Kyle |
| D. | MView Answer |
| Answer» B. Values | |
| 7. |
In the following SQL code, InnoDB is __________ |
| A. | database name |
| B. | table name |
| C. | reference engine |
| D. | storage engineView Answer |
| Answer» E. | |
| 8. |
What column names are displayed when this SQL command is executed? |
| A. | suffixed with ‘name’ |
| B. | prefixed with ‘name’ |
| C. | suffixed with ‘%name’ |
| D. | prefixed with ‘%name’View Answer |
| Answer» B. prefixed with ‘name’ | |
| 9. |
Studen? |
| A. | Values |
| B. | Kyle |
| C. | M |
| Answer» C. M | |
| 10. |
database name |
| A. | table name |
| B. | reference engine |
| C. | storage engine |
| Answer» D. | |
| 11. |
The special database that always exists after setting up MySQL in a computer is __________ |
| A. | sampdb |
| B. | mysql |
| C. | information_schema |
| D. | readme_db |
| Answer» E. | |
| 12. |
suffixed with ‘name’$ |
| A. | prefixed with ‘name’ |
| B. | suffixed with ‘%name’ |
| C. | prefixed with ‘%name’ |
| Answer» D. | |
| 13. |
Which of the following clauses is used to display information that match a given pattern? |
| A. | LIKE |
| B. | WHERE |
| C. | IS |
| D. | SAME |
| Answer» B. WHERE | |