Online 1Z0-083 Practice Test

Question 1

Which two are true about flashback features in Oracle Database 19c and later releases? (Choose two.)

Options :

A : Flashback logs are automatically purged when DB_FLASHBACK_RETENTION_TARGET is set lower than the time they have already been retained.

B : Flashback logs are monitored and proactively deleted when beyond the retention period defined in DB_FLASHBACK_RETENTION_TARGET only after there is space pressure.

C : Flashback logs are monitored and proactively deleted when beyond the retention period defined in DB_FLASHBACK_RETENTION_TARGET before there is space pressure.

D : Flashback logs are monitored for being older than the retention period defined in DB_FLASHBACK_RETENTION_TARGET and can be deleted by an administrator written event trigger.

E : Flashback logs are automatically purged whenever the value of DB_FLASHBACK_RETENTION_TARGET is changed.

Answer: A,C

Question 2

Choose three. Which three are true about RMAN archival backups with the RESTORE POINT clause?

Options :

A : They are never considered obsolete by RMAN.

B : They can optionally be written to a fast recovery area (FRA).

C : Â All archive logs are retained after an archival backup is taken, until the next archival backup is taken of the same database.

D : Archive logs are retained if they are necessary to allow the database to be recovered to a consistent state when an archival backup is restored.

E : The SPFILE is included in the archival backup.

F : Use of a recovery catalog is always required to support the creation and use of archival backups. G)The ARCHIVAL attribute for a backup overrides the RMAN retention policy.

G :

Answer: A,B,D

Question 3

Which two are true about the Automatic Database Diasnostic Monitor (ADDM)? (Choose two.)

Options :

A : It analyzes a period of time corresponding to the 12 hours of activity.

B : It runs automatically after each AWR snapshot.

C : A DBA can run it manually.

D : Results are written to the alert log.

E : It analyzes a period of time corresponding to the last day of activity.

Answer: B,C

Question 4

choose one You take regular backups of one of your production databases by using RMAN with a recovery catalog. You have added two new tablespaces to this database which must be included in future backups. Which process occurs which allows the new backups to contain the new datafiles?

Options :

A : The target database control file is synchronized from the recovery catalog with a partial resync at the next backup.

B : The recovery catalog is synchronized from the target database control file with a full resync at the next backup.

C : The target database control file is synchronized from the recovery catalog with a full resync at the next backup.

D : The recovery catalog is synchronized from the target database control file with a partial resync at the next backup.

Answer: B

Question 5

Choose the best answer. Examine this configuration:
1. CDB1 is a container database.
2. There are several pluggable databases (PDBs) in CDB1.
5. Each PDB has several tables with referential integrity constraints.
6. FLASHBACK DATABASE is ON.
7. UNDO RETENTION GUARANTEE is enabled.
Multiple undesired multitable changes were made in all the PDBs.
Which method can be used to undo the changes using a single command?

Options :

A : restore and recover database

B : flashback transaction

C : flashback database

D : flashback table and transaction

E : flashback table

Answer: C

EXPERTY DESIGNED 1Z0-083 PRACTICE TEST