Multiple Choice
Which of the following is a valid consideration when implementing physical database design?
A) normalization diminishes database integrity
B) normalized views of the data improve query performance
C) all relationships should be explicitly defined in the database
D) it's best to use data types that require conversion
Correct Answer:
Verified
Correct Answer:
Verified
Q4: Which counter indicates the number of requests
Q5: List three query design guidelines that can
Q6: Which command takes corrective action on a
Q7: How does external fragmentation occur?
Q8: What is a deadlock and how does
Q10: A(n)_ is always created for the primary
Q11: Indexes prevent the database engine from having
Q12: Which of the following would you use
Q13: Which problem occurs when a concurrent process
Q14: _ indexes and indexed views should be