多选题Which four statements correctly describe functions that are available in SQL? （）AINSTR returns the numeric position of a named character.BNVL2 returns the first non-null expression in the expression list.CTRUNCATE rounds the column, expression, or valu

题目
多选题
Which four statements correctly describe functions that are available in SQL? （）
A

INSTR returns the numeric position of a named character.

B

NVL2 returns the first non-null expression in the expression list.

C

TRUNCATE rounds the column, expression, or value to n decimal places.

D

DECODE translates an expression after comparing it to each search value.

E

TRIM trims the heading of trailing characters (or both) from a character string.

F

NVL compares two expressions and returns null if they are equal, or the first expression of they are not equal.

G

NULLIF compares twp expressions and returns null if they are equal, or the first expression if they are not equal.

相似考题

1.JSP EL表达式的语法为( )A、!JSP expressionB、@{JSP expression}C、${JSP expression}D、#{JSP expression}

2.In which scenario would index be most useful? ()A. The indexed column is declared as NOT NULL.B. The indexed columns are used in the FROM clause.C. The indexed columns are part of an expression.D. The indexed column contains a wide range of values.

3.Which two statements are true regarding partitioning in Mysql?()A.Tables with BLOB and TEXT columns cannot be partitionedB.Partitioning allows easier management of smaller data sets for certain queriesC.Partitioning allows different columns to be stored in separate filesD.The partitioning expression is an integer or function that returns an integer value or NULL valueE.Partitioning is only available for those storage engines that implements it natively

4.下面哪些jspaction中允许使用表达式(expression)?()A、jsp:setPropertyname=”name”value=%=expression%B、jsp:includepage=%=expresion%C、jsp:paranname=”name”value=%=expression%D、jsp:getPropertyname=%expression%

