网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
多选题
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? （）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 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 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.
考题
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.
考题
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 droppedB、The flashback drop feature can recover only the table structureC、Only the related indexes are dropped whereas views are invalidatedD、The flashback drop feature can recover both the table structure and its data
考题
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.
考题
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.
考题
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 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.
考题
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： RMAN RUN { ALLOCATE AUXILIARY CHANNEL aux 1 DEVICE TYPE DISK； DUPLICATE TARGET DATABASE TO auxdb； } 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
考题
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 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.
考题
多选题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？（））AIts entries are specific to a single database.BIt contains file systems that have been mounted by Direct NFS.CIt is globally available to all Oracle 11g databases on the machine.DIt contains file systems that have been mounted by the kernel NFS system.
考题
多选题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 about the Automatic Diagnostic Repository (ADR)?（） (Choose two.)AThe ADR base keeps all diagnostic information in binary formatBSQL*Plus provides the ADRI script, which can be used to work with ADRCThe ADR can be used for problem diagnosis only when the database is openDThe ADR can be disabled by settting the DIAGNOSTIC_DEST parameter to nullEThe ADR can be used for problem diagnosis even when the database instance is downFThe ADR base is shared across multiple instances
考题
多选题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？（）AThe instance aborts.BThe database cannot be recovered.CThe database can be recovered by restoring the control files from the backup.DThe database remains opened and you have to shut it down with the ABORT option.EThe database can be restored till the point of the last closed whole database backup.
考题
多选题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.
热门标签
最新试卷
