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 Which of the following improves a query's processing time? Write complex queries. Use compatible data types. Combine a table with itself. Query one query within another. Write complex queries. Use compatible data types. Combine a table with itself. Query one query within another. 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? 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 The length of all of the fields in a table row The number of columns Block contention 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? CHAR NUMBER VARCHAR2 LONG CHAR NUMBER VARCHAR2 LONG ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS