Database - Physical Database Design
Exercise :: Physical Database Design - General Questions
6. |
The blocking factor is: |
A. |
a group of fields stored in adjacent memory. | B. |
the number of physical records per page. | C. |
attributes grouped together by the same primary key. | D. |
attributes grouped together by the same secondary key. |
Answer: Option B
Explanation:
|
7. |
Which of the following improves a query's processing time? |
A. |
Write complex queries. | B. |
Combine a table with itself. | C. |
Query one query within another. | D. |
Use compatible data types. |
Answer: Option D
Explanation:
|
8. |
Which of the following are integrity controls that a DBMS may support? |
A. |
Assume a default value in a field unless a user enters a value for that field. | B. |
Limit the set of permissible values that a field may assume. | C. |
Limit the use of null values in some fields. | D. |
All of the above. |
Answer: Option D
Explanation:
|
9. |
Which of the following is not a factor to consider when switching from small to large block size? |
A. |
The length of all of the fields in a table row. | B. |
The number of columns | C. |
Block contention | D. |
Random row access speed |
Answer: Option B
Explanation:
|
10. |
What is the best data type definition for Oracle when a field is alphanumeric and has a fixed length? |
Answer: Option B
Explanation:
|