Self Test #2: Database Administration (Chapters 6-10)
Welcome to the Interactive Self-Study Module. This page contains all of the review questions from the end of each chapter. Read the question, then click on the appropriate answer. A correct answer will link you to the next question.
If you need further review of the topic, click on the 
icon to link to
the appropriate section in the electronic book.
Chapter 6 Self Test
1. The background process that coalesces small blocks of free space into larger blocks of free space is
A. DBWR B. LGWR C. SMON D. PMON E. LMON 2. In order to perform administrative tasks on the database using Oracle password authentication, the DBA should have the following two privileges granted to them:
A. sysdba or sysoper B. osdba or osoper C. CONNECT or RESOURCE D. restricted session or create session 3. Which component of the system global area stores parsed SQL statements used for process sharing?
A. Buffer cache B. Private SQL area C. Redo log buffer D. Library cache E. Row cache 4. A foreign key relationship between two tables with an ordinality of 0, N indicates that
A. The relationship is mandatory and one-to-one B. The relationship is optional and one-to-many C. The relationship is mandatory and one-to-one D. The relationship is optional and one-to-many 5. The INIT.ORA parameter that indicates the size of each buffer in the buffer cache is the
A. DB_BLOCK_BUFFERS B. BUFFER_SIZE C. DB_BLOCK_SIZE D. ROLLBACK_SEGMENTS 6. Which two of the following SQL scripts must be run as part of database creation?
A. utllockt.sql B. catalog.sql C. catalog6.sql D. utlmontr.sql E. utlestat.sql F. catexp.sql 7. Changing the password used to manage the password file changes the password for which of the following?
A. SYSTEM B. RPT_BATCH C. CONNECT D. internal E. audit 8. The default password for the SYS userid is
A. CHANGE_ON_INSTALL B. NO_PASSWORD C. MANAGER D. ORACLE E. NULL 9. DBAs who are planning to administer a database remotely should use operating system authentication.
A. TRUE B. FALSE 10. Power will disconnect on the machine running Oracle in two minutes. How should the DBA shut down the instance?
A. shutdown normal B. shutdown immediate C. shutdown abort D. shutdown force E. shutdown recover 11. What method should the DBA use to prevent access to the database while dropping and re-creating an index?
A. Enable restricted session to prevent users from accessing the database. B. Shutdown the database with the abort option to prevent users from accessing the database. C. Execute an alter database mount to prevent users from accessing the database. D. Execute a connect internal to prevent users from accessing the database.
Chapter 7 Self-Test
1. Examine the following statement and identify any errors.
A. create rollback segment RBS_01 B. tablespace ROLLBACK_SEGS C. storage (initial 10M next 10M D. minextents 5 maxextents 10 E. pctincrease 10 F. freelist groups 2); G. There are no errors in this statement. 2. When a CREATE TABLE command is issued with no storage options specified, what storage options are used to create it?
A. The default options specified for the user in the tablespace. B. The default options specified for the table in the tablespace. C. The default options specified for the user in the database. D. The default options specified for the table in the database. 3. A high PCTUSED
A. Increases performance costs by forcing Oracle to place the block on freelists frequently. B. Increases performance costs by forcing Oracle to place the block on freelists rarely. C. Decreases performance costs by forcing Oracle to place the block on freelists frequently. D. Decreases performance costs by forcing Oracle to place the block on freelists rarely. 4. To control the storage allocation of a table or index: (choose two)
A. Specify a low pctfree B. Specify a high pctused C. Specify a low maxextents D. Specify a high minextents E. Specify a low pctincrease F. Specify a high maxextents 5. Flushing the dirty buffer write queue is most directly handled by
A. PMON B. SMON C. ARCH D. RECO E. DBWR 6. To decrease the number of checkpoints that occur on the database
A. Set LOG_CHECKPOINT_INTERVAL to half the size of the online redo log. B. Set LOG_CHECKPOINT_INTERVAL to twice the size of the online redo log. C. Set LOG_CHECKPOINT_TIMEOUT to the number of bytes in the online redo log. D. Set LOG_CHECKPOINT_TIMEOUT to half the number of bytes in the online redo log. 7. The following strategies are recommended when customizing the redo log configuration:
A. Store redo log members on the same disk to reduce I/O contention. B. Run LGWR only at night. C. Store redo log members on different disks to reduce I/O contention. D. Run DBWR only at night. 8. By allowing user processes to write redo log entries to the redo memory buffer, Oracle reduces I/O contention for disks that contain redo log entries.
A. TRUE B. FALSE 9. At which point in an UPDATE is the data change actually made in the datafile?
A. Parse step B. Execution step C. Commit step D. Checkpoint step 10. Which of the following best supports the concept of transaction concurrency?
A. Read-only tablespaces B. Locking mechanisms C. Select statements issued by multiple users D. Distributing redo log members over multiple disks 11. By default, checkpoints happen at least as often as
A. Redo log switches B. update statements are issued against the database C. The SYSTEM tablespace is accessed D. SMON coalesces free space in a tablespace 12. To determine the storage allocation for temporary segments, the DBA can access which of the following views?
A. DBA_TEMP_SEGMENTS B. DBA_TABLES C. DBA_SEGMENTS D. DBA_TEMP_TABLES 13. If a redo log member becomes unavailable on the database,
A. The instance will fail. B. The instance will continue to run, but media recovery is needed. C. The database will continue to remain open, but instance recovery is needed. D. The system will continue to function as normal. 14. A read-consistent view of database data is
A. When data changes only when being read B. Handled by rollback segments C. When users execute the same query consistently D. Not available in Oracle
Chapter 8 Self Test
1. Which of the following statements are not true about primary keys?
A. A primary key cannot be NULL. B. Each column value in a primary key must be unique. C. Each column value in a primary key corresponds to a primary-key value in another table. D. A primary key identifies the uniqueness of that row in the table. E. An associated index is created with a primary key. 2. Clustering tables is appropriate when
A. The tables in the cluster are frequently joined B. The tables in the cluster are frequently updated C. The tables in the cluster have fewer than 60 rows D. The tables in the cluster have no primary key 3. The POSITION column in DBA_CONS_COLUMNS
A. Indicates the position of the constraint on disk B. Relates to the hierarchical position of the table in the data model C. Improves the scalability of the Oracle database D. Identifies the position of the column in a composite index 4. Available space for row entries in a data block is determined by
A. DB_BLOCK_SIZE + header size - pctfree B. DB_BLOCK_SIZE - header size - pctfree C. DB_BLOCK_SIZE + header size - pctused D. DB_BLOCK_SIZE - header size - pctused 5. Indexes improve database performance only when used as part of SELECT statements.
A. TRUE B. FALSE 6. Rollback segment shrinks can be avoided if
A. The optimal option is decreased. B. The DBA manually performs all rollback segment shrinks. C. Long-running transactions are assigned to larger rollback segments. D. V$ROLLSTAT is monitored carefully. 7. How many rollback segments will be required if the value set for TRANSACTIONS is 300 and the value set for TRANSACTIONS_PER_ROLLBACK_SEGMENT is 4?
A. 25 B. 50 C. 75 D. 100 8. When a rollback segment is created, its availability status is set to online.
A. TRUE B. FALSE 9. Which of the following are components of a data block? (Choose two.)
A. Library cache B. Row cache C. Row directory D. Fixed header E. pctincrease 10. Which of the following constraints has an index associated with it? (Choose two.)
A. Primary key B. Foreign key C. Unique D. NOT NULL E. Check 11. All data integrity needs are handled by using declarative integrity constraints.
A. TRUE B. FALSE 12. A low PCTUSED
A. Decreases performance on the database by requiring short, frequent placement of the blocks on a freelist B. Increases storage costs on the database by placing a block on the freelist only when a great deal of block space is free C. Decreases storage costs on the database by maximizing space usage in a data block D. Increases performance on the database by forcing Oracle to populate the block with rows frequently 13. Entries in a rollback segment are bound to a transaction by
A. Number of commits performed B. Number of rollbacks performed C. ROWID D. System change number 14. Hash functions
A. Are defined by Oracle only B. Are defined by the user only C. Can be defined by both Oracle and the user D. None of the above
Chapter 9 Self Test
1. If the DBA wishes to use resource costs to limit resource usage, the first thing she must do is
A. Change the value of RESOURCE_LIMIT to TRUE. B. Change the value of composite_limit in the user profile to zero. C. Change the value of composite_limit in the DEFAULT profile to zero. D. Change the value of the resource costs for the resources to be limited. 2. When revoking the REFERENCES privilege, the DBA must use which option to ensure success?
A. with admin option B. with grant option C. cascade constraints D. trailing nullcols 3. Which line of the following statement will produce an error?
A. CREATE USER ops$ellison B. IDENTIFIED EXTERNALLY C. DEFAULT TABLESPACE users_01 D. IDLE_TIME = 3 E. DEFAULT ROLE connect; F. There are no errors in this statement. 4. Audit trail information is stored in
A. SYS.SOURCE$ B. SYS.AUD$ C. DBA_SOURCE D. DBA_AUDIT_TRAIL 5. Which of the following views contain data necessary to kill a user session?
A. V$SYSSTAT B. V$ROLLSTAT C. V$QUEUE D. V$SESSION 6. The creator of a role is granted the use of the role WITH ADMIN OPTION.
A. TRUE B. FALSE 7. To find out how many database objects a user has created, the DBA can query which dictionary view?
A. DBA_USERS B. DBA_OBJECTS C. DBA_TS_QUOTAS D. DBA_TAB_PRIVS 8. On database creation, the value of the CONNECT_TIME parameter in the DEFAULT profile is
A. 1 B. 10 C. 300 D. unlimited E. None, the DEFAULT profile hasn't been created yet. 9. A user can change which of the following parameters with an ALTER USER statement?
A. identified by B. default tablespace C. temporary tablespace D. quota on E. profile F. default role 10. A resource cost is
A. A monetary cost for using a database resource B. A monetary cost for using a privilege C. An integer value representing the importance of the resource D. An integer value representing the dollar cost for using the resource 11. The database will not continue to allow users to access the database when
A. The database is up and running B. The AUD$ table has been filled and session is being audited. C. Restricted session has been disabled. D. Operating system authentication is being used. 12. When auditing instance startup, the audit records are placed in
A. SYS.AUD$ B. DBA_AUDIT_TRAIL C. ARCHIVE_DUMP_DEST D. AUDIT_TRAIL_DEST 13. A high resource cost indicates
A. A less expensive resource B. A lower amount of resource used per minute C. A more expensive resource D. A higher amount of resource used per minute 14. Privileges granted with the GRANT OPTION cannot be given to other users.
A. TRUE B. FALSE
Chapter 10 Self Test
1. SQL*Loader execution parameters can be located in which of the following locations? (Choose three)
A. Datafile B. Control file C. Command line D. Discard file E. Parameter file 2. Which of the following will improve performance on a data load?
A. Creating triggers before the load B. Enabling primary-key constraints before the load C. Specifying DIRECT=TRUE in the control file D. Running the load across a database link 3. A table index should be rebuilt after running a conventional path data load.
A. TRUE B. FALSE 4. After running SQL*Loader with the conventional path, which file contains records that could not be loaded due to violating integrity constraints?
A. The parameter file B. The bad file C. The discard file D. The log file 5. Indexes left in the direct path state after a data load must be rebuilt.
A. TRUE B. FALSE 6. In which of the following operations does the direct path load use the SGA?
A. Obtaining data blocks for writes B. Adjusting the highwatermark C. Updating the indexes D. Verifying integrity constraints 7. SQL*Loader can update existing rows of data in a table.
A. TRUE B. FALSE 8. If a discard file is produced by SQL*Loader, in what format will the data in the file be?
A. Fixed width B. Variable width C. Comma delimited D. The same as in the input file