Question 1

Omitting the LOGFILES clause in the CREATE DATABASE command means that the redo log files are not created.

Accepted Answer

A) True 
 B)False

Question 2

Describe how password file authentication works.

Accepted Answer

Password file authentication requires yo

Question 3

Database types are generally application driven,or determined by the kinds of applications that users are utilizing against a database.

Accepted Answer

A) True 
 B)False

Question 4

SHUTDOWN TRANSACTIONAL is the most prudent method of rapidly shutting down an Oracle database and should always be used if possible.

Accepted Answer

A) True 
 B)False

Question 5

The ____________________ role is a predefined database role containing all system privileges having the ADMIN option and the ability to execute the CREATE DATABASE command.

Accepted Answer

The answer of The ____________________ role is a predefined database...

Question 6

The main advantage of using OFA is the ability to control the exact size and name of datafiles,control files,and log files.

Accepted Answer

A) True 
 B)False

Question 7

The ____________________ (server binary parameter file)is also known as the binary parameter file.

Accepted Answer

The answer of The ____________________ (server binary parameter file)is also...

Question 8

Each tablespace is mapped to exactly one datafile.

Accepted Answer

A) True 
 B)False

Question 9

The ____ tool guides you through database setup and creation using windows with instructions for each step.

Accepted Answer

A)  DBCA 
B)  SQL*Plus 
C)  OMF 
D)  OFA 
A)  DBCA 
B)  SQL*Plus 
C)  OMF 
D)  OFA

Question 10

The RAW devices storage management option uses the operating system file system to store database files,such as datafiles,control files,and log files.

Accepted Answer

A) True 
 B)False

Question 11

You can edit the Windows Registry,using the program ____.

Accepted Answer

A)  registry.exe 
B)  regedit.exe 
C)  winreg.exe 
D)  wregistry.exe 
A)  registry.exe 
B)  regedit.exe 
C)  winreg.exe 
D)  wregistry.exe

Question 12

You can start up SQL*Plus without logging on by entering ____.

Accepted Answer

A)  sqlplus 
B)  sqlplus / nolog 
C)  sqlplus / log=OFF 
D)  sqlplus !log 
A)  sqlplus 
B)  sqlplus / nolog 
C)  sqlplus / log=OFF 
D)  sqlplus !log

Question 13

The binary parameter file is used in the STARTUP command by default,and is located by default in the ____ / database directory.

Accepted Answer

A)  ORACLE_HOME 
B)  ORACLE_BASE 
C)  HOME 
D)  BASE 
A)  ORACLE_HOME 
B)  ORACLE_BASE 
C)  HOME 
D)  BASE

Question 14

The Oracle Net Services software is needed for all editions,so it is usually automatically installed.

Accepted Answer

A) True 
 B)False

Question 15

STARTUP MOUNT is the default method of starting up the database.

Accepted Answer

A) True 
 B)False

Question 16

SHUTDOWN ____ simply stops all Oracle processes,and releases all memory buffers.

Accepted Answer

A)  NORMAL 
B)  TRANSACTIONAL 
C)  IMMEDIATE 
D)  ABORT 
A)  NORMAL 
B)  TRANSACTIONAL 
C)  IMMEDIATE 
D)  ABORT

Question 17

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

Accepted Answer

A)  startup 
B)  start 
C)  init 
D)  run 
A)  startup 
B)  start 
C)  init 
D)  run

Question 18

The two operating system groups specifically set up for DBAs are referred to as OSDBA and ____________________ in the Oracle documentation.

Accepted Answer

The answer of The two operating system groups specifically set...

Question 19

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

Accepted Answer

A)  256 
B)  512 
C)  1024 
D)  2048 
A)  256 
B)  512 
C)  1024 
D)  2048

Question 20

When a database is created using the DBCA tool,a parameter file is generated.

Accepted Answer

A) True 
 B)False

Omitting the LOGFILES clause in the CREATE DATABASE command means that the redo log files are not created.

Describe how password file authentication works.

Database types are generally application driven,or determined by the kinds of applications that users are utilizing against a database.

SHUTDOWN TRANSACTIONAL is the most prudent method of rapidly shutting down an Oracle database and should always be used if possible.

The ____________________ role is a predefined database role containing all system privileges having the ADMIN option and the ability to execute the CREATE DATABASE command.

The main advantage of using OFA is the ability to control the exact size and name of datafiles,control files,and log files.

The ____________________ (server binary parameter file)is also known as the binary parameter file.

Each tablespace is mapped to exactly one datafile.

The ____ tool guides you through database setup and creation using windows with instructions for each step.

The RAW devices storage management option uses the operating system file system to store database files,such as datafiles,control files,and log files.

You can edit the Windows Registry,using the program ____.

You can start up SQL*Plus without logging on by entering ____.

The binary parameter file is used in the STARTUP command by default,and is located by default in the ____ / database directory.

The Oracle Net Services software is needed for all editions,so it is usually automatically installed.

STARTUP MOUNT is the default method of starting up the database.

SHUTDOWN ____ simply stops all Oracle processes,and releases all memory buffers.

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

The two operating system groups specifically set up for DBAs are referred to as OSDBA and ____________________ in the Oracle documentation.

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

When a database is created using the DBCA tool,a parameter file is generated.

Oracle Architecture Overview

Tools and Architecture

Oracle Physical Architecture and Data Dictionary Views

Basic Storage Concepts and Settings

The Basics of Querying a Database

Basic Table Management

Advanced Table Management

Constraints, indexes, and Other Specialized Objects

Basic Data Management

Advanced Data Management

Security Management

Performance Monitoring

Proactive Maintenance

Backup and Recovery

Filters

Exam 3: Creating an Oracle Instance

Omitting the LOGFILES clause in the CREATE DATABASE command means that the redo log files are not created.

Describe how password file authentication works.

Database types are generally application driven,or determined by the kinds of applications that users are utilizing against a database.

SHUTDOWN TRANSACTIONAL is the most prudent method of rapidly shutting down an Oracle database and should always be used if possible.

The ____________________ role is a predefined database role containing all system privileges having the ADMIN option and the ability to execute the CREATE DATABASE command.

The main advantage of using OFA is the ability to control the exact size and name of datafiles,control files,and log files.

The ____________________ (server binary parameter file)is also known as the binary parameter file.

Each tablespace is mapped to exactly one datafile.

The ____ tool guides you through database setup and creation using windows with instructions for each step.

The RAW devices storage management option uses the operating system file system to store database files,such as datafiles,control files,and log files.

You can edit the Windows Registry,using the program ____.

You can start up SQL*Plus without logging on by entering ____.

The binary parameter file is used in the STARTUP command by default,and is located by default in the ____ / database directory.

The Oracle Net Services software is needed for all editions,so it is usually automatically installed.

STARTUP MOUNT is the default method of starting up the database.

SHUTDOWN ____ simply stops all Oracle processes,and releases all memory buffers.

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

The two operating system groups specifically set up for DBAs are referred to as OSDBA and ____________________ in the Oracle documentation.

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

When a database is created using the DBCA tool,a parameter file is generated.

Oracle Architecture Overview

Tools and Architecture

Oracle Physical Architecture and Data Dictionary Views

Basic Storage Concepts and Settings

The Basics of Querying a Database

Basic Table Management

Advanced Table Management

Constraints, indexes, and Other Specialized Objects

Basic Data Management

Advanced Data Management

Security Management

Performance Monitoring

Proactive Maintenance

Backup and Recovery

Filters