多选题Which of the following can be used in conjunction with a Flashback Versions Query to filter the results？（）AA range of SCN valuesBA list of SCN valuesCA starting and ending timestampDMinimum and maximum sequence valuesEA list of sequence values

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

相似考题

1.Note the following statements that use flashback technology:1. FLASHBACK TABLE <table> TO SCN <scn>;2. SELECT * FROM <table> AS OF SCN 123456;3. FLASHBACK TABLE <table> TO BEFORE DROP;4. FLASHBACK DATABASE TO TIMESTAMP <timestamp>;5. SELECT * FROM <table> VERSIONS AS OF SCN 123456 AND 123999;Which of these statements will be dependent on the availability of relevant undo data in the undo segment?（）A. 1, 2, and 5B. 1, 3, and 4C. 2, 3, 4, and 5D. 1, 2, 3, 4, and 5

2.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)

3.Given the following ALTER SEQUENCE statement: ALTER SEQUENCE myseq RESTART WITH 0 INCREMENT BY 1 NO MAXVALUE CACHE 5 ORDER Assuming that the sequence had reached a value of 100 prior to the RESTART, which of the following is true?（）A、The next value will be 0 and the sequence will never use the values 101 to 105.B、The next value will be 101 to ensure uniqueness between existing and newly generated sequence values.C、Previously cached values are retained by DB2, and after the restart, will be used for values 101 to 105.D、The next value will be 0 and DB2 will not ensure uniqueness between existing and newly generated values.

4.The EMP table has some discrepancy in data entry with a particular employee ID. You execute the query as shown in the Exhibit to retrieve all versions of the row that exist between two SCNs.View the Exhibit.Which two statements about the results of the query shown in the Exhibit are correct?（）A. The LAST_SCN value in the first row is NULL, which means that the versions of the row still exist at SCN 6636300. LAST_SCNB. The LAST_SCN value in the second row in NULL, which means that the version of the row still exists at SCN 6636300.C. The LAST_SCN value in the third row is 6636280, which means that the version of row exists above SCN 6636280.D. The LAST_SCN value in the second row is NULL, which means that the version of the row no longer exists because it was deleted. LAST_SCN

