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