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:

Information Technology

The use of computers, storage, networking, and other physical devices, infrastructure and processes to create, process, store, secure, and exchange all forms of electronic data.

Social Behavior

encompasses the actions and reactions of individuals or groups in interaction with others within a social context.

Status Differences

Disparities among individuals or groups in terms of prestige, authority, or importance within a social hierarchy.

Location Dependent

Referring to services or processes whose utility, availability, or relevance is related to a specific geographical location.