单项选择题
You have a range-partitioned table in your database. Each partition in the table contains the sales data for a quarter.
The partition related to the current quarter is modified frequently and other partitions undergo fewer data manipulations. The preferences for the table are set to their default values. You collect statistics for the table using the following command in regular intervals： SQL> EXECUTE
DBMS_STATS.GATHER_TABLE_STATS（’SH’，’SALES’，GRANULARITY=>’GLOBAL’）；
You need statistics to be collected more quickly.
What can you do to achieve this？（）
A. Set DYNAMIC_SAMPLING to level 4
B. Set the STATISTICS_LEVEL parameter to BASIC
C. Set the INCREMENTAL value to TRUE for the partition table
D. Increase the value of STALE_PERCENT for the partition table
相关考题
-
多项选择题
ou are using the flash recovery area （fast recovery area in 11g Release 2） to store backup related files in your database. After regular monitoring of space usage in the Mash recovery area. You realize that the flash recovery area is （jetting filled up very fast and it is running out of space. Your database flash recovery area is low on specie and you have no more room on disk. Proactively， which two options could you use to make more space available in the flash recovery（）
A. Change the RMAN archived log deletion policy.
B. Use the RMAN CROSSCHECK command to reclaim the archived log space.
C. Change the RMAN retention policy to retain backups for a shorter period of time.
D. Use OS command to move files from the flash recovery area to some other location. -
多项选择题
You are working on a CATDB database that contains an Oracle Database version 11.1 catalog schema owned by the user RCO11. The INST1 database contains an Oracle Database version 10.1 catalog schema owned by the user RCAT10. You want the RMAN to import metadata for database IDs 1423241 and 1423242， registered in RCAT10， into the recovery catalog owned by RCO11. You executed the following commands： RMAN> CONNECT CATALOG rco11/password@catdb RMAN> IMPORT CATALOG rcat10/oracle@inst1 NO UNREGISTER； Which two statements are true regarding the tasks accomplished with these commands？（）
A. They import all metadata from the RCAT10 catalog.
B. They unregister the database from the RCAT10 catalog.
C. They do not register the databases registered in the RCAT10 catalog.
D. They register all databases registered in the RCAT10 catalog. -
单项选择题
YouenabledFlashbackDataArchiveontheINVENTORYtable.WhichDDLoperationissupportedonthetableafterenablingFlashbackDataArchive？（）
A. Drop the table.
B. Partition the table.
C. Truncate the table.
D. Add a column to the table.
E. Rename a column in the table.
