Oracle 1Z0-083 Quiz 2 Topic 5 Questions 6-10

Question: 1

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:

q1_1Z0-083

What is the outcome?

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

Show Answer

Question: 2

Examine this configuration:

CDB1 is a container database.

PDB1 and PDB2 are pluggable databases in CDB1.

You execute these commands successfully:

q2_1Z0-083

Which two are true? (Choose two.)

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.

Show Answer

Question: 3

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:

q3_1Z0-083

Which two are true? (Choose two.)

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.

Show Answer

Question: 4

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:

q4_1Z0-083

Which two are true? (Choose two.)

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.

Show Answer

Question: 5

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:

q5_1Z0-083

Which two are true? (Choose two.)

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

Show Answer

Oracle 1Z0-083 Quiz:2 Topic:5 Questions:6-10