单选题Which of the following statements is true regarding the VERSIONS BETWEEN clause？（）AThe VERSIONS BETWEEN clause may be used in DML statements.BThe VERSIONS BETWEEN clause may be used in DDL statements.CThe VERSIONS BETWEEN clause may not be used to quer

第1题：

The relationship between the embedded clause and its matrix clause is one of a part to the whole.

第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 two statements are true about WHERE and HAVING clauses? （）

• A、A WHERE clause can be used to restrict both rows and groups.
• B、A WHERE clause can be used to restrict rows only.
• C、A HAVING clause can be used to restrict both rows and groups.
• D、A HAVING clause can be used to restrict groups only.
• E、A WHERE clause CANNOT be used in a query of the query uses a HAVING clause.
• F、A HAVING clause CANNOT be used in subqueries.

第4题：

Which two statements are true regarding the ORDER BY clause? （）

• A、It is executed first in the query execution 
• B、It must be the last clause in the SELECT statement 
• C、It cannot be used in a SELECT statement containing a HAVING clause
• D、You cannot specify a column name followed by an expression in this clause 
• E、You can specify a combination of numeric positions and column names in this clause

第5题：

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)

第6题：

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 

第7题：

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

What is the use of an "all configuration" backup in Cisco UCS？（）

• A、 Can be used to migrate from a 6120 to a 6140 and retain the same service profiles
• B、 Can only be used on the fabric interconnect on which it was created
• C、 Can be used to migrate from a 6120 to 6140 and retain system IP addresses and cluster information
• D、 Can be used to match firmware versions between 6120 and 6140 during a migration

第14题：

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.

第15题：

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)

第16题：

In which four clauses can a subquery be used? （）

• A、in the INTO clause of an INSERT statement
• B、in the FROM clause of a SELECT statement
• C、in the GROUP BY clause of a SELECT statement
• D、in the WHERE clause of a SELECT statement
• E、in the SET clause of an UPDATE statement
• F、in the VALUES clause of an INSERT statement

第17题：

Where can subqueries be used?（）

• A、field names in the SELECT statement 
• B、the FROM clause in the SELECT statement 
• C、the HAVING clause in the SELECT statement
• D、the GROUP BY clause in the SELECT statement 
• E、the WHERE clause in only the SELECT statement 
• F、the WHERE clause in SELECT as well as all DML statements

第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.

第19题：

第20题：

第21题：

第22题：

第23题：

第24题：