网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
多选题
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
参考答案
参考解析
解析：
暂无解析
更多 “多选题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” 相关考题
考题
An access list was written with the four statements shown in the graphic.Which single access list statement will combine all four of these statements into a single statement that will have exactly the same effect？（）A.access-list10 permit 172.29.16.00.0.0.255B.access-list10 permit 172.29.16.00.0.1.255C.access-list10 permit 172.29.16.00.0.3.255D.access-list10 permit 172.29.16.00.0.15.255E.access-list10 permit 172.29.0.00.0.255.255
考题
Which of the following answers is most true about the BGP Update message?（）A、It lists a set of path attributes, along with a list of prefixes that use those PAsB、It lists a prefix/length, plus the PA settings for that prefixC、It lists withdrawn routes, but never in the same Update message as newly advertised routesD、A single Update message lists at most a single prefix/lengtH
考题
When creating a service profiIe using the Expert Wizard in a single vlan vnic configuration which four optionsare available?（）A、Fabric IDB、Native VlanC、Vlan TrunkingD、Trunk encapsulationE、Mac Address assignment
考题
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 four are types of functions available in SQL? （）A、stringB、characterC、integerD、calendarE、numericF、translationG、dateH、conversion
考题
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 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.
考题
When planning high availability， which two components are important to minimize the effect of outages？（）A、work staff attributes， such as skills and communicationB、redundancy， to prevent single points of failureC、processes， such as documentation， change control， and labsD、appropriate technology， such as hardware and softwareE、tools， such as those for monitoring and reporting
考题
A user has a small network of four computers that they want to connect to a single cable modem. Which of the following devices would allow the user to do this？（）A、Four port switchB、Four port wireless routerC、Four port WAPD、Four port hub
考题
Application A currently holds an exclusive lock on a single row and application B tries to access that row. If lock timeout is set to -1 and both applications are using isolation level RS, which of the following will occur?（）A、Applications A and B will cause a deadlock situationB、Application B will read the previous version of the rowC、Application B will read the row and see uncommitted changes made by application AD、Application B will be placed in a lock-wait state until application A releases its lock
考题
A customer needs a new Microsoft Windows 2003 Server. They are running an application that requires substantial memory. They would like a rack mountable system， which will support four Xeon processors with 2MB of L3 cache. Which of the following is the minimum configuration to satisfy the customer’s requirements？（）A、x445 with four Xeon MP processors and 8GB of memoryB、x445 with four Xeon MP processors and 16GB of memory in a single SMP moduleC、x445 with four Xeon DP processors and 16GB of memory in a single SMP moduleD、x445 with two SMP modules each containing two Xeon DP processors and 8GB of memory
考题
Application A holds an Update lock on a single row and application B is trying to read that row. If both applications are using isolation level UR, which of the following will occur?（）A、Application B will read the row.B、Applications A and B will cause a deadlock situation.C、Application B will wait until application A releases the Update lock.D、Application A will be terminated so that application B can read the row.
考题
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 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 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.
考题
单选题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 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 parameter 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 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
考题
单选题Which of the following answers is most true about the BGP Update message?（）A
It lists a set of path attributes, along with a list of prefixes that use those PAsB
It lists a prefix/length, plus the PA settings for that prefixC
It lists withdrawn routes, but never in the same Update message as newly advertised routesD
A single Update message lists at most a single prefix/lengtH
考题
多选题When creating a service profiIe using the Expert Wizard in a single vlan vnic configuration which four optionsare available?（）AFabric IDBNative VlanCVlan TrunkingDTrunk encapsulationEMac Address assignment
考题
多选题Which four are types of functions available in SQL? （）AstringBcharacterCintegerDcalendarEnumericFtranslationGdateHconversion
考题
多选题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.
考题
多选题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.
考题
多选题When planning high availability， which two components are important to minimize the effect of outages？（）Awork staff attributes， such as skills and communicationBredundancy， to prevent single points of failureCprocesses， such as documentation， change control， and labsDappropriate technology， such as hardware and softwareEtools， such as those for monitoring and reporting
热门标签
最新试卷