Database - Physical Database Design

Exercise : Physical Database Design - General Questions
1.
If a denormalization situation exists with a one-to-one binary relationship, which of the following is true?
All fields are stored in one relation.
All fields are stored in two relations.
All fields are stored in three relations.
All fields are stored in four relations.
Answer: Option
Explanation:
No answer description is available. Let's discuss.

2.
Selecting a data type involves which of the following?
Maximize storage space
Represent most values
Improve data integrity
All of the above.
Answer: Option
Explanation:
No answer description is available. Let's discuss.

3.
What is the best data type definition for Oracle when a field is alphanumeric and has a length that can vary?
VARCHAR2
CHAR
LONG
NUMBER
Answer: Option
Explanation:
No answer description is available. Let's discuss.

4.
If a denormalization situation exists with a many-to-many or associative binary relationship, which of the following is true?
All fields are stored in one relation.
All fields are stored in two relations.
All fields are stored in three relations.
All fields are stored in four relations.
Answer: Option
Explanation:
No answer description is available. Let's discuss.

5.
Which of the following is an advantage of partitioning?
Complexity
Inconsistent access speed
Extra space
Security
Answer: Option
Explanation:
No answer description is available. Let's discuss.