New Features for Administrators - Question 024

Examine this startup script called startmydb.sql:

CONNECT myid/mypwd AS SYSDBA
STARTUP
EXIT

In Oracle8i, you could have executed this script by invoking Server Manager with the command:

svrmgrl @startmydb.sql

Which alternative command could you use to run the startmydb.sql script with SQL*Plus to start your Oracle9i database?

A. sqlplus @startmydb.sql

B. sqlplus -Sstartmydb.sql

C. sqlplus -S @startmydb.sql

D. sqlplus /NOLOG @startmydb.sql

Answer: D

Explanation:

This command is alternate command to start your Oracle9i database. The Server Manager is not supported in Oarcle9i any more, so you need to use SQL*Plus for administration tasks, as start or stop of database, also.

Incorrect Answers

A: The NOLOG option must be used to run this script because the instance is not started yet.

B: Script that need to be executed can be started with @ symbol, not with –S.

C: The S option cannot be used to run the startmydb.sql script.

OCP Oracle9i Database: New Features for Administrators, Daniel Benjamin, p. 4-10

Chapter 1: Security Enhancements

Oracle 9i New Features, Robert Freeman, p. 132-139

Chapter 5: Miscellaneous Oracle9i Features and Enhancements