Top

Physical Database Design

Answer: A

No answer description available for this question.

Enter details here

2.

Sequential retrieval on a primary key for sequential file storage has which of the following features?

Answer: A

No answer description available for this question. 

Enter details here

3.

The fastest read/write time and most efficient data storage of any disk array type is:

Answer: A

No answer description available for this question.

Enter details here

Answer: D

No answer description available for this question.

Enter details here

5.

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

Answer: B

No answer description available for this question.

Enter details here

6.

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

Answer: B

No answer description available for this question.

Enter details here

7.

Two basic constructs to link one piece of data with another piece of data: sequential storage and pointers.

Answer: A

No answer description available for this question. 

Enter details here

8.

What is the best data type definition for Oracle when a field is alphanumeric and has a fixed length?

Answer: A

No answer description available for this question. 

Enter details here

9.

Hashing algorithm converts a primary key value into a record address.

Answer: A

No answer description available for this question.

Enter details here

10.

If a denormalization situation exists with a many-to-many or associative binary relationship, which of the following is true?

Answer: B

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