MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 14 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 property of InnoDB that enforces foreign key relationships stay intact? |
| A. | atomicity |
| B. | durability |
| C. | consistency |
| D. | referential integrity |
| Answer» E. | |
| 2. |
The storage engine in MySQL that provides foreign key support is ___________ |
| A. | TRANSACTION |
| B. | InnoDB |
| C. | MyISAM |
| D. | MEMORY |
| Answer» C. MyISAM | |
| 3. |
What is the kind of delete when deletion of an employee from the table also deletes that employee from another table? |
| A. | transparent |
| B. | concrete |
| C. | elaborate |
| D. | cascaded |
| Answer» E. | |
| 4. |
The default value in seconds in the system variable ‘long_query_time’ is ______________ |
| A. | 5 |
| B. | 10 |
| C. | 20 |
| D. | 60 |
| Answer» C. 20 | |
| 5. |
THE_STORAGE_ENGINE_IN_MYSQL_THAT_PROVIDES_FOREIGN_KEY_SUPPORT_IS____________?$ |
| A. | TRANSACTION |
| B. | InnoDB |
| C. | MyISAM |
| D. | MEMORY |
| Answer» C. MyISAM | |
| 6. |
What_is_the_property_of_InnoDB_that_enforces_foreign_key_relationships_stay_intact?$ |
| A. | atomicity |
| B. | durability |
| C. | consistency |
| D. | referential integrity |
| Answer» E. | |
| 7. |
What is the kind of delete when deletion of an employee from table also deletes that employee from another table? |
| A. | transparent |
| B. | concrete |
| C. | elaborate |
| D. | cascaded |
| Answer» E. | |
| 8. |
The ALL subquery performs operations on _____________ |
| A. | row |
| B. | column |
| C. | table |
| D. | database |
| Answer» C. table | |
| 9. |
The operators that are used when a subquery returns multiple rows to be evaluated in comparison to the outer query are _____________ |
| A. | IN and NOT IN |
| B. | EXISTS and NOT EXISTS |
| C. | OUTER JOIN and INNER JOIN |
| D. | LEFT JOIN and RIGHT JOIN |
| Answer» B. EXISTS and NOT EXISTS | |
| 10. |
Usage of aggregates in WHERE clause is not allowed. |
| A. | True |
| B. | False |
| Answer» B. False | |
| 11. |
The logging option to enable binary log index file is ______________ |
| A. | –log-bin-index |
| B. | –bin-log-index |
| C. | –index-log-bin |
| D. | –index-bin-log |
| Answer» B. ‚Äö√Ñ√∂‚àö√ë‚àö¬®bin-log-index | |
| 12. |
The default value in seconds in the system variable ‘long_query_time’ is ______________$ |
| A. | 5 |
| B. | 10 |
| C. | 20 |
| D. | 60 |
| Answer» C. 20 | |
| 13. |
The log that identifies statements that may be in need of being rewritten for better performance is ______________ |
| A. | error log |
| B. | general query |
| C. | slow query log |
| D. | binary log |
| Answer» D. binary log | |
| 14. |
The log that contains a record of server startups and shutdowns and the messages about exceptional conditions is ______________ |
| A. | error log |
| B. | general query |
| C. | slow query log |
| D. | binary log |
| Answer» B. general query | |