EXAMIANS
Denormalization and clustering can work well to minimize data access time for small records.
YOUR ANSWER : ?
YOUR ANSWER : ?
Data-volume and frequency-of-use statistics are not critical inputs to the physical database design process.
YOUR ANSWER : ?
What is the best data type definition for Oracle when a field is alphanumeric and has a fixed length?
YOUR ANSWER : ?
A multidimensional database model is used most often in which of the following models?
YOUR ANSWER : ?
When storage space is scarce and physical records cannot span pages, creating multiple physical records from one logical relation will minimize wasted storage space.
YOUR ANSWER : ?
A field represents each component of a composite attribute.
YOUR ANSWER : ?
Hashing algorithm converts a primary key value into a record address.
YOUR ANSWER : ?
Sequential retrieval on a primary key for sequential file storage has which of the following features?
YOUR ANSWER : ?
Which of the following improves a query's processing time?
YOUR ANSWER : ?
Distributing the columns of a table into several separate physical records is known as horizontal partitioning.
YOUR ANSWER : ?