Physical Database Design Questions

• A secondary key is which of the following?
• Selecting a data type involves which of the following?
• The blocking factor is:
• Which of the following is not a factor to consider when switching from small to large block size?
• If a denormalization situation exists with a one-to-one binary relationship, which of the following is true?
• Which of the following improves a query's processing time?
• If a denormalization situation exists with a many-to-many or associative binary relationship, which of the following is true?
• What is the best data type definition for Oracle when a field is alphanumeric and has a fixed length?
• Which of the following are integrity controls that a DBMS may support?
• The fastest read/write time and most efficient data storage of any disk array type is:
• A rule of thumb for choosing indexes for a relational database includes which of the following?
• What is the best data type definition for Oracle when a field is alphanumeric and has a length that can vary?
• Sequential retrieval on a primary key for sequential file storage has which of the following features?
• A multidimensional database model is used most often in which of the following models?
• Which of the following is an advantage of partitioning?
• 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.
• The three newest database architectures in use today are relational, multidimensional and hierarchical.
• A bitmap index is an index on columns from two or more tables that come from the same domain of values.
• Hashing algorithm converts a primary key value into a record address.
• Some advantages of partitioning include: efficiency, security, and load balancing.