QUESTION $1$

Your database name is OCA$12$C$.$ The options show the files that are available in the $ORACLE$\_$HOME$/$dbx directory. Which file is used to start up the database instance when you issue the STARTUP command?

A$.$

initOCA$12$C$.$ora

B$.$

OCA$12$Cspfile.ora

C$.$

spfile.ora

D$.$

init.ora

$10$ points

QUESTION $2$

The Oracle Universal Installer is started by executing which program?

A$.$

emct$1$

B$.$

runInstaller

C$.$

ouistart

D$.$

isqlplusctl

$10$ points

QUESTION $3$

Which script creates the database dictionary?

A$.$

dictionary.sql

B$.$

catdict.sql

C$.$

catproc.sql

D$.$

catalog.sql

$10$ points

QUESTION $4$

All of the following are database$-$management options within the Database Configuration Assistant except which one?

A$.$

Change Database Initialization Parameters

B$.$

Create a Database.

C$.$

Manage Templates

D$.$

Delete a Database

$10$ points

QUESTION $5$

Which of the following shutdown statements does not perform a clean shutdown?

A$.$

SHUTDOWN ABORT

B$.$

SHUTDOWN TRANSACTIONAL

C$.$

SHUTDOWN

D$.$

SHUTDOWN IMMEDIATE

E$.$

All of these are considered clean shutdowns.

$10$ points

QUESTION $6$

Your database is not responding and is in a hung state. You want to shut down and start the database to release all resources. Which statement would you use.

A$.$

STARTUP AFTER SHUTDOWN

B$.$

STARTUP FORCE

C$.$

SHUTDOWN FORCE

D$.$

None of the above