更多“多选题Which of the following can be used in conjunction with a Flashback Versions Query to filter the results？（）AA range of SCN valuesBA list of SCN valuesCA starting and ending timestampDMinimum and maximum sequence valuesEA list of sequence values”相关问题

  • 第1题：

    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.

    正确答案:D

  • 第2题：

    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

  • 第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题：

    You executed the following query in your database： SELECT oldest_flashback_scn， oldest_flashback_time FROM V$FLASHBACK_DATABASE_LOG； What would you determine from the output？（）

    • A、 The time when the last flashback operation in your database was performed.
    • B、 The time when the first flashback operation in your database was performed.
    • C、 A list of flashback operations performed in your database using SCN and time.
    • D、 The approximate time and the lowest system change number （SCN） to which you can flash back your database.

    正确答案:D

  • 第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题：

    You executed the following query in your database：  FROM V$FLASHBACK_DATABASE_LOG;  What would you determine from the output？（）

    • A、the time when the last flashback operation in your database was performed
    • B、the time when the first flashback operation in your database was performed
    • C、a list of flashback operations performed in your database using SCN and time
    • D、the approximate time and the lowest system change number （SCN） to which you can flash back your database

    正确答案:D

  • 第7题：

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

  • 第8题：

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

  • 第9题：

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

  • 第10题：

    多选题
    The EMP table has some discrepancy in data entry with a particular employee ID. You execute the query as shown in the Exhibit to retrieve all versions of the row that exist between two SCNs. View the Exhibit. Which two statements about the results of the query shown in the Exhibit are correct?（）
    A

    The LAST_SCN value in the first row is NULL, which means that the versions of the row still exist at SCN 6636300. LAST_SCN

    B

    The LAST_SCN value in the second row in NULL, which means that the version of the row still exists at SCN 6636300.

    C

    The LAST_SCN value in the third row is 6636280, which means that the version of row exists above SCN 6636280.

    D

    The LAST_SCN value in the second row is NULL, which means that the version of the row no longer exists because it was deleted. LAST_SCN


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

  • 第11题：

    多选题
    Which of the following three BGP filtering methods enabled with the neighbor command  will filter BGP prefixes based on the prefix and prefix length？（）
    A

    A neighbor distribute - list out command, referencing a standard ACL

    B

    A neighbor prefix - list out command

    C

    A neighbor filter - list out command

    D

    A neighbor distribute - list  out command, referencing an extended ACL

    E

    A neighbor route - map out command


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

  • 第12题：

    多选题
    Which two statements about sequences are true?（）
    A

    You use a NEXTVAL pseudo column to look at the next possible value that would be generated from a sequence, without actually retrieving the value.

    B

    You use a CURRVAL pseudo column to look at the current value just generated from a sequence, without affecting the further values to be generated from the sequence.

    C

    You use a NEXTVAL pseudo column to obtain the next possible value from a sequence by actually retrieving the value from the sequence.

    D

    You use a CURRVAL pseudo column to generate a value from a sequence that would be used for a specified database column.

    E

    If a sequence starting from a value 100 and incremented by 1 is used by more then one application, then all of these applications could have a value of 105 assigned to their column whose value is being generated by the sequence.

    F

    You use REUSE clause when creating a sequence to restart the sequence once it generates the maximum value defined for the sequence.


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

  • 第13题：

    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

  • 第14题：

    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

  • 第15题：

    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

  • 第16题：

    Which two statements about sequences are true? （）

    • A、You use a NEXTVAL pseudo column to look at the next possible value that would be generated from a sequence, without actually retrieving the value.
    • B、You use a CURRVAL pseudo column to look at the current value just generated from a sequence, without affecting the further values to be generated from the sequence.
    • C、You use a NEXTVAL pseudo column to obtain the next possible value from a sequence by actually retrieving the value from the sequence.
    • D、You use a CURRVAL pseudo column to generate a value from a sequence that would be used for a specified database column.
    • E、If a sequence starting from a value 100 and incremented by 1 is used by more then one application, then all of these applications could have a value of 105 assigned to their column whose value is being generated by the sequence.
    • F、You use REUSE clause when creating a sequence to restart the sequence once it generates the maximum value defined for the sequence.

    正确答案:B,C

  • 第17题：

    You are working in an online transaction processing （OLTP） environment. You used the FLASHBACK TABLE command to flash back the CUSTOMERS table. Before executing the FLASHBACK TABLE command， the System Change Number （SCN） was 663571. After flashing back the CUSTOMERS table， you realize that the table is not in the correct state and the resultant changes are not what you had desired. So， you need to reverse the effects of the FLASHBACK TABLE command while ensuring that：  a） No other user data in the database is affected.  b） The operation takes the minimum possible time.  Which option would you choose？（）

    • A、use the ROLLBACK command with SCN 663571
    • B、perform Flashback Transaction Query with SCN 663571
    • C、execute the FLASHBACK DATABASE statement to retrieve the CUSTOMERS table as it was at SCN 663571
    • D、execute another FLASHBACK TABLE statement to retrieve the CUSTOMERS table as it was at SCN 663571

    正确答案:D

  • 第18题：

    单选题
    Note the following statements that use flashback technology: 1. FLASHBACK TABLE TO SCN ; 2. SELECT * FROM AS OF SCN 123456; 3. FLASHBACK TABLE TO BEFORE DROP; 4. FLASHBACK DATABASE TO TIMESTAMP ; 5. SELECT * FROM VERSIONS AS OF SCN 123456 AND 123999; Which of these statements will be dependent on the availability of relevant undo data in the undo segment?（）
    A

    1, 2, and 5

    B

    1, 3, and 4

    C

    2, 3, 4, and 5

    D

    1, 2, 3, 4, and 5


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

  • 第19题：

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

  • 第20题：

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

  • 第21题：

    单选题
    You executed the following query in your database：  FROM V$FLASHBACK_DATABASE_LOG;  What would you determine from the output？（）
    A

    the time when the last flashback operation in your database was performed

    B

    the time when the first flashback operation in your database was performed

    C

    a list of flashback operations performed in your database using SCN and time

    D

    the approximate time and the lowest system change number （SCN） to which you can flash back your database


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

  • 第22题：

    单选题
    You executed the following query in your database： SELECT oldest_flashback_scn， oldest_flashback_time FROM V$FLASHBACK_DATABASE_LOG； What would you determine from the output？（）
    A

     The time when the last flashback operation in your database was performed.

    B

     The time when the first flashback operation in your database was performed.

    C

     A list of flashback operations performed in your database using SCN and time.

    D

     The approximate time and the lowest system change number （SCN） to which you can flash back your database.


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

  • 第23题：

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

  • 第24题：

    单选题
    Which of the following is a characteristic of a sequence?（）
    A

    A sequence will never generate duplicate values

    B

    The MAXVALUE of a sequence can be equal to the MINVALUE

    C

    It is not possible to create a sequence that generates a constant since the INCREMENT value must be greater than zero

    D

    When a sequence cycles back to either the MAXVALUE or MINVALUE, it will always be equal to the specified value of either of these two boundaries


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

相关内容