单选题A table was just created on your Oracle database with six extents allocated to it. Which of the following factors most likely caused the table to have so many extents allocated?（）A The value for MINEXTENTS setting B The value for PCTINCREASE setting C

第1题：

You examine the output of SHOW GLOBAL STATUS and notice that the value of Created_tmp_disk_tables is consistently increasing. Which two variables would likely fix this issue?（）

• A、Table_open_cache
• B、Table_open_cache_instancs
• C、Table_definition_cache
• D、Tmp_table_size
• E、Max_heap_table_size
• F、Max_tmp_tables

第2题：

You are creating the CUST_PREMIUM data block in the AUTO_INSURANCE form. A new state law requires that premiums be lowered for drivers with a good driving history. Because this could potentially affect a large number of records, you want to base the data block on a stored procedure returning a table of records. Which statement supports this approach?（）

• A、A table of records is efficient in terms of network traffic. 
• B、A table of records improves developer productivity because the database administrator does not have to create a server side view. 
• C、A table of records is efficient because the number of records fetched depends on the Array Fetch property value.
• D、Your coding effort is simplified since DML operations are handles by setting form module properties.

第3题：

You issued the following statement in your SQL*Plus session：   SQL>ALTER SESSION ENABLE RESUMABLE TIMEOUT 600；   Which operation is neither suspended nor resumed using the Automatic Resumable Allocation feature in your database？（）

• A、 creating a table in your schema and you exceed your allocated space quota on the tablespace
• B、 executing a long query that involves a sort operation and the statement runs out of temporary space
• C、 loading data into tables by using the SQL*Loader and the number of extents in the table reaches the maximum limit
• D、 creating a table in a dictionary-managed tablespace with an explicit MAXEXTENTS setting which results in an out of space error

第4题：

A table was just created on your Oracle database with six extents allocated to it. Which of the following factors most likely caused the table to have so many extents allocated?（）

• A、The value for MINEXTENTS setting 
• B、The value for PCTINCREASE setting 
• C、The value for MAXEXTENTS setting 
• D、By default, Oracle allocates six extents to all database objects

第5题：

While creating a database using Database Configuration Assistant tool， you created a database default temporary tablespace. Which activity would cause the default temporary tablespace of the database to be used？（）

• A、the CREATE TABLE .. command
• B、sorting of the SYSTEM tablespace’s data
• C、sorting of data required by recursive SQL statements
• D、the CREATE TABLE .. ORGANIZATION EXTERNAL .. command
• E、sorting of data if the users have not been allocated temporary tablespace explicitly
• F、sorting of data if the users have been allocated temporary tablespace explicitly

第6题：

You are using Oracle Enterprise Manager to estimate the size of a table to be created. You have typed data regarding the column names， data types， sizes of the columns， and the projected number of rows in the table. Which additional information does the Oracle Enterprise Manager return？（）

• A、 space allocated in the tablespace
• B、 space required for the bitmap index on a column of the table
• C、 space remaining in the tablespace after creating the table
• D、 estimated value of the PCTFREE storage parameter

第7题：

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

You work as a database administrator for Certkiller .com. In your transaction application， you have scheduled a job to update the optimizer statistics at05：00 pm every Friday. The job has successfully completed. Which three pieces of information would you check to confirm that the statistics have been collected？（）

• A、Average row size
• B、Last analyzed date
• C、Size of table in bytes
• D、Size of table in database blocks
• E、Number of free blocks in the free list
• F、Number of extents present in the table.

第14题：

Your database is running under automatic undo management and the UNDO_RETENTION parameter is set to 900 sec. You executed the following command to enable retention guarantee：  SQL> ALTER TABLESPACE undotbs1 RETENTION GUARANTEE;  What effect would this statement have on the database？（）

• A、The extents in undo tablespace retain data until the next full database backup.
• B、The extents containing committed data in the undo tablespace are never overwritten.
• C、The extents which no longer contain uncommitted data in the undo tablespace are not overwritten for at least15 minutes.
• D、The extents containing committed data in the undo tablespace are not overwritten until the instance  is shut down.

第15题：

Two database users, Jack and Bill, are accessing the SupportCenter STAFF table of the SupportCenter DB database. When Jack modifies a value in the table, the new value is invisible to Bill. Which is the modified value invisible to Bill?（）

• A、The modified data are not available on disk.
• B、The modified data have been flushed out from memory.
• C、The modified rows of the SupportCenter STAFF table have been locked.
• D、Jack has not committed the changes after modifying the value.
• E、Both users are accessing the database from two different machines.

第16题：

In your database, the flash recovery area (FRA) is configured as the default for RMAN backups. You executed the following commands to configure the settings in RMAN: RMAN> CONFIGURE DEVICE TYPE disk PARALLELISM 2 BACKUP TYPE TO BACKUPSET; RMAN> CONFIGURE CHANNEL 1 DEVICE TYPE disk FORMAT '/home/oracle/disk1/%U'; RMAN> CONFIGURE CHANNEL 2 DEVICE TYPE disk FORMAT '/home/oracle/disk2/%U'; You issue the following RMAN command to backup the database: RMAN> RUN 2> { 3> ALLOCATE CHANNEL ch1 DEVICE TYPE disk; 4> BACKUP DATABASE; 5> } Which statement is true about the outcome?（）

• A、Only one channel is allocated and the backup is created in the flash recovery area
• B、Only one channel is allocated and the backup is created in the destination specified for channel 1
• C、Two channels are allocated and backup sets are created in the destinations specified for channels 1 and 2
• D、Three channels are allocated and backup sets are created in the destinations specified for channels 1, 2, and FRA

第17题：

In Oracle 11g，by default which one of the following conditions implicitly enables Automatic PGA Memory Management？（）  

• A、 Setting a nonzero value for SGA_TARGET
• B、 Configuring Automatic Shared Memory Management
• C、 Configuring Automatic Memory Management
• D、 Setting a nonzero value for SGA_MAX_SIZE and PGA_AGGREGATE_TARGET
• E、 None of the above

第18题：

In your Oracle 10g database ， you have scheduled a job to update the optimizer statistics at 05：00 pm every Friday. The job has successfully completed. Which three pieces of information would you check to confirm that the statistics have been collected？（）

• A、average row size
• B、last analyzed date
• C、size of table in bytes
• D、size of table in database blocks
• E、number of free blocks in the free list
• F、number of extents present in the table

第19题：

第20题：

第21题：

第22题：

第23题：

第24题：