1z0-053 braindumps [Jun 2016]


♥♥ 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

It is more faster and easier to pass the Oracle 1Z0-053 exam by using Actual Oracle Oracle Database 11g: Administration II questuins and answers. Immediate access to the Up to the immediate present 1Z0-053 Exam and find the same core area 1Z0-053 questions with professionally verified answers, then PASS your exam with a high score now.

2016 Jun 1z0-053 syllabus:

Q161. Examine the following scenario:

- Database is running in ARCHIVELOG mode.

- Complete consistent backup is taken every Sunday.

- On Tuesday the instance terminates abnormally because the disk on which control files are located gets corrupted

- The disk having active online redo log files is also corrupted.

- The hardware is repaired and the paths for online redo log files and control files are still valid. Which option would you use to perform the recovery of database till the point of failure?

A. Restore the latest whole backup, perform complete recovery, and open the database normally

B. Restore the latest whole backup, perform incomplete recovery, and open the database with the RESETLOGS option.

C. Restore the latest backups control file, perform complete recovery, and open the database with the RESETLOGS option.

D. Restore the latest backup control file, perform incomplete recovery using backup control file, and open the database with the RESETLOG option.

Answer: D


Q162. Which of the following Oracle features is enabled by setting a nonzero value for the MEMORY_TARGET initialization parameter?

A. Automatic PGA Memory Management

B. Automatic SGA Memory Management

C. Automatic Shared Memory Management

D. Automatic Memory Management

E. Manual SGA Memory Management

F. None of the above

Answer: D


Q163. You run the SQL Tuning Advisor (STA) to tune a SQL statement that is part of a fixed SQL plan baseline. The STA generates a SQL profile for the SQL statement, which recommends that you accept the profile. Which statement is true when you accept the suggested SQL profile?

A. The tuned plan is not added to the SQL plan baseline.

B. The tuned plan is added to the fixed SQL plan baseline as a fixed plan.

C. The tuned plan is added to the fixed SQL plan baseline as a nonfixed plan.

D. The tuned plan is added to a new nonfixed SQL plan baseline as a nonfixed plan.

Answer: C


Q164. For Oracle 11g, Oracle strongly recommends that you configure your database to use which of the following memory-management features?

A. Automatic PGA Memory Management

B. Automatic SGA Memory Management

C. Automatic Shared Memory Management

D. Automatic Memory Management

E. Manual SGA Memory Management

F. None of the above

Answer: D


Q165. Which two statements are true regarding the starting of the database instance using the following command? (Choose two.)

SQL>STARTUP UPGRADE

A. It enables all system triggers.

B. It allows only SYSDBA connections.

C. It ensures that all job queues remain active during the upgrade process.

D. It sets system initialization parameters to specific values that are required to enable database upgrade scripts to be run.

Answer: BD


1Z0-053  exams

Improved 1z0-053 download:

Q166. What are three benefits of using ASM? (Choose three.)

A. Ease of disk administration and maintenance

B. Load balancing across physical disks

C. Software RAID-1 data redundancy with double or triple mirrors

D. Automatic recovery of failed disks

Answer: ABC


Q167. Your database is running in ARCHIVELOG mode, and the database is open. You execute an RMAN backup and specify the KEEP clause.

Which components are backed up when this option is specified?

A. only the control file, the current SPFILE, and data files

B. only the current SPFILE and data files if autobackup is disabled

C. only the data files and the archived redo logs

D. the control file, current SPFILE file, data files, and archived redo logs

Answer: D


Q168. Evaluate the following command:

SQL> CREATE TABLE design_data (id NUMBER,

doc CLOB)

LOB(doc) STORE AS SECUREFILE(DEDUPLICATE);

Which statement is true regarding the above command?

A. The LOB values are automatically compressed.

B. The LOB values are cached by default in the buffer cache.

C. The LOB values are automatically stored in encrypted mode.

D. All LOB data that is identical in two or more rows in a LOB column share the same data blocks.

Answer: D


Q169. Examine the following ALTER command:

SQL> ALTER DISKGROUP dgroup1 UNDROP DISKS;

What is the purpose of the command?

A. It cancels all pending disk drops within the disk group.

B. It restores disks that are being dropped as the result of a DROP DISKGROUP operation

C. It mounts disks in the disk group for which the drop-disk operation has already been co pleted

D. It restores all the dropped disks in the disk group for which the drop-disk operation has already been completed

E. It adds previously dropped disks back into the disk group

Answer: A


Q170. You have three temporary tablespace groups named G1, G2, and G3 in your database.

You are creating a new temporary tablespace as follows:

CREATE TEMPORARY TABLESPACE TEMP1 TEMPFILE '/u1/data/temp1.dbf' SIZE 10M TABLESPACE GROUP ''

Which statement regarding the above command is correct?

A. It will create the tablespace TEMP1 in group G1.

B. It will create the tablespace TEMP1 in group G3.

C. It will not add the tablespace TEMP1 to any group.

D. It will create the tablespace TEMP1 in the default group.

Answer: C



see more Oracle Database 11g: Administration II