多选题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 to n decimal places.DDECODE translates an expression after comparing it to each search value.ETRIM trims the heading of trailing characters (or both) from a character string.FNVL compares two expressions and returns null if they are equal, or the first expression of they are not equal.GNULLIF compares twp expressions and returns null if they are equal, or the first expression if they are not equal.

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


参考解析

解析: 暂无解析

相关考题:

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

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

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.

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

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.

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

在Hibernate的Criteria查询中,Expression对象具体描述了查询条件,其对应SQL条件中的field=value的方法是()。A、Expression.eqB、Expression.gtC、Expression.geD、Expression.lt

Which four are types of functions available in SQL? ()A、stringB、characterC、integerD、calendarE、numericF、translationG、dateH、conversion

当()时,条件“expression1 XOR expression2”的值为真。A、expression1为真而expression2为假B、expression1为假而expression2为真C、expression1和expression2均为真D、a和b都对

在JavaScript中,下列哪段代码能够在1秒之后执行表达式expression?()A、window.setTimeout(1000,expression);B、window.setTimeout(expression,1);C、window.setTimeout(1,expression);D、window.setTimeout(expression,1000);

JAVA EE中,JSP表达式语言的语法是()。A、{EL expression}B、${EL expression}C、{EL expression}

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

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.

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.

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.

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

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 clauseD、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

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.

Which four are attributes of single row functions? ()A、cannot be nestedB、manipulate data itemsC、act on each row returnedD、return one result per rowE、accept only one argument and return only one valueF、accept arguments which can be a column or an expression

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)

多选题Which three tasks can be performed using regular expression support in Oracle Database 10g?()Ait can be used to concatenate two strings.Bit can be used to find out the total length of the string.Cit can be used for string manipulation and searching operations.Dit can be used to format the output for a column or expression having string data.Eit can be used to find and replace operations for a column or expression having string data.

多选题Which three statements about subqueries are true? ()AA main query can have more than one subquery.BA subquery can have more than one main query.CThe subquery and main query must retrieve data from the same table.DThe subquery and main query can retrieve data from different tables.EOnly one column or expression can be compared between the subquery and main query.FMultiple columns or expression can be compared between the subquery and main query.

多选题Which two statements are true regarding partitioning in Mysql?()ATables with BLOB and TEXT columns cannot be partitionedBPartitioning allows easier management of smaller data sets for certain queriesCPartitioning allows different columns to be stored in separate filesDThe partitioning expression is an integer or function that returns an integer value or NULL valueEPartitioning is only available for those storage engines that implements it natively

多选题Which four are types of functions available in SQL? ()AstringBcharacterCintegerDcalendarEnumericFtranslationGdateHconversion

多选题Which four are attributes of single row functions? ()Acannot be nestedBmanipulate data itemsCact on each row returnedDreturn one result per rowEaccept only one argument and return only one valueFaccept arguments which can be a column or an expression

多选题Which two statements are true regarding the ORDER BY clause? ()AIt is executed first in the query executionBIt must be the last clause in the SELECT statementCIt cannot be used in a SELECT statement containing a HAVING clauseDYou cannot specify a column name followed by an expression in this clauseEYou can specify a combination of numeric positions and column names in this clause

多选题Which three statements are true regarding single-row functions?()AThey can accept only one argument.BThey can be nested up to only two levels.CThey can return multiple values of more than one data type.DThey can be used in SELECT, WHERE, and ORDER BY clauses.EThey can modify the data type of the argument that is referenced.FThey can accept a column name, expression, variable name, or a user-supplied constant as arguments.