nerdexam
Oracle

1Z0-074 · Question #15

Which two statements are true about the In-Memory (IM) column store? (Choose two.)

The correct answer is C. IM area size is not controlled by Oracle Automatic Memory Management D. IM area size can be set at the CDB and PDB levels. Explanation/Reference:

Using Advanced SQL Features

Question

Which two statements are true about the In-Memory (IM) column store? (Choose two.)

Options

  • AIt may be used for columns in Index Organized Tables (IOTs)
  • BIt may be used for columns in clustered tables
  • CIM area size is not controlled by Oracle Automatic Memory Management
  • DIM area size can be set at the CDB and PDB levels
  • EIM area size can be increased or decreased dynamically
  • FIt is not used for partitioned tables

How the community answered

(54 responses)
  • A
    13% (7)
  • B
    2% (1)
  • C
    80% (43)
  • E
    4% (2)
  • F
    2% (1)

Explanation

Explanation/Reference:

Topics

#In-Memory column store#IM area size#Automatic Memory Management#CDB PDB memory

Community Discussion

No community discussion yet for this question.

Full 1Z0-074 Practice