多项选择题
In which scenarios would you rebuild an index？（）
A. when you need to disable the index usage
B. when you need to change storage options
C. when you need to enable index monitoring
D. when you need to move the index to another tablespace
相关考题
-
单项选择题
YousettherecoverywindowtosevendaysandthebackupoptimizationtoONusingtheCONFIGUREcommandofRecoveryManager（RMAN）.ThemostrecentbackupoftheTOOLStablespacetodiskwastakenonJanuary3.TheTOOLStablespaceisread-only.OnFebruary21，whenyouexecuteacommandtobackupallthetablespacestodisk，youfindthatRMANbacksupthe TOOLS tablespacealso，eventhoughthecontentsofthetablespacehavenotchangedafterthebackuponJanuary3.BecausetherearenochangesmadetotheTOOLStablespace，youdecidethatthetablespaceshouldnotbebackedupbyRMAN.WhatcanyoudotoskipbackinguptheTOOLStablespacewithoutchangingthecurrentbackupoptimizationsetting？（）
A. configure a default device for RMAN backups
B. temporarily disable the retention policy for RMAN backups
C. configure automatic channel allocation for RMAN backups
D. use the CONFIGURE command to reconfigure the recovery window to 60 days -
单项选择题
YouaredesigninganapplicationforCertkiller.comandyouhavebeenaskedtodesignadatabasetabletofacilitatemonthlybillgeneration.Thebillwouldincludedetailsofcustomercalls，listedinchronologicalorder.Whichmethodwouldyoufollowtoachievethisobjectivewithoutincreasingtheoverheadofsortingtherows？（）
A. create a hash cluster to store the data
B. create an index cluster to store the data
C. create a partitioned table to store the data
D. create a sorted hash cluster to store the data
E. create a heap table with rowid to store the data -
单项选择题
WhilecreatingajobclassusingtheDBMS_SCHEDULERpackage，yousettheloggingleveltoLOGGING_RUNS.Whatwouldbetheimpactofthissetting？（）
A. Oracle Scheduler would write detailed information to the job log for each run of each job in the job class.
B. Oracle Scheduler would write detailed information to the job log for the first run of each job in the job class.
C. Oracle Scheduler would write detailed information to the job log for each run of only the first job in the job class.
D. Oracle Scheduler would write detailed information for all operations performed on all jobs in the job class.
