EXAMIANS
Data-volume and frequency-of-use statistics are not critical inputs to the physical database design process.
YOUR ANSWER : ?
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 : ?
Two basic constructs to link one piece of data with another piece of data: sequential storage and pointers.
YOUR ANSWER : ?
Distributing the columns of a table into several separate physical records is known as horizontal partitioning.
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 multidimensional database model is used most often in which of the following models?
YOUR ANSWER : ?
Hashing algorithm converts a primary key value into a record address.
YOUR ANSWER : ?
The blocking factor is:
YOUR ANSWER : ?
Some advantages of partitioning include: efficiency, security, and load balancing.
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 : ?