Discussion
Home ‣ Database ‣ Physical Database Design Comments
- Question
Two basic constructs to link one piece of data with another piece of data: sequential storage and pointers.
Options- A. True
- B. False
- Correct Answer
- True
- 1. Distributing the columns of a table into several separate physical records is known as horizontal partitioning.
Options- A. True
- B. False Discuss
- 2. Data-volume and frequency-of-use statistics are not critical inputs to the physical database design process.
Options- A. True
- B. False Discuss
- 3. 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
- 4. Some advantages of partitioning include: efficiency, security, and load balancing.
Options- A. True
- B. False Discuss
- 5. Hashing algorithm converts a primary key value into a record address.
Options- A. True
- B. False Discuss
- 6. Denormalization and clustering can work well to minimize data access time for small records.
Options- A. True
- B. False Discuss
- 7. An extent is a contiguous section of disk storage space.
Options- A. True
- B. False Discuss
- 8. A pointer is a detailed coding scheme recognized by system software for representing organizational data.
Options- A. True
- B. False Discuss
- 9. It is usually not very important to design the physical database to minimize the time required by users to interact with the information systems.
Options- A. True
- B. False Discuss
- 10. The primary goal of physical database design is data processing efficiency.
Options- A. True
- B. False Discuss
Physical Database Design problems
Search Results
Correct Answer: False
Correct Answer: False
Correct Answer: True
Correct Answer: True
Correct Answer: True
Correct Answer: True
Correct Answer: True
Correct Answer: False
Correct Answer: False
Correct Answer: True
Comments
There are no comments.More in Database:
Programming
Copyright ©CuriousTab. All rights reserved.