Oracle
1Z0-064 · Question #83
1Z0-064 Question #83: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-064 to reveal the answer and full explanation for question #83. The question stem and answer options stay visible for context.
Question
You have been asked to use table compression for two large tables. Given are the details of the tables: The TRANS_DET table: The table is used by an OLTP application. High volume insert and update operations are performed on the table. The table is frequently queried using index range scans. The TRANS_HISTORY table: The table is used by a DSS application. High volume bulk loads are performed on the table. The table is used to store archival data on which large table full-table scans (FTS) are performed. Which row store compression would you recommend for these tables with minimal overhead on performance? (Choose the best answer.)
Options
- Abasic table compression for both the tables
- Badvanced row compression for both the tables
- Cbasic table compression for the TRANS_HISTORY table and advanced row compression for the
- Dbasic table compression for the TRANS_DET table and advanced row compression for the
- Ewarehouse compression for the TRANS_DET table and archive compression for the
Unlock 1Z0-064 to see the answer
You've previewed enough free 1Z0-064 questions. Unlock 1Z0-064 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.