单项选择题
A. ALTER DATABASE DROP LOGFILE GROUP 1;
B.ALTER DATABASE CLEAR LOGFILE GROUP 1;
C. ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 1;
D. ALTER DATABASE DROP LOGFILE MEMBER 'D:\REDO01.LOG';
单项选择题 You plan to have a larger moving window size for the default system-defined moving window baseline because you want to use the adaptive threshold. Which statement factors in this consideration while increasing the size of the moving window?()
多项选择题 While deploying a new application module, the software vendor ships the application software along with appropriate SQL plan baselines for the new SQLs being introduced. Which two statements describe the consequences?()
单项选择题 The following databases are registered in the base recovery catalog: PROD1, PROD2, and PROD3. The database user CATOWNER owns the base recovery catalog. You want a new user VPC1 to have access to only the PROD1 database and create a virtual private catalog. Given below are some of the commands required to achieve this: 1.SQL> GRANT recovery_catalog_owner TO vpc1; 2.RMAN> CONNECT CATALOG vpc1/password@catdb; 3.RMAN> GRANT CATALOG FOR DATABASE prod1 TO vpc1; 4.RMAN> CONNECT CATALOG catowner/password@catdb; 5.RMAN> CREATE VIRTUAL CATALOG; What is the correct sequence in which the commands have to be executed?()