随笔分类 -  ocp-procedure

053-9
摘要：Which statement describes the information returned by the DBMS_SPACE.SPACE_USAGE procedure for LOB space usage?A. It returns space usage of only Basic 阅读全文
posted @ 2017-12-18 18:25 巴啦啦大魔王 阅读(143) 评论(0) 推荐(0)
053-265
摘要：View the Exhibit for the object interdependency diagram.The PRODUCTS table is used to create the PRODCAT_VW view. PRODCAT_VW is used in the GET_DATA p 阅读全文
posted @ 2017-11-15 16:04 巴啦啦大魔王 阅读(78) 评论(0) 推荐(0)
053-99
摘要：View the Exhibit and examine the steps that you executed to create a database resource plan. Subsequently, you execute the following procedure which r 阅读全文
posted @ 2017-11-15 15:34 巴啦啦大魔王 阅读(133) 评论(0) 推荐(0)
053-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 阅读全文
posted @ 2017-11-14 17:22 巴啦啦大魔王 阅读(126) 评论(0) 推荐(0)
053-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_BL 阅读全文
posted @ 2017-11-14 17:13 巴啦啦大魔王 阅读(88) 评论(0) 推荐(0)
053-446
摘要：Consider the following code snippet:BEGINDBMS_SCHEDULER.SET_ATTRIBUTE (name => ,,lne_job1,attribute => ,,job_priority,value => 1);END;/If this code we 阅读全文
posted @ 2017-11-14 16:54 巴啦啦大魔王 阅读(69) 评论(0) 推荐(0)
053-445
摘要：To set the history retention period for either window logging or job logging individually, which parameters of the SET_SCHEDULER_ATTRIBUTE procedure n 阅读全文
posted @ 2017-11-14 16:51 巴啦啦大魔王 阅读(108) 评论(0) 推荐(0)
053-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_PARAMETE 阅读全文
posted @ 2017-11-14 16:43 巴啦啦大魔王 阅读(82) 评论(0) 推荐(0)
053-439
摘要：Which DBMS_SCHEDULER procedures can be used to enable a program? (Choose all that apply.)A. ENABLEB. ENABLE_PROGRAMC. VALIDATE_PROGRAMD. SET_ATTRIBUTE 阅读全文
posted @ 2017-11-14 16:21 巴啦啦大魔王 阅读(90) 评论(0) 推荐(0)
053-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_ 阅读全文
posted @ 2017-11-14 16:18 巴啦啦大魔王 阅读(72) 评论(0) 推荐(0)