Question 1
Question
1. Database designs that fail to recognize that the database is part of a larger information system are not likely to be successful.
Question 2
Question
2. Systems analysis is used to determine the need for an information system and to establish its limits.
Question 3
Question
3. The term “database development” is used to describe the process of database design and implementation.
Question 4
Question
4. The primary objective in database design is to create complete, denormalized, redundant, and fully integrated conceptual, logical, and physical database models.
Question 5
Question
5. The implementation phase of database design includes creating the database storage structure and loading the database, but does not provide for data management.
Question 6
Question
6. The SDLC traces the history of an information system.
Question 7
Question
7. The SDLC provides the big picture within which the database design and application development
can be mapped out and evaluated.
Question 8
Question
8. The SDLC's planning phase yields a general overview of the company and its objectives.
Question 9
Question
9. Problems defined during the planning phase are examined in greater detail during the analysis phase.
Question 10
Question
10. The existing hardware and software systems are studied during the planning phase.
Question 11
Question
11. The result of analysis should be a better understanding of the system's functional areas, actual and potential problems, and opportunities.
Question 12
Question
12. In the detailed systems design phase, the designer starts the design of the system's processes.
Question 13
Question
13. In the detailed systems design phase, steps are laid out for conversion from the old system to the new system.
Question 14
Question
14. Training principles and methodologies are planned during the implementation phase.
Question 15
Question
15. The detailed systems design phase includes all the necessary technical specifications for the screens, menus, reports, and other devices used to make the system more efficient.
Question 16
Question
16. During the implementation phase, the hardware, the DBMS software, and application programs are installed and the database design is implemented.
Question 17
Question
17. During the testing phase, the system is subjected to exhaustive testing until it is ready for use.
Question 18
Question
18. After testing is concluded, end-user training is not necessary.
Question 19
Question
19. Because every request for structural changes requires retracing the SDLC steps, the system is always
at some stage of the SDLC.
Question 20
Question
20. A system maintenance activity generated in response to changes in the business environment is referred to as corrective maintenance.
Question 21
Question
21. To analyze the company situation, the database designer must discover what the company's operational components are, how they function, and how they interact.
Question 22
Question
22. After the initial declarations in a study, the database designer must carefully probe in order to generate additional information that will help define the problem within the larger framework of company operations.
Question 23
Question
23. In most modern relational DBMSs, a new database implementation requires the creation of special
storage-related constructs to house the end-user tables.
Question 24
Question
24. Data integrity is enforced by the DBMS through the proper use of primary and foreign key rules.
Question 25
Question
25. The testing and evaluation phase occurs after applications programming
Question 26
Question
26. Database performance is one of the least important factors in all database implementations.
Question 27
Question
27. Performance evaluation is rendered more difficult by the fact that there are standard measurements
for database performance.
Question 28
Question
28. The database administrator must be prepared to perform routine maintenance activities within the
database
Question 29
Question
29. Physical design becomes simpler when data is distributed at different locations.
Question 30
Question
30. Decentralized design is typical of relatively simple and/or small databases and can be successfully
done by a single person.