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)- A77% (20)
- B8% (2)
- C4% (1)
- D12% (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.