Deck 3: Creating an Oracle Instance

Question 1

The syntax for the orapwd command is: orapwd file= password= entries=.

Answer 1

True

Question 2

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

Answer 2

True

Question 3

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

Answer 3

True

Question 4

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

Question 5

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

Question 6

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

Question 7

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

Question 8

Each tablespace is mapped to exactly one datafile.

Question 9

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

Question 10

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.

Question 11

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

Question 12

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

Question 13

Oracle recommends that you multiplex your control file.

Question 14

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

Question 15

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.

Question 16

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

Question 17

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

Question 18

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

Question 19

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

Question 20

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.

Question 21

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

Question 22

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

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

Question 23

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

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

Question 24

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

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

Question 25

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

Question 26

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.

A) 50
B) 100
C) 200
D) 500

Question 27

STARTUP MOUNT is used for database administration only.

Question 28

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.

Question 29

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

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

Question 30

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

Question 31

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

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

Question 32

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

Question 33

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

A) encrypted
B) hashed
C) shadow
D) operating system

Question 34

The initialization configuration parameters file is ____.

A) conf.ora
B) params.conf
C) init.ora
D) init.conf

Question 35

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

Question 36

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

Question 37

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

Question 38

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

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

Question 39

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

Question 40

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

A) shutdown
B) end
C) exit
D) quit

Question 41

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

A) Custom
B) Data Warehouse
C) General Purpose
D) Transaction Processing

Question 42

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

A) 1.5
B) 2
C) 3
D) 5

Question 43

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

A) LF
B) LOG
C) LOGF
D) LOGFILES

Question 44

The DBA authentication method encompasses the method used to validate logon of users with the SYSDBA or ____ role.

A) ADMIN
B) OSOPER
C) SYS
D) SYSOPER

Question 45

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

A) *
B) !
C) #
D) @

Question 46

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

A) Custom
B) Data Warehouse
C) General Purpose
D) OLTP

Question 47

There are well over ____ initialization parameters.

A) 50
B) 200
C) 500
D) 1000

Question 48

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

A) Custom
B) Data Warehouse
C) General Purpose
D) OLTP

Question 49

When creating a database,one of the screens in the DBCA tool allows configuration of a database using Oracle Enterprise Manager,the Database Control,or the ____ Control.

A) Data Warehouse
B) Custom
C) OLTP
D) Grid

Question 50

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

A) orapw.ora
B) shadow.ora
C) PWD.ORA
D) PASSWD.ORA

Question 51

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

A) CONNECT
B) @
C) /
D) AS

Question 52

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

A) Managed Files
B) Storage Manager
C) OFA
D) Data Dictionary

Question 53

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

A) tab
B) equal sign
C) colon
D) semicolon

Question 54

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

A) Distributed
B) Cluster
C) Remote
D) Grid

Question 55

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

A) ORA_DBA
B) WIN_DBA
C) SYSOPER
D) SYSWIN

Question 56

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

A) sqlplus / sys
B) sqlplus / nolog
C) sqlplus / dba
D) sqlplus / admin

Question 57

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

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

Question 58

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

A) DB_CREATE_FILE_DEST
B) DB_CREATE_ONLINE_LOG_DEST_n
C) DB_CREATE_DIR_DEST
D) DB_CREATE_DIRECTORY_DEST_n

Question 59

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

A) Custom
B) Data Warehouse
C) General Purpose
D) Transaction Processing

Question 60

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.

A) DB_CREATE_FILE_DEST
B) DB_CREATE_ONLINE_LOG_DEST
C) DB_CREATE_DIR_DEST
D) DB_CREATE_DIRECTORY_DEST

Question 61

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

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

Question 62

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

A) NOMOUNT
B) MOUNT
C) OPEN
D) PFILE

Question 63

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

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

Question 64

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

A) MAXLOGFILES
B) MAXLOGMEMBERS
C) MAXINSTANCES
D) MAXDATAFILES

Question 65

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.

A) NOMOUNT
B) MOUNT
C) OPEN
D) PFILE

Question 66

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

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

Question 67

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

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

Question 68

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

A) MAXLOGFILES
B) MAXLOGMEMBERS
C) MAXINSTANCES
D) MAXDATAFILES

Question 69

The ____ Connection Mode can help when there are more than 1000 concurrent users.

A) Single Server
B) Dedicated Server
C) Multiple
D) Shared Server

Question 70

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.

A) sql
B) ora
C) scr
D) pls

Question 71

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

A) redo
B) data
C) alert
D) error

Question 72

STARTUP ____ starts up all background processes,and allocates space in memory for all Oracle database instance memory buffers.

A) NOMOUNT
B) MOUNT
C) OPEN
D) PFILE

Question 73

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

A) DB_FILE_DEST
B) DB_BASE
C) DB_PATH
D) DB_HOME

Question 74

There are ____ options for the SHUTDOWN COMMAND.

A) two
B) three
C) four
D) five

Question 75

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

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

Question 76

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

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

Question 77

The CREATE DATABASE ____ option is an optional setting that determines the maximum number of datafiles that can be open when the database is open.

A) MAXLOGFILES
B) MAXLOGMEMBERS
C) MAXINSTANCES
D) MAXDATAFILES

Question 78

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

A) MAXLOGFILES
B) MAXLOGMEMBERS
C) MAXINSTANCES
D) MAXDATAFILES

Question 79

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

A) SQL*Plus
B) Net Services
C) Net Manager
D) Universal Installer

Question 80

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