Miguel Lucero
Quiz by , created more than 1 year ago

CIS 3365 Quiz on CHAPTER 9: DATABASE DESIGN, created by Miguel Lucero on 05/04/2017.

97
1
0
Miguel Lucero
Created by Miguel Lucero almost 9 years ago
Close

CHAPTER 9: DATABASE DESIGN

CHAPTER 9: DATABASE DESIGN

Question 1 of 61

1

1. Systems analysis establishes the need for an information system and its extent

Select one of the following:

  • True
  • False

Explanation

Question 2 of 61

1

2. The term “database development” is used to describe the process of database design and implementation.

Select one of the following:

  • True
  • False

Explanation

Question 3 of 61

1

3. The primary objective in database design is to create complete, normalized, nonredundant, and fully integrated conceptual, logical, and physical database models.

Select one of the following:

  • True
  • False

Explanation

Question 4 of 61

1

4. The implementation phase of database design includes creating the database storage structure and loading the database, but does not provide for data management.

Select one of the following:

  • True
  • False

Explanation

Question 5 of 61

1

5. The Systems Development Life Cycle (SDLC) traces the history of an information system.

Select one of the following:

  • True
  • False

Explanation

Question 6 of 61

1

6. The Systems Development Life Cycle (SDLC) provides the big picture within which the database design and application development can be mapped out and evaluated.

Select one of the following:

  • True
  • False

Explanation

Question 7 of 61

1

7. The Systems Development Life Cycle (SDLC) is a sequential process rather than an iterative process.

Select one of the following:

  • True
  • False

Explanation

Question 8 of 61

1

8. The Systems Development Life Cycle’s (SDLC’s) planning phase yields a general overview of the company and its objectives.

Select one of the following:

  • True
  • False

Explanation

Question 9 of 61

1

9. The result of analysis phase of the Systems Development Life Cycle (SDLC) should be a better understanding of the system’s functional areas, actual and potential problems, and opportunities.

Select one of the following:

  • True
  • False

Explanation

Question 10 of 61

1

10. In the Systems Development Life Cycle (SDLC), problems defined during the planning phase are examined in greater detail during the analysis phase.

Select one of the following:

  • True
  • False

Explanation

Question 11 of 61

1

11. The analysis phase of the Systems Development Life Cycle (SDLC) involves a cycle of coding, testing, and debugging.

Select one of the following:

  • True
  • False

Explanation

Question 12 of 61

1

12. In the Systems Development Life Cycle (SDLC), the design of the system’s processes begins in the detailed systems design phase.

Select one of the following:

  • True
  • False

Explanation

Question 13 of 61

1

13. In the detailed systems design phase of the Systems Development Life Cycle (SDLC), steps are laid out for the conversion of a database from an old system to a new system.

Select one of the following:

  • True
  • False

Explanation

Question 14 of 61

1

14. Training principles and methodologies are planned during the implementation phase of the Systems Development Life Cycle (SDLC).

Select one of the following:

  • True
  • False

Explanation

Question 15 of 61

1

15. The detailed systems design phase of the Systems Development Life Cycle (SDLC) includes all the necessary technical specifications for the screens, menus, reports, and other devices used to make the system more efficient.

Select one of the following:

  • True
  • False

Explanation

Question 16 of 61

1

16. During the implementation phase of the Systems Development Life Cycle (SDLC), the hardware, database management system (DBMS) software, and application programs are installed, and the database design is implemented.

Select one of the following:

  • True
  • False

Explanation

Question 17 of 61

1

17. The database contents might be loaded interactively or in batch mode using a variety of methods and devices including customized user programs.

Select one of the following:

  • True
  • False

Explanation

Question 18 of 61

1

18. The system is subjected to exhaustive testing during the testing phase of the Systems Development Life Cycle (SDLC).

Select one of the following:

  • True
  • False

Explanation

Question 19 of 61

1

19. In the Systems Development Life Cycle (SDLC), after testing is concluded, end-user training is not necessary.

Select one of the following:

  • True
  • False

Explanation

Question 20 of 61

1

20. A system is always at some stage of SDLC because every request for structural changes requires retracing the steps of the Systems Development Life Cycle (SDLC).

Select one of the following:

  • True
  • False

Explanation

Question 21 of 61

1

21. A system maintenance activity generated in response to changes in the business environment is referred to as corrective maintenance.

Select one of the following:

  • True
  • False

Explanation

