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