Exam Prep Questions

1:Which two commands start up the instance and leave the database mounted and normal users unable to log in? [Select two answers]

  • A. startup nomount

  • B. startup restrict

  • C. startup mount

  • D. startup open

  • E. STARTUP read-only

A1: Answers B and C are correct. STARTUP MOUNT allows the DBA to perform certain types of maintenance that cannot be accomplished when the database is open, and STARTUP RESTRICT opens the database yet allows the DBA to perform other types of maintenance that cannot be accomplished when users are logged in. Both require special privileges to allow the user to connect. Answer A starts the instance but does not mount the database. Answer D is the default and allows any user to log in and manipulate data in the ...

Get Oracle 9i Fundamentals I Exam Cram™ 2 (Exam 1Z0-031) now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial