更多“Anti-technicality clause”相关问题
  • 第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 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.

    正确答案:C

  • 第3题:

    翻译:Warehouse to Warehouse Clause()


    正确答案:仓至仓条款

  • 第4题:

    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.

    正确答案:A,E

  • 第5题:

    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.

    正确答案:B,D

  • 第6题:

    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

    正确答案:B,D,E,F

  • 第7题:

    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 

    正确答案:C,D

  • 第8题:

    单选题
    In a SELECT statement that includes a WHERE clause, where is the GROUP BY clause placed in the SELECT statement?()
    A

    Immediately after the SELECT clause

    B

    Before the WHERE clause

    C

    Before the FROM clause

    D

    After the ORDER BY clause

    E

    After the WHERE clause


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

  • 第9题:

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


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

  • 第10题:

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


    正确答案: C,D
    解析: 暂无解析

  • 第11题:

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


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

  • 第12题:

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


    正确答案: E,C
    解析: 暂无解析

  • 第13题:

    In which of the following situations should correlation names be used?()

    • A、A table referenced in the FROM clause has no indexed column.
    • B、The table referenced in the FROM clause has more than 200 columns.
    • C、Two or more tables in the FROM clause have identical column names.
    • D、The FROM clause contains two or more tables in the SELECT statement.

    正确答案:C

  • 第14题:

    You have configured a Classifier Access Control List(CLACL)with multiple match clauses.Each match clause has multiple defined fields within it.Which two statements describe how the router evaluates this CLACL?()

    • A、All fields in each match clause must match.
    • B、All match clauses in the CLACL must match.
    • C、Only asingle field in each match clause must match.
    • D、Only asingle match clause in the CLACL must match

    正确答案:A,D

  • 第15题:

    翻译:incorporation clause


    正确答案: (租约)并入提单

  • 第16题:

    In a SELECT statement that includes a WHERE clause, where is the GROUP BY clause placed in the SELECT statement?()

    • A、Immediately after the SELECT clause
    • B、Before the WHERE clause
    • C、Before the FROM clause
    • D、After the ORDER BY clause
    • E、After the WHERE clause

    正确答案:E

  • 第17题:

    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

    正确答案:B,E

  • 第18题:

    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

    正确答案:B,C,F

  • 第19题:

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


    正确答案: A,D
    解析: 暂无解析

  • 第20题:

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

    B


    正确答案:
    解析: 暂无解析

  • 第21题:

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


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

  • 第22题:

    名词解释题
    Anti-technicality clause

    正确答案: 反技巧性条款,又称抵御市场波动条款,为了防止出租人以承租人未准时付租金为由随便撤船而订立。一般规定,当承租人没有准时、定期地支付租金时,出租人应在撤船前书面通知承租人在若干个银行工作日内予以弥补,只有在该期间内承租人仍未能准时支付租金时,出租人才可撤船
    解析: 暂无解析

  • 第23题:

    单选题
    In which of the following situations should correlation names be used?()
    A

    A table referenced in the FROM clause has no indexed column.

    B

    The table referenced in the FROM clause has more than 200 columns.

    C

    Two or more tables in the FROM clause have identical column names.

    D

    The FROM clause contains two or more tables in the SELECT statement.


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