Which two statements regarding the LOGGING clause of the CRE

第1题：

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.

第2题：

Which two statements are true regarding high-availability chassis clustering？（）

• A、A chassis cluster consists of two devices.
• B、A chassis cluster consists of two or more devices.
• C、Devices participating in a chassis cluster can be different models.
• D、Devices participating in a chassis cluster must be the same models

第3题：

第4题：

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 if the query uses a HAVING clause.
• F、A HAVING clause CANNOT be used in subqueries.

第5题：

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

• A、The sort is in ascending by order by default.
• B、The sort is in descending order by default.
• C、The ORDER BY clause must precede the WHERE clause.
• D、The ORDER BY clause is executed on the client side.
• E、The ORDER BY clause comes last in the SELECT statement.
• F、The ORDER BY clause is executed first in the query execution.

第6题：

Which two statements about views are true? （）

• A、A view can be created as read only.
• B、A view can be created as a join on two or more tables.
• C、A view cannot have an ORDER BY clause in the SELECT statement.
• D、A view cannot be created with a GROUP BY clause in the SELECT statement.
• E、A view must have aliases defined for the column names in the SELECT statement.

第7题：

Which two statements are true regarding L2TP? （）(Choose two.)

• A、Tunnels are initiated by the LAC
• B、Tunnels are initiated by the LNS
• C、By default, subscriber authentication occurs on the LNS
• D、By default, subscriber authentication occurs on the LAC

第8题：

第9题：

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

第10题：

Which two statements are true regarding subqueries? （）

• A、A subquery can retrieve zero or more rows 
• B、Only two subqueries can be placed atone level 
• C、A subquery can be used only in SQL query statements 
• D、A subquery can appear on either side of a comparison operator 
• E、There is no limit on the number of subquery levels in the WHERE clause of a SELECT statement