多选题Which two statements are true regarding hot patching? ()AIt requires relinking of the Oracle binary.BIt does not require database instance shutdown.CIt can detect conflicts between two online patches.DIt is available for installing all patches on all p

题目
多选题
Which two statements are true regarding hot patching? ()
A

It requires relinking of the Oracle binary.

B

It does not require database instance shutdown.

C

It can detect conflicts between two online patches.

D

It is available for installing all patches on all platforms.

E

It works only in a single database instance environment.

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

第1题:

Which two statements are true about the Automatic Diagnostic Repository (ADR)?() (Choose two.)

A. The ADR base keeps all diagnostic information in binary format

B. SQL*Plus provides the ADRI script, which can be used to work with ADR

C. The ADR can be used for problem diagnosis only when the database is open

D. The ADR can be disabled by settting the DIAGNOSTIC_DEST parameter to null

E. The ADR can be used for problem diagnosis even when the database instance is down

F. The ADR base is shared across multiple instances


参考答案:E, F

第2题:

Which two statements are true about the RMAN validate database command?()

A. It checks the database for intrablock corruptions.

B. It can detect corrupt pfiles.

C. It can detect corrupt spfiles.

D. It checks the database for interblock corruptions.

E. It can detect corrupt block change tracking files.


参考答案:A, C

第3题:

Which two statements are true regarding the starting of the database instance using the following command?()SQL>STARTUP UPGRADE

A. It enables all system triggers.

B. It allows only SYSDBA connections.

C. It ensures that all job queues remain active during the upgrade process.

D. It sets system initialization parameters to specific values that are required to enable database upgrade scripts to be run.


参考答案:B, D

第4题:

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.

正确答案:C,E

第5题:

Your database is configured in NOARCHIVELOG mode. All the control files have been lost due to a hard disk failure but the data files are not lost. You have the closed whole database backup available to you.  Which two statements are true in this scenario?()

  • A、The instance aborts.
  • B、The database cannot be recovered.
  • C、The database can be recovered by restoring the control files from the backup.
  • D、The database remains opened and you have to shut it down with the ABORT option.
  • E、The database can be restored till the point of the last closed whole database backup.

正确答案:A,E

第6题:

Examine the following scenario:The target database instance is running. The most recent backup available for the target database was taken two days ago. Log files switches have occurred in last two days. The target database is duplicated on the same host, using the Recovery Manager (RMAN) duplicate command as follows:Which statement is true about the duplicate database in this scenario?()

A. It contains data till the last backup

B. It contains all data from target database until the current time

C. It contains all data from only the committed transactions in the target database

D. It contains all data except that which is used by the transactions in the current online redo file of target database


参考答案:D

第7题:

Which two statements are true about the RMAN validate database command?()

  • A、It checks the database for intrablock corruptions.
  • B、It can detect corrupt pfiles.
  • C、It can detect corrupt spfiles.
  • D、It checks the database for interblock corruptions.
  • E、It can detect corrupt block change tracking files.

正确答案:A,C

第8题:

In which two aspects does hot patching differ from conventional patching?()

A. It consumes more memory compared with conventional patching.

B. It can be installed and uninstalled via OPatch unlike conventional patching.

C. It takes more time to install or uninstall compared with conventional patching.

D. It does not require down time to apply or remove unlike conventional patching.

E. It is not persistent across instance startup and shutdown unlike conventional patching.


参考答案:A, D

第9题:

The RECYCLEBIN parameter is set to ON for your database. You drop a table, PRODUCTS, from the SCOTT schema. Which two statements are true regarding the outcome of this action? ()(Choose two)

  • A、All the related indexes and views are automatically dropped
  • B、The flashback drop feature can recover only the table structure
  • C、Only the related indexes are dropped whereas views are invalidated
  • D、The flashback drop feature can recover both the table structure and its data

正确答案:C,D

第10题:

You are managing an Oracle Database 11g database. You configured the database to run in ARCHIVELOGmode.  Which two statements are true in this scenario()

  • A、You must shut down the database instance to perform the backups.
  • B、You must configure the Flash Recovery Area (FRA) for the database.
  • C、You can perform complete database backups without closing the database.
  • D、All the previous closed database backups including control files become invalid after you configure thedatabase to ARCHIVELOG mode.

正确答案:C,D

更多相关问题