网友您好, 请在下方输入框内输入要搜索的题目:

题目内容 (请给出正确答案)

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)

参考答案

更多 “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)” 相关考题
考题 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)

考题 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 two table types are CEF components?()A、forwarding information baseB、adjacency tablesC、neighbor tablesD、caching tablesE、route tables

考题 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.

考题 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.

考题 While designing the database for one of your online transaction processing (OLTP) applications, you want to achieve the following:  a) high availability of data  b) faster primary key access to the table data  c) compact storage for the table  Which type of tables would you use to achieve these objectives?() A、heap tablesB、object tablesC、partitioned tablesD、index-organized tables (IOTs)

考题 Your Oracle Database 10g is online when you execute the following statement:        SQLALTER TABLESPACE MY_TABLESPACE FLASHBACK OFF;   What is the result of executing this statement if the Flashback Database feature is already enabled in the database?()A、 The database does not record flashback logs for MY_TABLESPACEB、 The tables residing in MY_TABLESPACE are not protected by the Recycle Bin.C、 All the tablespaces except MY_TABLESPACE can be recovered using Flashback Database feature.D、 None of the flashback technologies, such as Flashback Table, Flashback Transaction Query and Flashback Version Query can be used to recover individual rows within the objects from MY_TABLESPACE

考题 While designing the database for one of your online transaction processing (OLTP) applications, you want to achieve the following:  a) high availability of data  b) faster primary key access to the table data  c) compact storage for the table  Which type of tables would you use to achieve these objectives?()A、heap tablesB、object tablesC、partitioned tablesD、index­organized tables (IOTs)

考题 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

考题 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

考题 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.

考题 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 two statements are true regarding the USING and ON clauses in table joins?()A、Both USING and ON clauses can be used for equijoins and nonequijoins B、Amaximum of one pair of columns can be joined between two tables using the ON clause C、The ON clause can be used to join tables on columns that have different names but compatible data types D、The WHERE clause can be used to apply additional conditions in SELECT statements containing the ON or the USING clause 

考题 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.

考题 Which pseudocolumn could you use to identify a unique row in a Flashback Versions Query?()A、 XIDB、 VERSIONS_PKC、 VERSIONS_XIDD、 VERSIONS_UNIQUE

考题 单选题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.

考题 单选题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

考题 单选题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.

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

考题 单选题Your Oracle Database 10g is online when you execute the following statement:        SQLALTER TABLESPACE MY_TABLESPACE FLASHBACK OFF;   What is the result of executing this statement if the Flashback Database feature is already enabled in the database?()A  The database does not record flashback logs for MY_TABLESPACEB  The tables residing in MY_TABLESPACE are not protected by the Recycle Bin.C  All the tablespaces except MY_TABLESPACE can be recovered using Flashback Database feature.D  None of the flashback technologies, such as Flashback Table, Flashback Transaction Query and Flashback Version Query can be used to recover individual rows within the objects from MY_TABLESPACE

考题 单选题While designing the database for one of your online transaction processing (OLTP) applications, you want to achieve the following:  a) high availability of data  b) faster primary key access to the table data  c) compact storage for the table  Which type of tables would you use to achieve these objectives?()A  heap tablesB  object tablesC  partitioned tablesD  index-organized tables (IOTs)

考题 单选题Which pseudocolumn could you use to identify a unique row in a Flashback Versions Query?()A  XIDB  VERSIONS_PKC  VERSIONS_XIDD  VERSIONS_UNIQUE