Weekend Sale - Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: sntaclus

examout.co

Identify three benefits of Unified Auditing.

A.

Decreased use ofstorage to store audit trail rowsin the database.

B.

It improves overall auditing performance.

C.

It guarantees zero-loss auditing.

D.

The audit trail cannot be easily modified because it is read-only.

E.

It automatically audits Recovery Manager (RMAN) events.

A user complains about poor database performance. You want to verify if the user’s session has waited for certain types of I/O activity. Which view displays all waits waited on by a session at least once?

A.

V$SESSION_EVENT

B.

V$SESSTAT

C.

V$SESSION_WAIT

D.

V$SESSION_WAIT_CLASS

E.

V$SESSION

Choose the best answer. Your CDB has two regular PDBs as well as one application container with two application PDBs and an application seed. No changes have been made to the standard PDB $SEED. How many default temporary tablespaces can be assigned in the CDB?

A.

seven

B.

five

C.

eight

D.

three

E.

six

Which two are true about changing the LOCAL_UNDO_ENABLED property to false in a CDB? (Choose two.)

A.

After the change, only a common user with the required privilege can create an undo tablespace in CDB&ROOT.

B.

Any new PDB and existing PDBs are automatically configured to use the default undo tablespace in CDB$ROOT.

C.

After the change, only one undo tablespace can exist in CDB$ROOT.

D.

After the change, any user with the required privilege can create an undo tablespace in the PDBs.

E.

Undo tablespaces existing in PDBs must be dropped before the change.

F.

After the change, each existing PDB has to be reopened for the new undo mode to take effect.

Which two statements are true about RMAN duplexed backups?

A.

It is not supported for image copies.

B.

It is only supported for backups to tape via the media management interface.

C.

Duplex backups can be performed on either disk or media, but cannot be performed on media and disk simultaneously.

D.

Duplex backups can contain only data files and control files.

E.

For performing duplexed backups, the parallelism for the device must be set equal to the number of copies.

Which three are true about an application seed pluggable database (PDB)? (Choose three.)

A.

It is automatically synchronized with its application root PDB when an application is upgraded. B)It cannot be added to an application container after the application container has already been created.

B.

A new application PDB created by cloning an application seed PDB can have an old version of the application installed after cloning completes.

C.

It is automatically synchronized with its application root PDB when an application is installed.

D.

It cannot be dropped from its application container.

E.

A new application PDB created by cloning an application seed PDB can have an up-to-date version of the application installed after cloning completes.

F.

It is not required in an application container.

Which two are true about RMAN backups when using a media manager to write backups to tape when there are only two tape drives? (Choose two.)

A.

SBT tape compression can be used even if no RMAN compression is configured.

B.

Any backup set written to the SBT device in this configuration can contain a maximum of two backup pieces.

C.

Any backup written to the SBT device in this configuration can contain a maximum of two backup sets.

D.

SBT tape compression and RMAN backup compression should be used in parallel.

E.

The SBT device should be configured to use PARALLELISM 2 to allow both tape drive to be used simultaneously.

Choose two. Which two are true about reclaiming space used by Flashback logs in Oracle Database 19c and later releases?

A.

Space might be reclaimed proactively before space pressure occurs.

B.

Space is always reclaimed proactively before space pressure occurs.

C.

Space might be reclaimed automatically when the retention period for Flashback logs is lowered.

D.

Space is always reclaimed automatically when the retention period for Flashback logs is lowered.

E.

Space is only reclaimed when there is space pressure in the Fast Recovery Area (FRA).

Which two are true about SQL Performance Analyzer (SPA)? (Choose two.)

A.

It is integrated with the SQL Access Advisor.

B.

It predicts the impact of system changes on SQL workload response time.

C.

It provides before and after execution statistics for each SQL statement in the analysis task

D.

It offers fine-grained analysis of all the SQL statements in the analysis task as a group.

E.

SQL statements that were originally run concurrently are run concurrently by SPA.

A container database (CDB) contains two pluggable databases PDB1 and PDB2. The LOCAL_UNDO_ENABLED database property is set to FALSE in the CDB. Data file 24 of PDB2 was deleted and you need to restore and recover it. The only RMAN backup that exists was created with the BACKUP DATABASE command while connected to CDB$ROOT. Which three are true? (Choose three.)

A.

Data file 24 can be recovered only while connected to PDB2.

B.

Data file 24 can be restored and recovered while connected to CDB$ROOT.

C.

Data file 24 can be restored only while connected to CDB$ROOT.

D.

Data file 24 can be restored only while connected to PDB2.

E.

Data file 24 can be recovered while connected to PDB2.

F.

Data file 24 can be recovered while connected to CDB$ROOT.