Pass 1z0-083 Exam Guide

Page: 3 / 21

Question 12

choose three Identify three reasons for using a recovery catalog with Recovery Manager (RMAN).

Options:

to allow database duplication without a connection to the target instance.

to store backup metadata that would cause the controlfile to become too large.

to store backups that would cause the controlfile to become too large.

to report on the database schema at an earlier point in time.

to allow database duplication without a connection to the auxiliary instance.

Question 13

Choose two. Which two are true about an RPM-based Oracle Database installation?

Options:

It includes the Oracle Preinstallation RPM.

From Oracle Database 18c, a single RPM can be used to install only Oracle Database Server for a single instance.

It requires an Unbreakable Linux Network (ULN) subscription.

It performs a software-only Oracle Database installation.

It uses a service configuration script to create a single-instance database as part of the installation.

Question 14

You notice that the performance of your production 24x7 Oracle 12c database has significantly degraded. Sometimes, you are not able to connect to the database instance because it hangs. How can you detect the cause of the degraded performance?

Options:

by performing emergency monitoring using Real-Time Automatic Database Diagnostic Monitor (ADDM) to fetch data directly from SGA for analysis

by running ADDM to fetch information from the latest Automatic Workload Repository (AWR) snapshots

by using Active Session History (ASH) data and performing hang analysis

by running ADDM in diagnostic mode

Question 15

You are working on an Oracle Database 19c database. You enabled the Flashback Database feature. Which two statements regarding flashback logs are true? (Choose two.)