The database is running in the ARCHIVELOG mode. It has three redo log groups with one member each.One of the redo log groups has become corrupted. You have issued the following command during the recovery of a damaged redo log file: ALTER DATABASE CLEAR

题目

The database is running in the ARCHIVELOG mode. It has three redo log groups with one member each.One of the redo log groups has become corrupted. You have issued the following command during the recovery of a damaged redo log file: ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 3; Which action should you perform immediately after using this command?（）

A、You should perform a log switch
B、You should make a backup of the database
C、You should switch the database to the NONARCHIVELOG mode
D、You should shut down the database instance and perform a complete database recovery

如果没有搜索结果或未解决您的问题，请直接联系老师获取答案。

相似问题和答案

第1题：

Which WebSphere Commerce features require the Scheduler component to be running？（）

A、Auctions
B、Database replication
C、E-mail notifications
D、Discounts
E、Marketing campaigns

正确答案:A,C

第2题：

While an electrician was adding additional circuits for the Data Center， the system running the Database inadvertently powered down. The fallover of the service IP labels and volume groups to the hot standby node completed as expected； however， the database did not start. The database log file indicated that the database was already started. What is the most likely cause of this problem？（）

A、 The shared logical volumes and filesystems did not have database permissions.
B、 There was a test instance running on the standby system that must be shutdown.
C、 The tablespaces had an indicator indicating that the database had not shutdown properly.
D、 The startup script for the highly available instance did not first perform cleanup operations.

正确答案:D

第3题：

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?()

A. Oracle Net Manager

B. Listener Control utility

C. Database Configuration Assistant

D. Oracle Net Configuration Assistant

参考答案：B

第4题：

You are managing an Oracle Database 11g database. The database is open， and you plan to perform Recovery Manager （RMAN） backups. Which three statements are true about these backups（）

A、The backups would be consistent.
B、The backups would be inconsistent.
C、The backups would be possible only if the database is running in ARCHIVELOG mode.
D、The backups would be possible only if the database is running in NOARCHIVELOG mode.
E、The backups need to be restored and the database has to be recovered in case of a media failure

正确答案:B,C,E

第5题：

In order to perform Flashback Transaction Query operations， which of these steps are required？（）

A、 Ensure that database is running with version 10.1 compatibility.
B、 Enable Flashback Logging.
C、 Enable Supplemental Logging.
D、 Ensure that the database is running with version 10.0 compatibility.
E、 Ensure that the database is in ARCHIVELOG mode.

正确答案:C,D

第6题：

Your database instance is running with full workload after database creation. You have decided to useafixed-sizeundo tablespace. You want to use the Undo Advisor to estimate the capacity of the undotablespace. Which two factors must you consider before using the Undo Advisor to estimate the capacity of the undotablespace（）

A、the retention period to support flashback
B、the expected length of the longest-running query
C、the number of undo tablespaces in the database
D、the size of the Flash Recovery Area for the database instance

正确答案:A,B

第7题：

A customer with a small IT budget has one data center. Their main application is a database running on an IBM System Storage DS8000. The database has a data change rate of 50% per day. Once a week， they must do a point-in-time backup from the database to tape. The time it takes to run the backup now exceeds the backup window allowed. The customer requests a proposal to reduce database downtime caused by running backups， with nearly no impact to production volumes. In addition to the tape backup， which DS8000 feature should a technical specialist propose（）

A、FlashCopy
B、FlashCopy SE
C、Metro Mirror
D、Global Mirror

正确答案:A

第8题：

Your database is up and running and one of your three control files is accidentally erased. You start RMAN and run the following command： RESTORE CONTROLFILE FROM AUTOBACKUP； Which of the following statements is true？（）

A、 The command restores only the missing control file.
B、 The command restores all the control files.
C、 The command fails because the database is running.
D、 This is the correct way to address this problem.
E、 This is not the correct way to address this problem.

正确答案:C,E

第9题：

Which view will you use to view information regarding the jobs that are currently running in a database？（）

A、DBA_SCHEDULER_RUNNING_JOBS
B、DBA_SCHEDULER_JOB_RUN_DETAILS
C、DBA_SCHEDULER_JOBS
D、DBA_SCHEDULER_JOB_LOG

正确答案:A

第10题：

Which two prerequisites are needed for performing workload capture and replay？（）

A、Close all sessions performing queries using database links
B、running the database in shared server mode
C、The database on which the workload is replayed has to be a restore of the original database to a specific SCN
D、setting up the directory to capture the workload

正确答案:C,D

The database is running in the

题目

相似问题和答案

更多相关问题

相关内容