Nest 0 Cart
Nest Account
Popular Exams
All Categories...
Nest
Nest 0
Contact
Log In / Sign Up
Copyright 2024 © store. All rights reserved.
Home Oracle 1z0-063

Oracle 1z0-063 Exam Practice Questions (P. 1)

  • Full Access (266 questions)
  • Six months of Premium Access
  • Access to one million comments
  • Seamless ChatGPT Integration
  • Ability to download PDF files
  • Anki Flashcard files for revision
  • No Captcha & No AdSense
  • Advanced Exam Configuration
Get Contributor Access
Question #1
Which two statements are true about scheduling operations in a pluggable database (PDB)?
  1. A
    Scheduler jobs for a PDB can be defined only at the container database (CDB) level.
  2. B
    A job defined in a PDB runs only if that PDB is open.
  3. C
    Scheduler attribute setting is performed only at the CDB level.
  4. D
    Scheduler objects created by users can be exported or imported using Data Pump.
  5. E
    Scheduler jobs for a PDB can be created only by common users.

Correct Answer:
BD

Question #2
A complete database backup to media is taken for your database every day. Which three actions would you take to improve backup performance?
  1. A
    Set the backup_tape_io_slaves parameter to true.
  2. B
    Set the dbwr_io_slaves parameter to a nonzero value if synchronous I/O is in use.
  3. C
    Configure large pool if not already done.
  4. D
    Remove the rate parameter, if specified, in the allocate channel command.
  5. E
    Always use RMAN compression for tape backups rather than the compression provided by media manager.
  6. F
    Always use synchronous I/O for the database.

Correct Answer:
BCD
Reference:
http://docs.oracle.com/cd/B19306_01/backup.102/b14191/rcmtunin.htm

Question #3
For which three pieces of information can you use the RMAN list command?
  1. A
    stored scripts in the recovery catalog
  2. B
    available archived redo log files
  3. C
    backup sets and image copies that are obsolete
  4. D
    backups of tablespaces
  5. E
    backups that are marked obsolete according to the current retention policy

Correct Answer:
ABD
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
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

Question #4
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. A
    Database Replay
  2. B
    Automatic Database Diagnostic Monitor (ADDM) Compare Period report
  3. C
    Active Session History (ASH) report
  4. D
    SQL Performance Analyzer

Correct Answer:
B
Reference:
http://docs.oracle.com/cd/E24628_01/server.121/e17635/tdppt_degrade.htm

Question #5
Which three statements are true about a job chain?
  1. A
    It can contain a nested chain of jobs.
  2. B
    It can be used to implement dependency-based scheduling.
  3. C
    It cannot invoke the same program or nested chain in multiple steps in the chain.
  4. D
    It cannot have more than one dependency.
  5. E
    It can be executed using event-based or time-based schedules.

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

Next Questions

All Pages