Physical Database Design The blocking factor is: the number of physical records per page. attributes grouped together by the same primary key. 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. a group of fields stored in adjacent memory. attributes grouped together by the same secondary key. ANSWER DOWNLOAD EXAMIANS APP
Physical Database Design Which of the following improves a query's processing time? Combine a table with itself. Query one query within another. Use compatible data types. Write complex queries. Combine a table with itself. Query one query within another. Use compatible data types. Write complex queries. ANSWER DOWNLOAD EXAMIANS APP
Physical Database Design Which of the following are integrity controls that a DBMS may support? Assume a default value in a field unless a user enters a value for that field. All of these Limit the use of null values in some fields. Limit the set of permissible values that a field may assume. Assume a default value in a field unless a user enters a value for that field. All of these Limit the use of null values in some fields. Limit the set of permissible values that a field may assume. 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 The number of columns Block contention Random row access speed The length of all of the fields in a table row The number of columns Block contention Random row access speed ANSWER DOWNLOAD EXAMIANS APP
Physical Database Design What is the best data type definition for Oracle when a field is alphanumeric and has a fixed length? NUMBER VARCHAR2 LONG CHAR NUMBER VARCHAR2 LONG CHAR ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS