Self Test #5: Oracle8 Features for Administrators (Chapters 21-25)
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 21 Self Test
1. The SALES table is partitioned by month according to the date the sales order was taken. One of the salespeople enters a sales order dated July 31, then realizes he took the order on August 1. When he issues the UPDATE statement to modify the data, what happens?
A. The update fails because the partition-key column can never be updated. B. The update fails because a partition-key column cannot be updated such that the row must move partitions. C. The update fails because a NULL value was specified for the primary key. D. The update succeeds. 2. The most likely cause for a local index partition to be in the INDEX UNUSABLE state is
A. A user deleted one row from the table partition. B. The DBA issued an alter table add partition statement. C. The DBA issued an alter index rebuild partition statement. D. The DBA issued an alter table truncate partition statement. 3. Which of the following operations should the DBA execute to load data into ten partitions of a table simultaneously?
A. Execute SQL*Loader ten times in parallel. B. Execute SQL*Loader once with the parameter DEGREE=10. C. Execute SQL*Loader once with the parameter PARALLEL=TRUE. D. Execute SQL*Loader five times with the parameter INSTANCES=2. 4. The DBA creates a table called EXPENSES whose partition key is the EXPENSE_DATE column. The partitions are called EXP_JUNE, EXP_JULY, EXP_AUGUST, and EXP_SEPTEMBER. She drops the first partition, covering the month of June. Later, a user adds a row to the table with the EXPENSE_DATE column equal to '15-JUN-1999'. To which partition is the row added?
A. JULY. B. AUGUST. C. SEPTEMBER. D. None, the partition-key value is out of range. 5. Which of the following is not a benefit of partitioning?
A. Partition independence B. Greater data availability C. Inability to access one partition when another is unavailable D. Scaleable performance with data growth 6. When the DBA declares a global index with partitions identical to the table, equipartitioning is enforced automatically by Oracle.
A. TRUE B. FALSE 7. Which of the following are not partitioned indexes available in Oracle? (Choose two)
A. Global prefixed indexes B. Global nonprefixed indexes C. Local prefixed indexes D. Global equipartitioned indexes 8. The EXPENSES table uses a partition key called EXPENSE_DATE of datatype DATE, representing the date the sale was entered. The DBA splits the EXP_JULY partition of the SALES table into two partitions, EXP_JULY1-15 and EXP_JULY16-31. All rows in the EXP_JULY partition have a value greater than July 17 for the partition key. Which of the following statements is TRUE regarding the local prefixed indexes produced by the table partition split?
A. EXP_JULY1-15 will be unusable, but EXP_JULY16-31 will be valid. B. Both EXP_JULY1-15 and EXP_JULY16-31 will be valid. C. Both EXP_JULY1-15 and EXP_JULY16-31 will be unusable. D. EXP_JULY1-15 will be valid, but EXP_JULY16-31 will be unusable. 9. The DBA wants to eliminate partition X1 from table EMPLOYEES. If partition X1 contains 65 percent of the rows for the table and there are global indexes on the table, what is the fastest way for the DBA to eliminate partition X1 and make the global indexes available for use again?
A. Merge the partition, rebuild the index. B. Drop the partition, rebuild the index. C. Delete all rows from the partition, drop the partition, rebuild the index. D. Split the partition, Drop the partition, rebuild the index. 10. When a table partition is truncated, only the associated partition in the global index becomes INDEX UNUSABLE.
A. TRUE B. FALSE 11. Which statement can be used to place partition X1 on table EXPENSES from tablespace DATA_01 to tablespace DATA_05?
A. alter table EXPENSES modify partition X1 from DATA_01 to DATA_05; B. alter table EXPENSES rename partition X1 to DATA_05; C. alter table EXPENSES move partition X1 tablespace DATA_05; D. alter table EXPENSES drop partition X1 into DATA_05; 12. When the DBA executes the ALTER TABLE EXCHANGE PARTITION statement, data in the partition is physically moved into another table.
A. TRUE B. FALSE 13. If the DBA wants to determine the partition key for a table, she can use which of the following dictionary views?
A. DBA_PART_TABLES B. DBA_TAB_HISTOGRAMS C. DBA_TAB_COLUMNS D. DBA_TAB_COL_STATISTICS
Chapter 22 Self Test
1. During normal database operation, the DBA notices that session information for shared servers crowds out shared SQL parse information in the shared pool. To combat this situation, the DBA can use which of the following methods?
A. Increase value set for DB_BLOCK_BUFFERS B. Use dedicated servers C. Increase value set for DB_BLOCK_SIZE D. Increase value set for LARGE_POOL_SIZE 2. The best choice for decreasing size requirements for tables that need only be accessed via the primary key is
A. Create more indexes on the table B. Create an index-organized table to store the data C. Drop the primary key D. Increase the pctfree value set for table blocks 3. Which of the following statements do NOT describe features of the VARRAY type? (Choose three)
A. VARRAY allows indexes on attributes. B. VARRAY limits the number of elements placed in the object. C. VARRAY stores data in extents separate from the main object. D. VARRAY stores all data over 4 kilobytes inline. 4. The DBA has an Oracle7 relational table with a column containing ROWID data. What step may be required when migrating this table to Oracle8?
A. Execute the rowid_to_extended( ) function on the data in the column. B. Execute the rowid_to_restricted( ) function on the data in the column. C. Execute the rowid_type( ) procedure on the data in the column. D. Nothing--Oracle8 converts the ROWID automatically. 5. The user attempts to INSERT data into a column that would violate a nondeferrable constraint. The user has issued the ALTER SESSION SET CONSTRAINTS=DEFERRED statement. What happens on INSERT?
A. The insert succeeds at the time it is issued, but the transaction will roll back later. B. The insert fails at the time it is issued and the transaction will end. C. The insert succeeds at the time it is issued and the transaction will not roll back later. D. The insert fails at the time it is issued, but the transaction will continue. 6. The value stored in an index for a column is '596849'. The DBA then issues the ALTER INDEX REVERSE statement. What does the data in the index now look like?
A. '596849' B. '849596' C. '948695' D. '695948' 7. The DBA needs to find information about how EXTPROC is being called. To find out more information, the DBA may want to look in which file?
A. init.ora B. config.ora C. orapwsid.ora D. listener.ora 8. The datafile information stored in Oracle8's extended ROWID format details the absolute datafile location for that row of data.
A. TRUE B. FALSE 9. Which prefix must be used when referencing values stored in columns defined with the NVARCHAR2 datatype?
A. V B. N C. C D. P 10. The DBA executes the CREATE OR REPLACE LIBRARY QUICKSORT AS '/DISK01/USR/BIN/QSORT'; but the directory named is invalid. When will an error be produced?
A. At the time the library is created B. At the time the library is dropped C. At the time a PL/SQL procedure calls the library D. At the time the external procedure attempts a callback 11. The user attempts the following INSERT statement on the EMPLOYEES relational table defined with the address_type object type: INSERT INTO EMPLOYEES VALUES('30493','405 RIVER STREET','BARNES','OK','12345'). Which of the following reasons is most likely why the statement fails?
A. The address_type constructor was not used. B. The column values specified are out of order. C. The values keyword is incorrectly placed. D. Object data cannot be inserted into a relational table. 12. When an attribute of an object is defined with the REF type, what data is actually stored in the attribute?
A. The original data B. A copy of the data C. A pointer to the data D. A pointer to the copy of the data 13. A nested table is stored in the same segment as its parent data.
A. TRUE B. FALSE 14. The DBA chooses to allow the use of objects on relational tables in an Oracle8 database. To ease the migration effort, which of the following things might the DBA create?
A. Object views and instead of triggers B. Scalar types and index-organized tables C. Reverse-key indexes and table partitions D. None of the above
Chapter 23 Self Test
1. The DBA has run the START_TIME_MANAGER( ) process, but several the expiration features in queuing still don't work. Which of the following may solve the problem?
A. The DBMS_LOB package hasn't been created. B. The AQ_TM_PROCESSES initialization parameter hasn't been set. C. The DBA ran the grant_type_access( ) procedure. D. Queuing is not available in Oracle8. 2. To execute parallel DML on the Oracle database, the DBA must
A. Specify parallel clauses in the create table statement B. Execute the alter table name nologging statement C. Execute the alter session enable parallel DML statement D. Commit the transaction 3. An UPDATE statement on a partitioned table will parallelize by
A. Partitions B. ROWID ranges C. Slave I/O processes D. The /*+append */ hint 4. Which of the following can parallel DML not operate on? (Choose three.)
A. Partitioned tables B. Bitmap indexes C. Clustered tables D. Tables containing object types 5. Execution privileges on procedures in the DBMS_AQ package are managed with the
A. AQ_USER_ROLE B. AQ_EXECUTE_ROLE C. AQ_ADMINISTRATOR_ROLE D. CREATE_QUEUE_TABLE( ) 6. The DBA creates a directory object specifying a pathname that doesn't currently exist on the filesystem. She should expect to receive an error when
A. The create or replace directory statement is executed B. The create or replace directory statement is committed C. The BFILE object is created D. The BFILE object is accessed 7. The number of blocks that comprise a chunk is defined by
A. The DB_CHUNK_SIZE initialization parameter B. The chunk clause used in LOB storage definition C. The create tablespace statement D. The create datafile statement 8. The two components of a large object are
A. Value and type B. Value and locator C. Type and locator D. Value and control 9. What parameter is used to carry a message into the queue with the ENQUEUE( ) procedure?
A. message B. msgid C. queue_data D. payload 10. Oracle can write data to a BFILE object.
A. TRUE B. FALSE 11. The DBA should not define a directory object on a directory in the filesystem containing which files?
A. Oracle datafiles B. Operating system utilities C. Word processing software D. Web pages 12. The DBA creates a table containing two LOB columns, a BLOB and a CLOB. What is the maximum number of tablespaces that contain data for this table?
A. 2 B. 3 C. 5 D. 7
Chapter 24 Self Test
1. The ALLOCATE CHANNEL command used in conjunction with COPY must
A. Name the resource explicitly B. Use the disk clause C. Use the for delete clause D. Be run after the copy is complete 2. Which of the following maintenance operations should the DBA run after adding a datafile?
A. Register database B. Reset database C. Catalog D. Resync catalog 3. A full backup consists of which of the following elements?
A. All blocks in a datafile B. Changed blocks in a datafile C. All datafiles in the database D. Changed datafiles in the database 4. In the absence of the recovery catalog, where can RMAN find most of the information it needs?
A. Backup sets B. Datafiles C. Password file D. Control file 5. The DBA issues the ALTER DATABASE BACKUP CONTROLFILE TO '/DISK1/Oracle/home/dbcontrol.ctl' statement. What can the DBA do to use this control file backup in conjunction with RMAN?
A. Issue the catalog command. B. Copy the file to tape. C. Issue the copy command. D. Nothing, the control file backup can be used as is. 6. What effect does setting CONTROL_FILE_RECORD_KEEP_TIME to 0 have?
A. Forces Oracle8 to keep no information for RMAN B. Decreases backup and recovery performance C. Limits growth of the control file size D. Has no effect on control file size 7. The DBA identifies that the backups necessary for media recovery are on tape. What command should she first execute to perform the recovery?
A. Copy B. Switch C. Allocate channel D. Restore 8. Once the DBA defines attributes in a RUN command, how long will they be defined?
A. Permanently B. For the duration of the instance C. For the duration of the session D. For the duration of the run command 9. By default, how many errors will occur in a RUN command before RMAN terminates?
A. 1 B. 5 C. 25 D. Operating-system specific 10. The DBA completes incomplete recovery to a system change number and then opens the database. What recovery catalog maintenance command must be executed?
A. Register database B. Reset database C. Resync catalog D. Change database 11. Which command can the DBA issue to determine which datafiles in the database are in the most serious need of backup?
A. Report unrecoverable B. Report need backup C. List incarnation D. List copy of datafile 12. Which of the following best describes multiplexing in backup sets?
A. One archive log in one backup set with file blocks stored contiguously B. Multiple control files in one backup set with file blocks for each stored noncontiguously C. Multiple datafiles in one backup set with file blocks for each stored noncontiguously D. One datafile in multiple backup sets with file blocks stored contiguously
Chapter 25 Self Test
1. After migrating to Oracle8, the DBA must perform which of the following tasks? (Choose three)
A. Run catalog.sql B. Issue alter database open resetlogs C. Back up the source database D. Install a new version of migrate.bsq E. Drop the MIGRATE user 2. The migration of the database to Oracle8 is about to begin. Which of the following is not a parameter to the migration utility?
A. CFILE B. PFILE C. LFILE D. DBNAME 3. The DBA would like to implement password management on the Oracle8 database. To set up default values for password management in the DEFAULT profile, the DBA must
A. Run the utlpwdmg.sql script B. Assign users to the DEFAULT profile C. Set RESOURCE_LIMIT to TRUE D. Start the Password Manager background process 4. Once created, a password verification function is owned by
A. The DBA B. The user executing it C. The MIGRATE user D. The SYS user 5. The DBA is implementing password management. When users unsuccessfully log into the database five times, Oracle should lock the account for eight hours, after which time Oracle will unlock the account automatically. Which of the following correctly identifies both the options that must be specified and the correct value for that option?
A. password_reuse_max 5, password_lockout 8 B. password_login_attempts 5, password_lock_time 8 C. failed_login_attempts 5, password_lock_time 1/3 D. failed_login_attempts 5, password_lock_time 8 6. The DBA is deciding how to configure the Oracle networking options for the Oracle8 database. The organization uses TCP/IP with domain name service implemented. The Net8 listener will redirect connect requests for only one server. Required security is implemented at the database level using roles. What network options should the DBA use?
A. Oracle Names server B. Native hostname adapter C. Oracle Security server D. Advanced Networking option 7. To diagnose problems with networking between client and server, the DBA can use which of the following methods?
A. Oracle Trace, stored external to Net8 B. Oracle Trace, stored within Net8 C. Net8 Open API, stored external to Net8 D. Net8 Open API, stored internal to Net8 8. If additional security options are not required and the DBA would like to increase performance of communication between client and server while bypassing layers of protocol within Net8 for networking, the DBA can configure Net8 to use
A. Connection pooling B. TNS raw transport C. Oracle Security server D. Oracle Names server 9. Which of the following are drawbacks of using EXPORT/IMPORT for migrating to Oracle8? (Choose two.)
A. Slow migration time B. Unable to perform backward migration C. Requires great deal of additional disk space D. Cannot perform database reorganization during migration 10. The DBA must execute several scripts after migrating to Oracle8. What is the function provided by executing the CAT8000.SQL script?
A. Creates dictionary views B. Creates ability to use PL/SQL C. Converts SYSTEM tables D. Drops MIGRATE user 11. The Oracle7 control file is compatible for use on an Oracle8 database.
A. TRUE B. FALSE 12. Which of the following choices best describes the Oracle8 grace period?
A. The time limit for upgrading the Oracle server license to Oracle8 B. The time during which the user may not reuse a password C. The length of time before a password expires D. The length of time a user has to change an expired password 13. Which of the following complexity checks does the VERIFY_PASSWORD( ) function not perform? (Choose three.)
A. Password is six alphanumeric or punctuation characters long, or more B. Password contains one letter C. Password contains one number D. Password contains one unprintable character E. Password contains one multibyte character