MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 9 Mcqs, each offering curated multiple-choice questions to sharpen your Database knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
THE_ORACLE_RDBMS_USES_THE______STATEMENT_TO_DECLARE_A_NEW_TRANSACTION_START_AND_ITS_PROPERTIES.?$ |
| A. | BEGIN |
| B. | SET TRANSACTION |
| C. | BEGIN TRANSACTION |
| D. | COMMIT |
| Answer» C. BEGIN TRANSACTION | |
| 2. |
____ means that the data used during the execution of a transaction cannot be used by a second transaction until the first one is completed.$ |
| A. | Consistency |
| B. | Atomicity |
| C. | Durability |
| D. | Isolation |
| Answer» E. | |
| 3. |
__________ states that only valid data will be written to the database. |
| A. | Consistency |
| B. | Atomicity |
| C. | Durability |
| D. | Isolation |
| Answer» B. Atomicity | |
| 4. |
The property of a transaction that persists all the crashes is |
| A. | Atomicity |
| B. | Durability |
| C. | Isolation |
| D. | All of the mentioned |
| Answer» C. Isolation | |
| 5. |
The database system must take special actions to ensure that transactions operate properly without interference from concurrently executing database statements. This property is referred to as |
| A. | Atomicity |
| B. | Durability |
| C. | Isolation |
| D. | All of the mentioned |
| Answer» D. All of the mentioned | |
| 6. |
Which of the following has “all-or-none” property?$ |
| A. | Atomicity |
| B. | Durability |
| C. | Isolation |
| D. | All of the mentioned |
| Answer» B. Durability | |
| 7. |
Identify the characteristics of transactions |
| A. | Atomicity |
| B. | Durability |
| C. | Isolation |
| D. | All of the mentioned |
| Answer» E. | |
| 8. |
A transaction is delimited by statements (or function calls) of the form __________ |
| A. | Begin transaction and end transaction |
| B. | Start transaction and stop transaction |
| C. | Get transaction and post transaction |
| D. | Read transaction and write transaction |
| Answer» B. Start transaction and stop transaction | |
| 9. |
Consider money is transferred from (1)account-A to account-B and (2) account-B to account-A. Which of the following form a transaction? |
| A. | Only 1 |
| B. | Only 2 |
| C. | Both 1 and 2 individually |
| D. | Either 1 or 2 |
| Answer» D. Either 1 or 2 | |