Exam 3: Creating an Oracle Instance

When manually creating a database,you have to run scripts to create data dictionary (____________________)views and built-in PL / SQL procedures.

The CREATE DATABASE ____ option is used to set the maximum number of instances of the database that can be open at the same time.

When installing Oracle10g server software,you can choose between Enterprise,Standard,or ____________________ Edition.

DBCA stands for ___________________________________.

Oracle recommends that you multiplex your control file.

If you install Oracle 10g Enterprise Edition on Windows 2000,the recommended requirements for memory are ____ megabytes of RAM.

The initialization configuration parameters file is ____.

In Windows,the Universal Installer automatically creates the group for SYSDBA privileges and names it ____.

A(n)____ database is used to service Internet applications.

The DBCA tool executes the ____ for you,in order to configure the new database's Named Service.

The syntax of the CREATE DATABASE file contains numerous,optional parameters.

If you install Oracle 10g Enterprise Edition on Windows 2000,a storage space of ____ gigabytes are recommended in total.

The CREATE DATABASE ____ option is used to set the maximum number of redo log files in each redo log group.

In the SQL*Plus statement CONNECT / @ORACLASS AS SYSDBA,the ____ tells the database to use OS authentication.

SHUTDOWN IMMEDIATE may require recovery on database startup if an inconsistent shutdown occurred.

Oracle Managed Files have names that comply with ___________________________________.

The OS authentication method cannot be set up for remote database access over the Internet.

The SYSTEM tablespace and its corresponding datafiles are created when the database is created.

STARTUP MOUNT first executes STARTUP ____________________ before mounting the database instance.

OLTP stands for ______________________________.