Physical Database Design - Database MCQ Questions and answers- Technical Aptitude Page-3 section-1

21.
When storage space is scarce and physical records cannot span pages, creating multiple physical records from one logical relation will minimize wasted storage space.

A. True

B. False

Answer & Solution Discuss in Board Save for Later

22.
A field represents each component of a composite attribute.

A. True

B. False

Answer & Solution Discuss in Board Save for Later

23.
Some advantages of partitioning include: efficiency, security, and load balancing.

A. True

B. False

Answer & Solution Discuss in Board Save for Later

24.
A pointer is a detailed coding scheme recognized by system software for representing organizational data.

A. True

B. False

Answer & Solution Discuss in Board Save for Later

25.
Distributing the columns of a table into several separate physical records is known as horizontal partitioning.

A. True

B. False

Answer & Solution Discuss in Board Save for Later

26.
An extent is a contiguous section of disk storage space.

A. True

B. False

Answer & Solution Discuss in Board Save for Later

27.
The three newest database architectures in use today are relational, multidimensional and hierarchical.

A. True

B. False

Answer & Solution Discuss in Board Save for Later

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

A. True

B. False

Answer & Solution Discuss in Board Save for Later

29.
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 & Solution Discuss in Board Save for Later

30.
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 & Solution Discuss in Board Save for Later

Physical Database Design - Database MCQ Questions and answers- Technical Aptitude

21. When storage space is scarce and physical records cannot span pages, creating multiple physical records from one logical relation will minimize wasted storage space.

Answer & Solution

22. A field represents each component of a composite attribute.

Answer & Solution

23. Some advantages of partitioning include: efficiency, security, and load balancing.

Answer & Solution

24. A pointer is a detailed coding scheme recognized by system software for representing organizational data.

Answer & Solution

25. Distributing the columns of a table into several separate physical records is known as horizontal partitioning.

Answer & Solution

26. An extent is a contiguous section of disk storage space.

Answer & Solution

27. The three newest database architectures in use today are relational, multidimensional and hierarchical.

Answer & Solution

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

Answer & Solution

29. 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.

Answer & Solution

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

Answer & Solution

21.
When storage space is scarce and physical records cannot span pages, creating multiple physical records from one logical relation will minimize wasted storage space.

22.
A field represents each component of a composite attribute.

23.
Some advantages of partitioning include: efficiency, security, and load balancing.

24.
A pointer is a detailed coding scheme recognized by system software for representing organizational data.

25.
Distributing the columns of a table into several separate physical records is known as horizontal partitioning.

26.
An extent is a contiguous section of disk storage space.

27.
The three newest database architectures in use today are relational, multidimensional and hierarchical.

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

29.
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.

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