OCP-1Z0-053-V13.02-512题

MySQL OCP888006-MySQL InnoDB Cluster 阅读详情

512.Which two statements correctly describe the relationship among the Scheduler components: job,

program, and schedule? (Choose two)

A. A job is specified as part of a program definition

B. A program can be used in the definition of multiple jobs

C. A program and job can be specified as part of a schedule definition

D. A program and schedule can be specified as part of a job definition

Answer: A

答案解析:

参考:http://docs.oracle.com/cd/E11882_01/server.112/e25494/schedover.htm#ADMIN12374

http://docs.oracle.com/cd/E11882_01/server.112/e25494/schedover.htm#ADMIN12357


正确答案BD


Programs

A program object (program) describes what is to be run by the Scheduler. A program includes:

  • An action: For example, the name of a stored procedure, the name of an executable found in the operating system file system (an "external executable"), or the text of a PL/SQL anonymous block.

  • A type: STORED_PROCEDUREPLSQL_BLOCK, or EXTERNAL, where EXTERNAL indicates an external executable.

  • Number of arguments: The number of arguments that the stored procedure or external executable accepts.

A program is a separate entity from a job. A job runs at a certain time or because a certain event occurred, and invokes a certain program. You can create jobs that point to existing program objects, which means that different jobs can use the same program and run the program at different times and with different settings. With the right privileges, different users can use the same program without having to redefine it. Therefore, you can create program libraries, where users can select from a list of existing programs.

If a stored procedure or external executable referenced by the program accepts arguments, you define these arguments in a separate step after creating the program. You can optionally define a default value for each argument.


调度程序使用以下基本组件:
• “作业”指定要执行的操作。它可以是PL/SQL 过程、纯二进制可执行文件、Java 应用程序或Shell 脚本。 可以将程序(内容)和调度(时间)指定为作业定义的一部分,
也可以改用现有的程序或调度。可以使用作业的参数来定制其运行时行为。
• “调度”指定作业的执行时间和次数。调度可以基于时间或事件。可以为作业定义调度,方法是使用一系列日期、一个事件,或两者相结合,以及表示重复间隔的附加说
明。可以单独存储作业的调度,然后对多个作业使用同一个调度。
• “程序”是有关特定可执行文件、脚本或过程的元数据集合。自动作业将执行某个任务。使用程序,无需修改作业本身即可修改作业任务或者“内容”。可以定义程序的参数,使用户可以修改任务的运行时行为。


 


How Programs, Jobs, and Schedules are Related

To define what is executed and when, you assign relationships among programs, jobs, and schedules. Figure 28-5 illustrates examples of such relationships.

Figure 28-5 Relationships Among Programs, Jobs, and Schedules

Description of Figure 28-5 follows
Description of "Figure 28-5 Relationships Among Programs, Jobs, and Schedules"

To understand Figure 28-5, consider a situation where tables are being analyzed. In this example, program P1 analyzes a table using the DBMS_STATS package. The program has an input parameter for the table name. Two jobs, J1 and J2, both point to the same program, but each supplies a different table name. Additionally, schedule S1 specifies a run time of 2:00 a.m. every day. The end result is that the two tables named in J1 and J2 are analyzed daily at 2:00 a.m.

Note that J4 points to no other entity, so it is self-contained with all relevant information defined in the job itself. P2P9 and S2 illustrate that you can leave a program or schedule unassigned if you want. You can, for example, create a program that calculates a year-end inventory and temporarily leave it unassigned to any job.

 

mysql ocp第4 Which three statements correctly describe MySQL InnoDB Cluster?A. The cluster can be operated in multimaster mode with conflict detection for DML statements. B. All MySQL client programs and connectors can be used for executing queries.C. It provides fully 阅读详情

相关推荐

OCP-1Z0-052-V8.02-24

24. Which two statements correctly describe the relation between a data file and the logical database structures? (Choose two.) A.An extent cannot spread across data files. B.A segment cannot sprea

一抹曦阳-Oracle 1万+

【第33】2019年OCP认证12C062考试最新考试原-33

33、choose four Which four statements are true about the components of the Oracle Scheduler? A) A program and schedule can be specified as part of a job definition. B) A job may get started automati...

weixin_34319374的博客 251

24.Which two statements correctly describe the relation between a data file and the logical database

24.Which two statements correctly describe the relation between a data file and the logical database

dwj19830118的专栏 1668

OCP-1Z0-053-V13.02-538

