Exam 9: Database Design
Exam 1: Database Systems75 Questions
Exam 2: Data Models75 Questions
Exam 3: The Relational Database Model75 Questions
Exam 4: Entity Relationship Er Modeling75 Questions
Exam 5: Advanced Data Modeling75 Questions
Exam 6: Normalization of Database Tables75 Questions
Exam 7: Introduction to Structured Query Language Sql75 Questions
Exam 8: Advanced Sql75 Questions
Exam 9: Database Design75 Questions
Exam 10: Transaction Management and Concurrency Control74 Questions
Exam 11: Database Performance Tuning and Query Optimization75 Questions
Exam 12: Distributed Database Management Systems74 Questions
Exam 13: Business Intelligence and Data Warehouses74 Questions
Exam 14: Big Data and Nosql75 Questions
Exam 15: Database Connectivity and Web Technologies73 Questions
Exam 16: Database Administration and Security74 Questions
Select questions type
In a(n) _____, only the objects that have been updated or modified since the last full backup are backed up.
Free
(Multiple Choice)
4.9/5
(30)
Correct Answer:
C
The maintenance and evolution phase of the Database Life Cycle (DBLC) involves _____.
Free
(Multiple Choice)
4.8/5
(38)
Correct Answer:
B
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).
Free
(True/False)
4.7/5
(30)
Correct Answer:
True
The analysis phase of the Systems Development Life Cycle (SDLC) involves a cycle of coding, testing, and debugging.
(True/False)
4.8/5
(31)
The implementation and loading phase of the Database Life Cycle (DBLC) involves _____.
(Multiple Choice)
4.7/5
(38)
The logical systems design is created during the _____ phase of the Systems Development Life Cycle (SDLC).
(Multiple Choice)
4.9/5
(38)
"Should the existing system be replaced?" is a question that is asked during the _____ stage of the Systems Development Life Cycle (SDLC).
(Multiple Choice)
4.8/5
(38)
_____ is the process of determining the data storage organization and data access characteristics of the database to ensure its integrity, security, and performance.
(Multiple Choice)
4.7/5
(38)
Systems analysis establishes the need for an information system and its extent.
(True/False)
4.8/5
(30)
The Systems Development Life Cycle (SDLC) is a sequential process rather than an iterative process.
(True/False)
4.8/5
(43)
The traditional Systems Development Life Cycle (SDLC) phases are _____, analysis, detailed systems design, implementation, and maintenance.
(Short Answer)
4.7/5
(38)
In DBLC, the phase after the database initial study is _____.
(Multiple Choice)
4.7/5
(32)
_____ is a technique that creates logical representations of computing resources that are independent of the underlying physical computing resources.
(Multiple Choice)
4.7/5
(32)
Evaluation of database performance is rendered easier by the fact there are no standards to measure it.
(True/False)
4.9/5
(37)
_____ can render data useless to unauthorized users who might have violated some of the database security layers.
(Multiple Choice)
4.9/5
(42)
A(n) _____ is a carefully designed and constructed repository of facts that is a part of a larger whole known as an information system.
(Short Answer)
4.8/5
(40)
_____ allow end users to access the database without being able to download the information from their workstations.
(Short Answer)
4.9/5
(45)
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.
(True/False)
4.9/5
(38)
Because real-world database design is generally done by teams, the database design is probably divided into major components known as _____.
(Short Answer)
4.8/5
(30)
Showing 1 - 20 of 75
Filters
- Essay(0)
- Multiple Choice(0)
- Short Answer(0)
- True False(0)
- Matching(0)