Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.
Mail Us [email protected]
Menu
sale

Want to Unlock All Questions for this Exam?

Full Exam Access, Discussions, No Robots Checks

27
Students signed up in the last 24H

Oracle 1z0-067 Exam Actual Questions

The questions for 1z0-067 were last updated on April 14, 2024.
  • Viewing page 1 out of 53 pages.
  • Viewing questions 1-5 out of 269 questions
 

Topic 1 - Single Topic

Question #1 Topic 1

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

  • A. Scheduler jobs for a PDB can be defined only at the container database (CDB) level.
  • B. A job defined in a PDB runs only if that PDB is open.
  • C. Scheduler attribute setting is performed only at the CDB level.
  • D. Scheduler objects created by users can be exported or imported using Data Pump.
  • E. Scheduler jobs for a PDB can be created only by common users.
Reveal Solution Hide Solution   Discussion  

Correct Answer: BD 🗳️

Question #2 Topic 1

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

  • A. Set the backup_tape_io_slaves parameter to true.
  • B. Set the dbwr_io_slaves parameter to a nonzero value if synchronous I/O is in use.
  • C. Configure large pool if not already done.
  • D. Remove the rate parameter, if specified, in the allocate channel command.
  • E. Always use RMAN compression for tape backups rather than the compression provided by media manager.
  • F. Always use synchronous I/O for the database.
Reveal Solution Hide Solution   Discussion   2

Correct Answer: BCD 🗳️

Question #3 Topic 1

For which three pieces of information can you use the RMAN list command?

  • A. stored scripts in the recovery catalog
  • B. available archived redo log files
  • C. backup sets and image copies that are obsolete
  • D. backups of tablespaces
  • E. backups that are marked obsolete according to the current retention policy
Reveal Solution Hide Solution   Discussion   2

Correct Answer: ABD 🗳️

Question #4 Topic 1

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?

  • A. Database Replay
  • B. Automatic Database Diagnostic Monitor (ADDM) Compare Period report
  • C. Active Session History (ASH) report
  • D. SQL Performance Analyzer
Reveal Solution Hide Solution   Discussion  

Correct Answer: B 🗳️
References:

Question #5 Topic 1

Which three statements are true about a job chain?

  • A. It can contain a nested chain of jobs.
  • B. It can be used to implement dependency-based scheduling.
  • C. It cannot invoke the same program or nested chain in multiple steps in the chain.
  • D. It cannot have more than one dependency.
  • E. It can be executed using event-based or time-based schedules.
Reveal Solution Hide Solution   Discussion   1

Correct Answer: ABE 🗳️
References:

Next Questions

Get IT Certification

Unlock free, top-quality video courses on ExamTopics with a simple registration. Elevate your learning journey with our expertly curated content. Register now to access a diverse range of educational resources designed for your success. Start learning today with ExamTopics!

Start Learning for free
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel