Physical Database Design What is the best data type definition for Oracle when a field is alphanumeric and has a length that can vary? NUMBER CHAR LONG VARCHAR2 NUMBER CHAR LONG VARCHAR2 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 LONG CHAR NUMBER VARCHAR2 LONG CHAR ANSWER DOWNLOAD EXAMIANS APP
Physical Database Design Distributing the columns of a table into several separate physical records is known as horizontal partitioning. True False True False ANSWER DOWNLOAD EXAMIANS APP
Physical Database Design Which of the following is an advantage of partitioning? Complexity Inconsistent access speed Extra space Security Complexity Inconsistent access speed Extra space Security ANSWER DOWNLOAD EXAMIANS APP
Physical Database Design Which of the following improves a query's processing time? Query one query within another. Use compatible data types. Write complex queries. Combine a table with itself. Query one query within another. Use compatible data types. Write complex queries. Combine a table with itself. ANSWER DOWNLOAD EXAMIANS APP
Physical Database Design An extent is a contiguous section of disk storage space. True False True False ANSWER DOWNLOAD EXAMIANS APP