Database Design Chapters 9 – 12
Questions & Answers
What is the process that establishes the need for an information system and its extent?
- ANSWERSSystems analysis
Which of the following is NOT a factor of the performance of an information system?
a. Database management functions and features
b. Database design and implementation
c. Application design and implementation
d. Administrative procedures - ANSWERSDatabase management functions and
features
What is the primary objective in creating database design? - ANSWERSCreate
complete, normalized, nonredundant, and fully integrated conceptual, logical, and
physical database models.
What are the System Development Life Cycle phases? - ANSWERSPlanning, Analysis,
Design, Implementation, and Maintenance
The feasibility study must address all of the following except _____. - ANSWERSthe
technical aspects of hardware and software cost
The database can be loaded using which methods and devices? -
ANSWERSCustomized user programs, database interface programs, and conversion
programs that import the data from a different file structure
Which of the following is NOT true about the classical approaches to database design?
a. Top-down design first identifies entities and then defines the attributes within the
entities.
b. Top-down and bottom-up design methodologies are mutually exclusive.
c. A bottom-up approach may be more productive for small databases with few entities,
attributes, relations, and transactions.
d. Bottom-up design first defines attributes and then groups them into entities. -
ANSWERSTop-down and bottom-up design methodologies are mutually exclusive.
Identify the three steps of a physical design. - ANSWERSStorage, Security,
Performance
Which of the following is NOT a common factor for database management system
selection?
a. Features and tools
b. Cost
, c. Hardware requirements
d. Software requirements - ANSWERSSoftware requirements
Which of the following is NOT a benefit of business rules when designing a new
system?
a. Business rules eliminate the company's management problems.
b. Business rules constitute a communications tool between users and designers.
c. Business rules allow the designer to understand the nature, role, and scope of the
data.
d. Business rules allow the designer to understand business processes. -
ANSWERSBusiness rules eliminate the company's management problems.
Which of the following best defines a transaction? - ANSWERSA transaction is a logical
unit of work that must be entirely completed or entirely aborted.
Which of the following is not a transaction property?
a. Atomicity
b. Isolation
c. Consistency
d. Completeness - ANSWERSCompleteness
Which of the following is NOT an event to end a transaction?
a. Program is aborted.
b. New SQL statement is reached.
c. ROLLBACK statement is reached.
d. COMMIT statement is reached. - ANSWERSNew SQL statement is reached.
Which of the following best defines inconsistent retrievals? - ANSWERSA concurrency
control problem that arises when a transaction calculating summary functions over a set
of data while other transactions are updating the same retrieved data.
Which of the following is NOT a valid lock level?
a. Row lock level
b. Database lock level
c. Table lock level
d. Column lock level - ANSWERSColumn lock level
Which of the following statements best defines exclusive lock? - ANSWERSAn
exclusive lock exists when access is reserved specifically for the transaction that locked
the object.
When do deadlocks occur? - ANSWERSWhen two transactions wait indefinitely for
each other to unlock data
Which of the following allows dirty reads?
a. Serializable
Questions & Answers
What is the process that establishes the need for an information system and its extent?
- ANSWERSSystems analysis
Which of the following is NOT a factor of the performance of an information system?
a. Database management functions and features
b. Database design and implementation
c. Application design and implementation
d. Administrative procedures - ANSWERSDatabase management functions and
features
What is the primary objective in creating database design? - ANSWERSCreate
complete, normalized, nonredundant, and fully integrated conceptual, logical, and
physical database models.
What are the System Development Life Cycle phases? - ANSWERSPlanning, Analysis,
Design, Implementation, and Maintenance
The feasibility study must address all of the following except _____. - ANSWERSthe
technical aspects of hardware and software cost
The database can be loaded using which methods and devices? -
ANSWERSCustomized user programs, database interface programs, and conversion
programs that import the data from a different file structure
Which of the following is NOT true about the classical approaches to database design?
a. Top-down design first identifies entities and then defines the attributes within the
entities.
b. Top-down and bottom-up design methodologies are mutually exclusive.
c. A bottom-up approach may be more productive for small databases with few entities,
attributes, relations, and transactions.
d. Bottom-up design first defines attributes and then groups them into entities. -
ANSWERSTop-down and bottom-up design methodologies are mutually exclusive.
Identify the three steps of a physical design. - ANSWERSStorage, Security,
Performance
Which of the following is NOT a common factor for database management system
selection?
a. Features and tools
b. Cost
, c. Hardware requirements
d. Software requirements - ANSWERSSoftware requirements
Which of the following is NOT a benefit of business rules when designing a new
system?
a. Business rules eliminate the company's management problems.
b. Business rules constitute a communications tool between users and designers.
c. Business rules allow the designer to understand the nature, role, and scope of the
data.
d. Business rules allow the designer to understand business processes. -
ANSWERSBusiness rules eliminate the company's management problems.
Which of the following best defines a transaction? - ANSWERSA transaction is a logical
unit of work that must be entirely completed or entirely aborted.
Which of the following is not a transaction property?
a. Atomicity
b. Isolation
c. Consistency
d. Completeness - ANSWERSCompleteness
Which of the following is NOT an event to end a transaction?
a. Program is aborted.
b. New SQL statement is reached.
c. ROLLBACK statement is reached.
d. COMMIT statement is reached. - ANSWERSNew SQL statement is reached.
Which of the following best defines inconsistent retrievals? - ANSWERSA concurrency
control problem that arises when a transaction calculating summary functions over a set
of data while other transactions are updating the same retrieved data.
Which of the following is NOT a valid lock level?
a. Row lock level
b. Database lock level
c. Table lock level
d. Column lock level - ANSWERSColumn lock level
Which of the following statements best defines exclusive lock? - ANSWERSAn
exclusive lock exists when access is reserved specifically for the transaction that locked
the object.
When do deadlocks occur? - ANSWERSWhen two transactions wait indefinitely for
each other to unlock data
Which of the following allows dirty reads?
a. Serializable
