A. a job B. a program C. a schedule D. a PL/SQL procedure
Your database is in ARCHIVELOG mode. You have two online redo log groups, each of which contains one redo member. When you attempt to start the database, you receive the following errors: Which statement should you use to resolve this issue?()
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';
A. The collection level for the AWR should be set to BASIC B. The moving window size must be less than Undo Retention C. The moving window size should be greater than the Automatic Workload Repository (AWR) retention period D. The moving window size should be equal to or less than the Automatic Workload Repository (AWR) retention period