网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
多选题
Which two statements are true regarding single row functions?（）
A
They accept only a single argument
B
They can be nested only to two levels
C
Arguments can only be column values or constants
D
They always return a single result row for every row of a queried table
E
They can return a data type value different from the one that is referenced
参考答案
参考解析
解析：
暂无解析
更多 “多选题Which two statements are true regarding single row functions?（）AThey accept only a single argumentBThey can be nested only to two levelsCArguments can only be column values or constantsDThey always return a single result row for every row of a queried tableEThey can return a data type value different from the one that is referenced” 相关考题
考题
Choose the two correct statements regarding Oracle WebLogic Server（）A、 a server instance can be associated with multiple machinesB、 a machine can be associated with multiple server instance C、 a server instance can be associated with only a single machine D、 a machine can be associated with only one server instance
考题
Which statements are true regarding listeners（）A、Listeners use only the TCP/IP protocol.B、Multiple listener processes can run simultaneously on a host.C、Multiple database instances can be registered with a single listener.D、The listener-related errors can be traced only at the administrative level.E、Only one database instance can be registered with a single listener at any time
考题
Which two statements about subqueries are true? （）A、A subquery should retrieve only one row.B、A subquery can retrieve zero or more rows.C、A subquery can be used only in SQL query statements.D、Subqueries CANNOT be nested by more than two levels.E、A subquery CANNOT be used in an SQL query statement that uses group functions.F、When a subquery is used with an inequality comparison operator in the outer SQL statement, the column list in the SELECT clause of the subquery should contain only one column.
考题
Which three statements about subqueries are true?（）A、A single row subquery can retrieve only one column and one row.B、A single row subquery can retrieve only one row but many columns.C、A multiple row subquery can retrieve multiple rows and multiple columns.D、A multiple row subquery can be compared by using the "" operator.E、A single row subquery can use the IN operator.F、A multiple row subquery can use the "=" operator.
考题
Which two are true about aggregate functions? （）A、You can use aggregate functions in any clause of a SELECT statement.B、You can use aggregate functions only in the column list of the select clause and in the WHERE clause of a SELECT statement.C、You can mix single row columns with aggregate functions in the column list of a SELECT statement by grouping on the single row columns.D、You can pass column names, expressions, constants, or functions as parameter to an aggregate function.E、You can use aggregate functions on a table, only by grouping the whole table as one single group.F、You cannot group the rows of a table by more than one column while using aggregate functions.
考题
Which two statements are true regarding hot patching？（）A、 It requires relinking of the Oracle binary.B、 It does not require database instance shutdown.C、 It can detect conflicts between two online patches.D、 It is available for installing all patches on all platforms. E、 It works only in a single database instance environment.
考题
Which two statements about subqueries are true?（）A、A single row subquery can retrieve data from only one table.B、A SQL query statement cannot display data from table B that is referred to in its subquery, unless table B is included in the main query's FROM clause.C、A SQL query statement can display data from table B that is referred to in its subquery, without including table B in its own FROM clause.D、A single row subquery can retrieve data from more than one table.E、A single row subquery cannot be used in a condition where the LIKE operator is used for comparison.F、A multiple-row subquery cannot be used in a condition where the LIKE operator is used for comparison.
考题
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.
考题
Which two statements are true regarding listeners（）A、Listeners use only the TCP/IP protocol.B、Multiple listener processes can run simultaneously on a host.C、Multiple database instances can be registered with a single listener.D、The listener-related errors can be traced only at the administrative level.E、Only one database instance can be registered with a single listener at any time.
考题
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
考题
Which statement is true regarding subqueries?（）A、The LIKE operator cannot be used with single-row subqueries B、The NOT IN operator is equivalent to IS NULL with single-row subqueries C、=ANY and =ALL operators have the same functionality in multiple-row subqueries D、The NOT operator can be used with IN, ANY, and ALL operators in multiple-row subqueries
考题
Which two statements are true regarding single row functions?（）A、They accept only a single argument B、They can be nested only to two levels C、Arguments can only be column values or constants D、They always return a single result row for every row of a queried table E、They can return a data type value different from the one that is referenced
考题
多选题Which statements are true regarding listeners（）AListeners use only the TCP/IP protocol.BMultiple listener processes can run simultaneously on a host.CMultiple database instances can be registered with a single listener.DThe listener-related errors can be traced only at the administrative level.EOnly one database instance can be registered with a single listener at any time
考题
多选题Which three statements about subqueries are true?（）AA single row subquery can retrieve only one column and one row.BA single row subquery can retrieve only one row but many columns.CA multiple row subquery can retrieve multiple rows and multiple columns.DA multiple row subquery can be compared by using the “” operator.EA single row subquery can use the IN operator.FA multiple row subquery can use the “=” operator.
考题
多选题Flex Links are a pair of a Layer 2 interfaces (switchports or port channels), where one interface is configured to act as a backup to the other. Which two statements are correct regarding Flex Links?（）AAn interface can only belong to single Flex Links.BAn interface can belong to multiple Flex Links.CFlex Links operate only over single pairs of links.DFlex Links automatically disable STP so no BPDUs are propagated.
考题
多选题Which two are true about aggregate functions? （）AYou can use aggregate functions in any clause of a SELECT statement.BYou can use aggregate functions only in the column list of the SELECT clause and in the WHERE clause of a SELECT statement.CYou can mix single row columns with aggregate functions in the column list of a SELECT statement by grouping on the single row columns.DYou can pass column names, expressions, constants, or functions as parameters to an aggregate function.EYou can use aggregate functions on a table, only by grouping the whole table as one single group.FYou cannot group the rows of a table by more than one column while using aggregate functions.
考题
单选题Which statement is true regarding subqueries?（）A
The LIKE operator cannot be used with single-row subqueries B
The NOT IN operator is equivalent to IS NULL with single-row subqueries C
=ANY and =ALL operators have the same functionality in multiple-row subqueries D
The NOT operator can be used with IN, ANY, and ALL operators in multiple-row subqueries
考题
多选题Choose the two correct statements regarding Oracle WebLogic Server（）Aa server instance can be associated with multiple machinesBa machine can be associated with multiple server instanceCa server instance can be associated with only a single machineDa machine can be associated with only one server instance
考题
多选题Which two statements about subqueries are true? （）AA single row subquery can retrieve data from only one table.BA SQL query statement cannot display data from table B that is referred to in its subquery, unless table B is included in the main query's FROM clause.CA SQL query statement can display data from table B that is referred to in its subquery, without including B in its own FROM clause.DA single row subquery can retrieve data from more than one table.EA single row subquery cannot be used in a condition where the LIKE operator is used for comparison.FA multiple-row subquery cannot be used in an INSERT statement to insert multiple rows at a time.
考题
多选题Which two statements are true regarding the execution of the correlated subqueries？（）AThe nested query executes after the outer query returns the row.BThe nested query executes first and then the outer query executes.CThe outer query executes only once for the result returned by the inner query.DEach row returned by the outer query is evaluated for the results returned by the inner query.
考题
多选题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 about subqueries are true? （）AA subquery should retrieve only one row.BA subquery can retrieve zero or more rows.CA subquery can be used only in SQL query statements.DSubqueries CANNOT be nested by more than two levels.EA subquery CANNOT be used in an SQL query statement that uses group functions.FWhen a subquery is used with an inequality comparison operator in the outer SQL statement, the column list in the SELECT clause of the subquery should contain only one column.
考题
多选题Which two statements are true regarding listeners（）AListeners use only the TCP/IP protocol.BMultiple listener processes can run simultaneously on a host.CMultiple database instances can be registered with a single listener.DThe listener-related errors can be traced only at the administrative level.EOnly one database instance can be registered with a single listener at any time.
考题
多选题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.
热门标签
最新试卷