首页 > 代码库 > OCP-1Z0-053-V12.02-512题 【转】

OCP-1Z0-053-V12.02-512题 【转】

http://blog.csdn.net/gisinfo/article/details/8159875

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 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: B,D

实验:

SQL> desc dbms_scheduler.create_program
Parameter                                  Type           Mode Default?
-------------------                           -------------- ---- --------
PROGRAM_NAME                         VARCHAR2       IN           
PROGRAM_TYPE                          VARCHAR2       IN           
PROGRAM_ACTION                      VARCHAR2       IN           
NUMBER_OF_ARGUMENTS       BINARY_INTEGER IN   Y       
ENABLED                                        BOOLEAN         IN   Y       
COMMENTS                                    VARCHAR2     IN   Y       
 
SQL> desc dbms_scheduler.create_schedule
Parameter                         Type                     Mode Default?
--------------- ------------------------ ---- --------
SCHEDULE_NAME        VARCHAR2                 IN           
START_DATE                  TIMESTAMP WITH TIME ZONE IN   Y       
REPEAT_INTERVAL       VARCHAR2                 IN           
END_DATE                      TIMESTAMP WITH TIME ZONE IN   Y       
COMMENTS                     VARCHAR2                 IN   Y