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. |
The slow query log is written as __________ |
| A. | numbers |
| B. | text |
| C. | image |
| D. | graph |
| Answer» C. image | |
| 2. |
The slow query log can be used to identify queries that may be performing badly. |
| A. | True |
| B. | False |
| Answer» B. False | |
| 3. |
For a table having 4 columns, the number of columns to which hash function is applied when using hash indexes is __________ |
| A. | 1 |
| B. | 2 |
| C. | 3 |
| D. | 4 |
| Answer» E. | |
| 4. |
If a column contains 7 values and 6 distinct values, the cardinality is __________ |
| A. | 7 |
| B. | 6 |
| C. | 13 |
| D. | 1 |
| Answer» C. 13 | |
| 5. |
Suppose tbl_1 is a table consisting of 8 rows and tbl_2 is a table consisting of 6 rows, the number of combinations through which the search is performed is __________ |
| A. | 14 |
| B. | 2 |
| C. | 1 |
| D. | 48View Answer |
| Answer» E. | |
| 6. |
THE_SLOW_QUERY_LOG_CAN_BE_USED_TO_IDENTIFY_QUERIES_THAT_MAY_BE_PERFORMING_BADLY.?$ |
| A. | True |
| B. | False |
| Answer» C. | |
| 7. |
FOR_A_TABLE_HAVING_4_COLUMNS,_THE_NUMBER_OF_COLUMNS_TO_WHICH_HASH_FUNCTION_IS_APPLIED_WHEN_USING_HASH_INDEXES_IS___________?$ |
| A. | 1 |
| B. | 2 |
| C. | 3 |
| D. | 4 |
| Answer» B. 2 | |
| 8. |
If a column contains 7 values and 6 distinct values, the cardinality is _________? |
| A. | 7 |
| B. | 6 |
| C. | 13 |
| D. | 1 |
| Answer» E. | |
| 9. |
How many of the following shared tablespaces is bound by the OS file size limit? |
| A. | |
| B. | 0 |
| C. | 1 |
| Answer» C. 1 | |
| 10. |
In a single table (with 10 columns) join query the number of values needed to examine per column is __________ |
| A. | 1 |
| B. | 10 |
| C. | 0 |
| D. | 2 |
| Answer» C. 0 | |
| 11. |
The data rows of a MyISAM table are stored in __________ |
| A. | data file |
| B. | index file |
| C. | log file |
| D. | error file |
| Answer» B. index file | |
| 12. |
The maximum number of indexes on MyISAM table is __________ |
| A. | 0 |
| B. | 1 |
| C. | 2 |
| D. | more than 1 |
| Answer» E. | |
| 13. |
Using indexes optimizes query performance. |
| A. | True |
| B. | False |
| Answer» B. False | |