MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 8 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_EXTENT_OF_THE_DATABASE_RESOURCE_THAT_IS_INCLUDED_WITH_EACH_LOCK_IS_CALLED_THE_LEVEL_OF?$ |
| A. | Impact |
| B. | Granularity |
| C. | Management |
| D. | DBMS control |
| Answer» C. Management | |
| 2. |
DBMS_periodically_suspends_all_processing_and_synchronizes_its_files_and_journals_through_the_use_of$ |
| A. | Checkpoint facility |
| B. | Backup facility |
| C. | Recovery manager |
| D. | Database change log |
| Answer» B. Backup facility | |
| 3. |
Which of the following is not true about B+ trees? |
| A. | B+ tree index takes the form of balanced tree |
| B. | Performance of B+ tree degrades as the file grows |
| C. | Look-up in B+ tree is straightforward and efficient |
| D. | Insertion and deletion in B+ tree is complicated but efficient |
| Answer» C. Look-up in B+ tree is straightforward and efficient | |
| 4. |
_______ means that data used during the execution of a transaction cannot be used by a second transaction until the first one is completed. |
| A. | Serializability |
| B. | Atomicity |
| C. | Isolation |
| D. | Time stamping |
| Answer» D. Time stamping | |
| 5. |
A condition that occurs when two transactions wait for each other to unlock data is known as a(n) |
| A. | Shared lock |
| B. | Exclusive lock |
| C. | Binary lock |
| D. | Deadlock |
| Answer» E. | |
| 6. |
A lock that prevents the use of any tables in the database from one transaction while another transaction is being processed is called a |
| A. | Database-level lock |
| B. | Table-level lock |
| C. | Page-level lock |
| D. | Row-level lock |
| Answer» B. Table-level lock | |
| 7. |
ANSI-standard SQL allows the use of special operators in conjunction with the WHERE clause. A special operator used to check whether an attribute value is null is |
| A. | BETWEEN |
| B. | IS NULL |
| C. | LIKE |
| D. | IN |
| Answer» C. LIKE | |
| 8. |
The most recent version of standard SQL prescribed by the American National Standards Institute is |
| A. | SQL 2016 |
| B. | SQL 2002 |
| C. | SQL – 4 |
| D. | SQL2 |
| Answer» B. SQL 2002 | |