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
User requirements,existing system evaluation,and logical system design are part of the ____ phase of the SDLC.
(Multiple Choice)
4.9/5
(34)
In the detailed systems design phase,steps are laid out for conversion from the old system to the new system.
(True/False)
4.8/5
(32)
The ____ design is the process of selecting the data storage and data access characteristics of the database.
(Multiple Choice)
4.9/5
(30)
An initial assessment of the information flow-and-extent requirements must be made during the ____________________ portion of the SDLC.
(Short Answer)
4.9/5
(37)
A detailed system specification is part of the ____ phase of the SDLC.
(Multiple Choice)
4.9/5
(31)
____________________ is the process that establishes the need for,and the extent of,an information system.
(Short Answer)
4.8/5
(38)
In the detailed systems design phase,the designer starts the design of the system's processes.
(True/False)
4.9/5
(30)
The implementation phase of database design includes creating the database storage structure and loading the database,but does not provide for data management.
(True/False)
4.8/5
(30)
A(n)____________________ log backup backs up only the transaction log operations that are not reflected in a previous backup copy of the database.
(Short Answer)
4.9/5
(32)
The advent of very sophisticated application generators and ____________________ tools has substantially decreased coding and testing time.
(Short Answer)
5.0/5
(39)
The ____________________ design stage uses data modeling to create an abstract database structure that represents real-world objects in the most realistic way possible.
(Short Answer)
4.8/5
(28)
Creating the conceptual design and selecting DBMS software are part of the ____ phase of the DBLC.
(Multiple Choice)
4.9/5
(30)
The maintenance and evolution phase of the DBLC involves ____.
(Multiple Choice)
5.0/5
(39)
"Should the existing system be replaced?" is a question that is asked during the ____ stage of the SDLC.
(Multiple Choice)
4.7/5
(44)
During the testing phase,the system is subjected to exhaustive testing until it is ready for use.
(True/False)
4.8/5
(37)
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)
4.9/5
(33)
The conceptual design step that defines entities,attributes,and relationships is ____.
(Multiple Choice)
4.8/5
(33)
Showing 61 - 80 of 100
Filters
- Essay(0)
- Multiple Choice(0)
- Short Answer(0)
- True False(0)
- Matching(0)