Very Old - Oracle 8i - Database Administration

Quiz #1

 

Note - much of this material may not apply to more recent releases of Oracle

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)     Normal

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.