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

题目内容 (请给出正确答案)
多选题
Which are the two prerequisites before setting up Flashback Data Archive? ()(Choose two.)
A

Flash recovery area must be defined

B

Undo retention guarantee must be enabled.

C

Database must be running in archivelog mode.

D

Automatic undo management must be enabled.

E

The tablespace in which the Flashback Data Archive is created must have automatic segment space Management (ASSM).


参考答案

参考解析
解析: 暂无解析
更多 “多选题Which are the two prerequisites before setting up Flashback Data Archive? ()(Choose two.)AFlash recovery area must be definedBUndo retention guarantee must be enabled.CDatabase must be running in archivelog mode.DAutomatic undo management must be enabled.EThe tablespace in which the Flashback Data Archive is created must have automatic segment space Management (ASSM).” 相关考题
考题 Which are the two prerequisites before setting up Flashback Data Archive? ()(Choose two.) A. Flash recovery area must be definedB. Undo retention guarantee must be enabled.C. Database must be running in archivelog mode.D. Automatic undo management must be enabled.E. The tablespace in which the Flashback Data Archive is created must have automatic segment space Management (ASSM).

考题 Which two are prerequisites for performing a flashback transaction?() A. Flashback Database must be enabled.B. Undo retention guarantee for the database must be configured.C. EXECUTE privilege on the DBMS_FLASHBACK package must be granted to the user flashing back transaction.D. Supplemental logging must be enabled.E. Recycle bin must be enabled for the database.F. Block change tracking must be enabled tor the database.

考题 You are proceeding down a channel and lose the engine(s).You must use the anchors to stop the ship.Which statement is true ________.A.Pay out all of the cable before setting up on the brake to insure the anchors dig in and holdB.For a mud,mud and clay,or sandy bottom pay out a scope of 5 to 7 times the depth before setting up on the brakeC.Use one or both anchors with a scope of twice the depth before setting the brakeD.Drop the anchor to short stay and hold that scope

考题 Which two of these correctly describe Fibre Channel?()A、 supports multiple protocolsB、 works only in a shared or loop environmentC、 allows addressing for up to 4 million nodesD、 allows addressing for up to 8 million nodesE、 provides a high speed transport for SCSI payloadsF、 may stretch to a distance of up to 100 km before needing extenders

考题 Which two of these correctly describe Fibre Channel? ()A、supports multiple protocolsB、works only in a shared or loop environmentC、allows addressing for up to 4 million nodesD、allows addressing for up to 8 million nodesE、provides a high speed transport for SCSI payloadsF、may stretch to a distance of up to100 km before needing extenders

考题 If a technician is traveling outside of the US, which of the following should be checked before setting up a workstation? ()A、Local file formatB、Wattage settingC、Local power codesD、Voltage setting

考题 What two are the prerequisites for enabling Flashback Database?() (Choose two)A、The database must be in ARCHIVELOG modeB、The database must be in MOUNT EXCLUSIVE modeC、The database must be opened in RESTRICTED modeD、The database instance must be started in the NOMOUNT stateE、The database instance must have the keep buffer pool defined

考题 You are performing flashback of the EMPLOYEE table in SCOTT’s schema because some incorrect data was inserted into the table and committed by mistake. Which two clauses will you use in the FLASHBACK TABLE statement for using the Flashback Table feature? ()A、 RESETLOGSB、 TO TIMESTAMPC、 TO BEFORE DROPD、 RENAME TOE、 TO SCN

考题 You plan to execute the following command to perform a Flashback Database operation in your database:   SQL FLASHBACK DATABASE TO TIMESTAMP (SYSDATE -5/24);   Which two statements are true about this?()A、 The database must have multiplexed redo log filesB、 The database must be in the MOUNT state to execute the commandC、 The database must be in the NOMOUNT state to execute the commandD、 The database must be opened in RESTRICTED mode before this operationE、 The database must be opened with the RESETLOGS option after the flashback operation

考题 What two are the prerequisites for enabling Flashback Database?() A、 The database must be in ARCHIVELOG modeB、 The database must be in MOUNT EXCLUSIVE modeC、 The database must be opened in RESTRICTED modeD、 The database instance must be started in the NOMOUNT stateE、 The database instance must have the keep buffer pool defined

考题 Which two prerequisites are needed for performing workload capture and replay?()A、Close all sessions performing queries using database linksB、running the database in shared server modeC、The database on which the workload is replayed has to be a restore of the original database to a specific SCND、setting up the directory to capture the workload

考题 You are working on an Oracle Database 10g database. Because of data loss, you decided to perform a Flashback Database operation using the following command:  SQL FLASHBACK DATABASE TO TIMESTAMP(SYSDATE ?5/24); Which two statements are true? ()A、 SYSDATE should not be used with TIMESTAMP.B、 The database must have multiplexed redo log files.C、 The database must be in the MOUNT state to execute the command.D、 The database must be opened with the RESETLOGS option after the flashback operation.E、 The entire database needs to be restored from the most recent backup before the flashback operation.

