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

Question: 1

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:

q1_1Z0-083

For which databases will fixup scripts be created?

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

Show Answer

Question: 2

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:

q2_1Z0-083

Which two are true? (Choose two.)

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.

Show Answer

Question: 3

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

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.

Show Answer

Question: 4

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

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

Show Answer

Question: 5

Which three actions are performed by the Oracle Preinstallation RPM, oracle-database-server-xxxx- preinstall, for Oracle Grid Infrastructure, where xxxx is the Oracle version and release? (Choose three.)

Aperforming checks to ensure minimum configuration requirements for Oracle Grid Infrastructure are met

Bcreating the oracle OS user

Ccreating the OSDBA (dba) group

Dcreating thte oraInventory (oinstall) group

Ecreating the grid OS user

Fconfiguring the OS for Oracle Automatic Storage Management shared storage access

Show Answer

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