MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 17 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. |
How many storage engines among the following are transaction-safe? |
| A. | 1 |
| B. | 2 |
| C. | 3 |
| D. | 4View Answer |
| Answer» E. | |
| 2. |
What is the durability property of transactions? |
| A. | statements form a logic unit |
| B. | database remains consistent |
| C. | one transaction does not affect the other |
| D. | transaction effects are recorded permanently |
| Answer» C. one transaction does not affect the other | |
| 3. |
Transactional processing requires lesser overhead due to CPU cycles and memory. |
| A. | True |
| B. | False |
| Answer» B. False | |
| 4. |
Transactional processing provides strong guarantees about the outcome of operations. |
| A. | True |
| B. | False |
| Answer» C. | |
| 5. |
What does ‘C’ stand for in the ACID property of transactions? |
| A. | Compound |
| B. | Concrete |
| C. | Collision |
| D. | Consistency |
| Answer» E. | |
| 6. |
What does ‘A’ stand for in the ACID property of transactions? |
| A. | Availability |
| B. | Accuracy |
| C. | Adjustability |
| D. | Atomicity |
| Answer» E. | |
| 7. |
What is known as the set of SQL statements that either executes successfully or none of them have an effect? |
| A. | joins |
| B. | transactions |
| C. | filters |
| D. | deletions |
| Answer» C. filters | |
| 8. |
WHAT_IS_THE_DURABILITY_PROPERTY_OF_TRANSACTIONS??$ |
| A. | statements form a logic unit |
| B. | database remains consistent |
| C. | one transaction does not affect the other |
| D. | transaction effects are recorded permanently |
| Answer» E. | |
| 9. |
TRANSACTIONAL_PROCESSING_REQUIRES_LESSER_OVERHEAD_DUE_TO_CPU_CYCLES_AND_MEMORY.?$ |
| A. | True |
| B. | False |
| Answer» C. | |
| 10. |
How many storage engines among the following are transaction-safe?$ |
| A. | |
| B. | 1 |
| C. | 2 |
| Answer» C. 2 | |
| 11. |
Transactional processing provides strong guarantees about the outcome of operations? |
| A. | True |
| B. | False |
| Answer» B. False | |
| 12. |
What is the command to disable autocommit and launch a transaction? |
| A. | INITIATE TRANSACTION |
| B. | START TRANSACTION |
| C. | DISABLE AUTOCOMMIT |
| D. | TRANSACTION |
| Answer» C. DISABLE AUTOCOMMIT | |
| 13. |
What is the isolation property of transactions? |
| A. | statements form a logic unit |
| B. | database remains consistent |
| C. | one transaction does not affect the other |
| D. | transaction effects are recorded permanently |
| Answer» D. transaction effects are recorded permanently | |
| 14. |
What does ‘A’ stand for in the ACID property of transactions?$ |
| A. | Availability |
| B. | Accuracy |
| C. | Adjustability |
| D. | Atomicity |
| Answer» E. | |
| 15. |
What is generally done if an error occurs during the transaction? |
| A. | delete |
| B. | rollback |
| C. | commit |
| D. | update |
| Answer» C. commit | |
| 16. |
What is generally done after the transactions are executed successfully? |
| A. | delete |
| B. | rollback |
| C. | commit |
| D. | update |
| Answer» D. update | |
| 17. |
What is known as the set of SQL statements that either execute successfully or none of them have an effect. |
| A. | joins |
| B. | transactions |
| C. | filters |
| D. | deletions |
| Answer» C. filters | |