Question No. 1

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

AScheduler jobs for a PDB can be defined only at the container database (CDB) level.

BA job defined in a PDB runs only if that PDB is open.

CScheduler attribute setting is performed only at the CDB level.

DScheduler objects created by users can be exported or imported using Data Pump.

EScheduler jobs for a PDB can be created only by common users.

Show Answer

Correct Answer: B, D

Question No. 2

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.)

ASet the backup_tape_io_slaves parameter to true.

BSet the dbwr_io_slaves parameter to a nonzero value if synchronous I/O is in use.

CConfigure large pool if not already done.

DRemove the rate parameter, if specified, in the allocate channel command.

EAlways use RMAN compression for tape backups rather than the compression provided by media manager.

FAlways use synchronous I/O for the database.

Show Answer

Correct Answer: B, C, D

Question No. 3

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

Astored scripts in the recovery catalog

Bavailable archived redo log files

Cbackup sets and image copies that are obsolete

Dbackups of tablespaces

Ebackups that are marked obsolete according to the current retention policy

Show Answer

Correct Answer: A, B, D

Question No. 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?

ADatabase Replay

BAutomatic Database Diagnostic Monitor (ADDM) Compare Period report

CActive Session History (ASH) report

DSQL Performance Analyzer

Show Answer

Correct Answer: B

Question No. 5

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

AIt can contain a nested chain of jobs.

BIt can be used to implement dependency-based scheduling.

CIt cannot invoke the same program or nested chain in multiple steps in the chain.

DIt cannot have more than one dependency.

EIt can be executed using event-based or time-based schedules.

Show Answer

Correct Answer: A, B, E

Free Oracle 1Z0-063 Exam Actual Questions

The questions for 1Z0-063 were last updated On Apr 30, 2024