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
Learn More →
Q. In a star schema, what type of table is the central fact table?
-
A.
Dimension table
-
B.
Lookup table
-
C.
Aggregate table
-
D.
Fact table
Solution
In a star schema, the central table is the fact table, which contains quantitative data for analysis.
Correct Answer:
D
— Fact table
Learn More →
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
Learn More →
Showing 1 to 3 of 3 (1 Pages)