You want the size of the tablespace to increase when it is f

第1题：

Users are performing a large volume of inserts and deletes on the application tables in the APPS tablespace. You observe that there are several warning alerts being generated for the APPS tablespace space usage metrics. Currently， the warning threshold for the tablespace space usage metrics is set to 70%.  To make the generated alerts more useful as a problem identification tool， you want to reduce the frequency of alert generation for the tablespace space usage metrics for the APPS tablespace. What should you do？（）

• A、disable SQL tracing for theAPPS tablespace
• B、disable logging attribute for the APPS tablespace
• C、modify the tablespace to be a dictionary­managed tablespace
• D、increase the critical threshold value for the tablespace space usage metrics for the APPS tablespace
• E、increase the warning threshold value for the tablespace space usage metrics for the APPS tablespace

第2题：

You want to take the backup of the USERS tablespace. It has a single data file of 900 MB. You have tape drives of 300 MB each. The SBT channel is configured for Recovery Manager (RMAN). To accomplish the backup, you issued the following RMAN command: RMAN> BACKUP SECTION SIZE 300M TABLESPACE users; Which two statements are true about the execution of the above command? （）(Choose two.)

• A、The backup piece size will be limited to 300 MB
• B、The RMAN uses multiplexing to perform backup
• C、The operation is accomplished using the default channel available
• D、The RMAN parallelizes the backup although the parallelism is not set for a channel

第3题：

In which situation is the UNDO_RETENTION parameter be ignored， even if it is set to a value（）

• A、When the data file of the undo tablespace is autoextensible
• B、When there are more than one undo tablespaces available in the database
• C、When the undo tablespace is of a fixed size and retention guarantee is not enabled
• D、When the undo tablespace is autoextensible and retention guarantee is not enabled

第4题：

You have created a locally managed tablespace by issuing the following command：        CREATE TABLESPACE data1   DATAFILE ’data1_file1.dbf’ SIZE 10M AUTOEXTEND ON MAXSIZE        UNLIMITED；   For the DATA1 tablespace， you have set the warning level alert limit to 70 percent.  In which situation will a warning level alert be generated？（）  

• A、 when 700 KB is used
• B、 when 700 KB is left as free space
• C、 when 7MB is used
• D、 when 7MB is left as free space
• E、 no alert will be generated because an autoextensible datafile is included in the tablespace

第5题：

In which situation may the UNDO_RETENTION parameter be ignored， even if it is set to a value（）

• A、when the data file of the undo tablespace is autoextensible
• B、when there are more than one undo tablespaces available in the database
• C、when the undo tablespace is of a fixed size and retention guarantee is not enabled
• D、when the undo tablespace is autoextensible and retention guarantee is not enabled

第6题：

Your database instance is running with full workload after database creation. You have decided to use a fixed-size undo tablespace. You want to use the Undo Advisor to estimate the capacity of the undo tablespace. Which two factors must you consider before using the Undo Advisor to estimate the capacity of the undotablespace（）

• A、The retention period to support flashback
• B、The expected length of the longest-running query
• C、The number of undo tablespaces in the database
• D、The size of the Flash Recovery Area for the database instance

第7题：

Users in your PROD database complain about the slow response of the transactions. While investigating the reason， you find that the transactions are waiting for the undo segments to be available， and undo retention has been set to zero. What would you do to overcome this problem？（）

• A、increase the undo retention
• B、create more undo segments
• C、create another undo tablespace
• D、increase the size of the undo tablespace

第8题：

You want the size of the tablespace to increase when it is full. Which option would you use？（）

• A、use automatic extent allocation
• B、disable threshold for the tablespace
• C、use freelists to manage the free space
• D、use automatic segment space management
• E、create the tablespace as a bigfile tablespace
• F、use the RESIZE clause while creating the tablespace
• G、enable AUTOEXTEND for at least one of the data files in the tablespace

第9题：

A user receives the following error while executing a query： ORA/x7f01555：snapshot too old Which two options can be the solutions to avoid such errors in future？（）

• A、increase the size of redo log files
• B、increase the size of the undo tablespace
• C、increase the size of the Database Buffer Cache
• D、increase the size of the default temporary tablespace
• E、enable the retention guarantee for the undo tablespace

第10题：

You want to create a consumer group， GROUP1， and you execute the following command in the command/x7fline interface：  SQL> EXEC DBMS_RESOURCE_MANAGER.CREATE_CONSUMER_GROUP  （CONSUMER_GROUP =>’group1’， COMMENT => ’New Group’）;  This command errors out displaying the following message：  ERROR at line 1：  ORA/x7f29371： pending area is not active  ORA/x7f06512： at "SYS.DBMS_RMIN"， line 115  ORA/x7f06512： at "SYS.DBMS_RESOURCE_MANAGER"， line 108  ORA/x7f06512： at line 1  What action would you take to overcome this error？（）

• A、create the Pending Area before creating the consumer group
• B、activate the Pending Area before creating the consumer group
• C、increase the size of the large pool to accommodate the Pending Area
• D、increase the size of the shared pool to accommodate the Pending Area
• E、increase the size of the database buffer cache to accommodate the Pending Area