Oracle

1Z0-074 · Question #40

Which three types of database objects can have their columns stored in the In-Memory column store? (Choose two.)

The correct answer is A. heap tables with composite primary key constraints B. heap tables with dependent materialized views. Explanation/Reference:

New Features for Performance

Question

Which three types of database objects can have their columns stored in the In-Memory column store? (Choose two.)

Options

Aheap tables with composite primary key constraints
Bheap tables with dependent materialized views
Cclustered tables with dependent materialized views
Dindex-organized tables stored in system-defined tablespaces
Esys-owned objects stored in sysaux-defined tablespaces

How the community answered

(19 responses)

A
79% (15)
C
11% (2)
D
5% (1)
E
5% (1)

Explanation

Explanation/Reference:

Topics

#In-Memory column store#heap tables#materialized views#IM eligible objects

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion

Full 1Z0-074 Practice