Top

Physical Database Design

21.

A multidimensional database model is used most often in which of the following models?

Answer: A

No answer description available for this question.

Enter details here

22.

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: B

No answer description available for this question.

Enter details here

Answer: D

No answer description available for this question.

Enter details here

24.

A bitmap index is an index on columns from two or more tables that come from the same domain of values

Answer: B

No answer description available for this question. 

Enter details here

25.

Which of the following is an advantage of partitioning?

Answer: D

No answer description available for this question.

Enter details here

26.

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: B

No answer description available for this question. 

Enter details here

27.

Selecting a data type involves which of the following?

Answer: C

No answer description available for this question.

Enter details here

28.

The primary goal of physical database design is data processing efficiency.

Answer: A

No answer description available for this question. 

Enter details here

29.

An extent is a contiguous section of disk storage space.

Answer: A

No answer description available for this question. 

Enter details here

Loading…
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