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