1Z0-063 Study Guide and How to Crack Exam on Oracle Database 12c

1Z0-063 Oracle Database 12c - Advanced Administration Exam Summary – Syllabus – Questions

1Z0-063 Sample Questions and Exam Summary ____________________________________________________________________________________

Table of Contents Introduction to 1Z0-063 Exam on Oracle Database 12c - Advanced Administration ................................................................................................ 2 Oracle 1Z0-063 Certification Details: ............................................................ 2 Oracle 1Z0-063 Exam Syllabus: .................................................................... 3 1Z0-063 Sample Questions: ......................................................................... 6 Answers to 1Z0-063 Exam Questions: .......................................................... 8

____________________________________________________________________________________ 1Z0-063 - Oracle Database 12c - Advanced Administration

pg. 1

1Z0-063 Sample Questions and Exam Summary ____________________________________________________________________________________

Introduction to 1Z0-063 Exam on Oracle Database 12c - Advanced Administration You can use this document to collect all the information about Oracle Database 12c Advanced Administration (1Z0-063) certification. The Oracle 1Z0-063 certification is mainly targeted to those candidates who are from enterprise application background and want to flourish their career with Oracle Database 12c Administrator Certified Professional (OCP) credential. The Oracle Database 12c - Advanced Administration certification exam validates your understanding of the Oracle Applications technology and sets the stage for your future progression.

Oracle 1Z0-063 Certification Details: Exam Name

Oracle Database 12c - Advanced Administration

Exam Code

1Z0-063

Exam Product Version

Oracle Database 12c

Exam Price

USD $245 (Pricing may vary by country or by localized currency)

Duration

120

Number of Questions

80

Passing Score

60%

Validated Against

This exam has been validated against Oracle Database 12.1.0.1.0.

Format

Multiple Choice

Oracle Database 12c: Backup and Recovery Recommended Training Workshop and Oracle Database 12c: Managing Multitenant Architecture Schedule Exam

Pearson VUE - Oracle

Recommended Practice 1Z0-063 Online Practice Exam

____________________________________________________________________________________ 1Z0-063 - Oracle Database 12c - Advanced Administration

pg. 2

1Z0-063 Sample Questions and Exam Summary ____________________________________________________________________________________

Oracle 1Z0-063 Exam Syllabus: Subjects Backup and Recovery

Sub Topics

- Explain Oracle backup and recovery solutions - Describe types of database failures Oracle Data - Describe the tools available for backup and recovery tasks Protection Solutions - Describe RMAN and maximum availability architecture - Use the SYSBACK privilege - Use RMAN stand-alone and job commands Performing Basic - Back up and recover a NOARCHIVELOG database Backup and - Perform backup and recovery in NOARCHIVELOG mode Recovery - Use SQL in RMAN - Configure and manage RMAN settings - Configure persistent settings for RMAN - View persistent settings - Specify a retention policy Configuring for - Configure the Fast Recovery Area Recoverability - Explain the Fast Recovery Area - Configure the Fast Recovery Area - Configure control files and redo log files for recoverability - Multiplex control files - Multiplex redo log files - Create and use an RMAN recovery catalog - Configure a recovery catalog - Register target databases in a recovery catalog - Catalog additional backup files - Resynchronize a recovery catalog Using the RMAN - Use and maintain RMAN stored scripts Recovery Catalog - Upgrade and drop a recovery catalog - Protect the RMAN recovery catalog - Back up the recovery catalog - Re-create an unrecoverable recovery catalog - Export and import the recovery catalog - Use various RMAN backup types and strategies - Enable ARCHIVELOG mode - Create tape and disk based backups Implementing - Create whole database backups Backup Strategies - Create consistent and inconsistent backups - Create backup sets and image copies - Create backups of read-only tablespaces - Employ best practices for data warehouse backups - Perform full and incremental backups - Create full and incremental backups - Use the Oracle-suggested backup strategy Performing Backups - Manage backups - Configure and monitor block change tracking - Report on backups using LIST, REPORT commands - Manage backups using CROSSCHECK, DELETE commands

____________________________________________________________________________________ 1Z0-063 - Oracle Database 12c - Advanced Administration

pg. 3

