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

题目内容 (请给出正确答案)

What Oracle process runs when the database is in ARCHIVELOG mode but not when it is in NOARCHIVELOG mode?()

  • A、 MMON
  • B、 LGWR
  • C、 ARCH
  • D、 ARWR
  • E、 COPY

参考答案

更多 “What Oracle process runs when the database is in ARCHIVELOG mode but not when it is in NOARCHIVELOG mode?()A、 MMONB、 LGWRC、 ARCHD、 ARWRE、 COPY” 相关考题
考题 WhatOracleprocessrunswhenthedatabaseisinARCHIVELOGmodebutnotwhenitisinNOARCHIVELOGmode?() A.MMONB.LGWRC.ARCHD.ARWRE.COPY

考题 When performing recover of a database in NOARCHIVELOG mode with RMAN, the target database must be in the () state to restore the control file.A、OPENB、IDLEC、MOUNTD、NOMOUNT

考题 Oracle数据库运行在()模式时启用ARCH进程。A、PARALLEL ModeB、ARCHIVELOG ModeC、NOARCHIVELOG ModeD、RAC 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、archivalB、log writerC、database writerD、system monitorE、process monitorF、change tracking writer

考题 Your database is running in ARCHIVELOG mode. You are performing a user-managed backup of the DATA1 tablespace.  You place the DATA1 tablespace in backup mode by issuing the following statement:   ALTER TABLESPACE data1 BEGIN BACKUP;   While you are performing the backup, an error occurs that causes the instance to terminate abnormally. Which statement about the DATA1 tablespace is true?()  A、 The DATA1 tablespace is automatically taken out of backup mode when the instance aborts.B、 If you restart the database,the DATA1 tablespace will be automatically taken out of backup mode  when the database is opened.C、 If you restart the database,the DATA1 tablespace will be automatically taken out of backup mode  when the database is mounted.D、 If you restart the database,the database will not be opened.

考题 The database is currently running in the NOARCHIVELOG mode. What would be the first step to configure Flashback Database?()A、 Enable flashback logging.B、 Start the database in the ARCHIVELOG mode.C、 Issue the ALTER DATABASE FLASHBACK ON; command.D、 Set the FAST_START_MTTR_TARGET initialization parameter.

考题 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

考题 You executed the following command in Recovery Manager (RMAN) to perform a backup of the DETTBS tablespace: RMAN BACKUP TABLESPACE DETTBS;  Under which conditions would this command execute successfully? ()A、 The database is in NOMOUNT state.B、 The database is in NOARCHIVELOG mode and the tablespace is online.C、 The database is in NOARCHIVELOG mode and the tablespace is offline.D、 The database is in ARCHIVELOG mode and the tablespace is offline.E、 The database is in ARCHIVELOG mode and the tablespace is online.

考题 you can perform an active database duplication when the database is in NOARCHIVELOG mode.()A、 TrueB、 False

考题 What are the different logging modes available in Oracle Database 11g?() A、 NOLOG modeB、 NOARCHIVELOG modeC、 LOGGING modeD、 HOTDATABASE modeE、 ARCHIVELOG mode

考题 Which three actions are required to configure the Flashback Database? ()A、set Flash Recovery AreaB、enable Flashback loggingC、create FLASHBACK tablespaceD、start the database in the ARCHIVELOG modeE、start the database in the NOARCHIVELOG mode

考题 Another DBA issues a shutdown abort command on a database on which you were running an online backup. What will happen when you try to restart the database?()  A、 Oracle will automatically take the datafile out of hot backup mode,generate a warning message,and then open the database.B、 Oracle will automatically take the datafile out of hot backup mode and then open the database.C、 Oracle will generate an error when trying to open the database,indicating that a datafile is in hot backup mode.You will need to correct this error before you can open the database.D、 The database will open with the file in hot backup mode. You can restart the backup at any time.E、 The datafile in hot backup mode will be corrupted and you will have to recover it.

考题 Which two requirements are critically important to implement for your database backup strategy if you require a 24 hours a day, 7 days a week production environment?()A、ARCHIVELOG mode.B、NOARCHIVELOG mode.C、Open database backups.D、Consistent whole backups.

