单选题Which of the following statements best describes Flashback Versions Query？（）AFlashback Versions Query is used to make changes to multiple versions of data that existed between two points in time.BFlashback Versions Query is used to view all version cha

题目
单选题
Which of the following statements best describes Flashback Versions Query？（）
A

 Flashback Versions Query is used to make changes to multiple versions of data that existed between two points in time.

B

 Flashback Versions Query is used to view all version changes on rows that existed between the time  the query was executed and a point in time in the past.

C

 Flashback Versions Query is used to view version changes and the SQL to undo those changes on rows that existed between two points in time.

D

 Flashback Versions Query is used to view all version changes on rows that existed between two  points in time.

相似考题

1.On which two database objects can the VERSIONS clause of the Flashback Versions Query be used?()A. fixed tablesB. heap tablesC. external tablesD. temporary tablesE. Index-Organized Tables (IOTs)

2.Which of the following statements best describes Flashback Versions Query？（）  A、 Flashback Versions Query is used to make changes to multiple versions of data that existed between two points in time.B、 Flashback Versions Query is used to view all version changes on rows that existed between the time  the query was executed and a point in time in the past.C、 Flashback Versions Query is used to view version changes and the SQL to undo those changes on rows that existed between two points in time.D、 Flashback Versions Query is used to view all version changes on rows that existed between two points in time.

3.Which of the following statements is true regarding the VERSIONS BETWEEN clause？（）  A、 The VERSIONS BETWEEN clause may be used in DML statements.B、 The VERSIONS BETWEEN clause may be used in DDL statements.C、 The VERSIONS BETWEEN clause may not be used to query past DDL changes to tables.D、 The VERSIONS BETWEEN clause may not be used to query past DML statements to tables.

4.For which two database objects can the VERSIONS clause of the Flashback Versions Query be used?()(Choose two.)A. viewsB. fixed tablesC. heap tablesD. external tablesE. temporary tablesF. index-organized tables (IOT)

