Physical Database Design MCQs with Explanations

All fields are stored in one relation. is the correct answer to “If a denormalization situation exists with a one-to-one binary relationship, which of the following is true”. This question is standard in competitive examination syllabi for Physical Database Design.

Improve data integrity is the correct answer to “Selecting a data type involves which of the following”. This question is standard in competitive examination syllabi for Physical Database Design.

VARCHAR2 is the correct answer to “What is the best data type definition for Oracle when a field is alphanumeric and has a length that can vary”. This question is standard in competitive examination syllabi for Physical Database Design.

All fields are stored in two relations. is the correct answer to “If a denormalization situation exists with a many-to-many or associative binary relationship, which of the following is true”. This question is standard in competitive examination syllabi for Physical Database Design.

Security is the correct answer to “Which of the following is an advantage of partitioning”. This question is standard in competitive examination syllabi for Physical Database Design.

the number of physical records per page. is the correct answer to “The blocking factor is:”. This question is standard in competitive examination syllabi for Physical Database Design.

Use compatible data types. is the correct answer to “Which of the following improves a query's processing time”. This question is standard in competitive examination syllabi for Physical Database Design.

All of the above. is the correct answer to “Which of the following are integrity controls that a DBMS may support”. This question is standard in competitive examination syllabi for Physical Database Design.

The number of columns is the correct answer to “Which of the following is not a factor to consider when switching from small to large block size”. This question is standard in competitive examination syllabi for Physical Database Design.

CHAR is the correct answer to “What is the best data type definition for Oracle when a field is alphanumeric and has a fixed length”. This question is standard in competitive examination syllabi for Physical Database Design.

Nonunique key is the correct answer to “A secondary key is which of the following”. This question is standard in competitive examination syllabi for Physical Database Design.

RAID-0 is the correct answer to “The fastest read/write time and most efficient data storage of any disk array type is:”. This question is standard in competitive examination syllabi for Physical Database Design.

Be careful indexing attributes that have null values. is the correct answer to “A rule of thumb for choosing indexes for a relational database includes which of the following”. This question is standard in competitive examination syllabi for Physical Database Design.

Very fast is the correct answer to “Sequential retrieval on a primary key for sequential file storage has which of the following features”. This question is standard in competitive examination syllabi for Physical Database Design.

Data warehouse is the correct answer to “A multidimensional database model is used most often in which of the following models”. This question is standard in competitive examination syllabi for Physical Database Design.

True is the correct answer to “Two basic constructs to link one piece of data with another piece of data: sequential storage and pointers.”. This question is standard in competitive examination syllabi for Physical Database Design.

True is the correct answer to “Denormalization and clustering can work well to minimize data access time for small records.”. This question is standard in competitive examination syllabi for Physical Database Design.

True is the correct answer to “Hashing algorithm converts a primary key value into a record address.”. This question is standard in competitive examination syllabi for Physical Database Design.

True is the correct answer to “The primary goal of physical database design is data processing efficiency.”. This question is standard in competitive examination syllabi for Physical Database Design.

False is the correct answer to “A bitmap index is an index on columns from two or more tables that come from the same domain of values.”. This question is standard in competitive examination syllabi for Physical Database Design.

True is the correct answer to “When storage space is scarce and physical records cannot span pages, creating multiple physical records from one logical relation will minimize wasted storage space.”. This question is standard in competitive examination syllabi for Physical Database Design.

True is the correct answer to “A field represents each component of a composite attribute.”. This question is standard in competitive examination syllabi for Physical Database Design.

True is the correct answer to “Some advantages of partitioning include: efficiency, security, and load balancing.”. This question is standard in competitive examination syllabi for Physical Database Design.

False is the correct answer to “A pointer is a detailed coding scheme recognized by system software for representing organizational data.”. This question is standard in competitive examination syllabi for Physical Database Design.

False is the correct answer to “Distributing the columns of a table into several separate physical records is known as horizontal partitioning.”. This question is standard in competitive examination syllabi for Physical Database Design.

True is the correct answer to “An extent is a contiguous section of disk storage space.”. This question is standard in competitive examination syllabi for Physical Database Design.

False is the correct answer to “The three newest database architectures in use today are relational, multidimensional and hierarchical.”. This question is standard in competitive examination syllabi for Physical Database Design.

False is the correct answer to “Data-volume and frequency-of-use statistics are not critical inputs to the physical database design process.”. This question is standard in competitive examination syllabi for Physical Database Design.

False is the correct answer to “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.”. This question is standard in competitive examination syllabi for Physical Database Design.

False is the correct answer to “It is usually not very important to design the physical database to minimize the time required by users to interact with the information systems.”. This question is standard in competitive examination syllabi for Physical Database Design.