1Z0-063 Sample Questions and Exam Summary ____________________________________________________________________________________ - Use techniques to improve backups - Create compressed backups - Create multi-section backups of very large files - Create proxy copies Configuring RMAN - Create duplexed backup sets Backup Options and - Create backups of backup sets Creating Backup of - Create archival backups Non-Database Files - Perform backup of non-database files - Back up a control file to trace - Back up archived redo log files - Back up ASM diskgroup metadata - Create RMAN-encrypted backups - Use transparent-mode encryption Using RMAN- Use password-mode encryption Encrypted Backups - Use dual-mode encryption - Restore encrypted backups - Describe the Automatic Diagnostic Workflow - Use the Automatic Diagnostic Repository - Use ADRCI - Find and interpret message output and error stacks Diagnosing Failures - Use the Data Recovery Advisor - Handle block corruption - Detect block corruption using RMAN - Perform block recovery using RMAN - Describe and tune instance recovery - Perform complete and incomplete recovery Performing Restore - Use RMAN RESTORE and RECOVER commands and Recovery - Restore ASM disk groups Operations - Recover from media failures - Perform complete and incomplete or “point-in-time” recoveries using RMAN - Perform recovery for spfile, control file, redo log files Recovering Files - Perform table recovery from backups Using RMAN - Perform recovery of index and read-only tablespaces, temp file - Restore a database to a new host Using Oracle Secure - Configure and use Oracle Secure Backup Backup - Describe the Flashback technologies - Configure a database to use Flashback technologies - Guarantee undo retention - Use Flashback to query data - Use Flashback Query Using Flashback - Use Flashback Version Query Technologies - Use Flashback Transaction Query - Flash back a transaction - Perform Flashback Table operations - Perform Flashback Table - Restore tables from the recycle bin - Describe and use Flashback Data Archive

____________________________________________________________________________________ 1Z0-063 - Oracle Database 12c - Advanced Administration

pg. 4

1Z0-063 Sample Questions and Exam Summary ____________________________________________________________________________________ - Use Flashback Data Archive - Use DBMS_FLASHBACK_ARCHIVE package Using Flashback Database

Transporting Data

Duplicating a Database

Monitoring and Tuning of RMAN Operations

- Perform Flashback Database - Configure Flashback Database - Perform Flashback Database - Describe and use transportable tablespaces and databases - Transport tablespaces between databases using image copies or backup sets - Transport databases using data files or backup sets - Transport data across platforms - Choose a technique for duplicating a database - From an active database, connected to the target and auxiliary instances - From backup, connected to the target and auxiliary instances - From backup, connected to the auxiliary instance, not connected to the target, but with recovery catalog connection - From backup, connected to the auxiliary instance, not connected to the target and the recovery catalog - Duplicate a database with RMAN - Create a backup-up based duplicate database - Duplicate a database based on a running instance - Tune RMAN performance - Interpret RMAN error stacks - Diagnose performance bottlenecks - Tune RMAN backup performance

Managing Pluggable and Container Databases Introduction Multitenant Container and - Describe the multitenant container database architecture Pluggable Database - Explain pluggable database provisioning Architecture Creating Multitenant - Configure and create a CDB Container and - Create a PDB using different methods Pluggable - Unplug and drop a PDB Databases - Migrate a non-CDB database to PDB - Establish connections to CDB/PDB Managing a CDB - Start up and shut down a CDB and open and close PDBs and PDBs - Evaluate the impact of parameter value changes Managing Storage in - Manage permanent and temporary tablespaces in CDB and a CDB and PDBs PDBs - Manage common and local users Managing Security - Manage common and local privileges in a CDB and PDBs - Manage common and local roles - Enable common users to access data in specific PDBs

____________________________________________________________________________________ 1Z0-063 - Oracle Database 12c - Advanced Administration

pg. 5

1Z0-063 Sample Questions and Exam Summary ____________________________________________________________________________________ - Perform backups of a CDB and PDBs Managing - Recover PDB from PDB datafiles loss Availability - Use Data Recovery Advisor - Duplicate PDBs using RMAN - Monitor operations and performance in a CDB and PDBs Managing - Manage allocation of resources between PDBs and within a PDB Performance - Perform Database Replay Moving Data, - Use Data Pump Performing Security - Use SQL*Loader Operations and - Audit operations Interacting with - Use Other Products with CDB and PDBs - Database Vault, Data Other Oracle Guard, LogMiner Products

