Sequential retrieval on a primary key for sequential file storage has which of the following features? Moderately fast Slow Very fast Impractical TRUE ANSWER : ? YOUR ANSWER : ?
What is the best data type definition for Oracle when a field is alphanumeric and has a length that can vary? VARCHAR2 CHAR LONG NUMBER TRUE ANSWER : ? YOUR ANSWER : ?
Some advantages of partitioning include: efficiency, security, and load balancing. False True TRUE ANSWER : ? YOUR ANSWER : ?
The three newest database architectures in use today are relational, multidimensional and hierarchical. False True TRUE ANSWER : ? 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. True False TRUE ANSWER : ? YOUR ANSWER : ?
Which of the following is an advantage of partitioning? Complexity Extra space Inconsistent access speed Security TRUE ANSWER : ? 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. False True TRUE ANSWER : ? YOUR ANSWER : ?
The fastest read/write time and most efficient data storage of any disk array type is: RAID-0 RAID-2 RAID-3 RAID-1 TRUE ANSWER : ? YOUR ANSWER : ?
Denormalization and clustering can work well to minimize data access time for small records. True False TRUE ANSWER : ? YOUR ANSWER : ?
Hashing algorithm converts a primary key value into a record address. False True TRUE ANSWER : ? YOUR ANSWER : ?