Free 1z0-083 Exam Dumps

Question 26

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

A. Flashback logs areautomatically 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 retentionperiod defined inDB_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.

Correct Answer:BE

Question 27

Examine these queries and their output:
1Z0-083 dumps exhibit
An online RMAN backup of the CDB was taken an hour before Restore Point R1 was created. You want to
recover PDB1 toRestore Point R1. How do you achieve this?

A. Execute FLASHBACK PLUGGABLE DATABASE PDB1 TO RESTORE POINT R1 by using RMANwhile connected to PDB1.
B. Execute FLASHBACK PLUGGABLE DATABASE PDB1 TO RESTORE POINT R1 by using SQLwhile connected to PDB1.
C. Execute FLASHBACK PLUGGABLE DATABASE PDB1 TO RESTORE POINT R1 by using SQLwhile connected to CDB$ROOT.
D. Execute FLASHBACK PLUGGABLE DATABASE PDB1 TO RESTORE POINT R1 by using RMANwhile connected to CDB$ROOT.
E. This cannot be done due to the lack of aclean restore point.

Correct Answer:B

Question 28

Which three are true about Optimizer Statistics Advisor? (Choose three.)

A. It can berun only manually.
B. It is part of the DBMS_ADVISOR package.
C. It can recommend changes to improve the statistics gathering process.
D. It always analyzes all schemas in the database.
E. It runs automatically every night by default.
F. It is part of theDBMS_STATS package.

Correct Answer:ACF
https://mikedietrichde.com/2017/08/22/oracle-optimizer-statistics-advisor-in-oracle-database-12-2-0-1/ https://www.oracle.com/technetwork/database/bi-datawarehousing/twp-bp-for-stats-gather-19c-5324205.pdf

Question 29

Examine this configuration:
1Z0-083 dumps exhibit CDB1is a container database.
COMMON_USER_PREFIXisC##.
PDB1is a pluggable database contained inCDB1.
APP1_ROOTis an application container contained inCDB1.
APP1_PDB1is an application PDB contained inAPP1_ROOT.
You execute these commands successfully:

Which two are true? (Choose two.)

A. APP1_USER1 can be created in PDB1.
B. APP1_USER1 can be created in CDB1.
C. APP1_USER1 canhave different privileges in each Application PDB contained in APP1_ROOT.
D. C##_APP_USER1 can be created in CDB1.
E. P1_USER1 can be created in CDB1.
F. C##_USER1 will have the same privileges and roles granted in all PDBs in CDB1.

Correct Answer:CF

Question 30

Which three are true about Audit policies In container databases (CDBs)?

A. All audit records are written to the audit trail in CDB$ROOT
B. A common unified audit policy can be created at the application root level.
C. A common unified audit policy can be created at the CDB level.
D. An application PDB cannot have a local audit policy.
E. Fine-grained auditing policies defined in an application root must be manually synchronized by each application PDB contained in the application root.
F. Application-common unified audit policies defined In an application root must be manually synchronized by each application PDB contained in the application root.

Correct Answer:DEF