If a denormalization situation exists with a one-to-one binary relationship, which of the following is true?
Select an option to see the answer and solution.
Database · all questionsPhysical Database Design
Physical Database Design
practice.
Practice every MCQ with options. Use Show answers when you want the correct option and solution.
30
Questions
1/2
Page
Pick an option on a question to see the right answer and solution.
Selecting a data type involves which of the following?
Select an option to see the answer and solution.
What is the best data type definition for Oracle when a field is alphanumeric and has a length that can vary?
Select an option to see the answer and solution.
If a denormalization situation exists with a many-to-many or associative binary relationship, which of the following is true?
Select an option to see the answer and solution.
Which of the following is an advantage of partitioning?
Select an option to see the answer and solution.
The blocking factor is:
Select an option to see the answer and solution.
Which of the following improves a query's processing time?
Select an option to see the answer and solution.
Which of the following are integrity controls that a DBMS may support?
Select an option to see the answer and solution.
Which of the following is not a factor to consider when switching from small to large block size?
Select an option to see the answer and solution.
What is the best data type definition for Oracle when a field is alphanumeric and has a fixed length?
Select an option to see the answer and solution.
A secondary key is which of the following?
Select an option to see the answer and solution.
The fastest read/write time and most efficient data storage of any disk array type is:
Select an option to see the answer and solution.
A rule of thumb for choosing indexes for a relational database includes which of the following?
Select an option to see the answer and solution.
Sequential retrieval on a primary key for sequential file storage has which of the following features?
Select an option to see the answer and solution.
A multidimensional database model is used most often in which of the following models?
Select an option to see the answer and solution.
Two basic constructs to link one piece of data with another piece of data: sequential storage and pointers.
Select an option to see the answer and solution.
Denormalization and clustering can work well to minimize data access time for small records.
Select an option to see the answer and solution.
Hashing algorithm converts a primary key value into a record address.
Select an option to see the answer and solution.
The primary goal of physical database design is data processing efficiency.
Select an option to see the answer and solution.
A bitmap index is an index on columns from two or more tables that come from the same domain of values.
Select an option to see the answer and solution.