Two basic constructs to link one piece of data with another piece of data: sequential storage and pointers. False True TRUE ANSWER : ? YOUR ANSWER : ?
Hashing algorithm converts a primary key value into a record address. False True 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 NUMBER CHAR LONG TRUE ANSWER : ? YOUR ANSWER : ?
The blocking factor is: a group of fields stored in adjacent memory. attributes grouped together by the same secondary key. the number of physical records per page. attributes grouped together by the same primary key. TRUE ANSWER : ? YOUR ANSWER : ?
The fastest read/write time and most efficient data storage of any disk array type is: RAID-2 RAID-0 RAID-3 RAID-1 TRUE ANSWER : ? YOUR ANSWER : ?
Distributing the columns of a table into several separate physical records is known as horizontal partitioning. False True TRUE ANSWER : ? YOUR ANSWER : ?
The primary goal of physical database design is data processing efficiency. True False TRUE ANSWER : ? YOUR ANSWER : ?
A bitmap index is an index on columns from two or more tables that come from the same domain of values. False True TRUE ANSWER : ? YOUR ANSWER : ?
Which of the following is not a factor to consider when switching from small to large block size? The length of all of the fields in a table row Block contention The number of columns Random row access speed TRUE ANSWER : ? YOUR ANSWER : ?
It is usually not very important to design the physical database to minimize the time required by users to interact with the information systems. True False TRUE ANSWER : ? YOUR ANSWER : ?