Home » Oracle » 1z0-067 v.2 » Which table organization or type would provide the best performance for this hybrid workload?
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?
A. heap table with a primary key index
B. external table
C. hash clustered table
D. global temporary table
E. index clustered table
Correct Answer: E
Explanation/Reference:
Explanation:
Do not cluster tables if the application joins them only occasionally or modifies their common column values frequently. Modifying a row’s cluster key value takes longer than modifying the value in an unclustered table, because Oracle might need to migrate the modified row to another block to maintain the cluster. http:// docs.oracle.com/cd/B28359_01/server.111/b28274/data_acc.htm#i7690
Download Printable PDF. VALID exam to help you PASS.
|
|