Exam Prep Questions

1:Which of the following users would you use to connect to the instance to run the scripts that create the data dictionary in the database?

  • A. SYSTEM

  • B. SYS

  • C. SYSDBA

  • D. INTERNAL

A1: Answer B is correct. SYS is the user you connect to the database instance with in order to create the data dictionary structures. Answer A is incorrect because SYSTEM does not have, and should not be given, sufficient privileges to run the data dictionary creation scripts. Answer C in incorrect; SYSDBA is a role, not a user. Answer D is incorrect because INTERNAL, although a possible answer in previous releases, has been made obsolete in Oracle 9i.
2:You are ready to create the data dictionary in your new database. What scripts do you run at the SQL ...

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