Physical Database Design The blocking factor is: attributes grouped together by the same secondary key. attributes grouped together by the same primary key. a group of fields stored in adjacent memory. the number of physical records per page. attributes grouped together by the same secondary key. attributes grouped together by the same primary key. a group of fields stored in adjacent memory. the number of physical records per page. ANSWER DOWNLOAD EXAMIANS APP
Physical Database Design Which of the following improves a query's processing time? Combine a table with itself. 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. 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. 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. All of these Limit the use of null values in some fields. 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 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 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? VARCHAR2 NUMBER LONG CHAR VARCHAR2 NUMBER LONG CHAR ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS