CSCI 276/397C
- Fall 1999
Oracle 8 -
Database Administration
Quiz #1
Directions: Closed book, notes and computer. Multiple choice - choose the best possible
answer. Pick only one answer unless
specifically directed to do otherwise.
Use the answering sheet provided to mark your answers.
1) Using a browser to retrieve
data from an Oracle database is an e.g. of -
A) a two-tiered client-server
connection
B) a three-tiered client-server
connection
C) logging in directly to a
host
D) mainframe computing
E) Java programming
2) When a user gets the message
"ORA-01034: Oracle not available" when attempting to connect to an
Oracle server, the database administrator needs to -
A) create a database listener
for the database
B) login as internal and
shutdown the database
C) login as system and start
the database in nomount mode
D) login to the Instance
Manager and startup the database
E) login to the Schema Manager
and startup the database
2) Choose all below that are
true for a server process in a dedicated server configuration -
A) uses an exclusive PGA
B) includes the UPI
C) uses the Oracle Program
Interface
D) processes calls generated by
the client
E) generates calls to the
Oracle server
3) An Oracle Instance consists
of -
A) the operating system and PGA
B) the SGA, PMON and SMON
C) the the on-line redo log
files, Oracle database and background processes
D) the Oracle database and SGA
E) the SGA and background
processes
4) The LGWR background process
-
A) writes changed data to the
database
B) is responsible for updating
database status information whenever changes in the buffer cache are
permanently recorded in the database
C) initiates instance recovery
D) records changes registered
in the redo log buffer to the redo log files
E) cleans up resources if one
of the processes fails
5) An Oracle database consists
of -
A) data files, control files
and redo log files
B) control files and data files
C) data files only
D) the parameter file, password
file and data files
E) the data files, control
files, redo log files and archived redo log files
6) What , in the proper order,
are the main stages in processing a query?
A) Fetch, parse and then
execute
B) Fetch, execute and then
parse
C) Parse and execute
D) Parse, execute and then
fetch
E) Parse, execute and then
commit
7) Mark all that are true about
the Shared Pool -
A) Size is defined by
SHARED_POOL_SIZE in the parameter file
B) Holds the library cache
C) Holds the data dictionary
cache
D) Holds the database buffer
cache
E) Holds the PGA
8) When a user issues an UPDATE
command, what happens after the server process places locks on the data and
before the server process records the before-image to the rollback block and
updates the data block (both in database buffer cache)?
A) The server process reads the
data and rollback blocks from the data files, if they are not already in the
buffer cache.
B) The UPDATE statement is
parsed
C) Changes are recorded in the
redo log buffer
D) A commit is generated for
the UPDATE
E) A checkpoint is taken
10)
Mark all that are true about rollback segments -
A) They are used to undo the
changes if a transaction is rolled back.
B) Are used only for committed
transactions.
C) They ensure that other transactions
do not see uncommitted changes made by a DML statement.
D) They are written by the
LGWR.
E) They are used to recover the
database to a consistent state in case of failures.
11)Which
one is true about the redo log buffer ?
A) Its size is defined by LOG_SIZE
in the parameter file.
B) It is accessed by an index.
C) It is used in a circular
fashion so it can be reused.
D) Entries are recorded in the
data files on disk.
E)
Only one transaction at a time can write to it.
12)
The DBWR -
A) Takes over in the case of an
instance recovery.
B) Writes dirty buffers from
the database buffer cache to the data files.
C) Is invoked every time the
LGWR is invoked.
D) Writes to the control files
constantly.
E) Is never involved in checkpointing.
13)
What happens when a COMMIT is issued right after the server process places a
commit record and SCN in the redo log buffer and before the user is informed
that the commit is complete?
A) A checkpoint is taken.
B) The DBWR is invoked to write
changes in the buffer cache to disk.
C) The LGWR writes the redo log
buffer entries up to and including the commit record to the redo log files.
D) The server process releases
the lock on the transactions resources
E) PMON wakes up.
14)
The OEM Console -
A) Consists of several
intelligent agents.
B) Needs lots of database
listeners to run properly.
C) Is invoked by the Server
Manager.
D) Provides several services
such as job scheduling, security, and event management.
E) Is a command line driven
tool only.
15)
If one wants to load and reorganize data in Oracle 8 databases, which standard
application from the OEM would one use?
A) The Data Manager
B) The Backup Manager
C) The Storage Manager
D) The Schema Manager
E) The Instance Manager
16)
If one wants to create and maintain objects such as tables, indexes, and views,
which standard application from the OEM would one use?
A)
The Data Manager
B)
The Backup Manager
C)
The Storage Manager
D) The Schema Manager
E) The Instance Manager
17)
As the DBA, you need to have a special authentication method when you start up
the database. You want to administer the
database without using a password file.
How would you set up the authentication method for the DBA?
A) Execute the password
utility, set the REMOTE_LOGIN_PASSWORDFILE parameter to 'SHARED' and use
'CONNECT / AS SYSDBA to connect to the database.
B) Grant your operating system
login the DBA role.
C) Execute the ORAPWD80 utility
if you are working in Windows NT.
D) Execute the password utility
and set the REMOTE_LOGIN_PASSWORDFILE parameter to 'EXCLUSIVE' and use 'CONNECT
/ AS SYSDBA to connect to the database.
E) Set up operating system
authentication, set the REMOTE_LOGIN_PASSWORDFILE parameter to 'NONE' and use
'CONNECT / AS SYSDBA to connect to the database.
18)
Mark all that are true for setting up password file authentication for Windows
NT -
A) You can use the ORAPWD80
utility to create the password file.
B) The ORAPWD80 utility has
only 2 parameters.
C) The <password>
parameter for the ORAPWD80 utility is the password for SYSTEM.
D) Be sure to set the
REMOTE_LOGIN_PASSWORDFILE parameter to 'NONE'.
E) The <entries>
parameter for the ORAPWD80 utility is the maximum number of distinct database
administrators.
19)
Mark all that are true for the the Initialization Parameter File for an Oracle
8 database -
A) Used in the Shutdown
command.
B) Used in the Startup command.
C) Is read each time a
transaction is executed against the database.
D) Is used to specify control
files, archived log files, and trace file locations.
E) Is used to size the
components of the SGA.
20)
When a database is started in NOMOUNT mode -
A) The SGA is allocated.
B) Data files can be renamed.
C) Redo log files are opened.
D) Data files are opened.
E) Control files are opened.
21)
In order to access the data files of the database with PL/SQL commands the
database must be
A) in NOMOUNT mode.
B) In MOUNT mode.
C) OPEN.
D) SHUTDOWN.
E) SHUTDOWN IMMEDIATE.
22)
Which tool in the OEM allows one to Startup and Shutdown Databases?
A) The Data Manager
B) The Backup Manager
C) The Schema Manager
D) The Performance Tuner
E) The Instance Manager
23)
Which of the Shutdown options allows current sessions to end before shutting
down the database?
A) Abort
B)
C) Transactional
D) Immediate
E) None of the above
24)
Which command would you use to place an instance in restricted mode?
A) UPDATE V$PARAMETER_FILE
SET RESTRICTED = TRUE;
B) ALTER SYSTEM ENABLE
RESTRICTED SESSION;
C) ALTER SESSION ENABLE
RESTRICTED;
D) ALTER SYSTEM SET
RESTRICTED=TRUE;
E) ALTER SESSION SET RESTRICTED
= TRUE;
25)
When planning your database file locations in creating a database -
A) It is fine to have a single
control file.
B) Put all your files on a
single disk for easy access.
C) Be sure to multiplex your
online redo log files.
D) Put user data in with the
SYSTEM data files on the same disk.
E) Put temporary data on the
same disk with permanent user data.
26)
When creating a database manually, right after you start the instance and
before you run the scripts to generate the data dictionary you will -
A) Prepare the parameter file.
B) Set the operating system
variables.
C) Create a password file.
D) Use the ORADIM80 utility.
E) Create the database.
27)
The Oracle tool that make database creation a relatively easy task is -
A) The Instance Manager
B) The Schema Manager
C) The OEM
D) The Net 8 Assistant
E) The Database Assistant
28)
Mark all that can cause database creation to fail -
A) Files specified in the
Parameter file do not already exist.
B) Files that should be created
already exist.
C) The are syntax errors in the
script that creates the database.
D) There is plenty of space for
the database.
E) All the proper directory
permissions are in place.
29)
The scripts to run to create the base tables and data dictionary views after
database creation are (mark all that apply) -
A) sql.bsq
B) create.sql
C) catalog.sql
D) views.sql
E) datadict.sql
30)
Mark all that are true about Stored Procedures -
A) They can only be used by
their creator.
B) They are without parameters.
C) They are stored in the
shared pool.
D) The can be used by many
users.
E) They can reduce disk
retrieval.
31)
Mark all that can give you information regarding the control file -
A) DBA_OBJECTS
B) DBA_SESSIONS
C) V$CONTROLFILE
D) V$PARAMETER
E) V$DATABASE
32)
What happens when one is multiplexing the control file, right after making a
copy of the existing control file to a different device using operating system
commands and before starting up the database?
A) Shut down the database.
B) Start up the database in
MOUNT mode.
C) Start the NT Services.
D) Check the ALERT log.
E) Edit the CONTROL_FILES parameter and specify full paths
and names for the control files.
33)
An online redo log group -
A) Has members that are all
different from each other.
B) Is a set of identical
copies.
C) Should have its members all
on the same disk.
D) Is written to by the DBWR.
E) Is part of the SGA.
34)
Mark all that are true for checkpoints -
A) They occur at every log
switch.
B) They occur with a SHUTDOWN
ABORT.
C) They only involve the LGWR.
D) They can be force by setting
the LOG_CHECKPOINT_INTERVAL
E) They are a wasted of time.
35)
Which of the following can tell you whether or not you are in Archive Log Mode?
A) V$DATABASE
B) V$INSTANCE
C) DBA_TABLES
D) DBA_SESSIONS
E) DBA_USERS
36)
If you want to find out the status of a member of an redo log file group, use
the view -
A) V$DATABASE
B) V$INSTANCE
C) V$LOGFILE
D) V$THREAD
E) DBA_SESSIONS
37)
Use the following command to force log switches -
A) ALTER SYSTEM SWITCH LOGFILE;
B) ALTER SESSION SWITCH
LOGFILE;
C) ALTER DATABASE SWITCH
LOGFILE;
D) UPDATE LOGFILE SWITCH;
E) CHECKPOINT;
38)
Use the following tool in the OEM to multiplex online redo log groups -
A) The Instance Manager
B) The Schema Manager
C) The Data Manager
D) The Oracle Expert
E) The Backup Manager
39)
In relocating online redo log files, what is the first step just prior to
copying the online redo log files to a new location?
A) Startup the database in
NOMOUNT mode.
B) Stop the NT services.
C) Execute the ALTER DATABASE
RENAME FILE command.
D) Shut down the database.
E) Open the database.
40)
What will happen if all members of the next group of online redo log files is
not available at the time a log switch occurs?
A) The instance shuts down.
B) The LGWR ignores the error
and looks for a group beyond that group.
C) The current log group will
be dropped.
D) The DBA will need to force a
log switch.
E) The archiver will come
online.