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:
|