考题 Your test database is running in NOARCHIVELOG mode. What are the implications of this? ()A、You can perform open database backups.B、You can perform closed database backups.C、You cannot perform schema-level logical backups.D、You can perform the backup of only the SYSTEM tablespace when the database is open.

考题 In which of the following scenarios is a tablespace recovery required?()A、 when recovering a lost read-only tablespace from a read-only tablespace backupB、 when recovering a lost read-only tablespace from a read-write tablespace backup when the database is running in  ARCHIVELOG modeC、 when recovering a lost read-only tablespace from a read-write tablespace backup when the database is running in  NOARCHIVELOG mode and the changes in the online redo log files have been overwrittenD、 when recovering a lost read-only tablespace from a read-only tablespace backup using the backup of the control file, the control file was created using the ALTER DATABASE BACKUP CONTROLFILE TO TRACE statement, and this statement was issued when the tablespace was read-only

考题 Which of the following statements is true when the database is in ARCHIVELOG mode and tablespaces are in hot backup mode?()A、 Archive log generation is suspended until the tablespaces are taken out of hot backup mode. B、 Datafiles are not written to during hot backups.C、 Changes to the database are cached during the backup and not written to the datafiles to ensure that the datafiles are consistent when recovered.D、 The datafile headers are not updated during the backup.E、 The way data is written to the online redo logs is unchanged during the backup.

考题 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()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.

考题 单选题Your database is running in ARCHIVELOG mode. You are performing a user-managed backup of the DATA1 tablespace. You place the DATA1 tablespace in backup mode by issuing the following statement: ALTER TABLESPACE data1 BEGIN BACKUP; While you are performing the backup, an error occurs that causes the instance to terminate abnormally. Which statement about the DATA1 tablespace is true?()A The DATA1 tablespace is automatically taken out of backup mode when the instance aborts.B If you restart the database, the DATA1 tablespace will be automatically taken out of backup mode when the database is opened.C If you restart the database, the DATA1 tablespace will be automatically taken out of backup mode when the database is mounted.D If you restart the database, the database will not be opened.

考题 单选题The database is currently running in the NOARCHIVELOG mode. What would be the first step to configure Flashback Database?()A  Enable flashback logging.B  Start the database in the ARCHIVELOG mode.C  Issue the ALTER DATABASE FLASHBACK ON; command.D  Set the FAST_START_MTTR_TARGET initialization parameter.

考题 单选题What Oracle process runs when the database is in ARCHIVELOG mode but not when it is in NOARCHIVELOG mode?()A  MMONB  LGWRC  ARCHD  ARWRE  COPY

考题 多选题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 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

考题 多选题Which three actions are required to configure the Flashback Database?()Aset Flash Recovery AreaBenable Flashback loggingCcreate FLASHBACK tablespaceDstart the database in the ARCHIVELOG modeEstart the database in the NOARCHIVELOG mode

考题 多选题You executed the following command in Recovery Manager (RMAN) to perform a backup of the DETTBS tablespace:  RMAN BACKUP TABLESPACE DETTBS;  Under which conditions would this command execute successfully? ()AThe database is in NOMOUNT state.BThe database is in ARCHIVELOG mode and the tablespace is online.CThe database is in ARCHIVELOG mode and the tablespace is offline.DThe database is in NOARCHIVELOG mode and the tablespace is online.EThe database is in NOARCHIVELOG mode and the tablespace is offline.

考题 单选题you can perform an active database duplication when the database is in NOARCHIVELOG mode.()A  TrueB  False

考题 单选题Which of the following statements is true when the database is in ARCHIVELOG mode and tablespaces are in hot backup mode?()A  Archive log generation is suspended until the tablespaces are taken out of hot backup mode. B  Datafiles are not written to during hot backups.C  Changes to the database are cached during the backup and not written to the datafiles to ensure that the datafiles are consistent when recovered.D  The datafile headers are not updated during the backup.E  The way data is written to the online redo logs is unchanged during the backup.

考题 单选题If you issue the command shutdown abort prior to trying to put the database in ARCHIVELOG mode, what will be the result when you issue the command alter database archivelog?()A  The alter database archivelog command will failB  The alter database archivelog inconsistent command must be used to put the database in ARCHIVELOG modeC  The alter database archivelog command will succeedD  The alter database archivelog command will ask if you want to make the database consistent firstE  There is no alter database archivelog command. The correct command is alter database alterlogging