Two basic constructs to link one piece of data with another piece of data: sequential storage and pointers. True False TRUE ANSWER : ? YOUR ANSWER : ?
What is the best data type definition for Oracle when a field is alphanumeric and has a fixed length? LONG VARCHAR2 CHAR NUMBER TRUE ANSWER : ? YOUR ANSWER : ?
A bitmap index is an index on columns from two or more tables that come from the same domain of values. False True TRUE ANSWER : ? YOUR ANSWER : ?
Some advantages of partitioning include: efficiency, security, and load balancing. False True TRUE ANSWER : ? YOUR ANSWER : ?
The fastest read/write time and most efficient data storage of any disk array type is: RAID-3 RAID-2 RAID-1 RAID-0 TRUE ANSWER : ? YOUR ANSWER : ?
A multidimensional database model is used most often in which of the following models? Relational Network Hierarchical Data warehouse TRUE ANSWER : ? YOUR ANSWER : ?
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 TRUE ANSWER : ? YOUR ANSWER : ?
What is the best data type definition for Oracle when a field is alphanumeric and has a length that can vary? LONG NUMBER VARCHAR2 CHAR TRUE ANSWER : ? YOUR ANSWER : ?
A secondary key is which of the following? Useful for denormalization decisions Nonunique key Determines the tablespace required Primary key TRUE ANSWER : ? YOUR ANSWER : ?