Physical Database Design Questions and Answers

Q: Data-volume and frequency-of-use statistics are not critical inputs to the physical database design process.

Correct answer: FalseData volumes and access frequencies are among the most critical inputs to physical design: they decide which tables are large enough to warrant indexing, which queries run often enough to be worth optimising for, and where the storage and contention will fall. Without them the design decisions are guesses.

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

Correct answer: FalseThe sizes are the other way round. Transaction processing touches few rows at a time and benefits from small blocks, which reduce contention and wasted transfer. Warehousing scans large ranges, so large blocks bring more useful data per read. The statement has the two applications exchanged.

Q: It is usually not very important to design the physical database to minimize the time required by users to interact with the information systems.

Correct answer: FalseResponse time as the user experiences it is very nearly the point of physical design. The logical design is already correct; what physical design adds is the indexing, organisation and placement that decide whether the system is usable, and user interaction time is the measure that matters most.

41.

Data-volume and frequency-of-use statistics are not critical inputs to the physical database design process.

A.True
B.False

Answer: B

Correct answer: False

Data volumes and access frequencies are among the most critical inputs to physical design: they decide which tables are large enough to warrant indexing, which queries run often enough to be worth optimising for, and where the storage and contention will fall. Without them the design decisions are guesses.

Discuss in Forum

42.

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.

A.True
B.False

Answer: B

Correct answer: False

The sizes are the other way round. Transaction processing touches few rows at a time and benefits from small blocks, which reduce contention and wasted transfer. Warehousing scans large ranges, so large blocks bring more useful data per read. The statement has the two applications exchanged.

Discuss in Forum

43.

It is usually not very important to design the physical database to minimize the time required by users to interact with the information systems.

A.True
B.False

Answer: B

Correct answer: False

Response time as the user experiences it is very nearly the point of physical design. The logical design is already correct; what physical design adds is the indexing, organisation and placement that decide whether the system is usable, and user interaction time is the measure that matters most.

Discuss in Forum

Loading…

Topics

Other Subjects

Tags: Physical Database Design Questions and Answers || Physical Database Design MCQ Questions and Answers || Physical Database Design GK Questions and Answers || Physical Database Design GK MCQ Questions || Physical Database Design Multiple Choice Questions and Answers || Physical Database Design GK || GK on Physical Database Design || Database Questions and Answers || Database MCQ Questions and Answers || Database GK Questions and Answers || GK on Database

Physical Database Design Questions and Answers

Topics

Other Subjects

About Us

Stay informed about all important Dates & Notifications