Discussion
Home ‣ Database ‣ Physical Database Design Comments
- Question
Data-volume and frequency-of-use statistics are not critical inputs to the physical database design process.
Options- A. True
- B. False
- Correct Answer
- False
- 1. When storage space is scarce and physical records cannot span pages, creating multiple physical records from one logical relation will minimize wasted storage space.
Options- A. True
- B. False Discuss
- 2. Some advantages of partitioning include: efficiency, security, and load balancing.
Options- A. True
- B. False Discuss
- 3. Hashing algorithm converts a primary key value into a record address.
Options- A. True
- B. False Discuss
- 4. A bitmap index is an index on columns from two or more tables that come from the same domain of values.
Options- A. True
- B. False Discuss
- 5. The three newest database architectures in use today are relational, multidimensional and hierarchical.
Options- A. True
- B. False Discuss
- 6. Distributing the columns of a table into several separate physical records is known as horizontal partitioning.
Options- A. True
- B. False Discuss
- 7. Two basic constructs to link one piece of data with another piece of data: sequential storage and pointers.
Options- A. True
- B. False Discuss
- 8. Denormalization and clustering can work well to minimize data access time for small records.
Options- A. True
- B. False Discuss
- 9. An extent is a contiguous section of disk storage space.
Options- A. True
- B. False Discuss
- 10. A pointer is a detailed coding scheme recognized by system software for representing organizational data.
Options- A. True
- B. False Discuss
Physical Database Design problems
Search Results
Correct Answer: True
Correct Answer: True
Correct Answer: True
Correct Answer: False
Correct Answer: False
Correct Answer: False
Correct Answer: True
Correct Answer: True
Correct Answer: True
Correct Answer: False
Comments
There are no comments.More in Database:
Programming
Copyright ©CuriousTab. All rights reserved.