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 switchB、You should make a backup of the databaseC、You should switch the database to the NONARCHIVELOG modeD、You should shut down the database instance and perform a complete database recovery
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
相关考题：
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 ManagerB. Listener Control utilityC. Database Configuration AssistantD. Oracle Net Configuration Assistant
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.
Which WebSphere Commerce features require the Scheduler component to be running？（）A、AuctionsB、Database replicationC、E-mail notificationsD、DiscountsE、Marketing campaigns
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 flashbackB、the expected length of the longest-running queryC、the number of undo tablespaces in the databaseD、the size of the Flash Recovery Area for the database instance
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.
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、FlashCopyB、FlashCopy SEC、Metro MirrorD、Global Mirror
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.
Which view will you use to view information regarding the jobs that are currently running in a database？（）A、DBA_SCHEDULER_RUNNING_JOBSB、DBA_SCHEDULER_JOB_RUN_DETAILSC、DBA_SCHEDULER_JOBSD、DBA_SCHEDULER_JOB_LOG
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
Which two prerequisites are needed for performing workload capture and replay？（）A、Close all sessions performing queries using database linksB、running the database in shared server modeC、The database on which the workload is replayed has to be a restore of the original database to a specific SCND、setting up the directory to capture the workload
Which statement is true about a whole consistent database backup on a database running in ARCHIVELOG mode（）A、The backup will consist of used data blocks only.B、The database must be shut down to accomplish the backup.C、The backup can be accomplished without shutting down the database.D、The backup will contain all database files that have never been backed up.
Which of the following is a prerequisite for running DBMS_TDB.CHECK_DB to a successful completion？（）A、 The database must be in read-write mode.B、 The database must have no external files.C、 The database must open in read-only mode.D、 The database must be mounted but not opened.
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 ManagerB、 Listener Control utilityC、 Database Configuration AssistantD、 Oracle Net Configuration Assistant
多选题In order to perform Flashback Transaction Query operations， which of these steps are required？（）AEnsure that database is running with version 10.1 compatibility.BEnable Flashback Logging.CEnable Supplemental Logging.DEnsure that the database is running with version 10.0 compatibility.EEnsure that the database is in ARCHIVELOG mode.
多选题A Mysql instance is running on a dedicated server. Developers access the server from the same network subnet. Users access the database through an application that is running on a separate server in a DMZ. Which two will optimize the security of this setup?（）ADisabling connections from named pipes or socket files (depending on the operating system of the server)BEnabling and using SSL for connections to the Mysql databaseCInstalling Mysql on the application server, and running the database and application on the same serverDStarting the server with – bind- address=0.0.0.0 specifiedERunning the server with – skip-networking specifiedFLimiting logins to originate from the application server or the server's subnet'
单选题Your test database is running in NOARCHIVELOG mode. What are the implications of this？ （）AYou can perform open database backups.BYou can perform closed database backups.CYou cannot perform schema-level logical backups.DYou can perform the backup of only the SYSTEM tablespace when the database is open.
多选题You are managing an Oracle Database 11g database. The database is open， and you plan to performRecovery Manager （RMAN） backups. Which three statements are true about these backups（）AThe backups would be consistent.BThe backups would be inconsistent.CThe backups would be possible only if the database is running in ARCHIVELOG mode.DThe backups would be possible only if the database is running in NOARCHIVELOG mode.EThe backups need to be restored and the database has to be recovered in case of a media failure.
单选题Your test database is running in NOARCHIVELOG mode. Which statement is true regarding the type ofbackups that can be performed on the database（）AYou can perform online whole database backups.BYou can performofflinewhole database backups.CYou cannot perform schema-level export/import operations.DYou can perform the backup of only the SYSTEM tablespace when the database is open.
单选题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 ManagerB Listener Control utilityC Database Configuration AssistantD Oracle Net Configuration Assistant
单选题You need to design the consolidation strategy for the Promotions and Partners databases. You want to choose a strategy that results in the best database performance while maintaining the permissions of end users in each database.What consolidation strategy should you choose？（）APlace each database in a separate instance running on SQL2.BPlace each database in a separate instance running on SQL3.CPlace both databases in a single instance running on SQL2.DPlace both databases in a single instance running on SQL3.
单选题Which statement is true about a whole consistent database backup on a database running in ARCHIVELOG mode（）AThe backup will consist of used data blocks only.BThe database must be shut down to accomplish the backup.CThe backup can be accomplished without shutting down the database.DThe backup will contain all database files that have never been backed up.
单选题The database is currently open and the temp03.dbf tempfile belonging to the default temporary tablespace TEMP has been corrupted. What steps should you take to recover from this tempfile loss in an efficient manner?（）AAllow the database to continue running, drop the TEMP tablespace, and then re-create it with new tempfilesBShut down the database, restore and recover the tempfile from backup, and then open the database with RESETLOGSCAllow the database to continue running, take the TEMP tablespace offline, drop the missing tempfile, and then create a new tempfileDAllow the database to continue running, add a new tempfile to TEMP tablespace with a new name, and drop the tempfile that has been corrupted.
单选题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.
多选题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（）AThe backups would be consistent.BThe backups would be inconsistent.CThe backups would be possible only if the database is running in ARCHIVELOG mode.DThe backups would be possible only if the database is running in NOARCHIVELOG mode.EThe backups need to be restored and the database has to be recovered in case of a media failure
单选题Which view will you use to view information regarding the jobs that are currently running in a database？（）ADBA_SCHEDULER_RUNNING_JOBSBDBA_SCHEDULER_JOB_RUN_DETAILSCDBA_SCHEDULER_JOBSDDBA_SCHEDULER_JOB_LOG
多选题Your database instance is running with full workload after database creation. You have decided to use a fixed-size undo tablespace. You want to use the Undo Advisor to estimate the capacity of the undo tablespace. Which two factors must you consider before using the Undo Advisor to estimate the capacity of the undotablespace（）AThe retention period to support flashbackBThe expected length of the longest-running queryCThe number of undo tablespaces in the databaseDThe size of the Flash Recovery Area for the database instance
多选题Half of your network uses RIPv2 and the other half runs OSPF. The networks do not communicate with each other. Which two of these factors describe the impact of activating EIGRP over each separate part？（）AEIGRP will not be accepted when configured on the actual RIPv2 routers.BOSPF will no longer be used in the routing table， because you only have EIGRP internal routes running.COSPF will no longer be used in the routing table， because you only have EIGRP external routes running.DRIPv2 will populate its RIP database but not its routing table， because you only have EIGRP external routes running.ERIPv2 will populate its RIP database but not its routing table， because you only have EIGRP internal routes running.FOSPF database will have RIPv2 routes.
单选题Which of the following is a prerequisite for running DBMS_TDB.CHECK_DB to a successful completion？（）A The database must be in read-write mode.B The database must have no external files.C The database must open in read-only mode.D The database must be mounted but not opened.