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

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

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.

参考答案

更多 “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.” 相关考题
考题 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.

考题 Which two statements are true regarding the starting of the database instance using the following command?()SQLSTARTUP 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.

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

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

考题 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 backupB. It contains all data from target database until the current timeC. It contains all data from only the committed transactions in the target databaseD. It contains all data except that which is used by the transactions in the current online redo file of target database

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

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

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

考题 Choose the two correct statements regarding Oracle WebLogic Server()A、 a server instance can be associated with multiple machinesB、 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

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

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

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

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

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

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

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

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

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

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

考题 Which two statements are true regarding the starting of the database instance using the following command?() SQLSTARTUP 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.

考题 多选题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()AThe online redo log files and online data files are opened.BAll the online data file headers are checked for consistency.CInstance recovery is performed before opening the database.DThe path and existence of all the log file members are checked

考题 多选题Which two statements are true regarding transactions in an Oracle database()AMultiple transactions can use the same undo segment.BA transaction is assigned an undo segment when it is started.CMore than one transaction cannot share the same extent in the undo tablespace.DThe transactions use system undo segment to store undo data if all the segments in the undo tablespaceare used.

考题 多选题Which two statements are true about the RMAN validate database command?()AIt checks the database for intrablock corruptions.BIt can detect corrupt pfiles.CIt can detect corrupt spfiles.DIt checks the database for interblock corruptions.EIt can detect corrupt block change tracking files.

考题 多选题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 platforms.EIt works only in a single database instance environment.

考题 多选题Which two statements are true regarding the starting of the database instance using the following command?() SQLSTARTUP UPGRADEAIt enables all system triggers.BIt allows only SYSDBA connections.CIt ensures that all job queues remain active during the upgrade process.DIt sets system initialization parameters to specific values that are required to enable database upgrade scripts to be run.

考题 多选题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()AThe online redo log files and online data files are opened.BAll the online data file headers are checked for consistency.CInstance recovery is performed before opening the database.DThe path and existence of all the log file members are checked

考题 多选题In which two aspects does hot patching differ from conventional patching?()AIt consumes more memory compared with conventional patching.BIt can be installed and uninstalled via OPatch unlike conventional patching.CIt takes more time to install or uninstall compared with conventional patching.DIt does not require down time to apply or remove unlike conventional patching.EIt is not persistent across instance startup and shutdown unlike conventional patching.