Kopieren und bearbeiten

CHAPTER 9: DATABASE DESIGN

Beschreibung

CIS 3365 Quiz am CHAPTER 9: DATABASE DESIGN, erstellt von Miguel Lucero am 05/04/2017.
Miguel Lucero
Quiz von Miguel Lucero, aktualisiert more than 1 year ago
Miguel Lucero
Erstellt von Miguel Lucero vor etwa 8 Jahre
88
1
0
1 2 3 4 5 (0)

Zusammenfassung der Ressource

Frage 1

Frage
1. Systems analysis establishes the need for an information system and its extent
Antworten
  • True
  • False

Frage 2

Frage
2. The term “database development” is used to describe the process of database design and implementation.
Antworten
  • True
  • False

Frage 3

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

Frage 4

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

Frage 5

Frage
5. The Systems Development Life Cycle (SDLC) traces the history of an information system.
Antworten
  • True
  • False

Frage 6

Frage
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.
Antworten
  • True
  • False

Frage 7

Frage
7. The Systems Development Life Cycle (SDLC) is a sequential process rather than an iterative process.
Antworten
  • True
  • False

Frage 8

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

Frage 9

Frage
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.
Antworten
  • True
  • False

Frage 10

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

Frage 11

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

Frage 12

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

Frage 13

Frage
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.
Antworten
  • True
  • False

Frage 14

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

Frage 15

Frage
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.
Antworten
  • True
  • False

Frage 16

Frage
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.
Antworten
  • True
  • False

Frage 17

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

Frage 18

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

Frage 19

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

Frage 20

Frage
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).
Antworten
  • True
  • False

Frage 21

Frage
21. A system maintenance activity generated in response to changes in the business environment is referred to as corrective maintenance.
Antworten
  • True
  • False

Frage 22

Frage
22. The overall purpose of the database initial study is to create the conceptual design.
Antworten
  • True
  • False

Frage 23

Frage
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.
Antworten
  • True
  • False

Frage 24

Frage
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.
Antworten
  • True
  • False

Frage 25

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

Frage 26

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

Frage 27

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

Frage 28

Frage
28. The testing and evaluation phase of the Database Life Cycle (DBLC) occurs after applications programming.
Antworten
  • True
  • False

Frage 29

Frage
29. Database performance is one of the least important factors in all database implementations.
Antworten
  • True
  • False

Frage 30

Frage
30. Evaluation of database performance is rendered easier by the fact there are no standards to measure it.
Antworten
  • True
  • False

Frage 31

Frage
31. The main purpose of a backup is to guarantee database restoration following a hardware or software failure.
Antworten
  • True
  • False

Frage 32

Frage
32. The database administrator must be prepared to perform routine maintenance activities within the database.
Antworten
  • True
  • False

Frage 33

Frage
33. Physical design becomes simpler when data is distributed at different locations.
Antworten
  • True
  • False

Frage 34

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

Frage 35

Frage
35. The process of creating an information system is known as .
Antworten
  • a. systems development
  • b. database development
  • c. network development
  • d. enterprise development

Frage 36

Frage
36. The traditional Systems Development Life Cycle (SDLC) is divided into phases.
Antworten
  • a. two
  • b. three
  • c. four
  • d. five

Frage 37

Frage
37. Discovery of user requirements, existing system evaluation, and logical system design are part of the phase of the Systems Development Life Cycle (SDLC).
Antworten
  • a. planning
  • b. analysis
  • c. detailed systems design
  • d. implementation

Frage 38

Frage
38. Coding, testing, and debugging are part of the phase of the Systems Development Life Cycle (SDLC).
Antworten
  • a. planning
  • b. analysis
  • c. detailed systems design
  • d. implementation

Frage 39

Frage
39. “Should the existing system be replaced?” is a question that is asked during the stage of the Systems Development Life Cycle (SDLC).
Antworten
  • a. planning
  • b. analysis
  • c. implementation
  • d. maintenance

Frage 40

Frage
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).
Antworten
  • a. planning
  • b. analysis
  • c. implementation
  • d. maintenance

Frage 41

Frage
41. The feasibility study during the planning phase of the Systems Development Life Cycle (SDLC) must address the:
Antworten
  • 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.

Frage 42

Frage
42. The logical systems design is created during the phase of the Systems Development Life Cycle (SDLC).
Antworten
  • a. planning
  • b. analysis
  • c. implementation
  • d. maintenance

Frage 43

Frage
43. The database contents are loaded during the phase of the Systems Development Life Cycle (SDLC).
Antworten
  • a. analysis
  • b. detailed systems design
  • c. implementation
  • d. maintenance

