多选题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
参考解析
解析：
暂无解析
相关考题：
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
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
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)
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.
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.
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 onlyB、Flashback Table onlyC、Flashback Versions Query onlyD、Flashback Database and Flashback Transaction QueryE、Flashback Versions Query and Flashback Transaction Query
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)
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_STARTSCNB、 VERSIONS_STARTTIMEC、 VERSIONS_XIDD、 VERSIONS_OPERATION
Which of the following can be used in conjunction with a Flashback Versions Query to filter the results？（）A、 A range of SCN valuesB、 A list of SCN valuesC、 A starting and ending timestampD、 Minimum and maximum sequence valuesE、 A list of sequence values
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)
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.
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.
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.
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 663571B、perform Flashback Transaction Query with SCN 663571C、execute the FLASHBACK DATABASE statement to retrieve the CUSTOMERS table as it was at SCN 663571D、execute another FLASHBACK TABLE statement to retrieve the CUSTOMERS table as it was at SCN 663571
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 performedB、the time when the first flashback operation in your database was performedC、a list of flashback operations performed in your database using SCN and timeD、the approximate time and the lowest system change number （SCN） to which you can flash back your database
单选题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?（）A1, 2, and 5B1, 3, and 4C2, 3, 4, and 5D1, 2, 3, 4, and 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.
多选题For which two database objects can the VERSIONS clause of the Flashback Versions Query be used?（）(Choose two.)AviewsBfixed tablesCheap tablesDexternal tablesEtemporary tablesFindex-organized tables (IOT)
多选题On which two database objects can the VERSIONS clause of the Flashback Versions Query be used?（）Afixed tablesBheap tablesCexternal tablesDtemporary tablesEIndex-Organized Tables (IOTs)
单选题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_STARTSCNB VERSIONS_STARTTIMEC VERSIONS_XIDD VERSIONS_OPERATION
单选题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.
单选题You executed the following query in your database： FROM V$FLASHBACK_DATABASE_LOG; What would you determine from the output？（）Athe time when the last flashback operation in your database was performedBthe time when the first flashback operation in your database was performedCa list of flashback operations performed in your database using SCN and timeDthe approximate time and the lowest system change number （SCN） to which you can flash back your database
多选题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?（）AThe LAST_SCN value in the first row is NULL, which means that the versions of the row still exist at SCN 6636300. LAST_SCNBThe LAST_SCN value in the second row in NULL, which means that the version of the row still exists at SCN 6636300.CThe LAST_SCN value in the third row is 6636280, which means that the version of row exists above SCN 6636280.DThe 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
单选题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.
多选题Which of the following three BGP filtering methods enabled with the neighbor command will filter BGP prefixes based on the prefix and prefix length？（）AA neighbor distribute - list out command, referencing a standard ACLBA neighbor prefix - list out commandCA neighbor filter - list out commandDA neighbor distribute - list out command, referencing an extended ACLEA neighbor route - map out command
多选题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 two statements about sequences are true?（）AYou use a NEXTVAL pseudo column to look at the next possible value that would be generated from a sequence, without actually retrieving the value.BYou 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.CYou use a NEXTVAL pseudo column to obtain the next possible value from a sequence by actually retrieving the value from the sequence.DYou use a CURRVAL pseudo column to generate a value from a sequence that would be used for a specified database column.EIf 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.FYou use REUSE clause when creating a sequence to restart the sequence once it generates the maximum value defined for the sequence.
单选题Which of the following is a characteristic of a sequence?（）AA sequence will never generate duplicate valuesBThe MAXVALUE of a sequence can be equal to the MINVALUECIt is not possible to create a sequence that generates a constant since the INCREMENT value must be greater than zeroDWhen 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