更多“多选题Which four statements correctly describe functions that are available in SQL? （）AINSTR returns the numeric position of a named character.BNVL2 returns the first non-null expression in the expression list.CTRUNCATE rounds the column, expression, or valu”相关问题

  • 第1题：

    Evaluate these two SQL statements:What is true about them?()

    A. The two statements produce identical results.

    B. The second statement returns a syntax error.

    C. There is no need to specify DESC because the results are sorted in descending order by default.

    D. The two statements can be made to produce identical results by adding a column alias for the salary column in the second SQL statement.


    参考答案：A

  • 第2题：

    在Hibernate的Criteria查询中，Expression对象具体描述了查询条件，其对应SQL条件中的field>=value的方法是（）。

    • A、Expression.eq
    • B、Expression.gt
    • C、Expression.ge
    • D、Expression.lt

    正确答案:C

  • 第3题：

    当（）时，条件“expression1 XOR expression2”的值为真。

    • A、expression1为真而expression2为假
    • B、expression1为假而expression2为真
    • C、expression1和expression2均为真
    • D、a和b都对

    正确答案:D

  • 第4题：

    JAVA EE中，JSP表达式语言的语法是（）。

    • A、{EL expression}
    • B、${EL expression}
    • C、&{EL expression}

    正确答案:B

  • 第5题：

    Which four statements correctly describe functions that are available in SQL? （）

    • A、INSTR returns the numeric position of a named character.
    • B、NVL2 returns the first non-null expression in the expression list.
    • C、TRUNCATE rounds the column, expression, or value to n decimal places.
    • D、DECODE translates an expression after comparing it to each search value.
    • E、TRIM trims the heading of trailing characters (or both) from a character string.
    • F、NVL compares two expressions and returns null if they are equal, or the first expression of they are not equal.
    • G、NULLIF compares twp expressions and returns null if they are equal, or the first expression if they are not equal.

    正确答案:A,D,E,G

  • 第6题：

    Which three statements about subqueries are true? （）

    • A、A main query can have more than one subquery.
    • B、A subquery can have more than one main query.
    • C、The subquery and main query must retrieve data from the same table.
    • D、The subquery and main query can retrieve data from different tables.
    • E、Only one column or expression can be compared between the subquery and main query.
    • F、Multiple columns or expression can be compared between the subquery and main query.

    正确答案:A,C,E

  • 第7题：

    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

  • 第8题：

    Which four are attributes of single row functions? （）

    • A、cannot be nested
    • B、manipulate data items
    • C、act on each row returned
    • D、return one result per row
    • E、accept only one argument and return only one value
    • F、accept arguments which can be a column or an expression

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

  • 第9题：

    多选题
    Which four statements correctly describe functions that are available in SQL? （）
    A

    INSTR returns the numeric position of a named character.

    B

    NVL2 returns the first non-null expression in the expression list.

    C

    TRUNCATE rounds the column, expression, or value to n decimal places.

    D

    DECODE translates an expression after comparing it to each search value.

    E

    TRIM trims the heading of trailing characters (or both) from a character string.

    F

    NVL compares two expressions and returns null if they are equal, or the first expression of they are not equal.

    G

    NULLIF compares twp expressions and returns null if they are equal, or the first expression if they are not equal.


    正确答案： E,D
    解析： 暂无解析

  • 第10题：

    多选题
    Which three statements about subqueries are true? （）
    A

    A main query can have more than one subquery.

    B

    A subquery can have more than one main query.

    C

    The subquery and main query must retrieve data from the same table.

    D

    The subquery and main query can retrieve data from different tables.

    E

    Only one column or expression can be compared between the subquery and main query.

    F

    Multiple columns or expression can be compared between the subquery and main query.


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

  • 第11题：

    多选题
    Which four are types of functions available in SQL? （）
    A

    string

    B

    character

    C

    integer

    D

    calendar

    E

    numeric

    F

    translation

    G

    date

    H

    conversion


    正确答案： H,G
    解析： 暂无解析

  • 第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题：

    在switch(expression)语句中,expression的数据类型不能是( )。 A.doubleB.char

    在switch(expression)语句中，expression的数据类型不能是（ ）。

    A.double

    B.char

    C.byte

    D.short


    正确答案：A
    A。【解析】本题考查考生对switch(expression)语句的理解。表达式expression只能返回int、byte、short和char，题目中的double是不正确的。同时还要注意，多分支结构中，case子句的值必须是常量，而且所有case子句中的值应是不同的，default子句是任选的。

  • 第14题：

    Which four are types of functions available in SQL? （）

    • A、string
    • B、character
    • C、integer
    • D、calendar
    • E、numeric
    • F、translation
    • G、date
    • H、conversion

    正确答案:B,E,G,H

  • 第15题：

    在JavaScript中，下列哪段代码能够在1秒之后执行表达式expression？（）

    • A、window.setTimeout(1000，expression)；
    • B、window.setTimeout(expression，1)；
    • C、window.setTimeout(1，expression)；
    • D、window.setTimeout(expression，1000)；

    正确答案:D

  • 第16题：

    When a valid SQL Query in a DB Read step returns 0 rows, which branch of the step will be executed? （）

    • A、Timeout  
    • B、SQL Error  
    • C、Successful  
    • D、Connection Not Available  

    正确答案:C

  • 第17题：

    Which three tasks can be performed using regular expression support in Oracle Database 10g？（）

    • A、 it can be used to concatenate two strings.
    • B、 it can be used to find out the total length of the string.
    • C、 it can be used for string manipulation and searching operations.
    • D、 it can be used to format the output for a column or expression having string data.
    • E、 it can be used to find and replace operations for a column or expression having string data.

    正确答案:C,D,E

  • 第18题：

    Which two statements are true regarding partitioning in Mysql?（）

    • A、Tables with BLOB and TEXT columns cannot be partitioned
    • B、Partitioning allows easier management of smaller data sets for certain queries
    • C、Partitioning allows different columns to be stored in separate files
    • D、The partitioning expression is an integer or function that returns an integer value or NULL value
    • E、Partitioning is only available for those storage engines that implements it natively

    正确答案:B,E

  • 第19题：

    In which scenario would index be most useful?（）

    • A、The indexed column is declared as NOT NULL.
    • B、The indexed columns are used in the FROM clause.
    • C、The indexed columns are part of an expression.
    • D、The indexed column contains a wide range of values.

    正确答案:D

  • 第20题：

    You define the following regular expression of currency values: regex tx = new regex("^-?/d+(/./d{2})?$") You are required to write code that will be used to find whether a string in the variable named Bill matches the regular expression or not. You are also required to use this code as the expression in a conditional statement and need to know which code segment to use. What should you do?（）

    • A、The tx.Matches（Bill）
    • B、The tx.Equals（Bill）
    • C、The tx.Match（Bill）
    • D、The tx.IsMatch（Bill）

    正确答案:D

  • 第21题：

    多选题
    Which three tasks can be performed using regular expression support in Oracle Database 10g？（）
    A

    it can be used to concatenate two strings.

    B

    it can be used to find out the total length of the string.

    C

    it can be used for string manipulation and searching operations.

    D

    it can be used to format the output for a column or expression having string data.

    E

    it can be used to find and replace operations for a column or expression having string data.


    正确答案： C,A
    解析： 暂无解析

  • 第22题：

    多选题
    Which two statements are true regarding partitioning in Mysql?（）
    A

    Tables with BLOB and TEXT columns cannot be partitioned

    B

    Partitioning allows easier management of smaller data sets for certain queries

    C

    Partitioning allows different columns to be stored in separate files

    D

    The partitioning expression is an integer or function that returns an integer value or NULL value

    E

    Partitioning is only available for those storage engines that implements it natively


    正确答案： B,E
    解析： 暂无解析

  • 第23题：

    多选题
    Which four are attributes of single row functions? （）
    A

    cannot be nested

    B

    manipulate data items

    C

    act on each row returned

    D

    return one result per row

    E

    accept only one argument and return only one value

    F

    accept arguments which can be a column or an expression


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

  • 第24题：

    多选题
    Which three statements are true regarding single-row functions？（）
    A

    They can accept only one argument.

    B

    They can be nested up to only two levels.

    C

    They can return multiple values of more than one data type.

    D

    They can be used in SELECT， WHERE， and ORDER BY clauses.

    E

    They can modify the data type of the argument that is referenced.

    F

    They can accept a column name， expression， variable name， or a user-supplied constant as arguments.


    正确答案： D,E
    解析： 暂无解析

相关内容