Correct! OLTP systems are optimized for getting data into a database—for
storing data as a transaction occurs. Data warehouses are optimized for getting
data out— providing a quick response for analysis purposes.
Incorrect. This statement is true. OLTP systems are optimized for getting
data into a database—for storing data as a transaction occurs. Data warehouses
are optimized for getting data out— providing a quick response for analysis
purposes.
Incorrect. This statement is false. Many warehouse models are strictly
1NF, which means that redundant data does exist.
Correct! Many warehouse models are strictly 1NF, which means that redundant
data does exist..
Correct! Cardinality is defined as the number of relationships, and is
applied to relationships between entities.
Incorrect. This statement is true. Cardinality is defined as the
number of relationships, and is applied to relationships between entities.