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：（）
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’
您可能感兴趣的试卷
你可能感兴趣的试题
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？（）
A. The plan baselines can be evolved over time to produce better performance.
B. The newly generated plans are directly placed into the SQL plan baseline without being verified.
C. The new SQL statements initially run with the plans that are known to produce good performance under standard test configuration.
D. The optimizer does not generate new plans for the SQL statements for which the SQL plan baseline has been imported.
最新试题
Tape streaming is not happening while performing RMAN tape backup. On investigation， you find that it is not because of the incremental backup or the empty file backup and that RMAN is sending data blocks to the tape drive fast enough. What could be a solution to make tape streaming happen during the backup？（）
Your database instance is running. You are not able to access Oracle Enterprise Manager Database Control because the listener is not started. Which tool or utility would you use to start the listener？（）
You want to take a complete database backup using RMAN. The backup should consist onlythe used blocks from your database. Which two statements are true about this backup operation？（）
In your production database， users report that they are unable to generate reports on an important table because it does not contain any data. While investigating the reason， you realize that another user executed the TRUNCATE TABLE command， which accidentally caused the data to be lost. Now you want to recover the lost data of the table without affecting objects in other schemas. Which method must you use to recover the lost data？（）
Which two commands never trigger an implicit rebalancing within the disk group？（）
View the Exhibit and examine the output. You execute the following RMAN command to perform the backup operation： RMAN> RUN { ALLOCATE CHANNEL c1 DEVICE TYPE disk MAXOPENFILES 8； BACKUP DATABASE FILESPERSET 4； } What is the multiplexing level in the preceding backup process？（）
Examine the CREATE DISKGROUP command used to create a disk group： SQL> CREATE DISKGROUP misc EXTERNAL REDUNDANCY DISK ’ORCL： FRA3’ NAME misc1， ’ORCL： FRA4’ NAME misc2； In which situation would you use this method of disk group creation？（）
Which three functions are performed by the SQL Tuning Advisor？（）
View the Exhibit and examine the disk groups created at the time of migrating the database storage to Automatic Storage Management （ASM）. Why does the FRA disk group initially have more free space even though both DATA and FRA disk groups are provided with the same size？（）
Examine the following RMAN command： RMAN> CONFIGURE ENCRYPTION FOR DATABASE ON； RMAN> BACKUP DATABASE PLUS ARCHIVELOG； Which prerequisite must be met before accomplishing the backup？（）