多项选择题
Which two statements are correct about database transportation？（）
A. The source and target platforms must be the same
B. Redo logs，control files and temp files are also transported
C. The transported database must have the same database identifier （DBID） as the source database and cannot be changed
D. The COMPATIBLE parameter must be set to 10.0.0.0 or higher and the database must be opened in readonly mode before being transported
E. Recovery Manager （RMAN） is used to convert the necessary data files of the database if the target platform is different and has different endian format
相关考题
-
多项选择题
Whichtwostatementsaretruewithrespecttothemaintenancewindow？（）.
A. A DBA can enable or disable an individual task in all maintenance windows.
B. A DBA cannot change the duration of the maintenance window after it is created.
C. In case of a long maintenance window，all Automated Maintenance Tasks are restarted every four hours.
D. A DBA can control the percentage of the resource allocated to the Automated Maintenance Tasks in each window -
单项选择题
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.
