CompTIA Online Training

1Z0-053 Oracle Database 11g: Administration II

August 1, 2018 by admin

Exam Number: 1Z0-053
Exam Title: Oracle Database 11g: Administration II
Associated Certification Paths Oracle Database 11g Administrator Certified Professional
Duration: 120 minutes
Number of Questions: 78
Passing Score: 66%
View passing score policy
Validated Against: The exam has been validated against Oracle® Database 11g Release 2 version 11.2.0.1.0.
Format: Multiple Choice

Complete Recommended Training

Complete the training below to prepare for your exam (optional):

Oracle Database 11g: Administration Workshop II DBA Release 2

Additional Preparation and Information

A combination of Oracle training and hands-on experience (attained via labs and/or field experience) provides the best preparation for passing the exam.

Exam Preparation Seminar
Certification Exam Prep Seminar: Oracle Database 11g Administration II
Exam Prep Seminar Package: Oracle Database 11g Administration II

Practice Exams
Practice Exams: Oracle Authorized practice exam from Kaplan IT Training: 1Z0-053 Oracle Database 11g: Administration II

Additional Training
The earlier course is still a valid exam preparation tool but is no longer being scheduled:
Oracle Database 11g: Administration Workshop II
Training Opportunities for Oracle Partner Network Members (avialable to partners only)
OPN Guided Learning Path: Oracle Database 11g Implementation Specialist (avialable to partners only)
Training Resources by Exam Topics (avialable to partners only)

Database Architecture and ASM
Describe Automatic Storage Management (ASM)
Set up initialization parameter files for ASM and database instances
Start up and shut down ASM instances
Administer ASM disk groups

Configuring for Recoverability
Configure multiple archive log file destinations to increase availability
Define, apply and use a retention policy
Configure the Flash Recovery Area
Use Flash Recovery Area

Using the RMAN Recovery Catalog
Identify situations that require RMAN recovery catalog
Create and configure a recovery catalog
Synchronize the recovery catalog
Create and Use RMAN stored scripts
Back up the recovery catalog
Create and use a virtual private catalog

Configuring Backup Specifications
Configure backup settings
Allocate channels to use in backing up
Configure backup optimization

Using RMAN to Create Backups
Create image file backups
Create a whole database backup
Enable fast incremental backup
Create duplex backup and back up backup sets
Create an archival backup for long-term retention
Create a multisection, compressed and encrypted backup
Report on and maintain backups

Performing User-Managed Backup and Recovery
Recover from a lost TEMP file
Recover from a lost redo log group
Recover from the loss of password file
Perform user-managed complete database recovery
Perform user-managed incomplete database recovery
Perform user-managed and server managed backups
Identify the need of backup mode
Back up and recover a control file

Using RMAN to Perform Recovery
Perform complete recovery from a critical or noncritical data file loss using RMAN
Perform incomplete recovery using RMAN
Recover using incrementally updated backups
Switch to image copies for fast recovery
Restore a database onto a new host
Recover using a backup control file
Perform Disaster recovery

Using RMAN to Duplicate a Database
Creating a duplicate database
Using a duplicate database

Performing Tablespace Point-in-Time Recovery
Identify the situations that require TSPITR
Perform automated TSPITR

Monitoring and Tuning RMAN
Monitoring RMAN sessions and jobs
Tuning RMAN
Configure RMAN for Asynchronous I/O

Using Flashback Technology
Restore dropped tables from the recycle bin
Perform Flashback Query
Use Flashback Transaction

Additional Flashback Operations
Perform Flashback Table operations
Configure, Monitor Flashback Database and Perform Flashback Database operations
Set up and use a Flashback Data Archive

Diagnosing the Database
Set up Automatic Diagnostic Repository
Using Support Workbench
Perform Block Media Recovery

Managing Memory
Implement Automatic Memory Management
Manually configure SGA parameters
Configure automatic PGA memory management

Managing Database Performance
Use the SQL Tuning Advisor
Use the SQL Access Advisor to tune a workload
Understand Database Replay

Space Management
Manage resumable space allocation
Describe the concepts of transportable tablespaces and databases
Reclaim wasted space from tables and indexes by using the segment shrink functionality

Managing Resources
Understand the database resource manager
Create and use Database Resource Manager Components

Automating Tasks with the Scheduler
Create a job, program, and schedule
Use a time-based or event-based schedule for executing Scheduler jobs
Create lightweight jobs
Use job chains to perform a series of related tasks

Administering the Scheduler
Create Windows and Job Classes
Use advanced Scheduler concepts to prioritize jobs

QUESTION 2
You want to perform the following operations for the DATA ASM disk group:
Verify the consistency of the disk.
Cross-check all the file extent maps and allocation tables for consistency.
Check whether the alias metadata directory and file directory are linked correctly.
Check that ASM metadata directories do not have unreachable allocated blocks.
Which command accomplishes these tasks?

