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

题目内容 (请给出正确答案)
多选题
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.


参考答案

参考解析
解析: 暂无解析
更多 “多选题Which two statements are true regarding the database in ARCHIVELOG mode?()AYou have to shut down the database to perform the backups.BArchiving information is written to the data files and redo log files.CYou can perform complete database backups without closing the database.DOnline redo log files have to be multiplexed before putting the database in ARCHIVELOG mode.EAll the previous database backups become invalid after you configure the database 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.

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

考题 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 L2TP? ()(Choose two.) A. Tunnels are initiated by the LACB. Tunnels are initiated by the LNSC. By default, subscriber authentication occurs on the LNSD. By default, subscriber authentication occurs on the LAC

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

考题 You are working on an Oracle Database 10g database. You enabled the Flashback Database feature. Which two statements regarding flashback logs are true? ()A、 Flashback logs are not archived.B、 Flashback logs are maintained in redo log files.C、 Flashback logs are maintained in the Flash Recovery Area.D、 Flashback logs are used to maintain Flashback Database related errors.E、 Flashback logs need to be cleared manually after you disable Flashback Database.

考题 Which two statements are true regarding the starting of the database instance using the following command?() SQLSTARTUP 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 high-availability chassis clustering?()A、A chassis cluster consists of two devices.B、A chassis cluster consists of two or more devices.C、Devices participating in a chassis cluster can be different models.D、Devices participating in a chassis cluster must be the same models

考题 Which two statements are true regarding L2TP? ()(Choose two.)A、Tunnels are initiated by the LACB、Tunnels are initiated by the LNSC、By default, subscriber authentication occurs on the LNSD、By default, subscriber authentication occurs on the LAC

考题 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 installed Oracle Database 11g afresh. Which statements are true regarding the default audit settings in this database?() A、 The audit trail is stored in an operating system file.B、 Auditing is disabled for all privileges.C、 The audit trail is stored in the database.D、 Auditing is enabled for all privileges.E、 Auditing is enabled for certain privileges related to database security.

考题 Which two statements are true regarding subqueries? ()A、A subquery can retrieve zero or more rows B、Only two subqueries can be placed atone level C、A subquery can be used only in SQL query statements D、A subquery can appear on either side of a comparison operator E、There is no limit on the number of subquery levels in the WHERE clause of a SELECT statement 

考题 Which two statements regarding the control file and Recover Manager are true? ()A、The control file can grow in size.B、The control file can store RMAN scripts.C、CONTROL_FILE_RECORD_KEEP_TIME determines retention time for RMAN records.D、The RMAN catalog can exist solely in the control file of the target database.

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

考题 多选题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?()AAll the related indexes and views are automatically droppedBThe flashback drop feature can recover only the table structureCOnly the related indexes are dropped whereas views are invalidatedDThe flashback drop feature can recover both the table structure and its data

考题 多选题Your database is running in NOARCHIVELOG mode. You want to put the database in ARCHIVELOG mode. Which two statements regarding archive log destinations are true?()AThe destination must be global only.BA maximum of five destinations can be assigned.CA maximum of ten different destinations can be assigned.DAll the destinations are determined by the server automatically.EThe destination may be local or remote for a Standby Database.FThe destination can be changed by setting the LOG_ARCHIVE_FORMAT initialization parameter.

考题 多选题You are working on an Oracle Database 10g database. You enabled the Flashback Database feature. Which two statements regarding flashback logs are true? ()AFlashback logs are not archived.BFlashback logs are maintained in redo log files.CFlashback logs are maintained in the Flash Recovery Area.DFlashback logs are used to maintain Flashback Database related errors.EFlashback logs need to be cleared manually after you disable Flashback Database.

考题 多选题Which two statements are true regarding the database in ARCHIVELOG mode?()AYou have to shut down the database to perform the backups.BArchiving information is written to the data files and redo log files.CYou can perform complete database backups without closing the database.DOnline redo log files have to be multiplexed before putting the database in ARCHIVELOG mode.EAll the previous database backups become invalid after you configure the database to ARCHIVELOG mode.

考题 多选题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 L2TP? ()(Choose two.)ATunnels are initiated by the LACBTunnels are initiated by the LNSCBy default, subscriber authentication occurs on the LNSDBy default, subscriber authentication occurs on the LAC

考题 多选题Which two statements regarding external authentication servers for firewall userauthentication are true?()AUp to three external authentication server types can be used simultaneously.BOnly one external authentication server type can be used simultaneously.CIf the local password database is not configured in the authentication order, and the configured authentication server is unreachable, authentication is not performed.DIf the local password database is not configured in the authentication order, and the configured authentication server rejects the authentication request, authentication is not performed

考题 多选题Which two statements regarding the control file and Recover Manager are true? ()AThe control file can grow in size.BThe control file can store RMAN scripts.CCONTROL_FILE_RECORD_KEEP_TIME determines retention time for RMAN records.DThe RMAN catalog can exist solely in the control file of the target database.

考题 多选题Which two statements regarding external authentication servers for firewall user authentication are true?() (Choose two.)AUp to three external authentication server types can be used simultaneously.BOnly one external authentication server type can be used simultaneously.CIf the local password database is not configured in the authentication order, and the configured authentication server bypassed.DIf the local password database is not configured in the authentication order, and the configured authentication server authentication is rejected.

考题 多选题Which two statements are true regarding the Oracle Data Pump export and import operations()AYou cannot export data from a remote database.BYou can rename tables during an import operation.CYou can overwrite existing dump files during an export operation.DYou can compress the data during export but not the metadata because it is not supported.

考题 多选题Which two statements are true regarding listeners()AListeners use only the TCP/IP protocol.BMultiple listener processes can run simultaneously on a host.CMultiple database instances can be registered with a single listener.DThe listener-related errors can be traced only at the administrative level.EOnly 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 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.

考题 多选题Which two statements are true regarding high-availability chassis clustering?()AA chassis cluster consists of two devices.BA chassis cluster consists of two or more devices.CDevices participating in a chassis cluster can be different models.DDevices participating in a chassis cluster must be the same models