Ch. 9/A5

Question 1

1. "Should the existing system be replaced?" is a question that is asked during the
\_\_\_\_\_\_\_\_ stage of the SDLC.
a. planning
b. maintenance
c. analysis
d. implementation

Answer 1

a. planning

Question 2

2. Coding, testing, and debugging are part of the ________ phase of the SDLC.
   a. implementation
   b. planning
   c. analysis
   d. detailed systems design

Answer 2

a. implementation

Question 3

3. "What are the requirements of the current system's end users?" is a question asked
during the \_\_\_\_\_\_\_\_ phase of the SDLC.
a. analysis
b. planning
c. maintenance
d. implementation

Answer 3

a. analysis

Question 4

4. The logical systems design is created during the ________ phase of the SDLC.
   a. implementation
   b. maintenance
   c. analysis
   d. planning

Answer 4

c. analysis

Question 5

5. The last phase in the Database Life Cycle is ________.
   a. implementation and loading
   b. testing and evaluation
   c. maintenance and evolution
   d. operation

Answer 5

c. maintenance and evolution

Question 6

6. Installing the DBMS, creating the database, and loading or converting the data are
part of the \_\_\_\_\_\_\_\_ phase of the DBLC.
a. testing and evaluation
b. database initial study
c. database design
d. implementation and loading

Answer 6

d. implementation and loading

Question 7

7. Testing, fine-tuning, and evaluating the database and its applications are part of the
\_\_\_\_\_\_\_\_ phase of the DBLC.
a. database initial study
b. implementation and loading
c. testing and evaluation
d. database design

Answer 7

c. testing and evaluation

Question 8

8. Which of the conceptual design steps determines end-user views, outputs, and
   transaction-processing requirements?
   a. Database analysis and requirements
   b. Distributed database design
   c. Data model verification
   d. Entity relationship modeling and normalization

Answer 8

a. Database analysis and requirements

Question 9

9. Which of the conceptual design steps defines entities, attributes, and relationships?
   a. Distributed database design
   b. Entity relationship modeling and normalization
   c. Data model verification
   d. Database analysis and requirements

Answer 9

b. Entity relationship modeling and normalization

Question 10

10. The first step in developing the conceptual model using ER diagrams is to
    ________.
    a. identify, analyze, and refine the business rules
    b. complete the initial ER diagram
    c. define the attributes, primary keys, and foreign keys for each of the entities
    d. normalize the entities

Answer 10

a. identify, analyze, and refine the business rules

Question 11

11. During the Entity-Relationship modeling process, the designer must ________.
    a. avoid all ternary relationships
    b. delete the ER diagram
    c. make decisions about the placement of primary keys in 1:1 relationships
    d. make decisions about adding derived attributes to satisfy processing requirements

Answer 11

d. make decisions about adding derived attributes to satisfy processing requirements

Question 12

12. The first step in the ER model verification process is to ________.
    a. identify each module’s internal transaction requirements
    b. identify each module and its components
    c. identify the ER model’s central entity
    d. verify all processes against the ER model

Answer 12

c. identify the ER model’s central entity

Question 13

13. The ________ design is used to translate the conceptual design into the internal
    model for a selected database management system.
    a. logical
    b. physical
    c. network
    d. time

Answer 13

a. logical

Question 14

14. \_\_\_\_\_\_\_\_ design is the process of selecting the data storage and data access
characteristics of the database.
a. Logical
b. Physical
c. Time
d. Network

Answer 14

b. Physical

Question 15

15. Once the data have been loaded into the database, the ________ tests and finetunes
    the database to ensure that it performs as expected.
    a. database administrator
    b. systems administrator
    c. programmer
    d. manager

Answer 15

a. database administrator

Question 16

16. The assignment of ________ may restrict operations on predetermined objects such
    as databases, tables, views, queries and reports.
    a. password security
    b. audit trails
    c. diskless workstations
    d. access rights

Answer 16

d. access rights

Question 17

17. ________ are usually provided by the DBMS to check for access violations.
    a. Audit trails
    b. Diskless workstations
    c. Access rights
    d. Security devices

Answer 17

a. Audit trails

Question 18

18. Once the database has passed the evaluation stage, it is considered to be
\_\_\_\_\_\_\_\_.
a. finished
b. complete
c. secure
d. operational

Answer 18

d. operational

Question 19

19. Which activity in the SDLC is parallel to implementation and loading in the DBLC?
    a. analysis
    b. detailed design
    c. coding
    d. testing and evaluation

Answer 19

c. coding

Question 20

20. \_\_\_\_\_\_\_\_ design is productive when the data component is composed of a relatively
small number of objects and procedures.
a. Denormalized
b. Decentralized
c. Centralized
d. Normalized

Answer 20

c. Centralized