Free Oracle 1Z0-083 Exam Dumps and 1Z0-083 Exam Questions

Question No: 11

MultipleChoice

Which two are true about an Oracle gold image-based installation in Oracle 18c and later releases? (Choose

two.)

Options

AIt can be used for both Oracle Database and Oracle Grid Infrastructure installation.

BIt can only install and configure Oracle Database software. The database has to be created separately.

CIt does not require the setup wizard.

DIt uses a single RPM that automatically extracts and installs the Oracle Database software.

EIt can be used to install and upgrade Oracle Database for single-instance and cluster configurations.

Question No: 12

MultipleChoice

Your database is in ARCHIVELOG mode and you plan to use Flashback Database.

Which two features or parameters manage space availability in the fast recovery area? (Choose two.)

Options

Athe archived log deletion policy

Bthe backup optimization policy

Cthe backup retention policy

Dusing guaranteed UNDO retention

Ethe DB_CREATE_ONLINE_LOG_DEST_n parameter setting

Fthe DB_RECOVERY_FILE_DEST parameter setting

Question No: 13

MultipleChoice

Which three capabilities require the use of the RMAN recovery catalog? (Choose three.)

Options

Ausing the KEEP FOREVER clause with the BACKUP command

Busing RMAN stored scripts

Cusing the REPORT SCHEMA command to list a database's current data files and tablespaces

Dcreating customized reports about a single database's backups

Ecreating encrypted backups

Fusing the REPORT SCHEMA command to list a database's data files and tablespaces at times in the past

Question No: 14

MultipleChoice

On the 10th of August, you implement an incremental database backup strategy and configure a recovery window of five days.

Level 0 backups are taken on the 10th, 17th, and 24th of August.

Differential level 1 incremental backups are taken daily between the level 0 backups.

Today is the 26th of August.

Which backups will be obsolete?

Options

Aall backups prior to 10th of August

Ball backups prior to 22nd of August

Call backups prior to 24th of August

Dall backups prior to 20th of August

Eall backups prior to 17th of August

Question No: 15

MultipleChoice

Which three are true about an application container?

Options

AIt must have an application root PDB.

BIt can contain multiple applications.

CAn application PDB can belong to multiple application containers.

DTwo application containers can share an application seed PDB.

EIt can contain a single application.

FIt must have an application seed PDB.

Question No: 16

MultipleChoice

Examine this configuration:

1. CDB1 is a container database running in archivelog mode.

2. Multiple uncommitted transactions are running in CDB1.

3. Redo log groups 1 and 2 are inactive.

4. Redo log group 3 is the current group.

All members of redo log group 3 are lost before it is archived. Examine these possible steps:

1. SHUTDOWN ABORT

2. STARTUP NOMOUNT

3. STARTUP MOUNT

4. ALTER DATABASE MOUNT

5. RESTORE DATABASE

6. RECOVER DATABASE NOREDO

7. RECOVER DATABASE UNTIL AVAILABLE

8. RESTORE ARCHIVELOG ALL

9. ALTER DATABASE OPEN

10. ALTER DATABASE OPEN RESETLOGS

Choose the minimum required steps in the correct order to recover the database.

Options

A1, 3, 5, 6, 10

B1, 3, 5, 8, 6, 10

C1, 3, 5, 6, 9

D1, 3, 5, 6, 10

E1, 2, 5, 7, 4, 10

F1, 3, 5, 7, 10

Question No: 17

MultipleChoice

Your CDB has two regular PDBs as well as one application container with two application PDBs and an application seed

No changes have been made to the standard PDB$SEED.

How many default temporary tablespaces can be assigned in the CDB?

Options

Athree

Beight

Cseven

Dsix

Efive

Question No: 18

MultipleChoice

Which two are true about unplugging an application container from a container database and plugging it into a different container database?

Options

AIt requires local undo mode in both container databases.

BIt requires only local undo mode in the database where the application container will be unplugged.

CPlugging the application root into a different CDB plugs In all its application PDBs.

DApplication PDBs In the application container must be unplugged before the application root Is unplugged.

EUnplugging the application root from a CDB unplugs all its application PDBs.

FThe application root of an application container should be plugged Into the other CDB before Its application PDBs are plugged in.

Question No: 19

MultipleChoice

Which three are true In Oracle 19c and later releases?

Options

ATablespaces always remain In read/write mode during transportable tablespace operations.

BSimultaneous data pump jobs can be limited at the pluggable database (PDB) level.

CTablespaces never remain In read/write mode during transportable tablespace operations.

DAn ordinary data pump export of a table with encrypted columns will always encrypt the same columns when imported.

EA transportable data pump import can leave a plugged-in tablespace in read-only mode.

FA transportable data pump import can leave a plugged-in tablespace In read/write mode.

Question No: 20

MultipleChoice

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

Options

AAll audit records are written to the audit trail in CDB$ROOT

BA common unified audit policy can be created at the application root level.

CA common unified audit policy can be created at the CDB level.

DAn application PDB cannot have a local audit policy.

EFine-grained auditing policies defined in an application root must be manually synchronized by each application PDB contained in the application root.

FApplication-common unified audit policies defined In an application root must be manually synchronized by each application PDB contained in the application root.