1Z0-053 177-Q69

177-Q69:

You work as a Database Administrator for Veedol Inc. Your manager wants you to run a job that updates the transaction table every 30 minutes. To schedule the job, you have to set the value of the interval element. Which of the following setting for the repeat_interval argument will archive the desired objective. Each correct answer represents a complete solution.(Choose two.)

A. 'freq=hourly; interval=1/2'

B. 'freq=hourly; byminute=30'

C. '0 00:30:00'

D. 'freq=minutely; interval=30'

E. 'freq=minutely; byminute=30'

F. 'freq=minutely; interval='30'minutes'

Answer: D

SQL> alter session set nls_timestamp_tz_format='MM-DD-YYYY HH24:MI:SS tzr tzd';

会话已更改。

SQL> set serveroutput on;

SQL> declare

  2    procedure list_next_run_dates(

  3      start_date_i in timestamp with time zone,

  4      calendar_string_i in varchar2,

  5      date_count_i in integer default 8)

  6    is

  7      i_return_date_after timestamp with time zone;

  8      i_next_run_date timestamp with time zone;

  9    begin

 10      i_return_date_after :=start_date_i;

 11      for i in 1 .. date_count_i

 12      loop

 13        dbms_scheduler.evaluate_calendar_string(

 14          calendar_string => calendar_string_i,

 15          start_date      => start_date_i,

 16          return_date_after => i_return_date_after,

 17          next_run_date     => i_next_run_date);

 18        dbms_output.put_line(i_next_run_date);

 19        i_return_date_after := i_next_run_date;

 20      end loop;

 21      exception

 22        when others then

 23          dbms_output.put_line('ERROR');

 24    end;

 25    begin

 26      dbms_output.put_line('FREQ=HOURLY; BYMINUTE=30');

 27      list_next_run_dates(to_timestamp_tz(trunc(sysdate)+10/24),'FREQ=HOURLY; BYMINUTE=30');

 28      dbms_output.put_line('FREQ=HOURLY; interval=30');

 29      list_next_run_dates(to_timestamp_tz(trunc(sysdate)+10/24),'FREQ=MINUTELY; interval=30');

 30      dbms_output.put_line('FREQ=MINUTELY; BYMINUTE=30');

 31      list_next_run_dates(to_timestamp_tz(trunc(sysdate)+10/24),'FREQ=MINUTELY; BYMINUTE=30');

 32      dbms_output.put_line('FREQ=MINUTELY; interval=30 minutes');

 33      list_next_run_dates(to_timestamp_tz(trunc(sysdate)+10/24),'FREQ=MINUTELY; interval=30 minutes');

 34      dbms_output.put_line('FREQ=HOURLY; interval=1/2');

 35      list_next_run_dates(to_timestamp_tz(trunc(sysdate)+10/24),'FREQ=HOURLY; interval=1/2');

 36      dbms_output.put_line('0 00;30:00');

 37      list_next_run_dates(to_timestamp_tz(trunc(sysdate)+10/24),'0 00;30:00');

 38    end;

 39    /

FREQ=HOURLY; BYMINUTE=30

09-23-2016 10:30:00 +08:00

09-23-2016 11:30:00 +08:00

09-23-2016 12:30:00 +08:00

09-23-2016 13:30:00 +08:00

09-23-2016 14:30:00 +08:00

09-23-2016 15:30:00 +08:00

09-23-2016 16:30:00 +08:00

09-23-2016 17:30:00 +08:00

FREQ=HOURLY; interval=30

09-23-2016 10:30:00 +08:00

09-23-2016 11:00:00 +08:00

09-23-2016 11:30:00 +08:00

09-23-2016 12:00:00 +08:00

09-23-2016 12:30:00 +08:00

09-23-2016 13:00:00 +08:00

09-23-2016 13:30:00 +08:00

09-23-2016 14:00:00 +08:00

FREQ=MINUTELY; BYMINUTE=30

09-23-2016 10:30:00 +08:00

09-23-2016 11:30:00 +08:00

09-23-2016 12:30:00 +08:00

09-23-2016 13:30:00 +08:00

09-23-2016 14:30:00 +08:00

09-23-2016 15:30:00 +08:00

09-23-2016 16:30:00 +08:00

09-23-2016 17:30:00 +08:00

FREQ=MINUTELY; interval=30 minutes

ERROR

FREQ=HOURLY; interval=1/2

ERROR

0 00;30:00

ERROR

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/81227/viewspace-2125383/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/81227/viewspace-2125383/