ITPub博客

（460）Given two different character sets(A and B),which of the following must be true for A to be considered a strict superset of B?(Choose all that apply.)A. A must contain all of the characters defined in B.B. A must be Unicode.C. The encoded values in A must match the encoded values i...

（459）What elements of globalization can be explicitly defined using the NLS_LANG environment variable?(Choose all that apply.)A. NLS_LANGUAGEB. NLS_SORTC. NLS_CALENDARD. NLS_CHARACTERSETE. NLS_TERRITORY答案：（A、D、E）解析：NLS_LANG环境变量可以定义语言、字符集、te...

（458）Globalization support is implemented through the text-and character-processing functions provided by which Oracle feature?A. RSTLNEB. NLSRTLC. LISTENERD. NLSSORTE. Linguistic sorts答案：（B）解析：《Globalization Support Guide》 glossaryNLSRTL（National...

（457）If two windows overlap,which window attribute will determine whether one should be chosen over the other?A. WINDOW_PRIORITYB. PRIORITYC. PRIORITY_LEVELD. WINDOW_PRIORITY_LEVELE. OVERLAP_RULE答案：（A）解析：DBMS_SCHEDULER.CREATE_WINDOWwindow_priority = ...

（456）Which of the following is true about job chains?A. They consist of one or more Scheduler programs.B. They are used to implement dependency scheduling.C. They are used to implement time-based scheduling.D. They are used to implement event-based scheduling.E. None of the abov...

（455）When a job exceeds the date specified in its END_DATE attribute,which of the following will happen?(Choose all that apply.)A. The job will be dropped automatically if the value of the AUTO_DROP attribute is TRUE.B. The job will only be disabled if the value of the AUTO_DROP attribute i...

（454）If a job references a schedule that has been disabled,what will be the result?A. The job will be automatically disabled.B. The job will never execute.C. The job will attempt to execute but will fail.D. The job will inherit the DEFAULT_SCHEDULE schedule.E. A schedule object ...

（453）What is the danger associated with stopping a running job by using the STOP_JOB procedure?A. The job will need to be reenabled before it will execute again.B. The job may hold locks on objects referenced within it.C. All jobs within the job group will also be stopped.D. The job...

（452）Which of the following Scheduler elements encourage object reuse?(Choose all that apply.)A. Schedule objectsB. Program argumentsC. Job classesD. Job argumentsE. All of the above答案：（A、B、D）解析：《Administrator’s Guide》 29...

（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）解析：...