Which four are attributes of single row functions? （）

第1题：

When creating a service profiIe using the Expert Wizard in a single vlan vnic configuration which four optionsare available?（）

• A、Fabric ID
• B、Native Vlan
• C、Vlan Trunking
• D、Trunk encapsulation
• E、Mac Address assignment

第2题：

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

第3题：

第4题：

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 switch
• B、Four port wireless router
• C、Four port WAP
• D、Four port hub

第5题：

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.

第6题：

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.

第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

第8题：

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 PAs
• B、It lists a prefix/length, plus the PA settings for that prefix
• C、It  lists withdrawn routes, but never in the same Update message as newly advertised routes
• D、A single Update message lists at most a single prefix/lengtH

第9题：

When planning high availability， which two components are important to minimize the effect of outages？（）

• A、work staff attributes， such as skills and communication
• B、redundancy， to prevent single points of failure
• C、processes， such as documentation， change control， and labs
• D、appropriate technology， such as hardware and software
• E、tools， such as those for monitoring and reporting

第10题：

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 situation
• B、Application B will read the previous version of the row
• C、Application B will read the row and see uncommitted changes made by application A
• D、Application B will be placed in a lock-wait state until application A releases its lock