Question 22 of 61

1

22. The overall purpose of the database initial study is to create the conceptual design.

Select one of the following:

  • True
  • False

Explanation

Question 23 of 61

1

23. To analyze the company situation, the database designer must discover what the company’s operational components are, how they function, and how they interact.

Select one of the following:

  • True
  • False

Explanation

Question 24 of 61

1

24. After the initial declarations in Database Life Cycle (DBLC), 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.

Select one of the following:

  • True
  • False

Explanation

Question 25 of 61

1

25. In most modern relational DBMSs, a new database implementation requires the creation of special storage-related constructs to house the end-user tables.

Select one of the following:

  • True
  • False

Explanation

Question 26 of 61

1

26. The assignment of access rights may restrict operations on predetermined objects such as databases, tables, views, queries, and reports.

Select one of the following:

  • True
  • False

Explanation

Question 27 of 61

1

27. Data integrity is enforced by the database management system (DBMS) through the proper use of primary and foreign key rules.

Select one of the following:

  • True
  • False

Explanation

Question 28 of 61

1

28. The testing and evaluation phase of the Database Life Cycle (DBLC) occurs after applications programming.

Select one of the following:

  • True
  • False

Explanation

Question 29 of 61

1

29. Database performance is one of the least important factors in all database implementations.

Select one of the following:

  • True
  • False

Explanation

Question 30 of 61

1

30. Evaluation of database performance is rendered easier by the fact there are no standards to measure it.

Select one of the following:

  • True
  • False

Explanation

Question 31 of 61

1

31. The main purpose of a backup is to guarantee database restoration following a hardware or software failure.

Select one of the following:

  • True
  • False

Explanation

Question 32 of 61

1

32. The database administrator must be prepared to perform routine maintenance activities within the database.

Select one of the following:

  • True
  • False

Explanation

Question 33 of 61

1

33. Physical design becomes simpler when data is distributed at different locations.

Select one of the following:

  • True
  • False

Explanation

Question 34 of 61

1

34. Decentralized design is typical of relatively simple, small databases and can be successfully done by a single person.

Select one of the following:

  • True
  • False

Explanation

Question 35 of 61

1

35. The process of creating an information system is known as .

Select one of the following:

  • a. systems development

  • b. database development

  • c. network development

  • d. enterprise development

Explanation

Question 36 of 61

1

36. The traditional Systems Development Life Cycle (SDLC) is divided into phases.

Select one of the following:

  • a. two

  • b. three

  • c. four

  • d. five

Explanation

Question 37 of 61

1

37. Discovery of user requirements, existing system evaluation, and logical system design are part of the phase of the Systems Development Life Cycle (SDLC).

Select one of the following:

  • a. planning

  • b. analysis

  • c. detailed systems design

  • d. implementation

Explanation

Question 38 of 61

1

38. Coding, testing, and debugging are part of the phase of the Systems Development Life Cycle (SDLC).

Select one of the following:

  • a. planning

  • b. analysis

  • c. detailed systems design

  • d. implementation

Explanation

Question 39 of 61

1

39. “Should the existing system be replaced?” is a question that is asked during the stage of the Systems Development Life Cycle (SDLC).

Select one of the following:

  • a. planning

  • b. analysis

  • c. implementation

  • d. maintenance

Explanation

Question 40 of 61

1

40. “What are the requirements of the current system’s end users?” is a question asked during the phase of the Systems Development Life Cycle (SDLC).

Select one of the following:

  • a. planning

  • b. analysis

  • c. implementation

  • d. maintenance

Explanation

Question 41 of 61

1

41. The feasibility study during the planning phase of the Systems Development Life Cycle (SDLC) must address the:

Select one of the following:

  • a. requirements of the current system’s end users.

  • b. problems and constraints related to the company situation.

  • c. questions about modification and replacement of existing system.

  • d. technical aspects of hardware and software requirements.

Explanation

Question 42 of 61

1

42. The logical systems design is created during the phase of the Systems Development Life Cycle (SDLC).

Select one of the following:

  • a. planning

  • b. analysis

  • c. implementation

  • d. maintenance

Explanation

Question 43 of 61

1

43. The database contents are loaded during the phase of the Systems Development Life Cycle (SDLC).

Select one of the following:

  • a. analysis

  • b. detailed systems design

  • c. implementation

  • d. maintenance

Explanation

Question 44 of 61

1

44. In DBLC, the phase after the database initial study is .