考题 When setting up the Flashback Data Archive, which of these key parameters are required?()A、 Tablespace nameB、 Storage quotaC、 RetentionD、 Table nameE、 Create a default archive

考题 Which two are prerequisites for performing a flashback transaction?()A、Flashback Database must be enabled.B、Undo retention guarantee for the database must be configured.C、EXECUTE privilege on the DBMS_FLASHBACK package must be granted to the user flashing back transaction.D、Supplemental logging must be enabled.E、Recycle bin must be enabled for the database.F、Block change tracking must be enabled tor the database.

考题 Which three statements are true about Flashback Database?()A、Flashback logs are written sequentially, and are archived.B、Flashback Database uses a restored control file to recover a database.C、The Oracle database automatically creates, deletes, and resides flashback logs in the Fast RecoveryArea.D、Flashback Database can recover a database to the state that it was in before a reset logs operation.E、Flashback Database can recover a data file that was dropped during the span of time of the flashback.F、Flashback logs are used to restore to the blocks' before images, and then the redo data may be used to roll forward to the desired flashback time.

考题 Which two are the prerequisites to enable Flashback Data Archive?()A、 Database must be running in archivelog mode.B、 Automatic undo management must be enabled.C、 Undo retention guarantee must be enabled.D、 The tablespace on which the Flashback Data Archive is created must be managed with Automatic Segment Space Management (ASSM).

考题 单选题You are proceeding down a channel and lose the engine(s).You must use the anchors to stop the ship.Which statement is true().A Pay out all of the cable before setting up on the brake to insure the anchors dig in and holdB For a mud,mud and clay,or sandy bottom pay out a scope of 5 to 7 times the depth before setting up on the brakeC Use one or both anchors with a scope of twice the depth before setting the brakeD Drop the anchor to short stay and hold that scope

考题 多选题Which two of these correctly describe Fibre Channel?()Asupports multiple protocolsBworks only in a shared or loop environmentCallows addressing for up to 4 million nodesDallows addressing for up to 8 million nodesEprovides a high speed transport for SCSI payloadsFmay stretch to a distance of up to 100 km before needing extenders

考题 多选题You plan to execute the following command to perform a Flashback Database operation in your database: SQL FLASHBACK DATABASE TO TIMESTAMP (SYSDATE -5/24); Which two statements are true about this?()AThe database must have multiplexed redo log filesBThe database must be in the MOUNT state to execute the commandCThe database must be in the NOMOUNT state to execute the commandDThe database must be opened in RESTRICTED mode before this operationEThe database must be opened with the RESETLOGS option after the flashback operation

考题 多选题Which two are the prerequisites to enable Flashback Data Archive?()ADatabase must be running in archivelog mode.BAutomatic undo management must be enabled.CUndo retention guarantee must be enabled.DThe tablespace on which the Flashback Data Archive is created must be managed with Automatic Segment Space Management (ASSM).

考题 多选题When setting up the Flashback Data Archive, which of these key parameters are required?()ATablespace nameBStorage quotaCRetentionDTable nameECreate a default archive

考题 多选题Which two prerequisites are needed for performing workload capture and replay?()AClose all sessions performing queries using database linksBrunning the database in shared server modeCThe database on which the workload is replayed has to be a restore of the original database to a specific SCNDsetting up the directory to capture the workload

考题 多选题What two are the prerequisites for enabling Flashback Database?() (Choose two)AThe database must be in ARCHIVELOG modeBThe database must be in MOUNT EXCLUSIVE modeCThe database must be opened in RESTRICTED modeDThe database instance must be started in the NOMOUNT stateEThe database instance must have the keep buffer pool defined

考题 多选题Which two are prerequisites for performing a flashback transaction?()AFlashback Database must be enabled.BUndo retention guarantee for the database must be configured.CEXECUTE privilege on the DBMS_FLASHBACK package must be granted to the user flashing back transaction.DSupplemental logging must be enabled.ERecycle bin must be enabled for the database.FBlock change tracking must be enabled tor the database.

考题 多选题Which are the prerequisites for performing flashback transactions on your database?()AUndo retention guarantee for the database must be configured.BSupplemental log must be enabled for the primary key.CSupplemental log must be enabled.DExecute permission on the DBMS_FLASHBACK package must be granted to the user.

考题 多选题Which two are the prerequisites to enable Flashback Data Archive?() (Choose two.)ADatabase must be running in archivelog mode.BAutomatic undo management must be enabled.CUndo retention guarantee must be enabled.DThe tablespace on which the Flashback Data Archive is created must be managed with Automatic Segment Space Management (ASSM).

考题 多选题You are performing flashback of the EMPLOYEE table in SCOTT’s schema because some incorrect data was inserted into the table and committed by mistake. Which two clauses will you use in the FLASHBACK TABLE statement for using the Flashback Table feature? ()ARESETLOGSBTO TIMESTAMPCTO BEFORE DROPDRENAME TOETO SCN