Exam 3: Creating an Oracle Instance

Control files are created when the database is created,based on the ____________________ parameter in the initialization parameter file.

To create a new database you can use the ____________________ command.

To implement user-managed redo log files,you should use the ____ clause in the CREATE DATABASE command itself.

Creating a database is a separate process (from the installation process)that occurs after the database software has been installed.

The most common DBA authentication method is to set up a password file for authentication.

The ____ database configuration option allows for a lot of change activity,raising concurrency requirements,and lowering I / O activity requirements.

A(n)____ database allows you to define anything and everything - this one is for the experts.

If you execute STARTUP with no PFILE parameter,then you will get an error.

Oracle databases can be managed from a central location using the OEM ____ Control,or locally using the OEM Database Control.

There are ____ options for the SHUTDOWN COMMAND.

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

The ____ initialization parameter defines one or more directories where control files and redo log files are to be created.

In the parameter file,comment lines are marked with a leading ____ sign;blank lines are ignored.

When managing a database with the Database Control you can configure the system to utilize automated email notifications (used to preempt potential problems),and you can also schedule regular backups.

When the ____ initialization parameter is set,Oracle 10g knows where to locate all the datafiles.

What is the difference between ASM and raw device storage mechanisms?

ASM stands for ______________________________.

STARTUP ____ mounts the database files,essentially creating the connection between file pointers in the control file and the files themselves,such as datafiles and redo log files.

The Oracle command,____________________ creates the password file.

Any user with the SYSOPER role can perform any task necessary in the database,including creation of an instance,recovery of an instance,and maintenance or creation of tables and data owned by any user in the database.