Question No. 1

A schema owner truncated a table in error and must recover the data.

Which Oracle Flashback feature could be used to recover the data?

AFLASHBACK TRANSACTION

BFLASHBACK VERSION QUERY

CFLASHBACK DATA ARCHIVE

DFLASHBACK TABLE

EFLASHBACK DATABASE

Show Answer

Correct Answer: B

Question No. 2

Which three are true about patchsets? (Choose three.)

AThey can be applied in a rolling fashion for Clusterware and the databases.

BThey can introduce new features.

CThey are installed via OPatch or OPatchAuto.

DInstalling a patchset is considered an ''upgrade''.

EThey are only released quarterly.

FA base release is not needed to install patchsets.

Show Answer

Correct Answer: D, E, F

Question No. 3

Which two are true about data movement between a non-CDB and a PDB using Data Pump? (Choose two.)

ATablespaces are automatically created as neeed while importing full exports in either a non-CDB or a PDB.

BOracle attempts to convert conventional database users to local users when moving schemas from a non- CDB to a PDB.

CA new PDB is automatically created when importing a non-CDB into a CDB.

DOracle attempts to convert common users to conventional users when moving schemas from a PDB to a non-CDB.

EMoving data from a PDB to a non-CDB is only possible by using transportable tablespace export and import.

FMoving data from a non-CDB to a PDB is only possible by using conventional export and import.

Show Answer

Correct Answer: B, D

Question No. 4

Which two are true about memory advisors? (Choose two.)

AIf Automatic Shared Memory Management is enabled, both the SGA Advisor and PGA Advisor are always
available.

BIf Automatic Memory Management is enabled, no memory advisors are available.

CAll memory advisors use data from Automatic Workload Repository.

DIf Manual Shared Memory Management is enabled, only the Shared Pool Advisor and Buffer Cache
Advisor are available.

EIf Automatic Memory Management is enabled, the Shared Pool Advisor and Buffer Cache Advisor are
available to set the maximum size for these individual System Global Area components.

Show Answer

Correct Answer: A, B

Question No. 5

RMAN has just been connected to a target database and the recovery catalog database.

In which two cases would an automatic full resynchronization occur between this target database's control file

and the RMAN recovery catalog? (Choose two.)

Awhen control file metadata for archive log backups or image copies has been overwritten in the target
database's control file due to being older than CONTROL_FILE_RECORD_KEEP_TIME

Bwhen control file metadata for data file backups or image copies has been overwritten in the target
database's control file due to being older than CONTROL_FILE_RECORD_KEEP_TIME

Cwhen a new tablespace is added to a registered target database

Dwhen a backup of the current control file is created

Ewhen the target is first registered

Show Answer

Correct Answer: B, D

Free Oracle 1Z0-083 Exam Actual Questions

The questions for 1Z0-083 were last updated On Jan 18, 2025