Exam Prep Questions

1:What three tablespaces can be created using the CREATE DATABASE statement? [Select three]

  • A. Undotbs1

  • B. System

  • C. Users

  • D. Datatbs

  • E. Indextbs

  • F. Temporary

A1: Answers A, B, and F are correct. The three tablespaces that you can create at database creation time are the Undo tablespace (which defaults to the name in A if none is given and automatic undo is used), a default temporary tablespace, and the system tablespace (SYSTEM is the only one that is mandatory). Although Users (C), Datatbs (D), and Indextbs (E) may be valid tablespaces, they have to be created after the database is created.
2:What should you do as soon as you have successfully created the database and the data dictionary?

  • A. Open the database for users to start ...

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