1Z0-063 Sample Questions: 01. Which two are prerequisites for creating a backup-based duplicate database? a) connecting to the target database and a recovery catalog to execute the duplicate command b) creating a password file for an auxiliary instance c) connecting to an auxiliary instance d) matching the database identifier (DBID) of the source database and the duplicate database e) creating an SPFILE for the target database 02. Which two statements are true about scheduling operations in a pluggable database (PDB)? a) Scheduler jobs for a PDB can be defined only at the container database (CDB) level. b) A job defined in a PDB runs only if that PDB is open. c) Scheduler attribute setting is performed only at the CDB level. d) Scheduler objects created by users can be exported or imported using Data Pump. e) Scheduler jobs for a PDB can becreated only by common users.

03. Which two statements are true about dropping a pluggable database (PDB)? a) A PDB must be in mount state or it must be unplugged. b) The data files associated with a PDB are automatically removed from disk. c) A dropped and unplugged PDB can be plugged back into the same multitenant container database (CDB) or other CDBs. d) A PDB must be in closed state. e) The backups associated with a PDB are removed. f) A PDB must have been opened at least once after creation.

04. Which three statements are true about Consolidated Database Replay? a) The workload capture and replay systems must have the same operating system (OS). b) Multiple workload captures from multiple databases can be replayed simultaneously on all pluggable databases (PDBs) in a multitenant container database (CDB). c) A subset of the captured workload can be replayed.

____________________________________________________________________________________ 1Z0-063 - Oracle Database 12c - Advanced Administration

pg. 6

1Z0-063 Sample Questions and Exam Summary ____________________________________________________________________________________ d) The number of captured workloads must be the same as the number of PDBs in a multitenant CDB. e) Multiple replay schedules can be defined for a consolidated replay and during replay initialization, you can select from any of the existing replay schedules.

05. Which of the following is not the name of an Oracle Database process? a) DBWDBW b) LGWR c) ARCH d) ORCL e) All are database processes 06. What type of backup is stored in a proprietary RMAN format? a) Backup set b) Image copy c) Backup section d) Backup group 07. Which command will restore all data files to the date 9/30/2013 at 18:00 hours? a) RESTORE DATAFILES UNTIL TIME '09/28/2013:21:03:11'; b) RESTORE DATABASE FILES UNTIL TIME '09/28/2013:18:00:00'; c) RESTORE DATABASE UNTIL TIME '09/28/2013:18:00:00'; d) RECOVER DATABASE UNTIL TIME '09/28/2013:18:00:00'; e) RECOVER DATABASE UNTIL TIMESTAMP '09/28/2013:18:00:00'; 08. In order to perform Flashback Transaction Query operations, which of these steps are required? a) Ensure that the database is running with version 10.1 or greater compatibility. b) Enable Flashback Logging. c) Enable Supplemental Logging. d) Ensure that the database is running with version 10.0 compatibility. e) Ensure that the database is in archive log mode.

09. Which of the following are advantages of the multitenant architecture? a) Reduced hardware requirements b) Efficient management of data and code c) Simpler management of the database d) Platform independence 10. When creating a physical standby of a CDB, which of the following must be considered? a) Each PDB functions independently as a primary or standby. b) The entire CDB and all its PDBs are in the same role, either primary or standby. c) When you fail over the primary to a standby, each PDB must be failed over separately. d) When you fail over the primary to a standby, each PDB will fail over automatically. e) None of the above.

____________________________________________________________________________________ 1Z0-063 - Oracle Database 12c - Advanced Administration

pg. 7

1Z0-063 Sample Questions and Exam Summary ____________________________________________________________________________________

Answers to 1Z0-063 Exam Questions: QUESTION: 01

QUESTION: 02

QUESTION: 03

QUESTION: 04

QUESTION: 05

Answer: a, b

Answer: b, d

Answer: a, d

Answer: b, c, e

Answer: d

QUESTION: 06

QUESTION: 07

QUESTION: 08

QUESTION: 09

QUESTION: 10

Answer: a

Answer: c

Answer: c, d

Answer: a, b, c

Answer: b, d

Note: If you find any typo or data entry error in these sample questions, we request you to update us by commenting on this page or write an email on feedback@oraclestudy.com

____________________________________________________________________________________ 1Z0-063 - Oracle Database 12c - Advanced Administration

pg. 8