TheDatabaseResourceManagerisnotcurrentlyactiveinyourdatabasethatisupandrunning.YoucreatedaresourceplannamedDAY_PLANthatcontainstwosub-plansnamedMANAGERS_PLANandCLERKS_PLAN.YoudecidedtoactivateDAY_PLANbyexecutingthefollowingstatement:SQL>ALTERSYSTEMSETRESOURCE_MANAGER_PLAN=’managers_plan’;Whatwillbetheoutcomeofthisstatement?()
A. ThestatementwilldeactivateDAY_PLAN.
B. ThestatementwillactivateDAY_PLANasthetopplan.
C. ThestatementwillactivateMANAGERS_PLANasthetopplan.
D. ThestatementwillreturnanerrorbecauseMANAGERS_PLANisnotthetopplan.
查看答案
Which Scheduler view(s) can be queried to see which jobs are currently executing? ()
A. DBA_SCHEDULER_JOB_RUN_DETAILS
B. DBA_SCHEDULER_RUNNING_JOBS DBA
C. DBA_SCHEDULER_CURRENT_JOBS
DBA_SCHEDULER_JOBS DBA
E. DBA_SCHEDULER_EXECUTING_JOBS
Which DBMS_SCHEDULER procedures can be used to enable a program?()
A. ENABLE启用
B. ENABLE_PROGRAM
C. VALIDATE_PROGRAM
D. SET_ATTRIBUTE设置属性
E. SET_ENABLED
YouaremaintainingyourdatabaseinOracle10g.Youfindthatthenumberoflanguagesthatshouldbesupportedinyourdatabasehasincreased.ThecharactersetofyourdatabaseisUTF8.YoudecidetomigrateyourdatabasetotheAL16UTF16nationalcharacterset.HowwillyoumigrateyourdatabasefromUTF8toAL16UTF16?()
A. byusingtheRMANutility
B. byusingtheexport/importutility
C. byusingtheALTERDATABASEcommand
D. byenablingthechangetrackingfeature