多选题Which two statements are correct regarding the Flashback Versions Query feature?()AYou can use this feature to identify the committed versions of the rows, but not the uncommitted versions.BYou can use this feature to identify the versions of V$ views.

题目
多选题
Which two statements are correct regarding the Flashback Versions Query feature?()
A

You can use this feature to identify the committed versions of the rows, but not the uncommitted versions.

B

You can use this feature to identify the versions of V$ views.

C

You can use this feature to identify the inserts, deletes, and updates performed on a particular row but not the data definition language (DDL) operations performed on the table.

D

You can use this feature for a table only if row movement is enabled for the table.

E

You can use this feature to identify the versions of external and fixed tables.


相似考题
参考答案和解析
正确答案: C,B
解析: 暂无解析
更多“Which two statements are correct regarding the Flashback Ver”相关问题
  • 第1题:

    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.

    正确答案:A,C

  • 第2题:

    Which two of these statements regarding RSTP are correct? ()

    • A、RSTP cannot operate with PVST+.
    • B、RSTP defines new port roles.
    • C、RSTP defines no new port states.
    • D、RSTP is a proprietary implementation of IEEE 802.1D STP.
    • E、RSTP is compatible with the original IEEE 802.1D STP.

    正确答案:B,E

  • 第3题:

    Which two statements regarding JUNOS architecture are correct?()

    • A、The Routing Engine handles all exception traffic.
    • B、The Routing Engine synchronizes the route table with the PFE
    • C、The Routing Engine is hot-pluggable.
    • D、The Routing Engine controls the PFE

    正确答案:C,D

  • 第4题:

    Which two statements are correct regarding the Flashback Versions Query feature?()

    • A、 You can use this feature to identify the committed versions of the rows, but not the uncommitted versions.
    • B、 You can use this feature to identify the versions of V$ views.
    • C、 You can use this feature to identify the inserts, deletes, and updates performed on a particular row but not the data definition language (DDL) operations performed on the table.
    • D、 You can use this feature for a table only if row movement is enabled for the table.
    • E、 You can use this feature to identify the versions of external and fixed tables.

    正确答案:A,C

  • 第5题:

    These are the details about V$FLASHBACK_DATABASE_STAT: SQL> DESC v$FLASHBACK_DATABASE_STAT  Name                    Null?              Type  ------------- -------- --------------  BEGIN_TIME                               DATE  END_TIME                                 DATE  FLASHBACK_DATA                        NUMBER  DB_DATA                                  NUMBER  REDO_DATA                               NUMBER  ESTIMATED_FLASHBACK_SIZE             NUMBER  Which two statements regarding the V$FLASHBACK_DATABASE_STATview aretrue? ()

    • A、 BEGIN_TIME is the time at which Flashback logging is enabled.
    • B、 END_TIME is the time at which the query is executed on the view.
    • C、 REDO_DATA is the number of bytes of redo data written during the interval.
    • D、 This view contains information about flashback data pertaining to the last 24 hours.
    • E、 FLASHBACK_DATA is the amount of flashback data generated since the database was opened.

    正确答案:C,D

  • 第6题:

    多选题
    Which two statements regarding the FLASHBACK_TRANSACTION_QUERY view are correct?()
    A

    You can find information about only active transactions from the view

    B

    You can find information about read only transactions from the view

    C

    You require the SELECT ANY TRANSACTION system privilege to access the view

    D

    You can find information about both active and committed transactions from the view

    E

    You require the SELECT ON FLASHBACK_TRANSACTION_QUERY object privilege to access the view


    正确答案: A,D
    解析: 暂无解析

  • 第7题:

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


    正确答案: A,C
    解析: 暂无解析

  • 第8题:

    单选题
    You work as a database administrator at Certkiller .com. You are working in an online transaction processing (OLTP) environment. You realize that the salary for an employee, John, has been accidentally modified in the EMPLOYEEStable. Two days ago, the data was in the correct state. Flashback logs generated during last two days are available in the flash recovery area. Which option would you choose to bring the data to the correct state while ensuring that no other data in the same table is affected?()
    A

     perform point-in-time recovery

    B

     perform a Flashback Table operation to restore the table to the state it was in two days ago

    C

     perform a Flashback Database operation to restore the database to the state it was in two days ago

    D

     perform Flashback Versions Query and Flashback Transaction Query to determine all the necessary undo SQL statements, and then use them for recovery


    正确答案: C
    解析: 暂无解析

  • 第9题:

    单选题
    You are working in an online transaction processing (OLTP) environment. You realize that the salary for an employee, John, has been accidentally modified in the EMPLOYEES table. Two days ago, the data was in the correct state. Flashback logs generated during last two days are available in the flash recovery area.  Which option would you choose to bring the data to the correct state while ensuring that no other data in the same table is affected?()
    A

    perform point-in-time recovery

    B

    perform a Flashback Table operation to restore the table to the state it was in two days ago

    C

    perform a Flashback Database operation to restore the database to the state it was in two days ago

    D

    perform Flashback Versions Query and Flashback Transaction Query to determine all the necessary undo SQL statements, and then use them for recovery


    正确答案: D
    解析: 暂无解析

  • 第10题:

    多选题
    These are the details about V$FLASHBACK_DATABASE_STAT: SQL> DESC v$FLASHBACK_DATABASE_STAT  Name                    Null?              Type  ------------- -------- --------------  BEGIN_TIME                               DATE  END_TIME                                 DATE  FLASHBACK_DATA                        NUMBER  DB_DATA                                  NUMBER  REDO_DATA                               NUMBER  ESTIMATED_FLASHBACK_SIZE             NUMBER  Which two statements regarding the V$FLASHBACK_DATABASE_STATview aretrue? ()
    A

    BEGIN_TIME is the time at which Flashback logging is enabled.

    B

    END_TIME is the time at which the query is executed on the view.

    C

    REDO_DATA is the number of bytes of redo data written during the interval.

    D

    This view contains information about flashback data pertaining to the last 24 hours.

    E

    FLASHBACK_DATA is the amount of flashback data generated since the database was opened.


    正确答案: C,D
    解析: 暂无解析

  • 第11题:

    Which two statements regarding the Flashback Table feature are correct?()

    • A、Flashback Table can be performed on system tables.
    • B、Flashback Table operation does not shrink the segments.
    • C、Flashback Table uses log mining to extract SQL_REDO and SQL_UNDO statements.
    • D、Flashback Table operation acquires exclusive data manipulation language (DML) locks.

    正确答案:B,D

  • 第12题:

    Which two statements regarding SNMP monitoring of a UCS system are correct?()

    • A、SNMP v3 is supported
    • B、includes same MIBs as the Cisco Nexus7000
    • C、does not provides MIBs downstream of the fabric interconnect
    • D、includes same MIBs as the Cisco Nexus2000

    正确答案:A,C

  • 第13题:

    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 dropped
    • B、The flashback drop feature can recover only the table structure
    • C、Only the related indexes are dropped whereas views are invalidated
    • D、The flashback drop feature can recover both the table structure and its data

    正确答案:C,D

  • 第14题:

    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?()

    • A、 All the related indexes and views are automatically dropped
    • B、 The flashback drop feature can recover only the table structure
    • C、 Only the related indexes are dropped whereas views are invalidated
    • D、 The flashback drop feature can recover both the table structure and its data

    正确答案:C,D

  • 第15题:

    You executed the following FLASHBACK TABLE command: FLASHBACK TABLE emp TO TIMESTAMP (’11:45’,’hh12:mi’); Which two statements are correct? ()

    • A、 The FLASHBACK TABLE statement will not be written to the alert log file.
    • B、 The EMP table that was dropped by mistake from the database will be restored.
    • C、 The changes made to the EMP table since the specified time will be undone.
    • D、 The FLASHBACK TABLE statement will not maintain the existing indexes on the EMP table.
    • E、 The FLASHBACK TABLE statement will be executed within a single transaction.
    • F、 The list of transactions that have modified the EMP table since the specified time will be displayed.

    正确答案:C,E

  • 第16题:

    多选题
    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?()
    A

    All the related indexes and views are automatically dropped

    B

    The flashback drop feature can recover only the table structure

    C

    Only the related indexes are dropped whereas views are invalidated

    D

    The flashback drop feature can recover both the table structure and its data


    正确答案: B,D
    解析: 暂无解析

  • 第17题:

    多选题
    Which two statements are correct regarding MPLS LSP establishment methods?() (Choose two.)
    A

    LDP uses Down Stream On Demand.

    B

    RSVP uses Down Stream On Demand.

    C

    LDP uses Down Stream Unsolicited.

    D

    RSVP uses Down Stream Unsolicited.


    正确答案: B,C
    解析: 暂无解析

  • 第18题:

    多选题
    Which two statements regarding the Flashback Table feature are correct?()
    A

    Flashback Table can be performed on system tables.

    B

    Flashback Table operation does not shrink the segments.

    C

    Flashback Table uses log mining to extract SQL_REDO and SQL_UNDO statements.

    D

    Flashback Table operation acquires exclusive data manipulation language (DML) locks.


    正确答案: C,B
    解析: 暂无解析

  • 第19题:

    多选题
    Which two statements are correct regarding the default protocol preference values? ()
    A

    RIP is preferred over OSPF external routes

    B

    Direct, local and static routes have the same preference value

    C

    OSPF's preference value is lower than BGP

    D

    OSPF has a single preference value for both internal and external routes


    正确答案: D,C
    解析: 暂无解析

  • 第20题:

    多选题
    Which two statements regarding traceroute on JUNOS devices are correct?()
    A

    Traceroute transmits ICMP echo-request packets.

    B

    Traceroute transmits UDP packets.

    C

    Traceroute receives ICMP echo-reply packets.

    D

    Traceroute receives ICMP port-unreachable packets.


    正确答案: B,A
    解析: 暂无解析