网友您好， 请在下方输入框内输入要搜索的题目：

题目内容 （请给出正确答案）
单选题
A database is running In ARCHIVBXXMS mode. It has two online redo log groups and each group has one member.  A LGWR Input/output （I/O） fells due to permanent media failure that has resulted In the loss of redo log file and the LWGR terminates causing the instance to crash. The steps to recover from the loss of a current redo log group member in the random order are as follow.   1） Restore the corrupted redo log group. 2） Restore from a whole database backup.  3） Perform incomplete recovery.  4） Relocate by renaming the member of the damaged online redo log group to a new location.  5） Open the database with the RESETLOGS option.  6） Restart the database instance.  7） Issue a checkpoint and clear the log.   Identify the option with the correct sequential steps to accomplish the task efficiently（）.
A

 1，3，4，and 5

B

 7，3，4. and 5

C

 2，3，4，and 5

D

 7，4，3，and 5

E

 Only 6 is required

参考答案

参考解析
解析： 暂无解析
更多 “单选题A database is running In ARCHIVBXXMS mode. It has two online redo log groups and each group has one member.  A LGWR Input/output （I/O） fells due to permanent media failure that has resulted In the loss of redo log file and the LWGR terminates causing the instance to crash. The steps to recover from the loss of a current redo log group member in the random order are as follow.   1） Restore the corrupted redo log group. 2） Restore from a whole database backup.  3） Perform incomplete recovery.  4） Relocate by renaming the member of the damaged online redo log group to a new location.  5） Open the database with the RESETLOGS option.  6） Restart the database instance.  7） Issue a checkpoint and clear the log.   Identify the option with the correct sequential steps to accomplish the task efficiently（）.A  1，3，4，and 5B  7，3，4. and 5C  2，3，4，and 5D  7，4，3，and 5E  Only 6 is required” 相关考题
考题 Which two operations are NOT performed by the DUPLICATE command in Recovery Manager (RMAN)while duplicating a running database?() A. Creating the control file for the duplicate databaseB. Restoring the target data files to the duplicate databaseC. Performing complete recovery using all available backupsD. Generating a new, unique DBID for the duplicate databaseE. Copying the online redo log files from the target database to the duplicate database
查看答案
考题 Your database is in ARCHIVELOG mode. You have two online redo log groups, each of which contains oneredo member. When you attempt to start the database, you receive the following errors:ORA-00313: open failed for members of log group 1 of thread 1ORA-00312: online log 1 thread 1: ‘D:\REDO01.LOG‘You discover that the online redo log file of the current redo group is corrupted.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
查看答案
考题 Which two operations are NOT performed by the DUPLICATE command in Recovery Manager (RMAN) whileduplicating a running database? ()(Choose Two) A. Creating the control file for the duplicate databaseB. Restoring the target data files to the duplicate databaseC. Performing complete recovery using all available backupsD. Generating a new, unique DBID for the duplicate databaseE. Copying the online redo log files from the target database to the duplicate database
查看答案
考题 You are working in a dedicated server environment. Your database is running in the automatic Program Global Area （PGA） memory management mode. Which two statements are correct in this scenario？ （）A、 The WORK_AREASIZE_POLICY initialization parameter cannot be set to AUTO.B、 The Oracle database automatically controls the amount of PGA memory allotted to SQL work areas.C、 Setting the value of the SGA_TARGET initialization parameter to 0 will disable the automatic PGA memory management.D、 The SORT_AREA_SIZE parameter is ignored by all the sessions running in the automatic PGA memory management mode.
查看答案
考题 An administrator is planning a cluster running applications in 3 separate resource groups. RGA - Database 1 RGB - Web Server RGC - Database 2 Database 1 and Database 2 must be online before the Web Server. All resource groups have a Startup Policyof Online on Home Node Only. Which of the following will ensure that the resource groups are processed in the correct order？（）A、Set the Serial Acquisition OrderB、Set the Parallel Acquisition OrderC、Configure Online on the Same Node DependencyD、Configure Online on Different Nodes Dependency
查看答案
考题 Your production database is running in the ARCHIVELOG mode and the ARCn process is functional. You have two online redo log groups. Which three background processes would be involved when a log switch happens？ （）A、archivalB、log writerC、database writerD、system monitorE、process monitorF、change tracking writer
查看答案
考题 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 two statements are true regarding the database in ARCHIVELOG mode？（）A、You have to shut down the database to perform the backups.B、Archiving information is written to the data files and redo log files.C、You can perform complete database backups without closing the database.D、Online redo log files have to be multiplexed before putting the database in ARCHIVELOG mode.E、All the previous database backups become invalid after you configure the database to ARCHIVELOG mode.
查看答案
考题 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
查看答案
考题 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 1B、 ALTER DATABASE CLEAR LOGFILE GROUP 1C、 ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 1D、 ALTER DATABASE DROP LOGFILE MEMBER ’D:///REDO01.LOG’
查看答案
考题 Which two operations are NOT performed by the DUPLICATE command in Recovery Manager (RMAN) whileduplicating a running database? （）(Choose Two)A、Creating the control file for the duplicate databaseB、Restoring the target data files to the duplicate databaseC、Performing complete recovery using all available backupsD、Generating a new, unique DBID for the duplicate databaseE、Copying the online redo log files from the target database to the duplicate database
查看答案
考题 多选题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.
查看答案
考题 单选题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 1B  ALTER DATABASE CLEAR LOGFILE GROUP 1C  ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 1D  ALTER DATABASE DROP LOGFILE MEMBER ’D:///REDO01.LOG’
查看答案
考题 单选题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
查看答案
考题 单选题A database is running in ARCHIVELOG mode and regular backups are performed. A user receives the following error message . Which is the recommended sequence of operations you need to perform for the query successfully?（）A Drop the affected tablespace, re-create the tablespace, restore the datafiles, and the tablespace. B Take the affected datafile offline (if not already offline), restore the damaged image of the datafile, and then bring it online. C Restart the database in MOUNT mode, restore the damaged datafile, recover the datafile and then open the database with resetlogs.D Put the database in RESTRICTED mode, restore all the datafiles in the affected datafile and recover the tablespace, and then put the database in normal operational mode. 
查看答案
考题 单选题Your database is in NOARCHIVELOG mode. The database has three online redo log groups， and each group contains three online redo log members. The online redo log members are stored across three hard disks， E， F， and G， respectively. Hard disk G crashed while the LGWR background process was writing redo information to the online redo log files. What effect will this crash have on the database？（）A  The database will operate normally without generating any redo.B  The database will hang， and you must shut down and restart the instance.C  The database will crash， and you must recover the database from the point of failure.D  The database will operate normally and will generate minimal redo for the tables created with the NOLOGGING clause.
查看答案
考题 多选题Your database is running in NOARCHIVELOG mode. You want to put the database in ARCHIVELOG mode. Which two statements regarding archive log destinations are true？（）AThe destination must be global only.BA maximum of five destinations can be assigned.CA maximum of ten different destinations can be assigned.DAll the destinations are determined by the server automatically.EThe destination may be local or remote for a Standby Database.FThe destination can be changed by setting the LOG_ARCHIVE_FORMAT initialization parameter.
查看答案
考题 单选题Your test database is running in NOARCHIVELOG mode. Which statement is true regarding the type ofbackups that can be performed on the database（）A You can perform online whole database backups.B You can performofflinewhole database backups.C You cannot perform schema-level export/import operations.D You can perform the backup of only the SYSTEM tablespace when the database is open.
查看答案
考题 单选题Two data files have been deleted at the operating system level by accident. Your database is running in ARCHIVELOG mode and online backups are taken nightly. One of the data files that has been deleted belongs to the USERS tablespace on the other belongs to the SYSTEM tablespace. How can you recover from this situation？（）A Shut down the database, restore the two data files and then start up the database. B Take the system and users tablespace offline, restore the two data files, recover the two datafiles, and then bring the SYSTEM and USERS tablespaces online. C Shut down the database, restore the two data files, start up the database in MOUNT mode, recover the two data files, and then alter the database open. D Take the SYSTEM and USERS tablespaces offline, recover the two datafiles and then bring the SYSTEM and USERS tablespaces online.
查看答案
考题 单选题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: ORA-00313: open failed for members of log group 1 of thread 1 ORA-00312: online log 1 thread 1: 'D:/REDO01.LOG' You discover that the online redo log file of the current redo group is corrupted. 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
查看答案
考题 多选题Your database is functioning in NOARCHIVELOG mode. Your database contains 15 tablespaces. You want to use Recovery Manager （RMAN） to perform backups.  Which two backups would you be able to perform when the database is being accessed by users？（）Abackup of offline tablespacesBbackup of read­only tablespacesCbackup of system­critical tablespacesDbackup of online， locally managed tablespacesEbackup of read/write dictionary­managed tablespaces
查看答案
考题 多选题Which two operations are NOT performed by the DUPLICATE command in Recovery Manager (RMAN)while duplicating a running database?（）ACreating the control file for the duplicate databaseBRestoring the target data files to the duplicate databaseCPerforming complete recovery using all available backupsDGenerating a new, unique DBID for the duplicate databaseECopying the online redo log files from the target database to the duplicate database
查看答案
考题 多选题Which two operations are NOT performed by the DUPLICATE command in Recovery Manager (RMAN) whileduplicating a running database? （）(Choose Two)ACreating the control file for the duplicate databaseBRestoring the target data files to the duplicate databaseCPerforming complete recovery using all available backupsDGenerating a new, unique DBID for the duplicate databaseECopying the online redo log files from the target database to the duplicate database
查看答案
考题 多选题Your production database is running in the ARCHIVELOG mode and the ARCn process is functional. You have two online redo log groups. Which three background processes would be involved when a log switch happens？ （）AarchivalBlog writerCdatabase writerDsystem monitorEprocess monitorFchange tracking writer
查看答案
考题 多选题You are working in a dedicated server environment. Your database is running in the automatic Program Global Area （PGA） memory management mode.   Which two statements are correct in this scenario？（）AThe WORK_AREASIZE_POLICY initialization parameter cannot be set to AUTO.BThe Oracle database automatically controls the amount of PGA memory allotted to SQL work areas.CSetting the value of the SGA_TARGET initialization parameter to 0 will disable the automatic PGA  memory management.DThe SORT_AREA_SIZE parameter is ignored by all the sessions running in the automatic PGA  memory management mode.
查看答案
考题 单选题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 NOARCHIVELOG mode. A data file is lost. Which two are valid options for recover？（）ARestore the data file and perform incomplete recovery.BRestore the data file and perform point-in-time recover.CDrop the tablespace and lose all data in the tablespace.DRestore the database and lose all data since the last backup.
查看答案
热门标签
最新试卷