1z0-053 dumps free download (451 to 460)


♥♥ 2017 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.certleader.com/1Z0-053-dumps.html


1Z0-053 Product Description:
Exam Number/Code: 1Z0-053 vce
Exam name: Oracle Database 11g: Administration II
n questions with full explanations
Certification: Oracle Certification
Last updated on Global synchronizing

Instant Access to Free VCE Files: Oracle 1Z0-053 Oracle Database 11g: Administration II

1Z0-053 examcollection

Exam Code: 1Z0-053 (Practice Exam Latest Test Questions VCE PDF)
Exam Name: Oracle Database 11g: Administration II
Certification Provider: Oracle
Free Today! Guaranteed Training- Pass 1Z0-053 Exam.

2016 May 1Z0-053 Study Guide Questions:

Q451. As DBA for the Rebel Alliance you have decided that you need to facilitate some redundancy in your database. Using ASM, you want to create a disk group that will provide for the greatest amount of redundancy for your ASM data (you do not have advanced SAN mirroring technology available to you, unfortunately). Which of the following commands would create a disk group that would offer the maximum in data redundancy?

A. CREATE DISKGROUP dg_alliance1 NORMAL REDUNDANCY failgroup diskcontrol1 DISK

`c:\oracle\asm_disk\_file_disk3' NAME file_ diska1 failgroup diskcontrol2 DISK

`c:\oracle\asm_disk\_file_disk4' NAME file_

diskb1;

B. CREATE DISKGROUP dg_alliance1 EXTERNAL REDUNDANCY

failgroup diskcontrol1 DISK 'c:\oracle\asm_disk\_file_disk3' NAME file_ diska1;

C. CREATE DISKGROUP dg_alliance1

HIGH REDUNDANCY

failgroup diskcontrol1 DISK 'c:\oracle\asm_disk\_file_disk1' NAME file_ disk1

failgroup diskcontrol2 DISK 'c:\oracle\asm_disk\_file_disk2' NAME file_ disk2

failgroup diskcontrol2 DISK 'c:\oracle\asm_disk\_file_disk3' NAME file_ disk3;

D. CREATE DISKGROUP dg_alliance1

MAXIMUM REDUNDANCY

failgroup diskcontrol1 DISK 'c:\oracle\asm_disk\_file_disk1' NAME file_ disk1

failgroup diskcontrol2 DISK 'c:\oracle\asm_disk\_file_disk2' NAME file_ disk2

failgroup diskcontrol2 DISK 'c:\oracle\asm_disk\_file_disk3' NAME file_ disk3

failgroup diskcontrol2 DISK 'c:\oracle\asm_disk\_file_disk4' NAME file_ disk4;

E. None of the above

Answer: C


Q452. You want to track and store all transactional changes to a table over its lifetime. To accomplish this task, you enabled Flashback Data Archive with the retention of 5 years. After some time, the business requirement changed and you were asked to change the retention from 5 years to 3 years. To accomplish this, you issued the following command:

ALTER FLASHBACK ARCHIVE fla1 MODIFY RETENTION 3 YEAR;

What is the implication of this command?

A. The command produces an error because the retention time cannot be reduced.

B. All historical data is retained but the subsequent flashback data archives are maintained for only three years.

C. All historical data is purged and the new flashback data archives are maintained for three years.

D. All historical data older than three years is purged from the flashback archive FLA1.

Answer: D


Q453. Identity two advantages of using a recovery catalog in-load of the control File of the target database Recovery Manager (RMAN). (Choose two.)

A. You can use RMAN stored scripts.

B. Recovery is faster if data is stored in catalog in addition to the control file.

C. You can store backup Information of all registered databases in one place.

D. Database backups are automatically deleted when they are older than the specified time period.

Answer: AC


1Z0-053  free download

Up to the immediate present exams 1z0-051 1z0-052 1z0-053:

Q454. Evaluate the following command and its output:

SQL>SELECT * FROM dba_temp_free_space;

TABLESPACE_NAME TABLESPACE_SIZE ALLOCATED_SPACE FREE_SPACE

--------------------------- -------------------------- --------------------------- -------------------

LMTEMP 250609664 101048576 149561088

Which two statements correctly interpret the output? (Choose two.)

A. FREE_SPACE indicates only the space that is currently unallocated.

B. ALLOCATED_SPACE indicates only the space currently allocated and in use.

C. FREE_SPACE indicates only the space that is currently allocated and available for reuse.

D. ALLOCATED_SPACE indicates both the space currently allocated and used, and the space that is available for reuse.

E. FREE_SPACE indicates both the space that is currently allocated and available for reuse, and the space that is currently unallocated.

Answer: DE


Q455. Exhibit:


View the Exhibit to examine a portion of the output from the VALIDATE DATABASE command.

Which statement is true about the block corruption detected by the command?

A. No action is taken except the output in the Exhibit.

B. The ADVISE FAILURE command is automatically called to display the repair script.

C. The failure is logged into the Automatic Diagnostic Repository (ADR).

D. The corruption is repaired by the command implicitly.

Answer: C


Q456. You perform a backup using the following BACKUP command:

RMAN> BACKUP AS COMPRESSED BACKUPSET DATABASE;

Which statement is true of this command?

A. A different procedure is required to restore a database from compressed backups

B. The AS COMPRESSED clause of the BACKUP command provided by RMAN is used to create compressed backup sets and image copies.

C. Using this command to create backups minimizes the bandwidth consumed

D. Using this command to create backups improves the performance of the backup process

Answer: C


1Z0-053  free download

Refined 1z0-053 latest exam:

Q457. Which two are the uses of the ASM metadata backup and restore (AMBR) feature? (Choose two.)

A. It can be used to back up all data on ASM disks.

B. It can be used to recover the damaged ASM disk group along with the data.

C. It can be used to gather information about a preexisting ASM disk group with disk paths, disk name, failure groups, attributes, templates, and alias directory structure.

D. It can be used to re-create the ASM disk group with its attributes.

Answer: CD


Q458. Which command do you use to create a recovery-catalog schema?

A. create recovery catalog

B. create catalog

C. build catalog

D. catalog create

E. mount catalog

Answer: B


Q459. Which statement is true regarding the VALIDATE DATABASE command? 

A. It checks the database for intrablock corruptions only.

B. It checks for block corruption in the valid backups of the database.

C. It checks the database for both intrablock and interblock corruptions.

D. It checks for only those corrupted blocks that are associated with data files.

Answer: A


Q460. View the Exhibit to examine the error obtained during the I/O calibration process.

There are no data files on raw devices. What is the reason for this error? 


A. The DISK_ASYNCH_IO parameter is set to TRUE.

B. The FILESYSTEMIO_OPTIONS parameter is set to NONE.

C. Another session runs the I/O calibration process concurrently.

D. The pending area has not been created before running the I/O calibration process.

Answer: B



see more Oracle Database 11g: Administration II