QUESTION: 45

Which two statements are true about Resource Manager plans for individual pluggable databases (PDB plans) in a multitenant container database (CDB)?

If no PDB plan is enabled for a pluggable database, then all sessions for that PDB are treated to an equal degree of the resource share of that PDB.
In a PDB plan, subplans may be used with up to eight consumer groups.
If a PDB plan is enabled for a pluggable database, then resources are allocated to consumer groups across all PDBs in the CDB.
If no PDB plan is enabled for a pluggable database, then the PDB share in the CDB plan is dynamically calculated.
If a PDB plan is enabled for a pluggable database, then resources are allocated to consumer groups based on the shares provided to the PDB in the CDB plan and the shares provided to the consumer groups in the PDB plan.

Answer(s): A,E

Show Answer Next Question

QUESTION: 46

Which two are true about the execution of operating system scripts starting from Oracle Database 19c? (Choose two.)

orainstRoot.sh can be executed automatically by the Database installer by using sudo or root credentials.
root.sh can be executed automatically by the Database Installer only if it is provided with root credentials.
The sudo password can be specified in a response file.
root.sh can be executed automatically by the Database installer only by using sudo credentials.
The sudo password must be specified in a response file.
The root password cannot be specified in a response file.

Answer(s): A,F

Show Answer Next Question

Automatic Shared Memory Management is disabled for one of your database instances. Some SQL statements perform poorly due to excessive hard parse activity, thereby degrading performance. What would be your next step?

Run the SQL Access Advisor.
Run the Memory Advisor for the shared pool.
Run the SQL Tunning Advisor.
Run the Memory Advisor for the Program Global Area.
Run the Memory Advisor for the System Global Area.

Answer(s): B

Show Answer Next Question

QUESTION: 48

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

Flashback logs are automatically purged when DB_FLASHBACK_RETENTION_TARGET is set lower than the time they have already been retained.
Flashback logs are monitored and proactively deleted when beyond the retention period defined in DB_FLASHBACK_RETENTION_TARGET only after there is space pressure.
Flashback logs are monitored and proactively deleted when beyond the retention period defined in DB_FLASHBACK_RETENTION_TARGET before there is space pressure.
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.
Flashback logs are automatically purged whenever the value of DB_FLASHBACK_RETENTION_TARGET is changed.

Answer(s): A,C

Show Answer Next Question

Free Oracle 1z0-083 Exam Questions (page: 13)

QUESTION: 45

QUESTION: 46

QUESTION: 47

QUESTION: 48

1z0-083 Exam Discussions & Posts