Database Redesign
Q. In a star schema, what type of table is the central fact table surrounded by?
-
A.
Dimension tables
-
B.
Normalization tables
-
C.
Transaction tables
-
D.
Index tables
Solution
In a star schema, the central fact table is surrounded by dimension tables that provide context to the data.
Correct Answer: A — Dimension tables
Q. What is a transaction in the context of a database?
-
A.
A single SQL command
-
B.
A sequence of operations treated as a single unit
-
C.
A backup of the database
-
D.
A method of data retrieval
Solution
A transaction is a sequence of operations that are executed as a single unit of work.
Correct Answer: B — A sequence of operations treated as a single unit
Showing 1 to 2 of 2 (1 Pages)
