单项选择题
Using Oracle Scheduler you have scheduled two jobs， JOB_A and JOB_B， to run at 9：00 p.m. every Friday. You want both the jobs to use a single resource plan， WEEKEND_PLAN. Which task must have already been performed to enable you to achieve this objective？（）
A. A window must have been created with the WEEKEND_PLAN resource plan.
B. A program must have been created with the WEEKEND_PLAN resource plan.
C. A job class must have been created with the WEEKEND_PLAN resource plan.
D. A windows group must have been created with the WEEKEND_PLAN resource plan.
相关考题
-
单项选择题
UsersareperformingalargevolumeofinsertsanddeletesontheapplicationtablesintheAPPStablespace.YouobservethatthereareseveralwarningalertsbeinggeneratedfortheAPPStablespacespaceusagemetrics.Currently，thewarningthresholdforthetablespaceusagemetricsissetto70%.Tomakethegeneratedalertsmoreusefulasaproblemidentificationtool，youwanttoreducethefrequencyofalertgenerationforthetablespaceusagemetricsfortheAPPStablespace.Whatshouldyoudo？（）
A. Disable SQL tracing for the APPS tablespace.
B. Disable logging attributes for the APPS tablespace.
C. Modify the tablespace to be a dictionary-managed tablespace.
D. Increase the critical threshold value for the tablespace space usage metrics for the APPS tablespace.
E. Increase the warning threshold value for the tablespace space usage metric for the APPS tablespace. -
多项选择题
Youareworkinginadedicatedserverenvironment.YourdatabaseisrunningintheautomaticProgramGlobalArea（PGA）memorymanagementmode.Whichtwostatementsarecorrectinthisscenario？（）
A. The WORK_AREASIZE_POLICY initialization parameter cannot be set to AUTO.
B. The Oracle database automatically controls the amount of PGA memory allotted to SQL work areas.
C. Setting the value of the SGA_TARGET initialization parameter to 0 will disable the automatic PGA memory management.
D. The SORT_AREA_SIZE parameter is ignored by all the sessions running in the automatic PGA memory management mode. -
单项选择题
Inoneofyouronlinetransactionprocessing（OLTP）applications，usersaremanipulatingandqueryingadatabasetablesimultaneously.FromtheSegmentAdvisor，youfindthatoneofthetablesishighlyfragmentedandyouwanttoshrinkthetableimmediatelywithoutaffectingthecurrentlyactivequeries.WhichoptionwouldyouusewiththeALTERTABLEcommandtoachievethisobjective？（）
A. REBUILD
B. CASCADE
C. TRUNCATE
D. ROW MOVEMENT
E. SHRINK SPACE COMPACT
F. SHRINK SPACE CASCADE
