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 purpose of an N-Ary association is:$ |
| A. | To capture a parent-child relationship |
| B. | To deal with one to many relationships |
| C. | To deal with relationships that involve more than two tables |
| D. | To represent an inheritance relationship |
| Answer» D. To represent an inheritance relationship | |
| 2. |
The database design that consists of multiple tables that are linked together through matching data stored in each table is calle? |
| A. | Hierarchical database |
| B. | Network database |
| C. | Object oriented database |
| D. | Relational database |
| Answer» E. | |
| 3. |
The traditional storage of data that is organized by customer, stored in separate folders in filing cabinets is an example of what type of ‘database’ system?$ |
| A. | Hierarchical |
| B. | Network |
| C. | Object oriented |
| D. | Relational |
| Answer» B. Network | |
| 4. |
In the client / server model, the database: |
| A. | Is downloaded to the client upon request |
| B. | Is shared by both the client and server |
| C. | Resides on the client side |
| D. | Resides on the server side |
| Answer» E. | |
| 5. |
The separation of the data definition from the program is known as: |
| A. | Data dictionary |
| B. | Data independence |
| C. | Data integrity |
| D. | Referential integrity |
| Answer» C. Data integrity | |
| 6. |
The property (or set of properties) that uniquely defines each row in a table is called the: |
| A. | Identifier |
| B. | Index |
| C. | Primary key |
| D. | Symmetric key |
| Answer» D. Symmetric key | |
| 7. |
What is the main limitation of Hierarchical Databases? |
| A. | Limited capacity (unable to hold much data) |
| B. | Limited flexibility in accessing data |
| C. | Overhead associated with maintaining indexes |
| D. | The performance of the database is poor |
| Answer» C. Overhead associated with maintaining indexes | |
| 8. |
A hash function must meet ________ criteria. |
| A. | Two |
| B. | Three |
| C. | Four |
| D. | None of the mentioned |
| Answer» C. Four | |
| 9. |
A(n) _________ can be used to preserve the integrity of a document or a message. |
| A. | Message digest |
| B. | Message summary |
| C. | Encrypted message |
| D. | None of the mentioned |
| Answer» D. None of the mentioned | |