Physical Database Design The blocking factor is: attributes grouped together by the same secondary key. attributes grouped together by the same primary key. the number of physical records per page. a group of fields stored in adjacent memory. attributes grouped together by the same secondary key. attributes grouped together by the same primary key. the number of physical records per page. a group of fields stored in adjacent memory. ANSWER DOWNLOAD EXAMIANS APP
Physical Database Design The fastest read/write time and most efficient data storage of any disk array type is: RAID-0 RAID-3 RAID-1 RAID-2 RAID-0 RAID-3 RAID-1 RAID-2 ANSWER DOWNLOAD EXAMIANS APP
Physical Database Design 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. True False True False ANSWER DOWNLOAD EXAMIANS APP
Physical Database Design What is the best data type definition for Oracle when a field is alphanumeric and has a length that can vary? VARCHAR2 LONG CHAR NUMBER VARCHAR2 LONG CHAR NUMBER ANSWER DOWNLOAD EXAMIANS APP
Physical Database Design Distributing the columns of a table into several separate physical records is known as horizontal partitioning. False True False True ANSWER DOWNLOAD EXAMIANS APP
Physical Database Design Which of the following improves a query's processing time? Write complex queries. Use compatible data types. Query one query within another. Combine a table with itself. Write complex queries. Use compatible data types. Query one query within another. Combine a table with itself. ANSWER DOWNLOAD EXAMIANS APP