Figuer: (Oracle) CREATE DIMENSION StoreDim

question 68

Multiple Choice

Figuer: (Oracle)
CREATE DIMENSION StoreDim
LEVEL StoreID IS Store. StoreID
LEVEL City IS Store. StoreCity
LEVEL State IS Store. StoreState
LEVEL Zap IS Store.StoreZip
LEVEL Nation IS Store. StoreNation
LEVEL DivID IS Division. DivID
HIERARCHY CityRollup (
StoreID CHILD OF
City CHILD OF
State CHILD OF
Nation )
HIERARCHY ZipRollup
StoreID CHILD OF
Zip CHILD OF
State CHILD OF
Nation )
HIERARCHY DivisionRollup (
StoreID CHILD OF
DivID
JOIN KEY Store.DivID REFERENCES DivID )
ATTRIBUTE DivID DETERMINES Division. DivName
ATTRIBUTE DivID DETERMINES Division. DivManager;
-The dimension StoreDim contains how many levels?

• A) 1
• B) 3
• C) 6
• D) None of the above

---

Definitions:

Basis

The financial value assigned to an asset for tax purposes, used to determine the gain or loss upon its sale or other disposition.

Divorce

The legal dissolution of a marriage by a court or other competent body, often involving division of assets and debts.

Investment

An investment is an asset or item acquired with the goal of generating income or appreciation over time.

Schedule D

A form used with tax returns to report capital gains and losses from transactions of capital assets.