DBA Fundamental II Exam (IZ0-032) Questions from Oracle Magazine 
(Jan-Feb 2003):

1. What is the minimum number of granules allocated at SGA startup?What is the purpose 
   of Oracle Net Services in an Oracle database environment? 

A. Process requests within the database
B. Establish the connection between a client and the database
C. Maintain data integrity within the client application
D. Start the listener process 

2. What is the default name of the listener process? 

A. LSNRCTL
B. Listener01
C. Listener
D. Listener_01 

3. When using dynamic service registration, the process monitor (PMON) reads initialization 
   parameters using what file? 

A. listener.ora
B. tnsnames.ora
C. sqlnet.ora
D. init.ora 

4. What two init.ora file parameters must be set to support dynamic service registration? 

A. TNS_ADMIN
B. SERVICE_NAMES
C. SID_NAME
D. INSTANCE_NAME 

5. What file resides on a client machine and is used to store Oracle Net Services names? 

A. tnsnames.ora
B. sqlnet.ora
C. listener.ora
D. init.ora 

6. What four statements regarding a dedicated server process environment are true? 

A. The user process and server process are separate
B. Each user process has its own server process
C. The user and server processes can run on different machines to take advantage of 
   distributed processing
D. There is a one-to-many ratio between the user and server processes
E. Even when the user process is not making a database request, the dedicated server 
   exists but remains idle
F. Processing results are sent from the server processes satisfying the request to a 
   dispatcher process Next Steps 

7. What two parameters are required to configure an Oracle shared server process environment? 

A. SHARED_SERVERS
B. CIRCUITS
C. MAX_SHARED_SERVERS
D. DISPATCHERS
E. MAX_DISPATCHERS 

8. What dynamic performance view can you query to determine if you are connected using a 
   shared server process? 

A. V$DISPATCHER
B. V$SESSION
C. V$CIRCUIT
D. V$QUEUE
E. V$SHARED_SERVER 

9. In a dedicated server configuration, the contents of the PGA include which of the 
   following three pieces of data? 

A. User session data
B. Stack space
C. Cursor state
D. Shared pool and other memory structures 

Answers