Question 1 of 25
Hints left: 3
Q1
It is appropriate to use a supertype/subtype relationship when there are attributes that apply to some of the instances of an entity type.
Q2
Hashing algorithm converts a primary key value into a record address.
Q3
The fastest read/write time and most efficient data storage of any disk array type is:
Q4
A multidimensional database model is used most often in which of the following models?
Q5
If an entity adheres to the disjoint rule, then an entity instance can be a member of more than one entity for a given supertype.
Q6
If a denormalization situation exists with a one-to-one binary relationship, which of the following is true?
Q7
What is the best data type definition for Oracle when a field is alphanumeric and has a length that can vary?
Q8
Generalization is the process of defining more general entity types from a set of more specialized entity types.
Q9
What is the best data type definition for Oracle when a field is alphanumeric and has a fixed length?
Q10
A secondary key is which of the following?
Q11
If a denormalization situation exists with a many-to-many or associative binary relationship, which of the following is true?
Q12
Which of the following improves a query's processing time?
Q13
An entity cluster is a set of one or more entity types and associated relationships.
Q14
Which of the following is not a factor to consider when switching from small to large block size?
Q15
Selecting a data type involves which of the following?
Q16
Two basic constructs to link one piece of data with another piece of data: sequential storage and pointers.
Q17
Which of the following is an advantage of partitioning?
Q18
Sequential retrieval on a primary key for sequential file storage has which of the following features?
Q19
A rule of thumb for choosing indexes for a relational database includes which of the following?
Q20
The primary goal of physical database design is data processing efficiency.
Q21
Denormalization and clustering can work well to minimize data access time for small records.
Q22
Action assertions have traditionally been implemented within an application program.
Q23
Which of the following are integrity controls that a DBMS may support?
Q24
Total specialization is represented by double lines between the supertype and subtype on an EER.
Q25
The blocking factor is: