单项选择题
You are working on the APPDB database as a DB A. The database has a default Flashback Data Archive DFLA1 created on it. You issued the following command to drop the Flashback Archive FLA1：
DROP FLASHBACK ARCHIVE fla1；
What is the effect of this command？（）
A. The Flashback Archive FLA1 is dropped only if it is empty.
B. The tablespace having Flashback Archive is dropped.
C. The Flashback Archive FLA1 is dropped after moving the existing data in it to the default Flashback Archive.
D. The Flashback Data Archive and historical data are dropped.
相关考题
-
单项选择题
Your company wants to upgrade the current production database to the RAC environment. To perform testing before migrating to the RAC environment， you performed the workload capture on the production database to record the peak workload. You set up the test RAC databaseand want to replay the recorded workload on the testmachine. Note the following steps that you may require to replay the database workload： 1） Preprocess the captured workload. 2） Restart the database in RESTRICTED mode. 3） Set up the Replay Clients. 4） Restore the test database to the point when the capture started. 5） Remap connections. Arrange the steps required in the correct sequence to accomplish this task on the test machine.（）
A. 1，4，5，3 （2 is not required.）
B. 1，4，3，5 （2 is not required.）
C. 1，2，4，5 （3 is not required.）
D. 2，1，5，3，4
E. 1，2，4，5，3 -
单项选择题
You issued the following command to mount the DATA disk group in restricted mode： ALTER DISKGROUP data MOUNT RESTRICT； What is the implication of this command？（）
A. The client RDBMS instance can access the file as a read-only file.
B. A new disk cannot be added to a disk group.
C. A disk in a disk group can be taken offline.
D. The client RDBMS instance cannot access the files in the disk group. -
单项选择题
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.
