多項選擇題

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 the RMAN. To accomplish the backup， you issued the following RMAN command：
RMAN> BACKUP SECTION SIZE 300M TABLESPACE users；
Which two statements are true regarding the execution of the above command？（）

A. The RMAN parallelizes the backup although the parallelism is not set for a channel.
B. The backup piece size will be limited to 300 MB.
C. The operation is accomplished using the default channel available.
D. Three channels for the tape drive must be configured by setting the parallelism to three.

你可能感興趣的試題

單項選擇題

You need to perform an online table redefinition of an existing SALES table to partition it into two tablespaces TBS1 and TBS2. The SALES table has a materialized view， materialized log， indexes， referential integrity constraint， and triggers with the PRECEDES clause existing on it.
What action is required for dependent objects when you perform online table redefinition？（）

A. The dependent materialized view should have a complete refresh performed after the online table redefinition process.
B. Triggers with the PRECEDES clause should be disabled before the online table redefinition process.
C. Referential integrity constraints must be manually enabled after the online table redefinition process.
D. The materialized log should be dropped before the online table redefinition process.

單項選擇題

In your database， the RESULT_CACHE_MODE parameter has been set to MANUAL in the initialization parameter file. You issued the following command：
SQL>SELECT /+ RESULT_CACHE / sale_category， sum（sale_amt） FROM sales
GROUP BY sale_category；
Where would the result of this query be stored（）？

A. database buffer cache
B. shared pool
C. PGA
D. large pool

无码高清视频|成人自拍视频|欧美成人午夜无码A片秀色直播|草美女视频网站|美女被操网站在线观看

你可能感興趣的試題