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 What is the best data type definition for Oracle when a field is alphanumeric and has a length that can vary? LONG VARCHAR2 NUMBER CHAR LONG VARCHAR2 NUMBER CHAR ANSWER DOWNLOAD EXAMIANS APP
Physical Database Design A pointer is a detailed coding scheme recognized by system software for representing organizational data. True False True False ANSWER DOWNLOAD EXAMIANS APP
Physical Database Design A rule of thumb for choosing indexes for a relational database includes which of the following? Indexes are more useful for columns that do not appear frequently in the WHERE clause in queries. Indexes are more useful on smaller tables. Be careful indexing attributes that have null values. Do not specify a unique index for the primary key of each table. Indexes are more useful for columns that do not appear frequently in the WHERE clause in queries. Indexes are more useful on smaller tables. Be careful indexing attributes that have null values. Do not specify a unique index for the primary key of each table. 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. False True False True ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS