Free Download Oracle 1Z0-053 VCE Test Engine Full Version Now (341-350)

QUESTION 341
Which Scheduler view(s) can be queried to see which jobs are currently executing? (Choose all that apply.)

A.    DBA_SCHEDULER_JOB_RUN_DETAILS
B.    DBA_SCHEDULER_RUNNING_JOBS
C.    DBA_SCHEDULER_CURRENT_JOBS
D.    DBA_SCHEDULER_JOBS
E.    DBA_SCHEDULER_EXECUTING_JOBS

Answer: BD

QUESTION 342
A schedule defined entirely within the confines of a Scheduler job object is known as a (n) ________________.

A.    Fixed schedule
B.    Inline schedule
C.    Stored schedule
D.    Hard-coded schedule
E.    None of the above

Answer: B

QUESTION 343
Which DBMS_SCHEDULER procedure(s) can be used to alter an existing job? (Choose all that apply.)

A.    SET_ATTRIBUTE_NULL
B.    ALTER_JOB
C.    ALTER_JOB_PARAMETERS
D.    ALTER
E.    SET_ATTRIBUTE

Answer: AE

QUESTION 344
What is the default value for the ENABLED attribute of a job or program when it is created?

A.    TRUE
B.    FALSE
C.    There is no default. It must be defined at creation time.
D.    PENDING
E.    NULL

Answer: B

QUESTION 345
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_HISTORY
B.    JOB_LOG_RETENTION
C.    WINDOW_LOG_RETENTION
D.    WHICH_LOG
E.    LOG_NAME

Answer: AD
Explanation:
http://docs.oracle.com/cd/E11882_01/appdev.112/e40758/d_sched.htm#ARPLS72383

QUESTION 346
Consider the following code snippet:
BEGIN
DBMS_SCHEDULER.SET_ATTRIBUTE (
name => ,,lne_job1,
attribute => ,,job_priority,
value => 1);
END;
/
If this code were executed, which of the following statements would be true?

A.    The priority of the lne_job1 job would be set to 1.
B.    The lne_job1 job would be executed synchronously.
C.    The lne_job1 job would run immediately in the users current session.
D.    The lne_job1 job would retain its current priority.
E.    The job will immediately take priority over all running jobs.

Answer: A

QUESTION 347
Which of the following calendaring syntax expressions would evaluate to the last day of every month?

A.    FREQ = MONTHLY; BYMONTHDAY = 31
B.    FREQ = MONTHLY; BYMONTHDAY = -1
C.    FREQ = DAILY; BYDAY = -1
D.    FREQ = MONTHLY; BYDAY = 31
E.    FREQ = DAILY; BYMONTHDAY = LAST_DAY

Answer: B

QUESTION 348
Which of the following tasks is not performed by the job coordinator?

A.    Update job log when a job completes
B.    Spawn and remove job slaves
C.    Write/read job info to/from memory cache
D.    Query job table
E.    Pass job information to job slaves

Answer: A

QUESTION 349
Which of the following objects can be directly referenced by a window object? (Choose all that apply.)

A.    Schedule object
B.    Program object
C.    Job object
D.    Resource plan
E.    Resource consumer group

Answer: AD

QUESTION 350
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: AD
Explanation:
http://docs.oracle.com/cd/E11882_01/server.112/e25494/schedover.htm#ADMIN12357

If you want to pass Oracle 1Z0-053 successfully, donot missing to read latest lead2pass Oracle 1Z0-053 dumps.
If you can master all lead2pass questions you will able to pass 100% guaranteed.

http://www.lead2pass.com/1Z0-053.html