In 2026, flexible material means material you can use your way. CertkingdomPDF provides the 1z1-063 package — 278 verified practice questions — in PDF, PC engine, and online versions.
Oracle 1z1-063 Exam Syllabus Topics:
| Section | Objectives |
|---|---|
| Storage Structures and Space Management | - Tablespaces and Datafiles
|
| Security and User Management | - Database Security Features
|
| Backup and Recovery | - Flashback Technology
|
| Architecture and Multitenant Architecture | - Oracle Database Architecture Overview
|
| Performance Management and Monitoring | - Performance Tuning Concepts
|
1z1-063 Exam Practice FAQ
The Oracle Database 12c: Advanced Administration exam contains 77 questions, and you will have 150 minutes minutes to complete them. Practicing within the same limits builds the pacing the real exam demands.
This package includes 278 practice questions for the Oracle Database 12c: Advanced Administration exam. Every answer is verified by an experienced team of experts, so you can trust what you study.
The PDF version downloads in seconds and prints cleanly, so you can read on paper, flip through the pages freely, and write notes in the margins as you go. Marking each mistake on paper makes review sessions concrete: you see exactly which questions tripped you up and which topics need another round.
The Oracle Database 12c: Advanced Administration practice questions are organized around the official exam objectives. Key topics include:
- Backup and Recovery ()
- Architecture and Multitenant Architecture ()
- Performance Management and Monitoring ()
Use your printed pages to flag the topics that give you trouble, then focus your next session there.
You can register for the Oracle Database 12c: Advanced Administration exam through the official channels:
The Oracle Database 12c: Advanced Administration exam requires a score of 60-65% to pass, and the official registration fee is USD 245. Because the fee is significant, preparing thoroughly the first time is the practical choice.
Recommended: Oracle Database 12c Administrator Certified Associate (OCA) or equivalent experience
You can confirm the current eligibility requirements on the official 1z1-063 exam page before you register.
Many candidates combine practice questions with official training. Recommended options include:
If you learn best with physical pages, the PDF version is built for you. Print the full 278 practice questions for the 1z1-063 exam, work through them anywhere without a device, and keep your annotated pages as a personal review guide. The PC and online versions remain available whenever you want interactive practice.
Oracle Database 12c: Advanced Administration Sample Questions:
Your multitenant container database (CDB) CDB1 has two pluggable databases, PDB1 and PDB2. The local net service name CDB1 connects to the root database, and the service names PDB1 and PDB2 connect to the pluggable databases (PDBs), PDB1 and PDB2, respectively.
Examine the commands to change the value of the PDB modifiable initialization parameter:
Which statement is true about the OPTIMIZER_USE_SQL_PLAN_BASELINES parameter?
- A. It is set to TRUE for the root database and all the PDBs, but is effective only when the CDB is restarted and the PDBs are reopened.
- B. It is set to TRUE for the root database and the pluggable database PDB2, because values can be set for this parameter at the PDB level in a PDB.
- C. It is set to TRUE for the root database and all the PDBs, because the value set at the root level has higher precedence.
- D. It gives an error because it cannot be set for the root database.
Correct Answer: B 🗳️
Your Oracle 12c multitenant container database (CDB) contains multiple pluggable databases (PDBs). In the PDB HR_PDB, the common user C##ADMIN and the local user B_ADMIN have only the CONNECT privilege.
You create a common role C##ROLE1 with the CREATE ANY TABLE and SELECT ANY TABLE privileges.
You then execute the commands:
Which two statements are true? (Choose two.)
- A. B_ADMIN can create and select any table only in HR_PDB.
- B. The GRANT c##role1 TO b_admin command returns an error because CONTAINER should be set to ALL.
- C. C##ADMIN can create and select any table, and grant the C##ROLE1 role to users only in the root container.
- D. B_ADMIN can create and select any table in both the root container and HR_PDB.
- E. C##ADMIN can create and select any table in the root container and all the PDBs.
Correct Answer: A,E 🗳️
You want to create a database with a block size other than the default 8 KB by using the Database Configuration Assistant (DBCA).
Which option should you use?
- A. A file system for storage of data files
- B. Automatic Storage Management (ASM) for storage of data files
- C. A Data Warehouse database template
- D. A custom database template
Correct Answer: D 🗳️
You are administering a multitenant container database (CDB) that has no startup triggers and contains three pluggable databases (PDBs).
You execute the command to start up the CDB:
SQL> STARTUP
Which statement is true?
- A. CDB$ROOT is opened in read/write mode, but PDB$SEED and the PDBs are in closed mode.
- B. CDB$ROOT and PDB$SEED are opened in read-only mode, but the PDBs are in closed mode.
- C. CDB$ROOT is opened in read/write mode, PDB$SEED in read-only mode, and the PDBs in MOUNT state.
- D. CDB$ROOT, PDB$SEED, and the PDBs are opened in read/write mode.
- E. CDB$ROOT, PDB$SEED, and the PDBs are opened in read-only mode.
Correct Answer: C 🗳️
Explanation: Only visible for CertkingdomPDF members. You can sign-up / login (it's free).
Which three RMAN persistent settings can be set explicitly? (Choose three.)
- A. redo log backup duplexing
- B. image copy duplexing
- C. archivelog deletion policy
- D. controlfile autobackup formats
- E. SPFILE backup duplexing
- F. archivelog backup duplexing
Correct Answer: B,C,D 🗳️
Viewing page 1 out of 56 pages.
Viewing questions 1-5 out of 278 questions.
Tiffany 
Evan 
Cecilia 
Larry 
Maria 
Winston 
Elliot 
Moses 
Jason 
Molly 
