Physical Database Design What is the best data type definition for Oracle when a field is alphanumeric and has a length that can vary? VARCHAR2 LONG NUMBER CHAR VARCHAR2 LONG NUMBER CHAR ANSWER DOWNLOAD EXAMIANS APP
Physical Database Design Denormalization and clustering can work well to minimize data access time for small records. True False True False ANSWER DOWNLOAD EXAMIANS APP
Physical Database Design Which of the following is an advantage of partitioning? Complexity Security Inconsistent access speed Extra space Complexity Security Inconsistent access speed Extra space 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 CHAR LONG NUMBER VARCHAR2 CHAR LONG ANSWER DOWNLOAD EXAMIANS APP
Physical Database Design When storage space is scarce and physical records cannot span pages, creating multiple physical records from one logical relation will minimize wasted storage space. False True False True 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. Query one query within another. Use compatible data types. Combine a table with itself. Write complex queries. Query one query within another. Use compatible data types. ANSWER DOWNLOAD EXAMIANS APP