MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 23 Mcqs, each offering curated multiple-choice questions to sharpen your Database knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
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. | True |
| B. | False |
| Answer» B. False | |
| 2. |
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. | True |
| B. | False |
| Answer» B. False | |
| 3. |
Packaged data models can reduce implementation times and costs.%! |
| A. | True |
| B. | False |
| Answer» B. False | |
| 4. |
Enterprise data modeling typically occurs during information systems planning.%! |
| A. | True |
| B. | False |
| Answer» B. False | |
| 5. |
Functional decomposition is the process of breaking down the functions of an organization into greater levels of detail.%! |
| A. | True |
| B. | False |
| Answer» B. False | |
| 6. |
The systems development life cycle cannot be used with database implementation.%! |
| A. | True |
| B. | False |
| Answer» C. | |
| 7. |
The goal of information systems planning is to align information technology with the business strategies of the organization.%! |
| A. | True |
| B. | False |
| Answer» B. False | |
| 8. |
The most important reason for data architecture is reliability.%! |
| A. | True |
| B. | False |
| Answer» C. | |
| 9. |
One of the most popular systems development life cycle methods is prototyping.%! |
| A. | True |
| B. | False |
| Answer» B. False | |
| 10. |
There is one physical schema for each logical schema.%! |
| A. | True |
| B. | False |
| Answer» B. False | |
| 11. |
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 | |
| 12. |
*$_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 | |
| 13. |
*$_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 | |
| 14. |
*/*_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. | |
| 15. |
%_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. | |
| 16. |
%_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 | |
| 17. |
%_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. | |
| 18. |
__Which is not a type of data management technology?__ |
| A. | Relational |
| B. | Rational |
| C. | Object-oriented |
| D. | Dimensional |
| Answer» C. Object-oriented | |
| 19. |
__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. | |
| 20. |
__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. | |
| 21. |
The three-schema components include all, but:$? |
| A. | internal schema. |
| B. | conceptual schema. |
| C. | programming schema. |
| D. | external schema. |
| Answer» D. external schema. | |
| 22. |
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. | |
| 23. |
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. | |