DBA Fundamental I Exam (IZ0-031) Questions from Oracle Magazine 
(Sept-Oct and Nov-Dec 2002) :

1. What is the minimum number of granules allocated at SGA startup?

A.  1
B.  2
C.  3
D.  4

2. What four parameters most affect SGA size? 

A.  SGA_MAX_SIZE
B.  SHARED_POOL_SIZE 
C.  DB_CACHE_SIZE
D.  LARGE_POOL_SIZE
E.  LOG_BUFFERS

3. What command would you execute to decrease the size of the shared pool from 50MB to 20MB?

A.  ALTER SESSION set SHARED_POOL_SIZE
    50m;
B.  ALTER SYSTEM set SHARED_POOL_SIZE =
    50m;
C.  ALTER SYSTEM set SHARED_POOL_SIZE
    20m;
D.  ALTER SYSTEM set SHARED_POOL_SIZE =
    20m;

4. Oracle Managed Files are established by setting what two of the following parameters?

A.  DB_FILE_CREATE_DEST
B.  DB_FILE_NAME_CONVERT
C.  DB_FILES
D.  DB_CREATE_ONLINE_LOG_DEST_N

5. What ALTER SYSTEM command sets the default directory for OMF?

A.  ALTER SYSTEM set
    DB_CREATE_FILE_DEST
    '/u01/exam_files';
B.  ALTER SYSTEM set
    DB_CREATE_ONLINE_LOG_DEST_1
    '/u01/exam_files';
C.  ALTER SYSTEM set
    DB_CREATE_FILE_DEST =
    '/u01/exam_files';
D.  ALTER SYSTEM set
    DB_CREATE_ONLINE_LOG_DEST_2 =
    '/u01/exam_files';

6. Which of the following commands will fail if you are using OMF?

A.  CREATE TABLESPACE ocp_data size
    2m;
B.  CREATE TABLESPACE ocp_data datafile
    '/u01/exam.ora' size 2m;
C.  CREATE TABLESPACE ocp_data datafile
    2m;
D.  CREATE TABLESPACE ocp_data;


7. Which one statement is true with regard to dropping a tablespace in OMF? 

A.  The associated file(s) must be manually deleted at the operating system level. 
B.  The associated file(s) is automatically deleted from the operating system.
C.  The associated file(s) cannot be deleted until the database is shut down.
D.  A tablespace created with OMF cannot be dropped. 


8. What is the default value for MAXTRANS? 

A.  96
B.  155
C.  255
D.  256


9. Which one of the following statements is true regarding PCTFREE? 

A.  It specifies the minimum percentage of used space that the Oracle server tries to 
    maintain for each data block of the table.
B.  It specifies the percentage of space in each block reserved for growth resulting 
    from changes.
C.  The default value is 40 percent.
D.  It is not used for index segments. 


10. Which statement best describes the purpose of redo log files?

A. They ensure that log switches are performed efficiently.
B. They allow changes to the database to be asynchronously recorded.
C. They provide a means to redo transactions in the event of a database failure.
D. They record changes that have not yet been committed. 


11. What is the minimum number of redo log file groups that are required for an Oracle 
    database instance?

A. One
B. Two
C. Three
D. Four 


12. What answer best describes the process that results in the loss of one redo log file 
    member in a redo log group?

A. The database hangs, and no further transactions are processed.
B. The database will continue to write to valid members of the redo log group, and further 
   transactions are processed.
C. The database shuts down and requires the DBA to resolve the problem. 
D. Log switches will not occur


13. Select the three statements that are true about checkpoints:

A. Checkpoints occur when an automatic log switch is performed. 
B. Checkpoints occur when the database is shut down with the normal, immediate, or 
   transactional option.
C. The DBA cannot force checkpoints. 
D. Checkpoints automatically occur when the DBA performs a manual log switch.
E. Checkpoints are recorded in the alert.log file by default. 


14. Select two characteristics of locally managed tablespaces:

A. Extents are managed by the data dictionary.
B. A bitmap in the datafile keeps track of the free or used status of blocks in the datafile.
C. Each segment stored in the tablespace can have a different storage clause.
D. No coalescing is required.
E. UNDO is not generated when allocation or deallocation of extents occurs.


15. What type of tablespace is best for managing sort operations? 

A. UNDO tablespace
B. SYSTEM tablespace
C. Temporary tablespace
D. Permanent tablespace 


16. What command will ensure that newly created database users are automatically assigned 
    to a temporary tablespace named DBA_EXAM?

A. ALTER TABLESPACE DBA_EXAM DEFAULT TEMPORARY TABLESPACE; 
B. ALTER TABLESPACE DEFAULT TEMPORARY TABLESPACE DBA_EXAM;
C. ALTER DATABASE TEMPORARY TABLESPACE DBA_EXAM;
D. ALTER DATABASE DEFAULT TEMPORARY TABLESPACE DBA_EXAM; 

Answers