Figuer: (Oracle) CREATE DIMENSION StoreDim

question 22

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 gets data from how many tables?

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

---

Definitions:

Game Console

A dedicated electronic device designed to play video games where games are controlled using a specific input device.

Printer

A common output device that creates tangible or hard copies of text and graphics.

Twisted-Pair Cable

A type of wiring in which two conductors are twisted together to cancel out electromagnetic interference from external sources.

Fiber-Optic Cable

A cable made of glass or plastic fibers that transmits data at high speeds using light, commonly used for internet connections.