nerdexam
Oracle

1Z0-074 · Question #20

In a database on an Oracle Exadata Database machine, a DBA executes this command: SQL> exec DBMS_INMEMORY_ADMIN.ENABLE_FASTSTART ('fs_tbs'); What is the result?

The correct answer is A. All columns for all tables in the FS_TBS tablespace are loaded into the In-Memory column store. Explanation/Reference: https://docslide.us/download/link/database-in-memory-guide-oracle-help-center-find-any-errors-please-

New Features for Performance

Question

In a database on an Oracle Exadata Database machine, a DBA executes this command:

SQL> exec DBMS_INMEMORY_ADMIN.ENABLE_FASTSTART (‘fs_tbs’); What is the result?

Options

  • AAll columns for all tables in the FS_TBS tablespace are loaded into the In-Memory column store.
  • BAny data in the In-Memory column store is copied in compressed columnar format to the FS_TBS
  • CAny data in the In-Memory column store is copied in uncompressed columnar format to the FS_TBS
  • DAny data in the In-Memory column store is copied in row major format to the FS_TBS tablespace.

How the community answered

(26 responses)
  • A
    77% (20)
  • B
    8% (2)
  • C
    4% (1)
  • D
    12% (3)

Explanation

Explanation/Reference: https://docslide.us/download/link/database-in-memory-guide-oracle-help-center-find-any-errors-please-

Topics

#In-Memory FastStart#DBMS_INMEMORY_ADMIN#columnar format#Exadata

Community Discussion

No community discussion yet for this question.

Full 1Z0-074 Practice