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
(40)
The process of creating an information system is known as ____ development.
(Multiple Choice)
4.9/5
(39)
The conceptual design step that determines end-user views,outputs,and transaction-processing requirements is ____.
(Multiple Choice)
4.8/5
(29)
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
(33)
"Should the existing system be replaced?" is a question that is asked during the ____ stage of the SDLC.
(Multiple Choice)
4.9/5
(36)
The process of database design and implementation is ____ development.
(Multiple Choice)
4.9/5
(32)
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.7/5
(49)
The maintenance and evolution phase of the DBLC involves ____.
(Multiple Choice)
4.8/5
(30)
The initial assessment and the feasibility study are part of the SDLC's ____ phase.
(Multiple Choice)
4.9/5
(40)
Problems defined during the planning phase are examined in greater detail during the analysis phase.
(True/False)
4.7/5
(33)
The SDLC's planning phase yields a general overview of the company and its objectives.
(True/False)
4.7/5
(38)
Installation and fine tuning are part of the ____ phase of the SDLC.
(Multiple Choice)
4.8/5
(28)
The term "module ____________________" describes the extent to which modules are independent of one another.
(Short Answer)
4.7/5
(35)
During the implementation phase,the hardware,the DBMS software,and application programs are installed and the database design is implemented.
(True/False)
4.8/5
(33)
Training principles and methodologies are planned during the implementation phase.
(True/False)
4.7/5
(31)
Physical design becomes simpler when data is distributed at different locations.
(True/False)
4.9/5
(36)
The term "database development" is used to describe the process of database design and implementation.
(True/False)
4.8/5
(39)
Coding,testing,and debugging are part of the ____ phase of the SDLC.
(Multiple Choice)
4.9/5
(34)
The traditional SDLC phases are ____________________,analysis,detailed systems design,implementation and maintenance.
(Short Answer)
4.8/5
(38)
The designer must recognize the existence of two sets of limits: scope and ____________________.
(Short Answer)
4.9/5
(43)
Showing 21 - 40 of 100
Filters
- Essay(0)
- Multiple Choice(0)
- Short Answer(0)
- True False(0)
- Matching(0)