MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 11 Mcqs, each offering curated multiple-choice questions to sharpen your Mysql knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
The one that is not optional is _____________.SELECT select_list FROM table_list WHERE row_constraint GROUP BY grouping_columns; |
| A. | table_list |
| B. | grouping_columns |
| C. | select_list |
| D. | row_constraint |
| E. | None of these |
| Answer» D. row_constraint | |
| 2. |
The header that should be included first is ________________. |
| A. | mysql.h |
| B. | my_local.h |
| C. | my_global.h |
| D. | my_sys.h |
| E. | None of these |
| Answer» D. my_sys.h | |
| 3. |
The clause that is used to display information that matches a given pattern is _____________. |
| A. | LIKE |
| B. | WHERE |
| C. | IS |
| D. | SAME |
| E. | None of these |
| Answer» B. WHERE | |
| 4. |
The option that executes all SQL statements in a SQL script irrespective of the number of errors is _______________. |
| A. | force |
| B. | run |
| C. | violent |
| D. | ensure |
| E. | None of these |
| Answer» B. run | |
| 5. |
The operator that compares sounds is _____________. |
| A. | SOUNDS LIKE |
| B. | SOUNDS SIMILAR |
| C. | MATCH SOUNDS |
| D. | CHECK SOUNDS |
| E. | None of these |
| Answer» B. SOUNDS SIMILAR | |
| 6. |
The facility that allows nesting one select statement into another is ______________. |
| A. | subquerying |
| B. | encapsulating |
| C. | nesting |
| D. | binding |
| E. | None of these |
| Answer» B. encapsulating | |
| 7. |
The join in which all the rows from the right table appear in the output irrespective of the content of the other table is ______________. |
| A. | RIGHT JOIN |
| B. | CARTESIAN JOIN |
| C. | CROSS JOIN |
| D. | INNER JOIN |
| E. | None of these |
| Answer» B. CARTESIAN JOIN | |
| 8. |
The one that is not optional is _____________. |
| A. | table_list |
| B. | grouping_columns |
| C. | select_list |
| D. | row_constraint |
| E. | None of these |
| Answer» D. row_constraint | |
| 9. |
Which statement can produce the same output as SHOW COLUMNS ? |
| A. | GET |
| B. | SEE |
| C. | DISPLAY |
| D. | DESCRIBE |
| E. | None of these |
| Answer» E. None of these | |
| 10. |
The statement that alters an existing event to have the given definition is _____________. |
| A. | ALTER FUNCTION |
| B. | ALTER DATABASE |
| C. | ALTER EVENT |
| D. | ALTER DATABASE |
| E. | None of these |
| Answer» D. ALTER DATABASE | |
| 11. |
The server is told to accept spaces after function names by _____________. |
| A. | sql-mode=SPACE_SKIP |
| B. | sql-mode=SPACE_IGNORE |
| C. | sql-mode=SKIP_SPACE |
| D. | sql-mode=IGNORE_SPACE |
| E. | None of these |
| Answer» E. None of these | |