ExamQuestions.com

Register
Login
Oracle Database 12c Advanced Administration Exam Questions

Oracle

Oracle Database 12c Advanced Administration

150 / 155

Question 150:

In a database supporting an OLTP workload, tables are frequently updated on both key and non-keycolumns. Reports are also generated by joining multiple tables. Which table organization or type would provide the best performance for this hybrid workload? 

Answer options:

A. heap table with a primary key index
B. external table
C. hash clustered table
D. global temporary table
E. index clustered table