Amazon
Avaya
Checkpoint
Cisco®
CompTIA
CrowdStrike
EC-Council
EXIN
Fortinet
Google
ISC
ISC2
ITIL®
Juniper
Microsoft
MuleSoft
Okta
Oracle
Palo Alto Networks
Salesforce
All Vendors
  1. Home
  2. Oracle
  3. 1Z0-063

Oracle 1Z0-063 Exam (page: 1)
Oracle Database 12c: Advanced Administration
Updated on: 11-Nov-2025

Viewing Page 1 of 57
1Z0-063 PDF 320 Questions

Which two statements are true about scheduling operations in a pluggable database (PDB)? (Choose two.)

  1. Scheduler jobs for a PDB can be defined only at the container database (CDB) level.
  2. A job defined in a PDB runs only if that PDB is open.
  3. Scheduler attribute setting is performed only at the CDB level.
  4. Scheduler objects created by users can be exported or imported using Data Pump.
  5. Scheduler jobs for a PDB can be created only by common users.

Answer(s): B,D



A complete database backup to media is taken for your database every day. Which three actions would you take to improve backup performance? (Choose three.)

  1. Set the backup_tape_io_slaves parameter to true.
  2. Set the dbwr_io_slaves parameter to a nonzero value if synchronous I/O is in use.
  3. Configure large pool if not already done.
  4. Remove the rate parameter, if specified, in the allocate channel command.
  5. Always use RMAN compression for tape backups rather than the compression provided by media manager.
  6. Always use synchronous I/O for the database.

Answer(s): B,C,D


Reference:

http://docs.oracle.com/cd/B19306_01/backup.102/b14191/rcmtunin.htm



For which three pieces of information can you use the RMAN list command? (Choose three.)

  1. stored scripts in the recovery catalog
  2. available archived redo log files
  3. backup sets and image copies that are obsolete
  4. backups of tablespaces
  5. backups that are marked obsolete according to the current retention policy

Answer(s): A,B,D

Explanation:

The primary purpose of the LIST command is to list backup and copies. For example, you can list:
– Backups and proxy copies of a database, tablespace, datafile, archived redo log, or control file
– Backups that have expired
– Backups restricted by time, path name, device type, tag, or recoverability
– Archived redo log files and disk copies


Reference:

http://docs.oracle.com/cd/B19306_01/backup.102/b14192/bkup007.htm
http://docs.oracle.com/cd/B28359_01/backup.111/b28270/rcmreprt.htm#BRADV89585



You notice performance degradation in your production Oracle 12c database. You want to know what caused this performance difference. Which method or feature should you use?

  1. Database Replay
  2. Automatic Database Diagnostic Monitor (ADDM) Compare Period report
  3. Active Session History (ASH) report
  4. SQL Performance Analyzer

Answer(s): B



Which three statements are true about a job chain? (Choose three.)

  1. It can contain a nested chain of jobs.
  2. It can be used to implement dependency-based scheduling.
  3. It cannot invoke the same program or nested chain in multiple steps in the chain.
  4. It cannot have more than one dependency.
  5. It can be executed using event-based or time-based schedules.

Answer(s): A,B,E


Reference:

http://docs.oracle.com/cd/B28359_01/server.111/b28310/scheduse009.htm#ADMIN12459



Viewing Page 1 of 57



Share your comments for Oracle 1Z0-063 exam with other users:

Liz 9/11/2022 11:27:00 PM

support team is fast and deeply knowledgeable. i appreciate that a lot.
UNITED STATES


Namrata 7/15/2023 2:22:00 AM

helpful questions
Anonymous


lipsa 11/8/2023 12:54:00 PM

thanks for question
Anonymous


Eli 6/18/2023 11:27:00 PM

the software is provided for free so this is a big change. all other sites are charging for that. also that fucking examtopic site that says free is not free at all. you are hit with a pay-wall.
EUROPEAN UNION


open2exam 10/29/2023 1:14:00 PM

i need exam questions nca 6.5 any help please ?
Anonymous


Gerald 9/11/2023 12:22:00 PM

just took the comptia cybersecurity analyst (cysa+) - wished id seeing this before my exam
UNITED STATES


ryo 9/10/2023 2:27:00 PM

very helpful
MEXICO


Jamshed 6/20/2023 4:32:00 AM

i need this exam
PAKISTAN


Roberto Capra 6/14/2023 12:04:00 PM

nice questions... are these questions the same of the exam?
Anonymous


Synt 5/23/2023 9:33:00 PM

need to view
UNITED STATES


Vey 5/27/2023 12:06:00 AM

highly appreciate for your sharing.
CAMBODIA


Tshepang 8/18/2023 4:41:00 AM

kindly share this dump. thank you
Anonymous


Jay 9/26/2023 8:00:00 AM

link plz for download
UNITED STATES


Leo 10/30/2023 1:11:00 PM

data quality oecd
Anonymous


Blessious Phiri 8/13/2023 9:35:00 AM

rman is one good recovery technology
Anonymous


DiligentSam 9/30/2023 10:26:00 AM

need it thx
Anonymous


Vani 8/10/2023 8:11:00 PM

good questions
NEW ZEALAND


Fares 9/11/2023 5:00:00 AM

good one nice revision
Anonymous


Lingaraj 10/26/2023 1:27:00 AM

i love this thank you i need
Anonymous


Muhammad Rawish Siddiqui 12/5/2023 12:38:00 PM

question # 142: data governance is not one of the deliverables in the document and content management context diagram.
SAUDI ARABIA


al 6/7/2023 10:25:00 AM

most answers not correct here
Anonymous


Bano 1/19/2024 2:29:00 AM

what % of questions do we get in the real exam?
UNITED STATES


Oliviajames 10/25/2023 5:31:00 AM

i just want to tell you. i took my microsoft az-104 exam and passed it. your program was awesome. i especially liked your detailed questions and answers and practice tests that made me well-prepared for the exam. thanks to this website!!!
UNITED STATES


Divya 8/27/2023 12:31:00 PM

all the best
UNITED STATES


KY 1/1/2024 11:01:00 PM

very usefull document
Anonymous


Arun 9/20/2023 4:52:00 PM

nice and helpful questions
INDIA


Joseph J 7/11/2023 2:53:00 PM

i found the questions helpful
UNITED STATES


Meg 10/12/2023 8:02:00 AM

q 105 . ans is d
INDIA


Navaneeth S 7/14/2023 7:57:00 AM

i have interest to get a sybase iq dba certification
UNITED STATES


Aish 10/11/2023 5:27:00 AM

want to pass exm.
INDIA


Anonymous 6/12/2023 7:23:00 AM

are the answers correct?
INDIA


Kris 7/7/2023 9:43:00 AM

good morning, could you please upload this exam again, i need it to test my knowledge in sd-wan with version 7.0.
Anonymous


Meghraj mali 10/7/2023 1:47:00 PM

very nice question
CANADA


Noel 11/1/2022 9:14:00 PM

i have learning disability and this exam dumps allowed me to focus on the actual questions and not worry about notes and the those other study materials.
SOUTH AFRICA