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

Question No: 31

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: 32

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

Question No: 33

MultipleChoice

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.)

Options

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