Online Access Free 1Z0-053 Practice Test

The user SYS creates a job by using the following command:
BEGIN
DBMS_SCHEDULER.CREATE_JOB (
job_name => 'update_sales',
job_type => 'STORED-PROCEDURE',
job_action => 'OPS.SALES_PKG.UPDATE_SALES_SUMMARY',
start_date => '28-DEC-07 07.00.00 PM Australia/Sydney',
repeat_interval => 'FREQ=DAILY; INTERVAL=2',
end_date => '20-JAN-08 07.00.00 PM Australia/Sydney',
comments => 'New sales job');
END;
/
Which two statements are true about the job that was created by the preceding command? (Choose two.)

• A.The job is enabled by default after creation
• B.The job executes with the privileges of the user SYS
• C.The globalization environment that exists at the time of the job creation prevails at the job runs
• D.The job is automatically dropped after the end date

You issued the following command on the temporary tablespace LMTEMP in your database:
SQL>ALTER TABLESPACE lmtemp SHRINK SPACE KEEP 20M;
Which requirement must be fulfilled for this command to succeed?

• A.The tablespace can remain as the default but must have no active sort operations.
• B.The tablespace must have only one temp file.
• C.The tablespace must be locally managed.
• D.The tablespace must be made nondefault and offline.

Which of the following are not disabled by default?

• A.Schedule
• B.Jobs
• C.Chains
• D.Windows
• E.Window groups

You notice that a job in a chain has not completed on a nonconstrained RAC database. Which of these are valid reasons why that might occur?

• A.There is no service affinity.
• B.The job priority is 1 and the resource consumer group CPU emphasis allocation is a low percentage.
• C.The job affinity is to a service and one node in that service is unavailable.
• D.None of the above.
• E.The job affinity is to an instance and that instance is unavailable.

Which is the correct way to connect to both the target database and the recovery catalog from the RMAN command line? Assume that the target database is called ORCL and that the recovery catalog database is called RCAT. Also assume that the recovery-catalog owner is called RCAT_OWN. Assume the environment is configured for the ORCL database. (Choose all that apply.)

• A.rman target=/ catalog=/@rcat
• B.rman target=/ catalog=rcat_own/rcat_own@RCAT
• C.rman target=/ catalog=rcat_own/rcat_own
• D.You cannot connect to the target database and the recovery catalog at the same time.
• E.rman target=sys/robert@orcl catalog=rcat_own/rcat_own@RCAT