Exam 9: Database Design
Exam 1: Database Systems70 Questions
Exam 2: Data Models70 Questions
Exam 3: The Relational Database Model100 Questions
Exam 4: Entity Relationship (ER)Modeling100 Questions
Exam 5: Advanced Data Modeling70 Questions
Exam 6: Normalization of Database Tables100 Questions
Exam 7: Introduction to Structured Query Language (SQL)100 Questions
Exam 8: Advanced SQL100 Questions
Exam 9: Database Design100 Questions
Exam 10: Transaction Management and Concurrency Control70 Questions
Exam 11: Database Performance Tuning and Query Optimization70 Questions
Exam 12: Distributed Database Management Systems70 Questions
Exam 13: Business Intelligence and Data Warehouses100 Questions
Exam 14: Database Connectivity and Web Technologies100 Questions
Exam 15: Database Administration and Security100 Questions
Select questions type
An initial assessment of the information flow-and-extent requirements must be made during the ____________________ portion of the SDLC.
(Short Answer)
4.8/5
(89)
The process of creating an information system is known as ____ development.
(Multiple Choice)
4.9/5
(82)
The conceptual design step that determines end-user views,outputs,and transaction-processing requirements is ____.
(Multiple Choice)
4.8/5
(78)
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.
(True/False)
5.0/5
(83)
"Should the existing system be replaced?" is a question that is asked during the ____ stage of the SDLC.
(Multiple Choice)
4.9/5
(87)
The process of database design and implementation is ____ development.
(Multiple Choice)
4.8/5
(72)
Database designs that fail to recognize that the database is part of a larger information system are not likely to be successful.
(True/False)
4.8/5
(92)
The maintenance and evolution phase of the DBLC involves ____.
(Multiple Choice)
4.8/5
(81)
The initial assessment and the feasibility study are part of the SDLC's ____ phase.
(Multiple Choice)
5.0/5
(95)
Problems defined during the planning phase are examined in greater detail during the analysis phase.
(True/False)
4.7/5
(83)
The SDLC's planning phase yields a general overview of the company and its objectives.
(True/False)
4.7/5
(85)
Installation and fine tuning are part of the ____ phase of the SDLC.
(Multiple Choice)
4.8/5
(82)
The term "module ____________________" describes the extent to which modules are independent of one another.
(Short Answer)
4.8/5
(80)
During the implementation phase,the hardware,the DBMS software,and application programs are installed and the database design is implemented.
(True/False)
4.7/5
(80)
Training principles and methodologies are planned during the implementation phase.
(True/False)
4.8/5
(82)
Physical design becomes simpler when data is distributed at different locations.
(True/False)
4.8/5
(78)
The term "database development" is used to describe the process of database design and implementation.
(True/False)
4.8/5
(86)
Coding,testing,and debugging are part of the ____ phase of the SDLC.
(Multiple Choice)
4.9/5
(80)
The traditional SDLC phases are ____________________,analysis,detailed systems design,implementation and maintenance.
(Short Answer)
4.8/5
(77)
The designer must recognize the existence of two sets of limits: scope and ____________________.
(Short Answer)
4.9/5
(96)
Showing 21 - 40 of 100
Filters
- Essay(0)
- Multiple Choice(0)
- Short Answer(0)
- True False(0)
- Matching(0)