You are adding redo logs to the Oracle database. Creating a new redo log adds information to which of the following Oracle resources? （）

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 . log writer B . archival C . process monitor D . system monitor E . change tracking writer F . database writer

查看最佳答案

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&rsquo

查看最佳答案

In your database， online redo log files are multiplexed and one of the members in a group is lost due to media failure？ How would you recover the lost redo log member？（）

A . import the database from the last export B . restore all the members in the group from the last backup C . drop the lost member from the database and then add a new member to the group D . restore all the database files from the backup and then perform a complete recovery E . restore all the database files from the backup and then perform an incomplete recovery

查看最佳答案

When you are logged into aswitch，which prompt indicates that you are inprivileged mode？（）

A . % B . @ C . > D . $ E . #

查看最佳答案

When you are allowing RMAN to backup your archived redo log files，how does RMAN know which archived redo logs to back up from your archive log destination？（）

A . RMAN keeps a list of archive logs in a text file. B . The DBA must manually tell RMAN which archive logs to backup. C . RMAN has access to target control file and/or catalog information. D . RMAN looks at the ARCHIVE_LOG_DEST parameter of your target database and backs up all archive logs found.

查看最佳答案

A redo log file is corrupted while the database is open； as a consequence， database operations are stopped because archiving cannot continue. What would you do to solve the problem？（）

A . clear the redo log group B . perform redo log file import C . perform an incomplete recovery D . perform a redo log recovery using Recovery Manager （RMAN） E . shut down the database and open the database in the NOARCHIVELOG mode

查看最佳答案

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 . archival B . log writer C . database writer D . system monitor E . process monitor F . change tracking writer

查看最佳答案

In your database， online redo log files are multiplexed and one of the members in a group is lost due to media failure. How would you recover the lost redo log member？（）

A . import the database from the last export B . restore all the members in the group from the last backup C . drop the lost member from the database， and then add a new member to the group D . restore all the database files from the backup， and then perform a complete recovery E . restore all the database files from the backup， and then perform an incomplete recovery

查看最佳答案

You are using Oracle Database 10g. The LOG_ARCHIVE_FORMAT parameter is set to ’LOG%t_%s_%r.dbf’. Why is %r used in the file name format？（）

A . to uniquely identify the archived log files with the restore operation B . to uniquely identify the archived log files with the redo log group number C . to uniquely identify the archived log files for each incarnation of the database D . to uniquely identify the archived log files with the number of recovery operations performed

查看最佳答案

You configured the Flash Recovery Area for your database. The database instance has been started inARCHIVELOG mode and the LOG_ARCHIVE_DEST_1 parameter is not set. What will be the implications onthe archiving and the location of archive redo log files（）

A . Archiving will be disabled because the destination for the redo log files is missing. B . The database instance will shut down and the error details will be logged in the alert log file. C . Archiving will be enabled and the destination for the archived redo log file will be set to the Flash RecoveryArea implicitly. D . Archiving will be enabled and the location for the archive redo log file will be created in the default location$ORACLE_HOME/log.

查看最佳答案

Which of the following dynamic view would you query to identify the online CURRENT redo log group？（）

A . V$LOG B . V$LOFHIST C . V$LOGFILE D . V$LOG_HISTORY

查看最佳答案

You notice that your RMAN script used to copy the datafiles， control files， and archived redo log files is performing very slowly. Which two changes might you want to include in your RMAN script to speed up the COPY commands？（）

A . NOCHECKSUM B . MAXCORRUPT C . CHECK LOGICAL D . BACKUP INCREMENTAL E . CONFIGURE DEVICE TYPE ... PARALLELISM

查看最佳答案

As a result of a media failure， the current online redo log group is corrupted. The database crashes， as the current online group is inaccessible. Which type of incomplete recovery are you most likely to perform？（）

A . Cancel-based B . Recovery using a backup control file C . Time-based D . Change-based

查看最佳答案

During recovery， you need to know if log sequence 11 is in the online redo logs， and if so， you need to know the names of the online redo logs so you can apply them during recovery. Which view or views would you use to determine this information？（）