A. ALTER DISKGROUP data CHECK;
B. ALTER DISKGROUP data CHECK DISK;
C. ALTER DISKGROUP data CHECK FILE;
D. ALTER DISKGROUP data CHECK DISK IN FAILURE GROUP 1;

Answer: A

Explanation:
Syntax: ALTER DISKGROUP <disk_group_id> CHECK [REPAIR | NOREPAIR];
The check_diskgroup_clause lets you verify the internal consistency of Oracle ASM disk group
metadata. The disk group must be mounted. Oracle ASM displays summary errors and writes the
details of the detected errors in the alert log.
The CHECK keyword performs the following operations:
Refer to here

QUESTION 3
Which two statements are true regarding the functionality of the remap command in ASMCMD?
(Choose two.)

A. It repairs blocks that have read disk I/O errors.
B. It checks whether the alias metadata directory and the file directory are linked correctly.
C. It repairs blocks by always reading them from the mirror copy and writing them to the original
location.
D. It reads the blocks from a good copy of an ASM mirror and rewrites them to an alternate
location on disk if the blocks on the original location cannot be read properly.

Answer: A,D

Explanation:
Reference from the Oracle document release v11.1 at here:
Repairs a range of physical blocks on a disk. The remap command only repairs blocks that have
read disk I/O errors. It does not repair blocks that contain corrupted contents, whether or not those
blocks can be read. The command assumes a physical block size of 512 bytes and supports all
allocation unit sizes (1 to 64 MB).
Reference from the Oracle document release v11.2 at here:
The remap command marks a range of blocks as unusable on the disk and relocates any data
allocated in that range.

QUESTION 4
What is the advantage of setting the ASM-preferred mirror read for the stretch cluster
configuration?

A. It improves resync operations.
B. This feature enables much faster file opens.
C. It improves performance as fewer extent pointers are needed in the shared pool.
D. It improves performance by reading from a copy of an extent closest to the node.

Answer: D

Explanation:
Preferred Read Failure Groups
When you configure Oracle ASM failure groups, it might be more efficient for a node to read from
an extent that is closest to the node, even if that extent is a secondary extent. In other words, you
can configure Oracle ASM to read from a secondary extent if that extent is closer to the node
instead of Oracle ASM reading from the primary copy which might be farther from the node. Using
the preferred read failure groups feature is most useful in extended clusters.

QUESTION 5
Examine the following command:
ALTER DISKGROUP data MOUNT FORCE;
In which scenario can you use the above command to mount the disk group?

A. when ASM disk goes offline
B. when one or more ASM files are dropped
C. when some disks in a disk group are offline
D. when some disks in a failure group for a disk group are rebalancing

Answer: C

Explanation:
In the FORCE mode, Oracle ASM attempts to mount the disk group even if it cannot discover all of
the devices that belong to the disk group. This setting is useful if some of the disks in a normal or
high redundancy disk group became unavailable while the disk group was dismounted. When
MOUNT FORCE succeeds, Oracle
ASM takes the missing disks offline.
If Oracle ASM discovers all of the disks in the disk group, then MOUNT FORCE fails. Therefore,
use the MOUNT FORCE setting only if some disks are unavailable. Otherwise, use NOFORCE.
In normal- and high-redundancy disk groups, disks from one failure group can be unavailable and
MOUNT FORCE will succeed. Also in high-redundancy disk groups, two disks in two different
failure groups can be unavailable and MOUNT FORCE will succeed. Any other combination of
unavailable disks causes the operation to fail, because Oracle ASM cannot guarantee that a valid
copy of all user data or metadata exists on the available disks.
Refer to here

QUESTION 6
Which background process of a database instance, using Automatic Storage Management (ASM),
connects as a foreground process into the ASM instance?

A. ASMB
B. PMON
C. RBAL
D. SMON

Answer: A

Explanation:
ASMB (ASM Background Process): Communicates with the ASM instance, managing storage and
providing statistics, runs in ASM instances when the ASMCMD cp command runs or when the
database instance first starts if the server parameter file is stored in ASM. ASMB also runs with
Oracle Cluster Registry on ASM.
RBAL (ASM Rebalance Master Process): In an ASM instance, it coordinates rebalance activity for
disk groups. In a database instances, it manages ASM disk groups.
PMON (Process Monitor): Monitors the other background processes and performs process
recovery when a server or dispatcher process terminates abnormally.
SMON (System Monitor Process): Performs critical tasks such as instance recovery and dead
transaction recovery, and maintenance tasks such as temporary space reclamation, data
dictionary cleanup, and undo tablespace management

Click here to view complete Q&A of 1Z0-053 exam
Certkingdom Review, Certkingdom PDF Torrents

Best Oracle 1Z0-053 Certification, Oracle 1Z0-053 Training at certkingdom.com

Comments |0|