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
During decentralized design,after the ____ process has been completed,all modules are integrated into one conceptual model.
(Multiple Choice)
4.9/5
(33)
The implementation of ____-produced applications tends to prolong the operational life of systems by making them easier to update and maintain.
(Multiple Choice)
4.9/5
(30)
In order to develop an accurate data ____________________,the designer must have a thorough understanding of the company's data types,extent,and uses.
(Short Answer)
4.8/5
(39)
The database initial study phase of the DBLC involves ____.
(Multiple Choice)
4.9/5
(36)
The detailed systems design phase includes all the necessary technical specifications for the screens,menus,reports,and other devices used to make the system more efficient.
(True/False)
4.9/5
(25)
Performance evaluation is rendered more difficult by the fact that there are standard measurements for database performance.
(True/False)
4.8/5
(42)
The first step in the ER model verification process is to ____.
(Multiple Choice)
4.9/5
(33)
____ coupling describes the extent to which modules are independent of one another.
(Multiple Choice)
4.8/5
(35)
The database administrator must be prepared to perform routine maintenance activities within the database.
(True/False)
4.8/5
(33)
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.8/5
(33)
The design of the system's processes is completed during the ____ phase of the SDLC.
(Multiple Choice)
4.8/5
(40)
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
(34)
Evaluation,maintenance,and enhancement are part of the ____ phase of the SDLC.
(Multiple Choice)
4.8/5
(42)
The conceptual design step that defines entities,attributes,and relationships is ____.
(Multiple Choice)
4.7/5
(40)
Because real-world database design is generally done by teams,you should strive to organize the design's major components into ____________________.
(Short Answer)
4.8/5
(36)
After testing is concluded,the final ____________________ is reviewed and printed and end users are trained.
(Short Answer)
5.0/5
(33)
Showing 61 - 80 of 100
Filters
- Essay(0)
- Multiple Choice(0)
- Short Answer(0)
- True False(0)
- Matching(0)