A . V$LOGFILE B . V$RECOVER_LOG C . V$RECOVER_DATABASE D . V$LOG_RECOVER E . V$LOG

查看最佳答案

When performing a database duplication， which duplicate database parameter would you set to ensure that the online redo logs are created in the correct location？（）

A . log_file_name_convert B . convert_log_file_name C . file_name_convert_log D . redo_log_file_name_convert E . logfile_convert_directory

查看最佳答案

You have implemented OMF for redo log management. Which of the following choices reflects a log filename that might be employed when OMF is enabled?（）

A . log01.log B . logORCL01.log C . 1_2.logALTER ROLLBACK SEGMENT D . ora_1_asdf1234.log

查看最佳答案

Your boss at Supportcenter.cn wants you to clarify Oracle 10g. Which statement regarding the usage of redo log files during instance recovery is true？（）

A . Transactions are rolled back using redo log files. B . Transactions are rolled forward using redo log files. C . Transactions are rolled back using redo log files and archived log files. D . Transactions are rolled forward using redo log files and rolled back using redo log files.

查看最佳答案

You are attempting to clear an unarchived redo log file. In order to manually enact a log switch, which of the following statements is appropriate?（）

A . ALTER DATABASE B . ALTER SYSTEM C . ALTER USER D . ALTER REDO LOG

查看最佳答案

You are analyzing the components of the redo log mechanisms in your Oracle database. Which of the following purposes does the CKPT process serve?（）

A . Writes buffers to disk B . Writes current redo log number to datafile headers C . Writes redo log information to disk D . Reads information into memory for user

查看最佳答案

In your database， the Log Writer （LGWR） process is unable to write to a member of a current redo log group due to read/write failure. Which two effects would you see in your database？（）

A . The database instance aborts. B . The database operation temporarily halts till the member becomes available. C . Writing proceeds as normal. LGWR writes to the available members of a group and ignores the unavailable members. D . The member would be marked as STALE and an error message would be written to the alert log file and LGWR trace file. E . The status of the group changes to INACTIVE and an error message would be written to the alert log file and LGWR trace file.

查看最佳答案

One of the redo log members in your database is lost. You queried V$logfile for further details. What would be the member’s status？（）

A . LOST B . INVALID C . EXPIRED D . DELETED E . CORRUPT F . UNKNOWN G . OBSOLETE

查看最佳答案

As soon as you discover that you have lost an online redo log， if the database is still functioning， what should be your first action？（）

A . Shut down the database B . Clear the online redo log C . Back up the database D . Checkpoint the database E . Call Oracle support

查看最佳答案

If you lost your entire database，including the database spfile，control files，online redo logs，and database datafiles，what kind of recovery would be required with RMAN？（）

A . Complete database recovery. B . Incomplete database recovery. C . Approximate database recovery. D . Archived database recovery. E . The database could not be recovered with RMAN.

查看最佳答案

You are developing a Windows Communication Foundation （WCF) service. You enable logging in

You are developing a Windows Communication Foundation (WCF) service. You enable logging in the configuration file.The opening tag is defined as follows.＜messagelogging br="" logentiremessage="true"＞ logMalformedMessages="true"logMessagesAtServiceLevel="true"logMessagesAtTransportLevel="true"maxMessagesToLog="20"＞You need to ensure that logging is implemented so that only messages with SOAP headers are logged.What should you add to the filters element of the application configuration file？（） A.<img src='https://img2.soutiyun.com/ask/uploadfile/2019-02-04/dabf07576919d2888eaaebeeefbe8e42.jpg' /> B.<img src='https://img2.soutiyun.com/ask/uploadfile/2019-02-04/0d3fc5a751c48bf4454f58321ef53f4c.jpg' /> C.<img src='https://img2.soutiyun.com/ask/uploadfile/2019-02-04/c3e7538a5accad25aa4ac16ce8d2126d.jpg' /> D.<img src='https://img2.soutiyun.com/ask/uploadfile/2019-02-04/241428daaa8185f55a085326b8cf7f39.jpg' />

查看最佳答案

You are adding redo logs to the Oracle database. Creating a new redo log adds information to which of the following Oracle resources? （）

相似题目

推荐题目