Select one of the following:

  • a. operation

  • b. database design

  • c. database initial study

  • d. implementation and loading

Explanation

Question 45 of 61

1

45. The implementation of applications tends to prolong the operational life of systems by making them easier to update and maintain.

Select one of the following:

  • a. database-produced

  • b. network-produced

  • c. CASE-produced

  • d. design-produced

Explanation

Question 46 of 61

1

46. The maintenance and evolution phase of the Database Life Cycle (DBLC) involves .

Select one of the following:

  • a. defining objectives

  • b. introducing changes

  • c. testing the database

  • d. installing the DBMS

Explanation

Question 47 of 61

1

47. Selecting database management system (DBMS) software is part of the phase of the Database Life Cycle (DBLC).

Select one of the following:

  • a. database initial study

  • b. database design

  • c. implementation and loading

  • d. testing and evaluation

Explanation

Question 48 of 61

1

48. Producing the required information flow is part of the phase of the Database Life Cycle (DBLC).

Select one of the following:

  • a. database initial study

  • b. database design

  • c. operation

  • d. testing and evaluation

Explanation

Question 49 of 61

1

49. is a technique that creates logical representations of computing resources that are independent of the underlying physical computing resources.

Select one of the following:

  • a. Normalization

  • b. Virtualization

  • c. Specialization

  • d. Generalization

Explanation

Question 50 of 61

1

50. The implementation and loading phase of the Database Life Cycle (DBLC) involves .

Select one of the following:

  • a. defining objectives

  • b. introducing changes

  • c. testing the database

  • d. installing the DBMS

Explanation

Question 51 of 61

1

51. In the context of the database design process, the conceptual design step that defines the fragmentation and allocation strategy is .

Select one of the following:

  • a. Database analysis and requirements

  • b. ER modeling and normalization

  • c. data model verification

  • d. distributed database design

Explanation

Question 52 of 61

1

52. In the context of the database design process, the conceptual design step that determines end-user views, outputs, and transaction-processing requirements is .

Select one of the following:

  • a. Data analysis and requirements

  • b. entity relationship modeling and normalization

  • c. data model verification

  • d. distributed data design

Explanation

Question 53 of 61

1

53. can render data useless to unauthorized users who might have violated some of the database security layers.

Select one of the following:

  • a. Data encryption

  • b. Access rights

  • c. Physical security

  • d. Password security

Explanation

Question 54 of 61

1

54. Once the data has been loaded into the database, the tests and fine-tunes the database for performance, integrity, concurrent access, and security constraints.

Select one of the following:

  • a. programmer

  • b. manager

  • c. database administrator

  • d. systems administrator

Explanation

Question 55 of 61

1

55. In a(n) , only the objects that have been updated or modified since the last full backup are backed up.

Select one of the following:

  • a. transaction log backup

  • b. conservative backup

  • c. differential backup

  • d. adaptive backup

Explanation

Question 56 of 61

1

56. Which of the following is a hardware-induced database failure?

Select one of the following:

  • a. memory chip errors

  • b. viruses

  • c. malware

  • d. abortion due to deadlock

Explanation

Question 57 of 61

1

57. The last step in the Database Life Cycle (DBLC) is .

Select one of the following:

  • a. maintenance and evolution

  • b. operation

  • c. testing and evaluation

  • d. implementation and loading

Explanation

Question 58 of 61

1

58. The first step in developing the conceptual model using ER diagrams is to .

Select one of the following:

  • a. normalize the entities

  • b. complete the initial ER diagram

  • c. identify, analyze, and refine the business rules

  • d. define the attributes, primary keys, and foreign keys for each of the entities

Explanation

Question 59 of 61

1

59. The first step in the ER model verification process is to .

Select one of the following:

  • a. identify each module and its components

  • b. identify the ER model’s central entity

  • c. verify all processes against the ER model

  • d. identify each module’s internal transaction requirements

Explanation

Question 60 of 61

1

60. is the process of determining the data storage organization and data access characteristics of the database to ensure its integrity, security, and performance.

Select one of the following:

  • a. Conceptual design

  • b. Network design

  • c. Logical design

  • d. Physical design

Explanation

Question 61 of 61

1

61. During decentralized design, after the has been completed, all modules are integrated into one conceptual model.

Select one of the following:

  • a. declaration process

  • b. verification process

  • c. conceptual process

  • d. logical process

Explanation

Previous
Next