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

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

参考答案和解析
正确答案： D,B
解析： 暂无解析
更多“多选题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 value”相关问题

  • 第1题：

    A typical(160)language contains an applicative sub-language which approximates the mathematical abstractions of "timeless" functions applied to "spaceless" values, where the actual operation sequences and use of storage space during expression evaluation are organized behind the(161). In this setting, values are data structures of low volume, typically a few computer words or less, which means that an illusion of spacelessness can be realized by having(162)results during expression evaluation stored at the discretion of the language implementation, and effecting parameter(163)and(164)operations through value copying.

    A．imperative

    B．mandatory

    C．compulsory

    D．voluntary


    正确答案：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题：

    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

  • 第5题：

    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

  • 第6题：

    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

  • 第7题：

    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

  • 第8题：

    多选题
    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
    解析： 暂无解析

  • 第9题：

    多选题
    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
    解析： 暂无解析

  • 第10题：

    多选题
    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
    解析： 暂无解析

  • 第11题：

    多选题
    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
    解析： 暂无解析

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

    Which kind of non－sourced UDF can be created so that it only returns a single value?()

    A.Row

    B.Table

    C.Scalar

    D.Column


    参考答案：C

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

    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

  • 第17题：

    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

  • 第18题：

    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

  • 第19题：

    TestKing.com has a SQL Server 2005 computer. You have been assigned the task of retrieving information about a user who is currently logged in. You need to create a function that returns scalar information about the activity time for a particular user. What are two possible ways to achieve this goal？（）

    • A、Create a function that returns a list of values that represent the login times for the given user.
    • B、Create a function that returns a list of values that represent the people who have logged more hours than the current user has logged.
    • C、Create a function that returns a numeric value that represents the number of hours that a user has logged for the current day.
    • D、Create a function that returns a numeric value that represents the number of hours that a user has logged for the current month.

    正确答案:C,D

  • 第20题：

    多选题
    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
    解析： 暂无解析

  • 第21题：

    多选题
    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
    解析： 暂无解析

  • 第22题：

    多选题
    TestKing.com has a SQL Server 2005 computer. You have been assigned the task of retrieving information about a user who is currently logged in. You need to create a function that returns scalar information about the activity time for a particular user. What are two possible ways to achieve this goal？（）
    A

    Create a function that returns a list of values that represent the login times for the given user.

    B

    Create a function that returns a list of values that represent the people who have logged more hours than the current user has logged.

    C

    Create a function that returns a numeric value that represents the number of hours that a user has logged for the current day.

    D

    Create a function that returns a numeric value that represents the number of hours that a user has logged for the current month.


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

  • 第23题：

    多选题
    Which two statements are true about mouse button variables?（）
    A

    SYSTEM.MOUSE_BUTTON_PRESSED returns a string.

    B

    SYSTEM.MOUSE_BUTTON_PRESSED returns a numeric value. 1Z0-132 World Leaders In Certifications Material - Test-king.com

    C

    A possible value for SYSTEM.MOUSE_BUTTON_MODIFIERS is Control+Alt+Delete.

    D

    SYSTEM.MOUSE_BUTTON_MODIFIERS can only be references in form-level triggers.

    E

    SYSTEM.MOUSE_BUTTON_MODIFIERS identifies which special key was pressed in conjunction with the usual mouse button action.


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

  • 第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
    解析： 暂无解析

相关内容