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

题目
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).

相似考题

1.以下程序段的输出结果为 ( )int j=2；switch(j){case 2：System.out.print("two.")；case 2+1：System.out.println("three.")；breakdefault：System.out.println("value is"+j)；break；}A．two.three.B．two.C．three.D．value is 2

2.Youarerequiredtoflashbackyourdatabase.Youwanttofindtheamountofflashbackdatageneratedsincethedatabasewasopened.Whichtaskwillyouperformtoobtaintherequiredinformation?()A.QuerytheV$FLASHBACK_DATABASE_LOGview.B.QuerytheV$FLASHBACK_DATABASE_STATview.C.CheckthevalueoftheDB_FLASHBACK_RETENTION_TARGETinitializationparameter.D.QuerytheV$RECOVERY_FILE_DESTview.

3.Which two statements are true when row archival management is enabled?()A. The ORA_ARCHIVE_STATE column visibility is controlled by the ROW ARCHIVAL VISIBILITY session parameter.B. The ORA_ARCHIVE_STATE column is updated manually or by a program that could reference activity tracking columns, to indicate that a row is no longer considered active.C. The ROW ARCHIVAL VISIBILITY session parameter defaults to active rows only.D. The ORA_ARCHIVE_STATE column is visible if referenced in the select list of a query.E. The ORA_ARCHIVE_STATE column is updated automatically by the Oracle Server based on activity tracking columns, to Indicate that a row is no longer considered active.

4.ThesearethedetailsaboutV$FLASHBACK_DATABASE_STAT：SQL>DESCV$FLASHBACK_DATABASE_STATNameNull？Type-----------------------------------BEGIN_TIMEDATEEND_TIMEDATEFLASHBACK_DATANUMBERDB_DATANUMBERREDO_DATANUMBERESTIMATED_FLASHBACK_SIZENUMBERWhichtwostatementsregardingtheV$FLASHBACK_DATABASE_STATviewaretrue？（）A.BEGIN_TIMEisthetimeatwhichFlashbackloggingisenabled.B.END_TIMEisthetimeatwhichthequeryisexecutedontheview.C.REDO_DATAisthenumberofbytesofredodatawrittenduringtheinterval.D.Thisviewcontainsinformationaboutflashbackdatapertainingtothelast24hours.E.FLASHBACK_DATAistheamountofflashbackdatageneratedsincethedatabasewasopened.

更多“Which are the two prerequisites before setting up Flashback Data Archive? ()(Choose two.) ”相关问题

  • 第1题：

    You create a table with the PERIOD FOR clause to enable the use of the Temporal Validity feature of Oracle Database 12c. Examine the table definition:Which three statements are true concerning the use of the Valid Time Temporal feature for the EMPLOYEES table?（）

    A. The valid time columns employee_time_start and employee_time_end are automatically created.

    B. The same statement may filter on both transaction time and valid temporal time by using the AS OF TIMESTAMP and PERIOD FOR clauses.

    C. The valid time columns are not populated by the Oracle Server automatically.

    D. The valid time columns are visible by default when the table is described.

    E. Setting the session valid time using DBMS_FLASHBACK_ARCHIVE.ENABLE_AT_VALID_TIME sets the visibility for data manipulatio


    参考答案：A, B, E

  • 第2题：

    以下程序段的输出结果为( )。 int j=2 switch (j){ Case 2： system.out.print("two.")： Case 2+1： System.out.println("three.")； break： default: System.out.println (“value is”+j): Break }A.B.two

    A．two.three.

    B．two

    C．three

    D．value is 2


    正确答案：A

  • 第3题：

    WhichofthefollowingareassociatedwiththeapplicationlayeroftheOSImodel?(two.)()

    A.ping

    B.Telnet

    C.FTP

    D.TCP

    E.IP


    参考答案：B, C

  • 第4题：

    Youexecutedthefollowingqueryinyourdatabase:SELECToldest_flashback_scn,oldest_flashback_timeFROMV$FLASHBACK_DATABASE_LOG;Whatwouldyoudeterminefromthe output?()

    A.Thetimewhenthelastflashbackoperationinyourdatabasewasperformed.

    B.Thetimewhenthefirstflashbackoperationinyourdatabasewasperformed.

    C.AlistofflashbackoperationsperformedinyourdatabaseusingSCNandtime.

    D.Theapproximatetimeandthelowestsystemchangenumber（SCN）towhichyoucanflashbackyourdatabase.


    参考答案：D

  • 第5题：

    Whichinitializationparametermustyousettoenableautomaticarchiving?()

    A.LOG_ARCHIVE_DEST

    B.LOG_ARCHIVE_START

    C.LOG_ARCHIVE_FORMAT

    D.LOG_ARCHIVE_MAX_PROCESSES


    参考答案：B

  • 第6题：

    对于以下代码描述有误的是？ val data = Map（1 -＞ "One", 2 -＞ "Two") val res = for（（k, v) ＜- data; if（k ＞ 1)) yield v

    A．运行后res的结果为List("Two")

    B．运行后res的结果为List("One", "Two")

    C．对映射data中的每一个(键，值)对，k被绑定对键，而v则被绑定到值

    D．其中的if(k ＞ 1)是一个守卫表达式


    B

相关内容