更多“单选题Which of the following statements best describes Flashback Versions Query？（）A  Flashback Versions Query is used to make changes to multiple versions of data that existed between two points in time.B  Flashback Versions Query is used to view all version”相关问题

  • 第1题：

    By mistake， you ran the batch job （for updating the BILL_DETAILS table） twice. You are not sure which rows in the BILL_DETAILS table were affected. You need to identify：  a） a list of changes made along with the transaction identifier of each change  b） the necessary SQL statements to undo the erroneous changes  Which option would you choose？（）

    • A、RMAN only
    • B、Flashback Table only
    • C、Flashback Versions Query only
    • D、Flashback Database and Flashback Transaction Query
    • E、Flashback Versions Query and Flashback Transaction Query

    正确答案:E

  • 第2题：

    You are maintaining your OLTP database in Oracle10g. You are performing the Flashback Transaction Query to find the undo SQL statements that can be used to undo the changes made to the database in the specific time period. Which pseudocolumn will you use to perform the Flashback Transaction Query？（）

    • A、 VERSIONS_STARTSCN
    • B、 VERSIONS_STARTTIME
    • C、 VERSIONS_XID
    • D、 VERSIONS_OPERATION

    正确答案:C

  • 第3题：

    Which of the following can be used in conjunction with a Flashback Versions Query to filter the results？（）

    • A、 A range of SCN values
    • B、 A list of SCN values
    • C、 A starting and ending timestamp
    • D、 Minimum and maximum sequence values
    • E、 A list of sequence values

    正确答案:A,C

  • 第4题：

    For which two database objects can the VERSIONS clause of the Flashback Versions Query be used?（）(Choose two.)

    • A、views
    • B、fixed tables
    • C、heap tables
    • D、external tables
    • E、temporary tables
    • F、index-organized tables (IOT)

    正确答案:C,F

  • 第5题：

    Which statement is true regarding Flashback Version Query？ （）

    • A、 It returns versions of rows only within a transaction.
    • B、 It can be used in subqueries contained only in a SELECT statement.
    • C、 It will return an error if the undo retention time is less than the lower bound time or SCN specified.
    • D、 It retrieves all versions including the deleted as well as subsequently reinserted versions of the rows.

    正确答案:D

  • 第6题：

    Which pseudocolumn could you use to identify a unique row in a Flashback Versions Query？（）

    • A、 XID
    • B、 VERSIONS_PK
    • C、 VERSIONS_XID
    • D、 VERSIONS_UNIQUE

    正确答案:C

  • 第7题：

    多选题
    For which two database objects can the VERSIONS clause of the Flashback Versions Query be used?（）(Choose two.)
    A

    views

    B

    fixed tables

    C

    heap tables

    D

    external tables

    E

    temporary tables

    F

    index-organized tables (IOT)


    正确答案： F,A
    解析： 暂无解析

  • 第8题：

    单选题
    You are maintaining your OLTP database in Oracle10g. You are performing the Flashback Transaction Query to find the undo SQL statements that can be used to undo the changes made to the database in the specific time period. Which pseudocolumn will you use to perform the Flashback Transaction Query？（）
    A

     VERSIONS_STARTSCN

    B

     VERSIONS_STARTTIME

    C

     VERSIONS_XID

    D

     VERSIONS_OPERATION


    正确答案： A
    解析： 暂无解析

  • 第9题：

    单选题
    View the Exhibits. You performed operations on the DEPT4 table as shown in the Exhibit. When you perform the FlashbackVersions Query， you find that the first two updates are not listed. What could be the reason？（）
    A

    The row movement is not enabled on the table.

    B

    The first two updates were not explicitly committed.

    C

    The Flashback Versions Query lists only the most recent update.

    D

    The Flashback Versions Query stops producing rows after it encounters a time in the past when the  table structure was changed.


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

  • 第10题：

    单选题
    A user named Arren is executing this query：   select table_name，operation，undo_sql  from  flashback_transaction_query t，  （select versions_xid as xid  from employees versions between scn minvalue and maxvalue  where employee_id = 123） e  where t.xid = e.xid；   When the query runs，he receives an ORA-01031： insufficient privileges error. Since the user owns the employees table，you know that it is not the problem.  Which of the following SQL statements will correct this problem？（）
    A

     GRANT SELECT ANY TRANSACTION TO ARREN

    B

     GRANT SELECT ON FLASHBACK_TRANSACTION_QUERY TO ARREN

    C

     GRANT SELECT_ANY_TRANSACTION TO ARREN

    D

     GRANT FLASHBACK TO ARREN

    E

     GRANT SELECT ANY VIEW TO ARREN


    正确答案： B
    解析： 暂无解析

  • 第11题：

    单选题
    Over the course of a day，a department performed multiple DML statements （inserts， updates， deletes） on multiple rows of data in multiple tables. The manager would like a report showing the time， table name，and DML type for all changes that were made. Which Flashback technology would be the best choice to produce the list？（）
    A

     Flashback Drop

    B

     Flashback Query

    C

     Flashback Transaction Query

    D

     Flashback Versions Query

    E

     Flashback Table


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

  • 第12题：

    多选题
    Which of the following can be used in conjunction with a Flashback Versions Query to filter the results？（）
    A

    A range of SCN values

    B

    A list of SCN values

    C

    A starting and ending timestamp

    D

    Minimum and maximum sequence values

    E

    A list of sequence values


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

  • 第13题：

    On which two database objects can the VERSIONS clause of the Flashback Versions Query be used?（）

    • A、fixed tables
    • B、heap tables
    • C、external tables
    • D、temporary tables
    • E、Index-Organized Tables (IOTs)

    正确答案:B,E

  • 第14题：

    Over the course of a day，a department performed multiple DML statements （inserts， updates， deletes） on multiple rows of data in multiple tables. The manager would like a report showing the time， table name，and DML type for all changes that were made. Which Flashback technology would be the best choice to produce the list？（）

    • A、 Flashback Drop
    • B、 Flashback Query
    • C、 Flashback Transaction Query
    • D、 Flashback Versions Query
    • E、 Flashback Table

    正确答案:C

  • 第15题：

    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

  • 第16题：

    By using the transaction identifier provided by （） for a particular row change， you can use theFlashback Transaction Query to see the operation performed by the transaction. 

    • A、Flashback Table
    • B、Flashback Database
    • C、Flashback Versions Query
    • D、the RMAN REPORT command
    • E、the DBA_PENDING_TRANSACTIONS view

    正确答案:C

  • 第17题：

    By using the transaction identifier provided by （） for a particular row change， you can use the Flashback Transaction Query to see the operation performed by the transaction. 

    • A、Flashback Table
    • B、Flashback Database
    • C、Flashback Versions Query
    • D、the RMAN REPORT command
    • E、the DBA_PENDING_TRANSACTIONS view

    正确答案:C

  • 第18题：

    单选题
    Which statement is true regarding Flashback Version Query？（）
    A

     It returns versions of rows only within a transaction.

    B

     It can be used in subqueries contained only in a SELECT statement.

    C

     It will return an error if the undo retention time is less than the lower bound time or SCN specified.

    D

     It retrieves all versions including the deleted as well as subsequently reinserted versions of the rows.


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

  • 第19题：

    多选题
    On which two database objects can the VERSIONS clause of the Flashback Versions Query be used?（）
    A

    fixed tables

    B

    heap tables

    C

    external tables

    D

    temporary tables

    E

    Index-Organized Tables (IOTs)


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

  • 第20题：

    单选题
    Which of the following statements best describes Flashback Versions Query？（）
    A

     Flashback Versions Query is used to make changes to multiple versions of data that existed between two points in time.

    B

     Flashback Versions Query is used to view all version changes on rows that existed between the time  the query was executed and a point in time in the past.

    C

     Flashback Versions Query is used to view version changes and the SQL to undo those changes on rows that existed between two points in time.

    D

     Flashback Versions Query is used to view all version changes on rows that existed between two  points in time.


    正确答案： B
    解析： 暂无解析

  • 第21题：

    单选题
    By mistake， you ran the batch job （for updating the BILL_DETAILS table） twice. You are not sure which rows in the BILL_DETAILS table were affected. You need to identify：  a） a list of changes made along with the transaction identifier of each change  b） the necessary SQL statements to undo the erroneous changes  Which option would you choose？（）
    A

    RMAN only

    B

    Flashback Table only

    C

    Flashback Versions Query only

    D

    Flashback Database and Flashback Transaction Query

    E

    Flashback Versions Query and Flashback Transaction Query


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

  • 第22题：

    单选题
    Which of the following statements is true regarding the VERSIONS BETWEEN clause？（）
    A

     The VERSIONS BETWEEN clause may be used in DML statements.

    B

     The VERSIONS BETWEEN clause may be used in DDL statements.

    C

     The VERSIONS BETWEEN clause may not be used to query past DDL changes to tables.

    D

     The VERSIONS BETWEEN clause may not be used to query past DML statements to tables.


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

  • 第23题：

    单选题
    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
    解析： 暂无解析

  • 第24题：

    单选题
    Which pseudocolumn could you use to identify a unique row in a Flashback Versions Query？（）
    A

     XID

    B

     VERSIONS_PK

    C

     VERSIONS_XID

    D

     VERSIONS_UNIQUE


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

相关内容