1z0-083 Exam Questions and Answers | Exam-Dumps.net (Page: 10)

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

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

Reveal Solution 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

Reveal Solution Next Question

QUESTION: 49

Examine these queries and their output: After a system crash, an instance restart and an attempted opening of the PDBs result in: Which two are true? (Choose two.)

Data file 24 can be recovered while PDB2 is opened.
Data file 24 must be recovered while the CDB is opened.
Data file 24 can be recovered while CDB$ROOT and PDB$SEED are opened.
Data file 24 cannot be recovered while the CDB is opened.
Data file 24 must be recovered while PDB2 is closed.

Answer(s): A,C

Reveal Solution Next Question

QUESTION: 50

Which two are true about RMAN duplexed backup sets? (Choose two.)

A duplexed backup set uses the same number of SBT channels as a non-duplexed backup set for the same number of files.
A non-duplexed backup set written to disk can be duplexed to disk by backing up the backup set that is already on disk.
A non-duplexed backup set written to SBT can be duplexed to tape by backing up the backup set that is already on tape.
A non-duplexed backup set written to disk can be duplexed to tape by backing up the backup set that is already on disk.
A non-duplexed backup set written to SBT can be duplexed to disk by backing up the backup set that is already on tape.
A duplexed backup set always uses twice as many SBT channels as a non-duplexed backup set for the same number of files.

Answer(s): B,D

Reveal Solution Next Question

Oracle 1z0-083 Exam (page: 10)
Oracle Database Administration II
Updated on: 01-Sep-2025

QUESTION: 46

QUESTION: 47

QUESTION: 48

QUESTION: 49

QUESTION: 50

Oracle 1z0-083 Exam (page: 10) Oracle Database Administration II Updated on: 01-Sep-2025

QUESTION: 46

QUESTION: 47

QUESTION: 48

QUESTION: 49

QUESTION: 50

Oracle 1z0-083 Exam (page: 10)
Oracle Database Administration II
Updated on: 01-Sep-2025