Oracle

1Z0-074 · Question #45

You plan to execute this command: Which statement is true and why?

The correct answer is E. It creates partitions P1 and P2 where COUNTRY and CHANNEL are multi-column partition keys. Explanation/Reference:

New Features for Storage

Question

You plan to execute this command:

Which statement is true and why?

Exhibit

1Z0-074 question #45 exhibit

Options

AIt creates partitions P1 and P2 where COUNTRY is a single column partition key and CHANNEL is a
BIt returns an error because only one set of multiple values can be specified for each partition.
CIt returns an error because only a single column key can be used for a list-partitioned table.
DIt returns an error because the AUTOMATIC option must be specified.
EIt creates partitions P1 and P2 where COUNTRY and CHANNEL are multi-column partition keys.

How the community answered

(15 responses)

B
13% (2)
D
7% (1)
E
80% (12)

Explanation

Explanation/Reference:

Topics

#multi-column list partitioning#composite partition key#LIST partitioning#CREATE TABLE

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion

Full 1Z0-074 Practice