PrepAway - Latest Free Exam Questions & Answers

What does the DATA TAG 1 clause do?

A storage group named HOT_SG was created as follows:

What does the DATA TAG 1 clause do?

PrepAway - Latest Free Exam Questions & Answers

A.
It indicates that the multiple storage paths referenced in the HOT_SG storage group definition
exist in one physical location.

B.
It tells the DB2 Optimizer that database objects stored in the HOT_SG storage group are to be
given preference over other objects when data access plans are generated.

C.
It indicates that the value 1 is to be assigned to data stored in the HOT_SG storage group,
which Workload Manager (WLM) can then use to determine the processing priority to assign to
database activities that interact with this data.

D.
It assigns a unique identifier to the instance of the HOT_SG storage group being defined; this
identifier can then be used when moving table spaces to and from the storage group, when
dropping the storage group, or when commenting on the storage group.

Explanation:


Leave a Reply