538.Which type of database file is spread across all disks in a disk group? A. All types of files are spread across all disks in the disk group. B. Datafiles C. Redo log files D. Archived redo log

一抹曦阳-Oracle 4768

OCP-1Z0-053-V12.02-178

178.If a log file becomes corrupted, it may cause the database to stall. How would you correct such a situation? A. Recover the online redo log from backup. B. Delete and re-create the log file. C.

一抹曦阳-Oracle 6906

OCP-1Z0-053-V12.02-583

583.During recovery, you need to know if log sequence 11 is in the online redo logs, and if so, you need to know the names of the online redo logs so you can apply them during recovery. Which view o

一抹曦阳-Oracle 4190

OCP 11G 053库解析汇总链接(1-200)

V13.02版本,711

u011443258的博客 138

MODMAP:原生多视角调制的工业3D缺陷检测架构

多视角3D检测是工业质检中实现高精度缺陷识别的基础技术,其核心在于建模相机几何与物理成像之间的可微分映射关系。传统方法将视角视为后处理环节,导致跨视角特征不一致、配准漂移和模态失语等问;而基于视角调制(如FiLM)的原生架构,将内参、外参、物距、光源角等作为结构化输入,驱动特征空间的几何感知自适应。该技术显著提升微米级缺陷(<50μm)的跨视角一致性与镜面/高光区域鲁棒性,已在汽车焊装、半导体搬运、精密齿轮装配等场景落地验证。本文聚焦MODMAP这一典型原生多视角方案,解析其视角调制原理、工业级部署约束与

cmff98425的博客 323

调度程序1

1.Which two statements correctly describe the relationship among the Scheduler components: job, program, and schedule? (Choose two) A. A job is specified as part of a program definition B. A progra

阿虎点滴 2045

【第54】【062库】2019年OCP认证062考试新

54、choose two Which two statements describe the relationship between a scheduler window, a resource manager plan, and a job class? A) A schedule...

chouluanzhi0562的博客 540

ocp-112

QUESTION NO: 112 Which two statements correctly describe the relationship among the Scheduler components: job, program, and schedule? (Choose two) A. A job is specified as part of a program definit

jiayue's BLOG 951

ocp-455

QUESTION NO: 455Which three statements correctly describe the features of the I/O calibration process? (Choose three.) A. Only one I/O calibration process can run at a time. B. It automates the res

jiayue's BLOG 1113

OCP-1Z0-053-V13.02-450

450.Which of the following are valid program types for a lightweight job? (Choose all that apply.) A. PLSQL_BLOCK B. EXECUTABLE C. JAVA_STORED_PROCEDURE D. STORED_PROCEDURE E. EXTERNAL Answer: A

一抹曦阳-Oracle 6659

OCP-1Z0-053-V12.02-234

234.Which type of backup contains only the blocks that have changed since the last level 0 incremental backup? A. a cumulative level 1 backup B. a differential level 1 backup C. a full backup D

一抹曦阳-Oracle 5555

Oracle OCP 11G 0531-200)答案解析目录_20140304

Oracle OCP 11G 0531-200)答案解析目录   1 http://blog.csdn.net/rlhua/article/details/16369867  2 http://blog.csdn.net/rlhua/article/details/16527169  3 http://blog.c

一抹曦阳-Oracle 7万+

OCP11g 071

Number: 1z0-071 Passing Score: 800 Time Limit: 120 min File Version: 2.0 1z0-071 Oracle Database 12c SQL Version 2.0 1z0-071 ExamPass Exam A QUESTION 1 Evaluate the following SQL statement: SQL&gt; se...

qq_39883035的博客 1万+

OCP-1Z0-053-V12.02-4

4.Which three components does the Scheduler use for managing tasks within the Oracle environment? (Choose three.) A. a job B. a program C. a schedule D. a PL/SQL procedure Answer: ABC 答案解析: 参考

一抹曦阳-Oracle 1万+

OCP-1Z0-053-V12.02-680

680.Which two operations are NOT performed by the DUPLICATE command in Recovery Manager (RMAN) while duplicating a running database? (Choose Two) A.Creating the control file for the duplicate databa

一抹曦阳-Oracle 8552
上一篇: OCP-1Z0-053-200题-73题-650
下一篇: OCP-1Z0-053-200题-38题-617
Riveore
博客等级 码龄19年 1801粉丝 1432原创
评论 2
成就一亿技术人!
拼手气红包6.0元
还能输入1000个字符
 
 条评论被折叠 查看
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值