Exam 3: Creating an Oracle Instance

Windows system pre-installation tasks require more manual steps than Unix systems.

When creating a new database in Unix,the operating system user is automatically established by the Oracle Installer.

When starting up the database without specifying ____________________,the SPFILE in the ORACLE_HOME / database directory will be used to retrieve parameters.

To shutdown the database you can use the SQL*Plus ____ command.

The ____ initialization parameter defines the directory where all datafiles and tempfiles (files used for storage of temporary data during sorting and other operations)are to be created.

You can use the ____________________ tool to generate a CREATE DATABASE command for the database you wish to create.

SHUTDOWN ____waits for all users to log off,prohibits new connections,forcibly rolls back currently running transactions,and then shuts down the database.

The ____ database configuration option will change some configuration,generally allowing low concurrency and very high I / O activity.

Using SHUTDOWN ABORT to shut down a database saves you a significant amount of time.

OMF stands for ____________________.

The text parameter file is a text editable form of the configuration initialization parameter file and is by default stored in the ____________________\admin\trial01\pfile directory.

The script files generated by the DBCA tool include numerous SQL*Plus executable ____ files,a configuration parameter file called init.ora,and a batch file for executing all the scripts in a single shell command.

To log on to SQL*Plus with SYSDBA privileges using the OS authentication method,you can type the following command on the command line: ____.

In Windows systems,the password file filename must be ____.

STARTUP ____ will open the database in read / write,unrestricted mode.

The ____________________ role has all the system privileges needed to start up,shut down,and back up the database,as well as modify database components,such as datafiles and tablespaces.

The ASM storage management option optimizes the layout of a database,favoring I / O performance.

What are the prerequisites you must fulfill before creating a new database?

Omitting a fully qualified DATAFILE clause in the CREATE DATABASE command causes Oracle 10g to create Oracle Managed Files as the datafiles for the SYSTEM tablespace.

In Windows and Unix,you must manually set up the OSOPER group if you want to use it.