Exam 3: Creating an Oracle Instance

There are two basic file management methods available for a new database: user-managed and Oracle ____________________.

The CREATE DATABASE ____ option is used to set the maximum number of redo log groups.

What are the advantages of using Oracle Managed Files?

Clean up processing required by SHUTDOWN NORMAL during the shutdown process is just as fast as recovery processing caused to the subsequent startup as a result of a SHUTDOWN ABORT.

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

SHUTDOWN ____automatically completes and commits all pending transactions,then forcibly disconnects all connected users,and shuts down the database.

If you install Oracle 10g Enterprise Edition on Windows 2000,the storage space of the ORACLE_HOME drive for Oracle binary files (system drive)should be at least ____ megabytes.

To invoke OMF,you simply indicate all of the filenames and locations in the CREATE DATABASE command.

In the parameter file,the parameter names are followed by a(n)____,and then the value of the parameter follows.

The CREATE DATABASE command becomes elegantly simple when you use ________________________________________ settings.

There are well over ____ initialization parameters.

The location of ____________________ log files is critical for database performance,because these files record each transaction as it is executed in the database itself.

The ____ log is essential because it will contain all the essential information for the smooth running of your database.

A new database created using the DBCA tool can take up even as much as 4GB.

____ views provide system-related information by querying the database's internal management tables and presenting the data as views (metadata views).

The syntax for the orapwd command is: orapwd file=<filename> password=<pwd> entries=<maxusers>.

Databases in modern commercial environments are usually transactional,data ____________________,or a hybrid of those two.

A(n)____________________ is a logical data storage space.

When choosing the DBA authentication method,you can choose between ____ and password file authentication.

SHUTDOWN ____ disconnects all users,rolls back pending transactions,and prohibits new connections and new transactions even for already connected users.