多选题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? （）

INSTR returns the numeric position of a named character.

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

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

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

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

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

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

如果没有搜索结果或未解决您的问题，请直接联系老师获取答案。

相似问题和答案

第1题：

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

第2题：

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

第3题：

JSP EL表达式的语法为( )

A、!JSP expression

B、@{JSP expression}

C、${JSP expression}

D、#{JSP expression}

正确答案：C

第4题：

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

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

正确答案:D

第5题：

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

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

正确答案:C

第6题：

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

第7题：

在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子句是任选的。

第8题：

下面哪些jspaction中允许使用表达式(expression)?()

A、jsp:setPropertyname=”name”value=%=expression%

B、jsp:includepage=%=expresion%

C、jsp:paranname=”name”value=%=expression%

D、jsp:getPropertyname=%expression%

参考答案：A,B,C

第9题：

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

第10题：

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

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

正确答案:D

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

题目

相似问题和答案

更多相关问题

相关内容