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

Question No: 21

MultipleChoice

Which four are true about performing Tablespace Point -In-Time Recovery (TSPITR) using Recovery Manager (RMAN)?

Options

AIt can be performed using an auxiliary instance managed by a DBA.

BIt can be used to recover a truncated table.

CRMAN automatically adds any required tablespaces to the recovery set to make it self-contained.

DRMAN always includes tablespaces containing undo segments in the recovery set.

EIt can be performed repeatedly until the correct time is found without using an RMAN catalog.

Fflashback database must be enabled for it to work.

GIt can be used to recover a dropped tablespace.

HIt can be performed using an auxiliary instance managed by RMAN.

Question No: 22

MultipleChoice

Examine this configuration:

1. The ORCL database data files are in Automatic Storage Management (Oracle ASM) disk group +DATA.

2. ORCL uses disk group +FRA for the Fast Recovery Area.

3. LISTENER is the listener for ORCL.

4. The database, listener, ASM instance, and ASM disk groups are managed by Oracle Restart.

5. All components are currently shut down.

You execute this command:

What is the outcome?

Options

AThe ORCL database, the Oracle ASM instances, the +DATA and +FRA disk groups, and the LISTENER
are started.

BOnly the ORCL database instance is started.

COnly the ORCL database and the ASM instances are started.

DOnly the ORCL database instance, the Oracle ASM instance, and the +DATA and +FRA disk groups are started.

EOnly the ORCL database instance and the +DATA and +FRA disk groups are started.
https://docs.oracle.com/html/E25494_01/start001.htm

Question No: 23

MultipleChoice

Examine this configuration:

CDB1 is a container database.

PDB1 and PDB2 are pluggable databases in CDB1.

You execute these commands successfully:

Which two are true? (Choose two.)

Options

APDB1 and PDB2 are in MOUNT state.

BRedo logs are opened.

CPDB1 and PDB2 are in READ ONLY state.

DCDB$ROOT is in MOUNT state.

EPDB$SEED is in READ ONLY state.

Question No: 24

MultipleChoice

Your SALES_ROOT application container has two application PDBs.

The SALES_APP application has a common table, FIN.REVENUE, in the two PDBs.

Examine this query and its output:

Which two are true? (Choose two.)

Options

AThe CONTAINERS clause cannot be used in queries on the REVENUE table.

BThe REVENUE table must be a list-partitioned table.

CThe MAPTABLE tables defines a logical partition key on a commonly used column for the REVENUE table.

DThe MAPTABLE table is a metadata-linked table.

EA container map exists for the REVENUE table, but is not enabled.

FThe REVENUE table partitions are not pruned across the PDBs automatically.

Question No: 25

MultipleChoice

Examine this configuration:

CDB1 is a container database.

COMMON_USER_PREFIX is C##.

PDB1 is a pluggable database contained in CDB1.

APP1_ROOT is an application container contained in CDB1.

APP1_PDB1 is an application PDB contained in APP1_ROOT.

You execute these commands successfully:

Which two are true? (Choose two.)

Options

AAPP1_USER1 can be created in PDB1.

BAPP1_USER1 can be created in CDB1.

CAPP1_USER1 can have different privileges in each Application PDB contained in APP1_ROOT.

DC##_APP_USER1 can be created in CDB1.

EP1_USER1 can be created in CDB1.

FC##_USER1 will have the same privileges and roles granted in all PDBs in CDB1.

Question No: 26

MultipleChoice

Examine this configuration:

CDB1 is a container database.

PDB1 and PDB2 are pluggable databases in CDB1.

PDB1 and PDB2 are OPEN in READ WRITE mode.

You execute these commands successfully:

Which two are true? (Choose two.)

Options

AUncommitted transactions in PDB1 have been rolled back.

BPDB1 is closed.

CUncommitted transactions in CDB1 and PDB1 have been rolled back.

DCDB1 is shut down.

ECDB1 is in MOUNT state

Question No: 27

MultipleChoice

Examine this configuration:

CDB1 is an Oracle Database 12c Release 2 database containing pluggable databases PDB$SEED, PDB1, and PDB2.

PDB$SEED is open READ ONLY

PDB1 is open READ WRITE

PDB2 is MOUNTED.

ORACLE_HOME is /u01/app/oracle/product/18.1.0/dbhome_1.

You execute these commands before upgrading the database to the current release:

For which databases will fixup scripts be created?

Options

ACDB1, PDB$SEED, PDB1, and PDB2

BPDB$SEED, PDB1, and PDB2 only

CCDB1 and PDB$SEED only

DCDB1, PDB1, and PDB2 only

ECDB1, PDB$SEED, and PDB1 only

Question No: 28

MultipleChoice

You are managing this configuration:

CDB1 is a container database.

PDB1 and PDB2 are two pluggable databases in CDB1.

USER1.EMP is a table in PDB1 and USER2.DEPT is a table in PDB2.

CDB1 user SYS executes these commands after connecting successfully to PDB2:

Which two are true? (Choose two.)

Options

AThe inserts on USER1.EMP remain uncommitted when the session connected to PDB2.

BThe inserts on USER1.EMP were committed when the session inserted a row into USER2.DEPT.

CThe insert on USER2.DEPT fails because of the active transaction in the parent container.

DThe insert on USER2.DEPT is a recursive autonomous transaction by the child session and is committed.

EThe inserts on USER1.EMP were rolled back when the session connected to PDB2.

FThe insert on USER2.DEPT is uncommitted.

GThe inserts on USER1.EMP were committed when the session connected to PDB2.

Question No: 29

MultipleChoice

Which two are true about the Oracle dataabse methodology? (Choose two.)

Options

AThe Oracle Database time model should be used to find the database and instance areas most in need of tuning.

BTuning activities should stop once the user is satisfied with performance.

CTuning activities should stop once agreed service levels for performance have been met.

DThe database instance memory should always be tuned before tuning any file systems.

ESQL statements should always be tuned before tuning any file systems.

FThe alert log should be used to find the database and instance areas most in need of tuning.

Question No: 30

MultipleChoice

Which three are located by using environment variables? (Choose three.)

Options

Athe Optimal Flexible Architecture (OFA) compliant path to store Oracle software and configuration files.

Bthe location of Oracle Net Services configuration files

Cthe list of a disk group names to be mounted by an Oracle Automatic Storage Management (ASM) instance at startup

Ddefault directories for temporary files used by temporary tablespaces

Ethe temporary disk space used by Oracle Installer during installation

Fthe maximum number of database files that can be opened by a database instance