When storage space is scarce and physical records cannot span pages, creating multiple physical records from one logical relation will minimize wasted storage space.
Select an option to see the answer and solution.
Database · all questionsPhysical Database Design
Physical Database Design
practice.
Practice every MCQ with options. Use Show answers when you want the correct option and solution.
30
Questions
2/2
Page
Pick an option on a question to see the right answer and solution.
A field represents each component of a composite attribute.
Select an option to see the answer and solution.
Some advantages of partitioning include: efficiency, security, and load balancing.
Select an option to see the answer and solution.
A pointer is a detailed coding scheme recognized by system software for representing organizational data.
Select an option to see the answer and solution.
Distributing the columns of a table into several separate physical records is known as horizontal partitioning.
Select an option to see the answer and solution.
An extent is a contiguous section of disk storage space.
Select an option to see the answer and solution.
The three newest database architectures in use today are relational, multidimensional and hierarchical.
Select an option to see the answer and solution.
Data-volume and frequency-of-use statistics are not critical inputs to the physical database design process.
Select an option to see the answer and solution.
In general, larger block sizes are used for online transaction processing applications and smaller block sizes are used for databases with a decision support or data warehousing system.
Select an option to see the answer and solution.
It is usually not very important to design the physical database to minimize the time required by users to interact with the information systems.
Select an option to see the answer and solution.