QUESTION $1$

Under normal circumstances, which of the following actions or events is not found in the Oracle alert log$?$

A$.$

Database startup and shutdown information

B$.$

Nondefault initialization parameters

C$.$

ORA$-00600$ errors

D$.$

New columns added to a user table

$10$ points

QUESTION $2$

Which data dictionary view is used to view the current values of parameters?

A$.$

V$DATABASE

B$.$

V$SPPARAMETER

C$.$

V$PARAMETER

D$.$

V$SYSPARAMETER

$10$ points

QUESTION $3$

The Oracle Universal Installer is started by executing which program?

A$.$

emct$1$

B$.$

runInstaller

C$.$

ouistart

D$.$

isqlplusctl

$10$ points

QUESTION $4$

Which initialization parameter cannot be changed after the database is created?

A$.$

DB$\_$BLOCK$\_$SIZE

B$.$

DB$\_$NAME

C$.$

CONTROL$\_$FILES

D$.$

None. All parameters can be changed as and when required.

$10$ points

QUESTION $5$

Which startup options must be used to start the instance when you create a new database?

A$.$

STARTUP FORCE

B$.$

STARTUP MOUNT

C$.$

STARTUP RESTRICT

D$.$

STARTUP NOMOUNT

$10$ points

QUESTION $6$

The DIAGNOSTIC$\_$DEST parameter is not set up in the initialization$-$parameter file. The value of the ORACLE$\_$HOME environment variable is $/$u$01/$app$/$oracle$/$product$/12\mathrm{.}1\mathrm{.}9,$ and the value of ORACLE$\_$BASE is $/$u$01/$app$/$oracle$.$ The database and instance name is xyz$.$ What is the location of the text$-$alert log file for the xyz database?

A$.$

$/$u$01/$app$/$oracle$/$product$/12\mathrm{.}1\mathrm{.}0/$log$/$rdbms$/$xyz$/$xyz$/$trace

B$.$

$/$u$01/$app$/$oracle$/$diag$/$rdbms$/$xyz$/$xyz$/$trace

C$.$

$/$u$01/$app$/$oracle$/$diag$/$rdbms$/$xyz$/$xyz$/$alert

D$.$

$/$u$01/$app$/$oracle$/$product$/12\mathrm{.}1\mathrm{.}0/$diag$/$rdbms$/$xyz$/$xyz$/$trace

E$.$

$/$u$01/$app$/$oracle$/$log$/$rdbms$/$xyz$/$xyz$/$trace