单项选择题
The ADMIN_EMP table has columns EMPNO， ENAME， DEPTNO， and SAL. It has a materialized view EMP_MV with a materialized log and an ENAME_IDX index on the ENAME column. You need to perform an online table redefinition on the ADMIN_EMP table to move it from the TBS1 tablespace to the TBS2 tablespace in the same schema.
What action is required for the dependent objects when you perform online redefinition on the table？（）
A. The materialized view should have a complete refresh performed after the online table redefinition is completed.
B. The materialized view should have a fast refresh performed after the online table redefinition is completed.
C. The materialized view，materialized log，and the index should be dropped and re-created after the online table redefinition is complete.
D. The materialized view and materialized log should be dropped and all constraints disabled and re-created after the online table redefinition is complete.
相关考题
-
单项选择题
You are managing an Oracle Database 11g database. You want to take a backup on tape drives of the USERS tablespace that has a single data file of 900 MB. You have tape drives of 300 MB each. To accomplish the backup， you issued the following RMAN command： RMAN>BACKUP SECTION SIZE 300M TABLESPACE users； What configuration should be effected to accomplish faster and optimized backups by using the above command？（）
A. The SBT channel must be configured， with the default parallelism setting for the SBT device set to 1
B. The COMPATIBLE initialization parameter for the database instance must be set to at least 10.0
C. The SBT channel must be configured， with the parallelism setting for the SBT device set to 3
D. The SBT channel must be configured， with the MAXPIECESIZE set to 300 MB -
多项选择题
YouperformedtheRMANdatabasebackupwiththeKEEPoption.Whichtwostatementsaretrueregardingthisbackup？（）
A. The backup contains data files， the server parameter file，and the control file even if the control file autobackup is disabled.
B. The KEEP option overrides the configured retention policy.
C. The backup contains only data files and archived redo log files.
D. The KEEP option is an attribute of an individual backup piece. -
单项选择题
You are managing an Oracle Database 11g database. You want to take the backup of MULT_DATA， a big file tablespace of size 100 TB on tape drive， but you have tapedrives of only 10 GB each. Which method would accomplish the task quickly and efficiently？（）
A. parallel image copy backup
B. backup with MAXPIECESIZE configured for the channel
C. parallel backup with MAXPIECESIZE configured for the channe
D. intrafile parallel backup
