EXAMIANS
The fastest read/write time and most efficient data storage of any disk array type is:
YOUR ANSWER : ?
YOUR ANSWER : ?
Denormalization and clustering can work well to minimize data access time for small records.
YOUR ANSWER : ?
What is the best data type definition for Oracle when a field is alphanumeric and has a length that can vary?
YOUR ANSWER : ?
A bitmap index is an index on columns from two or more tables that come from the same domain of values.
YOUR ANSWER : ?
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.
YOUR ANSWER : ?
Distributing the columns of a table into several separate physical records is known as horizontal partitioning.
YOUR ANSWER : ?
Hashing algorithm converts a primary key value into a record address.
YOUR ANSWER : ?
A rule of thumb for choosing indexes for a relational database includes which of the following?
YOUR ANSWER : ?
Data-volume and frequency-of-use statistics are not critical inputs to the physical database design process.
YOUR ANSWER : ?
Sequential retrieval on a primary key for sequential file storage has which of the following features?
YOUR ANSWER : ?