单项选择题
In one of your online transaction processing （OLTP） applications， most users frequently modify the values， including the key values， of the application tables. Some users generate application reports by using multiple application tables. What is the best table structure that you can use to gain optimal performance？（）
A. Heap table
B. Object table
C. External table
D. Clustered table
E. Global temporary table
F. Index-organized table （IOT）
点击查看答案
相关考题
-
单项选择题
Youhavebeenassignedtomanageasetofdatabases.ThepreviousDBAdidnotleaveyounotesregardingthestructureofeachofthedatabases.Whileanalyzinganinstance，younoticethatthesystemidentifier（SID）fortheinstanceissetto’+ASM’.Whatisthepurposeofthisinstance？（）
A. This instance is being used to manage the operating system files.
B. This instance is being used to manage the files of other databases.
C. This instance is being used to manage the instances of other databases.
D. This instance is being used to manage the background processes of other instances. -
单项选择题
InanOracle10gdatabase，thein-memorystatisticsaregatheredatregularintervalsandusedtoperformgrowth-trendanalysisandcapacityplanningofthedatabase.Whichcomponentstoresthesestatistics？（）
A. Recovery catalog
B. Oracle Enterprise Manager Repository
C. Automatic Workload Repository （AWR）
D. Oracle 10g Enterprise Manager Grid Control
E. Automatic Database Diagnostic Monitor （ADDM） -
单项选择题
WhichtypeofPL/SQLconstructwouldyouusetoautomaticallycorrecttheerrorresultingfromastatementthatwassuspendedduetoaspace-relatedproblem？（）
A. functions
B. package
C. procedure
D. database trigger
E. anonymous PL/SQL block
