Cause all that matters here is passing the Oracle 1Z0-053 exam. Cause all that you need is a high score of 1Z0-053 Oracle Database 11g: Administration II exam. The only one thing you need to do is downloading Testking 1Z0-053 exam study guides now. We will not let you down with our money-back guarantee.


♥♥ 2021 NEW RECOMMEND ♥♥

Free VCE & PDF File for Oracle 1Z0-053 Real Exam (Full Version!)

★ Pass on Your First TRY ★ 100% Money Back Guarantee ★ Realistic Practice Exam Questions

Free Instant Download NEW 1Z0-053 Exam Dumps (PDF & VCE):
Available on: http://www.surepassexam.com/1Z0-053-exam-dumps.html

Q121. When exporting metadata for the transportable tablespaces, what is the correct next step after confirming endian format?

A. Export the tablespaces using data pump.

B. Determine if the transportable set is self-contained.

C. Convert the datafiles using RMAN.

D. Copy the datafiles from source to destination.

Answer: B


Q122. What command would you issue to enable automated backups of control files?

A. alter database controlfile autobackup on

B. alter system controlfile autobackup on

C. configure controlfile autobackup on

D. enable controlfile autobackup

Answer: C


Q123. View the Exhibit to examine the error during the database startup.

You open an RMAN session for the database instance. To repair the failure, you executed the following as the first command in the RMAN session:

RMAN> REPAIR FAILURE;

Which statement describes the consequence of the command?

A. The command performs the recovery and closes the failures.

B. The command only displays the advice and the RMAN script required for repair.

C. The command produces an error because the ADVISE FAILURE command has not been executed before the REPAIR FAILURE command.

D. The command executes the RMAN script to repair the failure and removes the entry from the Automatic Diagnostic Repository (ADR).

Answer: C


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


Q125. Automatic PGA Memory Management eliminates the need to manually configure which of the following initialization parameters? (Choose all that apply.)

A. SORT_AREA_SIZE

B. HASH_AREA_SIZE

C. BITMAP_MERGE_AREA_SIZE

D. CREATE_BITMAP_AREA_SIZE

E. PGA_AGGREGATE_TARGET

Answer: ABCD


Q126. If you lost your entire database, including the database spfile, control files, online redo logs, and database datafiles, what kind of recovery would be required with RMAN?

A. Complete database recovery.

B. Incomplete database recovery.

C. Approximate database recovery.

D. Archived database recovery.

E. The database could not be recovered with RMAN.

Answer: B


Q127. You want to take a complete database backup using RMAN. The backup should consist only the used blocks from your database.

Which two statements are true about this backup operation? (Choose two.)

A. Backup compression should be enabled

B. Parallelism for the channel should be set to 2

C. All the files must be backed up as backup sets

D. The backup may be stored either on disk or on media with media manager

Answer: CD


Q128. Examine the following RMAN command:

BACKUP DATABASE

TAG TESTDB

KEEP UNTIL 'SYSDATE+1'

RESTORE POINT TESTDB06;

Which two statements are true regarding the backup taken by using the above RMAN command? (Choose two.)

A. Only data files and the control file are backed up.

B. Archived redo logs are backed up only if the database is open during the backup.

C. The backup is deleted after one day, regardless of the default retention policy settings.

D. The backup becomes obsolete after one day, regardless of the default retention policy settings.

Answer: BD


Q129. View the exhibit and examine the TRANS table's storage information.

After a massive delete operation, you executed the following statement to shrink the TRANS table:

SQL> ALTER TABLE trans SHRINK SPACE CASCADE;

Which statement describes the outcome of the command?

Exhibit:

A. An error is produced.

B. The table and all related objects are compacted and the position of the high-water mark (HWM) for the table is adjusted

C. The table and related indexes are compacted but the position of the high-water mark (HWM) for the table remains unchanged

D. The unused space in the table is reclaimed and returned to the tablespace and the data manipulation language (DML) triggers on the table are fired during the shrinking process

Answer: B


Q130. You executed the following command in Recovery Manager (RMAN):

RMAN> REPORT NEED BACKUP days 3;

What is the output of this command?

A. a list of files that require a backup within three days

B. a list of files requiring more than 3 days of archive logs to apply

C. a list of files that RMAN recommends be backed up only once in every three days, based on low volatility

D. a list of files for which a backup has already been performed in the last three days and which is required to be backed up again based on the high number of transactions performed on them

Answer: A