MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 30 Mcqs, each offering curated multiple-choice questions to sharpen your Database knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
Incremental commitment does not allow a project to be easily redirected or to be terminated. |
| A. | 1 |
| B. | |
| Answer» C. | |
| 2. |
There are three stages involved when analyzing the initiation of an information systems project. |
| A. | 1 |
| B. | |
| Answer» C. | |
| 3. |
Functional decomposition is the process of breaking down the functions of an organization into greater levels of detail. |
| A. | 1 |
| B. | |
| Answer» B. | |
| 4. |
The longest step of database development is database maintenance. |
| A. | 1 |
| B. | |
| Answer» B. | |
| 5. |
With an enterprise data model, it is much easier to build applications because you know exactly what data exist and what needs to be added. |
| A. | 1 |
| B. | |
| Answer» B. | |
| 6. |
Packaged data models can reduce implementation times and costs. |
| A. | 1 |
| B. | |
| Answer» B. | |
| 7. |
The goal of information systems planning is to align information technology with the business strategies of the organization. |
| A. | 1 |
| B. | |
| Answer» B. | |
| 8. |
The physical database design identifies data integrity and security requirements. |
| A. | 1 |
| B. | |
| Answer» C. | |
| 9. |
The Enterprise tier of the three-tiered database architecture includes: |
| A. | managing the data. |
| B. | managing the User-system interface. |
| C. | processing HTTP protocol. |
| D. | processing scripting tasks. |
| Answer» B. managing the User-system interface. | |
| 10. |
One of the most popular systems development life cycle methods is prototyping. |
| A. | 1 |
| B. | |
| C. | 1 |
| D. | |
| Answer» B. | |
| 11. |
User views are included as part of which schema? |
| A. | Internal |
| B. | Conceptual |
| C. | External |
| D. | None of the above. |
| Answer» D. None of the above. | |
| 12. |
Which of the following database activities require a specific knowledge of a DBMS? |
| A. | Enterprise modeling |
| B. | Conceptual data modeling |
| C. | Logical database design |
| D. | Physical database design and definition |
| Answer» E. | |
| 13. |
A conceptual schema is usually depicted in graphical format using E-R or object-modeling notations. |
| A. | 1 |
| B. | |
| C. | 1 |
| D. | |
| Answer» B. | |
| 14. |
An entity type is which of the following? |
| A. | A major category of data about people, place, and things |
| B. | The various departments of an organization |
| C. | The application software |
| D. | The business processes the support the mission of an organization |
| Answer» B. The various departments of an organization | |
| 15. |
Whose role is it to determine the requirements and design for a database? |
| A. | Database analysts |
| B. | Database administrators |
| C. | Both A and B. |
| D. | Neither A or B. |
| Answer» B. Database administrators | |
| 16. |
The use of packaged data models can offer which of the following benefits? |
| A. | Reduce implementation time and costs |
| B. | Higher quality models |
| C. | Both A and B. |
| D. | Neither A nor B. |
| Answer» D. Neither A nor B. | |
| 17. |
In enterprise data modeling, which is incorrect? |
| A. | You review current systems. |
| B. | You implement the new database. |
| C. | You describe the data needed at a very high level of abstraction. |
| D. | You plan one or more database development projects. |
| Answer» C. You describe the data needed at a very high level of abstraction. | |
| 18. |
Enterprise data modeling typically occurs during information systems planning. |
| A. | 1 |
| B. | |
| Answer» B. | |
| 19. |
The systems development life cycle cannot be used with database implementation. |
| A. | 1 |
| B. | |
| Answer» C. | |
| 20. |
The most important reason for data architecture is reliability. |
| A. | 1 |
| B. | |
| Answer» C. | |
| 21. |
During logical database design, the conceptual data model is transformed into a logical data model which describes the data in terms of a specific data management technology. |
| A. | 1 |
| B. | |
| Answer» B. | |
| 22. |
Strategic Planning factors do not include which of the following? |
| A. | Organizational goals |
| B. | Critical success factors |
| C. | Information engineering |
| D. | Problem areas |
| Answer» D. Problem areas | |
| 23. |
The three-schema components include all, but: |
| A. | internal schema. |
| B. | conceptual schema. |
| C. | programming schema. |
| D. | external schema. |
| Answer» D. external schema. | |
| 24. |
The first step in database development is which of the following? |
| A. | Enterprise data modeling |
| B. | Logical database design |
| C. | Physical database design and definition |
| D. | Database Implementation |
| Answer» B. Logical database design | |
| 25. |
Which is not a relevant feature of CASE tools? |
| A. | The ability to help draw data models using entity-relationship notations |
| B. | The ability to generate code |
| C. | An information repository |
| D. | Access to a DB via the Internet |
| Answer» E. | |
| 26. |
CASE tools do not include which of the following features? |
| A. | Help to draw data models |
| B. | Help to generate code |
| C. | Help to manage people |
| D. | Create an information repository |
| Answer» D. Create an information repository | |
| 27. |
There is one physical schema for each logical schema. |
| A. | 1 |
| B. | |
| C. | 1 |
| D. | |
| Answer» B. | |
| 28. |
Which of the following database activities determines the entities, attributes, and relationships of data? |
| A. | Conceptual data modeling |
| B. | Logical database design |
| C. | Physical database design and definition |
| D. | Database implementation |
| Answer» B. Logical database design | |
| 29. |
Which is not a type of data management technology? |
| A. | Relational |
| B. | Rational |
| C. | Object-oriented |
| D. | Dimensional |
| Answer» C. Object-oriented | |
| 30. |
Which of the following database activities allow for the actual retrieval and use of a database? |
| A. | Enterprise modeling |
| B. | Logical database design |
| C. | Physical database design and definition |
| D. | Database implementation |
| Answer» E. | |