MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 7 Mcqs, each offering curated multiple-choice questions to sharpen your Database knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
IF_THE_STATE_OF_THE_DATABASE_NO_LONGER_REFLECTS_A_REAL_STATE_OF_THE_WORLD_THAT_THE_DATABASE_IS_SUPPOSED_TO_CAPTURE,_THEN_SUCH_A_STATE_IS_CALLED?$ |
| A. | Consistent state |
| B. | Parallel state |
| C. | Durable state |
| D. | Inconsistent state |
| Answer» E. | |
| 2. |
Ensuring isolation property is the responsibility of the$ |
| A. | Recovery-management component of the DBMS |
| B. | Concurrency-control component of the DBMS |
| C. | Transaction-management component of the DBMS |
| D. | Buffer management component in DBMS |
| Answer» C. Transaction-management component of the DBMS | |
| 3. |
A table can be logically connected to another table by defining ? |
| A. | Super key |
| B. | Candidate key |
| C. | Primary key |
| D. | Unique key |
| Answer» D. Unique key | |
| 4. |
Which of the following terms does refer to the correctness and completeness of the data in a database? |
| A. | Data security |
| B. | Data constraint |
| C. | Data independence |
| D. | Data integrity |
| Answer» E. | |
| 5. |
Which of the following are the process of selecting the data storage and data access characteristics of the database? |
| A. | Logical database design |
| B. | Physical database design |
| C. | Testing and performance tuning |
| D. | Evaluation and selecting |
| Answer» C. Testing and performance tuning | |
| 6. |
Which of the following is an attribute that can uniquely identify a row in a table? |
| A. | Secondary key |
| B. | Candidate key |
| C. | Foreign key |
| D. | Alternate key |
| Answer» C. Foreign key | |
| 7. |
Which of the following schemas does define a view or views of the database for particular users? |
| A. | Internal schema |
| B. | Conceptual schema |
| C. | Physical schema |
| D. | External schema |
| Answer» E. | |