ITPub博客

（451）Which of the following is not a valid setting for the PROGRAM_TYPE parameter in a program object or the JOB_TYPE parameter in a job object?A. PLSQL_BLOCKB. JAVA_STORED_PROCEDUREC. STORED_PROCEDURED. EXECUTABLEE. None of the above are invalid settings.答案：（B）解析...

（450）Which of the following are valid program types for a lightweight job?(Choose all that apply.)A. PLSQL_BLOCKB. EXECUTABLEC. JAVA_STORED_PROCEDURED. STORED_PROCEDUREE. EXTERNAL答案：（A、D）解析：《Administrator’s Guide》 28.3.1.6 lightweight joblightwei...

（449）Which of the following objects can be directly referenced by a window object?(Choose all that apply.)A.Schedule objectB.Program objectC.Job objectD.Resource planE.Resource consumer group答案：（A、D）解析：《Administrator's Guide》  29...

（448）Which of the following tasks is not performed by the job coordinator?A.Update job log when a job completesB.Spawn and remove job slavesC.Write/read job info to/from memory cacheD.Query job tableE.Pass job information to job slaves答案：（A）解析：《Administrat...

（447）Which of the following calendaring syntax expressions would evaluate to the last day of every month?A. FREQ=MONTHLY;BYMONTHDAY=31B. FREQ=MONTHLY;BYMONTHDAY=-1C. FREQ=DAILY;BYDAY=-1D. FREQ=MONTHLY;BYDAY=31E. FREQ=DAILY;BYMONTHDAY=LAST_DAY答案：（B）重复：440...

（446）Consider the following codeBEGIN  DBMS_SCHEDULER.SET_ATTRIBUTE(name => 'lne_job1', attribute => 'job_priority', value => 1);END;/If this code were executed,which of the following statements would ...

（445）To set the history retention period for either window logging or job logging individually,which parameters of the SET_SCHEDULER_ATTRIBUTE procedure need to be used?(Choose all that apply.)A. LOG_HISTORYB. JOB_LOG_RETENTIONC. WINDOW_LOG_RETENTIOND. WHICH_LOGE. LOG_NAME...

（444）What is the default value for the ENABLED attribute of a job or program when it is created?A. TRUEB. FALSEC. There is no default.It must be defined at creation time.D. PENDINGE. NULL答案：（B）解析：《Administrator’s Guide》 29.2JOB在创建时默认是DISABL...

（443）Which DBMS_SCHEDULER procedure(s)can be used to alter an existing job?(Choose all that apply.)A. SET_ATTRIBUTE_NULLB. ALTER_JOBC. ALTER_JOB_PARAMETERSD. ALTERE. SET_ATTRIBUTE答案：（A、E）解析：根本没有以ALTER_开头的过程...

（442）A schedule defined entirely within the confines of a Scheduler job object is known as a(n)__________A. Fixed scheduleB. Inline scheduleC. Stored scheduleD. Hard-coded scheduleE. None of the above答案：（B）

（441）Which Scheduler view(s) can be queried to see which jobs are currently executing?(Choose all that apply.)A. DBA_SCHEDULER_JOB_RUN_DETAILSB. DBA_SCHEDULER_RUNNING_JOBSC. DBA_SCHEDULER_CURRENT_JOBSD. DBA_SCHEDULER_JOBSE. DBA_SCHEDULER_EXECUTING_JOBS答案：（B、D）解析：...

（440）Which of the following is not a valid calendaring syntax element?A. FREQB. BYHOURC. RUNDATED. INTERVALE. BYMINUTE答案：（C）解析：查看DBMS_SCHEDULER包的定义支持的calendar syntax:FREQINTERVALBYMONTHBYWEEKNOBYYEARDAY...

（439）Which DBMS_SCHEDULER procedures can be used to enable a program?(Choose all that apply.)A. ENABLEB. ENABLE_PROGRAMC. VALIDATE_PROGRAMD. SET_ATTRIBUTEE. SET_ENABLED答案：（A、D）解析：查看DBMS_SCHEDULER包，B，C，E这三个过程根本就没有...

（438）When setting arguments for a job,which procedure do you use for types that cannot be implicitly converted to and from a VARCHAR2 datatype?A. SET_JOB_ARGUMENT_VALUEB. SET_JOB_VALUE_ANYDATAC. SET_JOB_ANYDATA_VALUED. SET_SPECIAL_JOB_VALUEE. SET_JOB_ANYTYPE_VALUE答案：（C）...

（437）Within a resource-plan definition,what differentiates a top-level plan from a subplan?A. A subplan has the PLAN_SUB parameter value set to SUB.B. A top-level plan has the GROUP_OR_PLAN parameter set to the name of the subplan in the resource-plan definition.C. There is no differenc...

（436）Which DBMS_RESOURCE_MANAGER procedure prioritizes consumer-group mappings?A. CREATE_MAPPING_PRIORITYB. SET_MAPPING_PRIORITYC. SET_MAPPING_ORDERD. PRIORITIZE_MAPPING_ORDERE. This functionality is not available through the DBMS_RESOURCE_MANAGER package.答案：（B）解析...

（435）Every resource plan must contain an allocation to which consumer group?A. LOW_GROUPB. SYS_GROUPC. DEFAULT_GROUPD. BASE_GROUPE. OTHER_GROUPS答案：（E）

（434）Which of these represent the main components of Database Resource Manager?(Choose all that apply.)A. Resource consumer groupsB. Resource plansC. Resource-plan groupsD. Resource-plan directivesE. All of the above答案：（A、B、D）解析：《administrator》 第27章...

（433）When shrinking a table segment,you choose to shrink all the indexes for that table using the SHRINK SPACE command.Which clause should you use?A. INCLUDING DEPENDENCIESB. INCLUDING DEPENDENCIES CASCADEC. COMPACTD. CASCADEE. None of the above答案：（D）...