100% Correct of 1Z0-053 practice test materials and answers for Oracle certification for consumer, Real Success Guaranteed with Updated 1Z0-053 pdf dumps vce Materials. 100% PASS Oracle Database 11g: Administration II exam Today!

2016 May 1Z0-053 Study Guide Questions:

Q371. If a job references a schedule that has been disabled, what will be the result?

A. The job will be automatically disabled.

B. The job will never execute.

C. The job will attempt to execute but will fail.

D. The job will inherit the DEFAULT_SCHEDULE schedule.

E. A schedule object cannot be disabled.

Answer: E


Q372. You discover that your Recycle Bin contains two tables with the same name, MY_TABLE. You also have a table named MY_TABLE in your schema.

You execute the following statement:

FLASHBACK TABLE my_table TO BEFORE DROP RENAME TO my_table2;

What will be the result of executing this statement?

A. One of the tables is recovered from the Recycle Bin using a First In First Out (FIFO) approach.

B. One of the tables is recovered from the Recycle Bin using a Last In First Out (LIFO) approach.

C. Both the tables are recovered from the Recycle Bin with one table renamed to MY_TABLE2 and the other to a system-generated name.

D. None of the tables are recovered from the Recycle Bin, and the statement returns an error.

Answer: B


Q373. AUM has been retaining about 15 minutes' worth of undo. You want to double the retention period, but not at the expense of new transactions failing. You decide to alter the system to set the parameter UNDO_RETENTION=18000. However, AUM still retains only about 15 minutes' worth of undo. What is the problem? (Choose the best answer.)

A. You need to alter the undo tablespace to add the RETENTION GUARANTEE setting.

B. You need to increase the size of the undo tablespace.

C. The undo tablespace is not set to auto-extend.

D. You need to alter the Recycle Bin to add the RETENTION GUARANTEE setting.

Answer: C


1Z0-053  practice test

Renewal oracle 1z0-053 exam dumps:

Q374. Which dependent object will get invalidated even if it is not affected by the table edefinition?

A. packages

B. triggers

C. synonyms

D. views

Answer: B


Q375. Which method would you use to undo the changes made by a particular transaction without affecting the changes made by other transactions?

A. point-in-time recovery

B. execute the ROLLBACK command with transaction number

C. flashback the database to before the transaction was committed

D. determine all the necessary undo SQL statements from FLASHBACK_TRANSACTION_QUERY and use them for recovery

Answer: D


Q376. 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


2passeasy.com

Guaranteed 1z0-053 free dumps:

Q377. Automatic data conversion will occur if which of the following happens? 

A. The client and server have different NLS_LANGUAGE settings.

B. The client and server character sets are not the same, and the database character set is not a strict superset of the client character set.

C. The client and server are in different time zones.

D. The client requests automatic data conversion.

E. The AUTO_CONVERT initialization parameter is set to TRUE.

Answer: B


Q378. What view might you use to try to determine how long a particular backup will take?

A. V$SESSION_EVENT

B. V$SESSION

C. V$WAITS

D. V$WAITSTAT

E. V$SESSION_LONGOPS

Answer: E


Q379. Identify the persistent configuration setting for the target database that can be set for the backup by using RMAN. (Choose all that apply.)

A. Backup retention policy

B. Default backup device type

C. Default destinations for backups

D. Multiple backup device types for single backup

E. Default section size for backups

Answer: ABC


Q380. True or false: you can perform an active database duplication when the database is in NOARCHIVELOG mode.

A. True

B. False

Answer: B