Physical Database Design Distributing the columns of a table into several separate physical records is known as horizontal partitioning. True False True False ANSWER DOWNLOAD EXAMIANS APP
Physical Database Design Two basic constructs to link one piece of data with another piece of data: sequential storage and pointers. True False True False ANSWER DOWNLOAD EXAMIANS APP
Physical Database Design Selecting a data type involves which of the following? All of these Represent most values Maximize storage space Improve data integrity All of these Represent most values Maximize storage space Improve data integrity ANSWER DOWNLOAD EXAMIANS APP
Physical Database Design 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 Random row access speed The number of columns The length of all of the fields in a table row Block contention Random row access speed The number of columns ANSWER DOWNLOAD EXAMIANS APP
Physical Database Design Which of the following is an advantage of partitioning? Extra space Complexity Inconsistent access speed Security Extra space Complexity Inconsistent access speed Security ANSWER DOWNLOAD EXAMIANS APP
Physical Database Design Hashing algorithm converts a primary key value into a record address. True False True False ANSWER DOWNLOAD EXAMIANS APP