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 a

题目

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 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.

2.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.

3.Which two statements are true about the Automatic Diagnostic Repository (ADR)?() (Choose two.)A. The ADR base keeps all diagnostic information in binary formatB. SQL*Plus provides the ADRI script, which can be used to work with ADRC. The ADR can be used for problem diagnosis only when the database is openD. The ADR can be disabled by settting the DIAGNOSTIC_DEST parameter to nullE. The ADR can be used for problem diagnosis even when the database instance is downF. The ADR base is shared across multiple instances

4.Which two statements are true regarding the starting of the database instance using the following command?()SQL>STARTUP UPGRADEA. 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.

更多“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 a”相关问题

  • 第1题：

    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

  • 第2题：

    Which statement is true regarding Dynamic Service Registration？（）

    • A、Dynamic service registration requires configuration in the listener .ora file.
    • B、Dynamic service registration can be used only with an Oracle9/instance.
    • C、Dynamic service registration cannot register a local listener that does not use TCP/IP or port 1521.
    • D、The PMON background process automatically registers each database instance if the necessary parameters have been set in the database initialization parameter file.

    正确答案:D

  • 第3题：

    Choose the two correct statements regarding Oracle WebLogic Server（）

    • A、 a server instance can be associated with multiple machines
    • B、 a machine can be associated with multiple server instance 
    • C、 a server instance can be associated with only a single machine 
    • D、 a machine can be associated with only one server instance

    正确答案:B,C

  • 第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题：

    After performing a clean shut down of the database instance for maintenance， you mount the database andthen execute a command to open the database：SQL> ALTER DATABASE OPEN； Which two statements are true（）

    • A、The online redo log files and online data files are opened.
    • B、All the online data file headers are checked for consistency.
    • C、Instance recovery is performed before opening the database.
    • D、The path and existence of all the log file members are checked

    正确答案:A,B

  • 第6题：

    Which two statements are true about checkpointing（）

    • A、The checkpoint frequency decreases with the smaller redo log file size.
    • B、It ensures that all committed data is written to the data files during normal shutdown.
    • C、The frequent full checkpoint in a database can cause the overall degradation of the database performance.
    • D、It prompts the Checkpoint （CKPT） process to write data to the data files and redo information to the online redo log files.

    正确答案:B,C

  • 第7题：

    Which two statements are true regarding transactions in an Oracle database（）

    • A、Multiple transactions can use the same undo segment.
    • B、A transaction is assigned an undo segment when it is started.
    • C、More than one transaction cannot share the same extent in the undo tablespace.
    • D、The transactions use system undo segment to store undo data if all the segments in the undo tablespaceare used.

    正确答案:A,B

  • 第8题：

    Which two statements are true regarding listeners（）

    • A、Listeners use only the TCP/IP protocol.
    • B、Multiple listener processes can run simultaneously on a host.
    • C、Multiple database instances can be registered with a single listener.
    • D、The listener-related errors can be traced only at the administrative level.
    • E、Only one database instance can be registered with a single listener at any time.

    正确答案:B,C

  • 第9题：

    多选题
    After performing a clean shut down of the database instance for maintenance， you mount the database andthen execute a command to open the database：SQL> ALTER DATABASE OPEN； Which two statements are true（）
    A

    The online redo log files and online data files are opened.

    B

    All the online data file headers are checked for consistency.

    C

    Instance recovery is performed before opening the database.

    D

    The path and existence of all the log file members are checked


    正确答案： C,A
    解析： 暂无解析

  • 第10题：

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


    正确答案： E,C
    解析： 暂无解析

  • 第11题：

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


    正确答案： C,B
    解析： 暂无解析

  • 第12题：

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


    正确答案： B,C
    解析： 暂无解析

  • 第13题：

    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

  • 第14题：

    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

  • 第15题：

    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

  • 第16题：

    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

  • 第17题：

    After performing a clean shut down of the database instance for maintenance， you mount thedatabase and then execute a command to open the database： SQL> ALTER DATABASE OPEN；  Which two statements are true（）

    • A、The online redo log files and online data files are opened.
    • B、All the online data file headers are checked for consistency.
    • C、Instance recovery is performed before opening the database.
    • D、The path and existence of all the log file members are checked

    正确答案:A,B

  • 第18题：

    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

  • 第19题：

    You decided to use Direct NFS configuration in a non-RAC Oracle installation and created the oranfstab file in /etc. Which two statements are true regarding this oranfstab file？（））  

    • A、 Its entries are specific to a single database.
    • B、 It contains file systems that have been mounted by Direct NFS.
    • C、 It is globally available to all Oracle 11g databases on the machine.
    • D、 It contains file systems that have been mounted by the kernel NFS system.

    正确答案:C,D

  • 第20题：

    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

  • 第21题：

    多选题
    Which two statements are true regarding transactions in an Oracle database（）
    A

    Multiple transactions can use the same undo segment.

    B

    A transaction is assigned an undo segment when it is started.

    C

    More than one transaction cannot share the same extent in the undo tablespace.

    D

    The transactions use system undo segment to store undo data if all the segments in the undo tablespaceare used.


    正确答案： B,D
    解析： 暂无解析

  • 第22题：

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


    正确答案： C,D
    解析： 暂无解析

  • 第23题：

    多选题
    After performing a clean shut down of the database instance for maintenance， you mount thedatabase and then execute a command to open the database： SQL> ALTER DATABASE OPEN；  Which two statements are true（）
    A

    The online redo log files and online data files are opened.

    B

    All the online data file headers are checked for consistency.

    C

    Instance recovery is performed before opening the database.

    D

    The path and existence of all the log file members are checked


    正确答案： D,C
    解析： 暂无解析

相关内容