Frage 44

Frage
44. In DBLC, the phase after the database initial study is .
Antworten
  • a. operation
  • b. database design
  • c. database initial study
  • d. implementation and loading

Frage 45

Frage
45. The implementation of applications tends to prolong the operational life of systems by making them easier to update and maintain.
Antworten
  • a. database-produced
  • b. network-produced
  • c. CASE-produced
  • d. design-produced

Frage 46

Frage
46. The maintenance and evolution phase of the Database Life Cycle (DBLC) involves .
Antworten
  • a. defining objectives
  • b. introducing changes
  • c. testing the database
  • d. installing the DBMS

Frage 47

Frage
47. Selecting database management system (DBMS) software is part of the phase of the Database Life Cycle (DBLC).
Antworten
  • a. database initial study
  • b. database design
  • c. implementation and loading
  • d. testing and evaluation

Frage 48

Frage
48. Producing the required information flow is part of the phase of the Database Life Cycle (DBLC).
Antworten
  • a. database initial study
  • b. database design
  • c. operation
  • d. testing and evaluation

Frage 49

Frage
49. is a technique that creates logical representations of computing resources that are independent of the underlying physical computing resources.
Antworten
  • a. Normalization
  • b. Virtualization
  • c. Specialization
  • d. Generalization

Frage 50

Frage
50. The implementation and loading phase of the Database Life Cycle (DBLC) involves .
Antworten
  • a. defining objectives
  • b. introducing changes
  • c. testing the database
  • d. installing the DBMS

Frage 51

Frage
51. In the context of the database design process, the conceptual design step that defines the fragmentation and allocation strategy is .
Antworten
  • a. Database analysis and requirements
  • b. ER modeling and normalization
  • c. data model verification
  • d. distributed database design

Frage 52

Frage
52. In the context of the database design process, the conceptual design step that determines end-user views, outputs, and transaction-processing requirements is .
Antworten
  • a. Data analysis and requirements
  • b. entity relationship modeling and normalization
  • c. data model verification
  • d. distributed data design

Frage 53

Frage
53. can render data useless to unauthorized users who might have violated some of the database security layers.
Antworten
  • a. Data encryption
  • b. Access rights
  • c. Physical security
  • d. Password security

Frage 54

Frage
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.
Antworten
  • a. programmer
  • b. manager
  • c. database administrator
  • d. systems administrator

Frage 55

Frage
55. In a(n) , only the objects that have been updated or modified since the last full backup are backed up.
Antworten
  • a. transaction log backup
  • b. conservative backup
  • c. differential backup
  • d. adaptive backup

Frage 56

Frage
56. Which of the following is a hardware-induced database failure?
Antworten
  • a. memory chip errors
  • b. viruses
  • c. malware
  • d. abortion due to deadlock

Frage 57

Frage
57. The last step in the Database Life Cycle (DBLC) is .
Antworten
  • a. maintenance and evolution
  • b. operation
  • c. testing and evaluation
  • d. implementation and loading

Frage 58

Frage
58. The first step in developing the conceptual model using ER diagrams is to .
Antworten
  • 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

Frage 59

Frage
59. The first step in the ER model verification process is to .
Antworten
  • 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

Frage 60

Frage
60. is the process of determining the data storage organization and data access characteristics of the database to ensure its integrity, security, and performance.
Antworten
  • a. Conceptual design
  • b. Network design
  • c. Logical design
  • d. Physical design

Frage 61

Frage
61. During decentralized design, after the has been completed, all modules are integrated into one conceptual model.
Antworten
  • a. declaration process
  • b. verification process
  • c. conceptual process
  • d. logical process
Zusammenfassung anzeigen Zusammenfassung ausblenden

0 Kommentare

There are no comments, be the first and leave one below:

Möchten Sie mit GoConqr kostenlos Ihre eigenen Quiz erstellen? eigenen Mehr erfahren.

ähnlicher Inhalt

VOKABELN- Deutsch-Englisch
Helene Hanna
SB Soziale Ungleichheit
Bibische
GPSY PEPS
Simon Wirsching
4 Phasen der kognitiven Entwicklung nach Piaget
Lena S.
Pädagogik Abitur 2016: Piaget
Lena S.
Grundzüge Soziologischer Theorien - Rudolf Richter 2017 - Version 2
Markus Gio
Vetie - MiBi 2011
Fioras Hu
Vetie Allgemeine Pathologie Altklausur 2015
Tropsi B
Onlinequiz zu MS-4.2 kapitel II
Deborah Büscher
Vetie Reprospaß 3
Tropsi B
Bibliothek durchsuchen