PDF Version DemoThree versions, one decision: the Oracle Database 12c: Advanced Administration package from ActualPDF comes as a budget-friendly printable PDF, a Windows software engine that flags your mistakes for re-practice, and an online version for any operating system. All carry the same 278 1z1-063 questions.
Oracle 1z1-063 Exam Overview:
| Certification Vendor: | Oracle |
|---|---|
| Exam Name: | Oracle Database 12c: Advanced Administration |
| Exam Number: | 1Z0-063 |
| Exam Price: | USD 245 |
| Real Exam Qty: | 77-80 |
| Related Certifications: | Oracle Database 12c Administrator Certified Master Oracle Database 12c Administrator Certified Associate |
| Exam Duration: | 120 minutes |
| Passing Score: | 60% |
| Available Languages: | Japanese, English |
| Certificate Validity Period: | Valid until recertification required; retired March 1, 2023 |
| Exam Format: | Multiple Choice, Multiple Select |
| Recommended Training: | Oracle Database 12c: Managing Multitenant Architecture Oracle Database 12c: Backup and Recovery Workshop |
| Exam Registration: | Pearson VUE Oracle University |
| Sample Questions: |  |
| Exam Way: | Online proctored or onsite at Pearson VUE test centers |
| Pre Condition: | Valid Oracle Database 12c Administrator Certified Associate (1Z0-071 + 1Z0-062) or equivalent upgrade certification |
| Official Syllabus URL: | https://education.oracle.com/pexam_1Z0-063 |
Oracle 1z1-063 Exam Syllabus Topics:
| Section | Weight | Objectives |
|---|---|---|
| Topic 1: Performing Database Recovery | 20% | - Perform block media recovery - Restore and recover PDBs and CDBs - Complete and incomplete database recovery - Recover control files, SPFILE, redo logs, and data files |
| Topic 2: Configuring for Recoverability | 15% | - Set up Fast Recovery Area - Configure ARCHIVELOG/NOARCHIVELOG mode - Configure RMAN persistent settings and retention policies - Implement Flashback technologies |
| Topic 3: Flashback Technologies | 10% | - Use Flashback Query, Table, Transaction, and Database - Create and manage restore points |
| Topic 4: Oracle Data Protection Solutions | 15% | - Explain backup and recovery architecture - Use RMAN commands and SYSBACKUP privilege - Identify database failure types and recovery strategies |
| Topic 5: Managing Multitenant Architecture | 10% | - Administer CDB and PDB backups and recovery - Clone, plug, and unplug PDBs |
| Topic 6: Transporting and Duplicating Databases | 12% | - Use active and backup-based duplication - Duplicate databases using RMAN - Transport tablespaces and databases across platforms |
| Topic 7: Using RMAN for Backup | 18% | - Create full, incremental, and multisection backups - Configure backup encryption and compression - Validate and maintain backups - Back up control files, SPFILE, and non-database files |
1z1-063 Exam FAQ: Before You Book Your Seat
Oracle Database 12c: Advanced Administration is an official Oracle exam, listed under exam code 1z1-063. A passing result earns you the Oracle Database 12c Administrator Certified Professional certification at the Professional level. It also ties into Oracle Database 12c Administrator Certified Associate, Oracle Database 12c Administrator Certified Master, extending its value across your certification roadmap. Employers read this credential as verified competence, which is why it keeps appearing in job requirements.
Expect 77-80 questions inside 120 minutes on the Oracle Database 12c: Advanced Administration exam. That pace punishes hesitation, so rehearse it: the ActualPDF software engine simulates the real exam scene, reminds you of the questions you got wrong, and pushes you to re-practice them until the clock stops being your enemy.
Passing Oracle Database 12c: Advanced Administration requires 60%, and the official registration fee is USD 245. Retakes charge the full USD 245 again, which is why experienced candidates treat preparation as the cheaper exam fee. Verify your readiness with repeated ActualPDF practice scores above the requirement before you commit to a date.
Valid Oracle Database 12c Administrator Certified Associate (1Z0-071 + 1Z0-062) or equivalent upgrade certification
Requirements evolve, so confirm the current conditions before registering on the official exam page.
Registration for Oracle Database 12c: Advanced Administration goes through the official channels listed here.
When you schedule, note that the exam is delivered Online proctored or onsite at Pearson VUE test centers.
Oracle recommends the following training for Oracle Database 12c: Advanced Administration candidates.
- Oracle Database 12c: Backup and Recovery Workshop
- Oracle Database 12c: Managing Multitenant Architecture
Follow any course with the 278 practice questions in the ActualPDF 1z1-063 package; the software engine will even remind you which mistakes need another round.
Yes. ActualPDF provides a free download demo of the Oracle Database 12c: Advanced Administration material, so you can check the content before choosing a version. After purchase, a one-year warranty covers you: the latest version is sent to you as it releases, free for 365 days, and after expiry you can extend the update service at a 50% discount.
Your purchase is covered by a 100% money-back guarantee with clear conditions. Take the Oracle Database 12c: Advanced Administration exam within 60 days of purchase; if you fail, provide your unqualified result by submitting a scanned enrollment slip and the official Score Report PDF within 2 days of the exam, and the full refund is processed within 7 days. The exam must match your product, candidate and payer names must match, and attempts within 3 days of purchase, unused downloads, free materials, and expired orders are not covered. Alternatively, exchange for two other exam products of equal value, free, or wait for updates while keeping your original product's update service.
Delivery is instant: files unlock for download at payment and are emailed within one minute. If nothing arrives within 2 hours, check spam and contact customer service, which works 7/24 and normally replies within two hours. Installation is unlimited across your computers.
The Oracle Database 12c: Advanced Administration syllabus spans 7 domains, led by Performing Database Recovery (20%), Transporting and Duplicating Databases (12%), and Flashback Technologies (10%). The complete topic list is published above; candidates who study the map first rarely get lost later.
Oracle Database 12c: Advanced Administration Sample Questions:
Question 1
Examine the output:
SQL> ARCHIVE LOG LIST
Database log modeArchive Mode
Automatic archival Enabled
Archive DestinationUSE_DB_RECOVERY_FILE_DEST
Oldest online log sequence376
Next log sequence to archive378
Current log sequence378
Which three types of files are automatically placed in the fast recovery area? (Choose three.)
A. Flashback data archives (FDA)
B. Archived redo log files
C. Control file autobackups
D. Recovery Manager (RMAN) backup pieces
E. Server parameter file (SPFILE)
Question 2
Your multitenant container database (CDB) CDB1 that is running in ARCHIVELOG mode contains two pluggable databases (PDBs), PDB2_1 and PDB2_2. RMAN is connected to the target database PDB2_1.
Examine the command executed to back up PDB2_1:
RMAN> BACKUP DATABASE PLUS ARCHIVELOG;
Which statement is true about the execution of this command?
A. It succeeds but only the data files belonging to the PDB2_1 pluggable database are backed up.
B. It fails because archive log files cannot be backed up using a connection to a PDB.
C. It fails because the PLUGGABLE clause is missing.
D. It succeeds and all data files belonging to PDB2_1 are backed up along with the archive log files.
Question 3
Which two statements are true about a multitenant architecture? (Choose two.)
A. A PDB can have a private undo tablespace.
B. A PDB can have a private temporary tablespace.
C. Each pluggable database (PDB) has its own initialization parameter file.
D. Each PDB has a private control file.
E. Log switches occur only at the container database level.
Question 4
Which three conditions must be met before you Virtual Private Catalog (VPC) can be created and used by an Administrator? (Choose three.)
A. A base recovery catalog must exist.
B. The DBA role must be granted to the virtual catalog owner.
C. The REGISTER DATABASE privilege should be granted to the virtual catalog owner.
D. The owner of the VPC cannot own recovery catalog.
E. At least one target database should be registered in the recovery catalog.
Question 5
In CDB$ROOT of your multitenant container database (CDB), you create a common user, C##A_ADMIN, and then execute the command:
Which statement is true?
A. The command fails because system privileges cannot be granted to a common user.
B. The command executes successfully, enabling the C##A_ADMIN user to create a tablespace only in the root database.
C. The command fails because the CONTAINER clause is not used.
D. The command executes successfully, enabling the C##A_ADMIN user to create tablespaces in the root database, as well as in the pluggable databases (PDBs).
Solutions:
| Question 1 Answer: B,C,D | Question 2 Answer: A | Question 3 Answer: B,E | Question 4 Answer: A,B,D | Question 5 Answer: B |
