网友您好, 请在下方输入框内输入要搜索的题目:

题目内容 (请给出正确答案)
多选题
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 or trailing characters (or both) from a character string.

F

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

G

NULLIF compares two 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? ()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 or trailing characters (or both) from a character string.FNVL compares two expressions and returns null if they are equal, or the first expression if they are not equal.GNULLIF compares two expressions and returns null if they are equal, or the first expression if they are not equal.” 相关考题
考题 Which of the following correctly describe the various functions and virtues of a router? (Select all valid answer choices)A. Packet switchingB. Collision prevention on a LAN segment.C. Packet filteringD. Broadcast domain enlargementE. Broadcast forwardingF. Internetwork communicationG. None of the above

考题 Which three statements correctly describe the Cisco Validated Designs program? ()(Choose three.) A. includes three design levelsB. incorporates products and technologies into enterprise, service provider, and commercial systemsC. extends the value of designs through a sustained development planD. does not factor customer input design processE. facilitates faster and more reliable customer deploymentsF. incorporates a narrow range of technologies and products

考题 Which of the following describe router functions?() A. Packet switchingB. Collision prevention on a LAN segmentC. Packet filteringD. Broadcast domain enlargementE. Broadcast forwardingF. Internetwork communication

考题 Which two statements correctly describe a situation in which an Active/Standby Service Module design is being used?() A. Troubleshooting is more complicated.B. Service and switch modules are underutilized.C. Layer 2 adjacency is required with the servers that use this design.D. Layer 3 adjacency is required with the servers that use this design.E. Load balancing will always occur across both access layer uplinks.

考题 Which of the following statements describe the network shown in the graphic?() A. There are two broadcast domains in the network.B. There are four broadcast domains in the network.C. There are six broadcast domains in the network.D. There are four collision domains in the network.E. There are five collision domains in the network.F. There are seven collision domains in the network.

考题 Which two statements correctly describe VTP?()A、Transparent mode always has a configuration revision number of 0.B、Transparent mode cannot modify a VLAN database.C、Client mode cannot forward received VTP advertisements.D、Client mode synchronizes its VLAN database from VTP advertisements.E、Server mode can synchronize across VTP domains.

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

考题 Which of the following correctly describe the various functions and virtues of a router?()A、Packet switchingB、Collision prevention on a LAN segment.C、Packet filteringD、Broadcast domain enlargementE、Broadcast forwardingF、Internetwork communication

考题 You are the network consultant from Cisco.com. Please point out two statements correctly describe an IPS device()A、It resembles a Layer 2 bridge.B、Traffic flow through the IPS resembles traffic flow through a Layer 3 router.C、Inline interfaces which have no IP addresses cannot be detected.D、Malicious packets that have been detected are allowed to pass through, but all subsequent traffic is blocked.

考题 Which three statements correctly describe the Cisco Validated Designs program? ()(Choose three.)A、includes three design levelsB、incorporates products and technologies into enterprise, service provider, and commercial systemsC、extends the value of designs through a sustained development planD、does not factor customer input design processE、facilitates faster and more reliable customer deploymentsF、incorporates a narrow range of technologies and products

考题 Which two statements correctly describe a situation in which an Active/Standby Service Module design is being used?()A、Troubleshooting is more complicated.B、Service and switch modules are underutilized.C、Layer 2 adjacency is required with the servers that use this design.D、Layer 3 adjacency is required with the servers that use this design.E、Load balancing will always occur across both access layer uplinks.

考题 Which two statements describe the functions and operations of IDS and IPS systems?()A、A network administrator entering a wrong password would generate a true-negative alarm.B、A false positive alarm is generated when an IDS/IPS signature is correctly identified.C、An IDS is significantly more advanced over IPS because of its ability to prevent network attacks.D、Cisco IDS works inline and stops attacks before they enter the network.E、Cisco IPS taps the network traffic and responds after an attack.F、Profile-based intrusion detection is also known as "anomaly detection".

考题 Which of the following describe router functions?()A、Packet switchingB、Collision prevention on a LAN segmentC、Packet filteringD、Broadcast domain enlargementE、Broadcast forwardingF、Internetwork communication

考题 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 statements correctly describe the functions and use of constraints? ()A、Constraints provide data independence.B、Constraints make complex queries easy.C、Constraints enforce rules at the view level.D、Constraints enforce rules at the table level.E、Constraints prevent the deletion of a table if there are dependencies.F、Constraints prevent the deletion of an index if there are dependencies.

考题 多选题Which of the following describe router functions?()APacket switchingBCollision prevention on a LAN segmentCPacket filteringDBroadcast domain enlargementEBroadcast forwardingFInternetwork communication

考题 多选题Refer to the router topology shown in the graphic. Assuming that all routers are running OSPF, which statements correctly describe how the routers exchange routing information?()ADenmark exchanges with Utah, Paris, and Berlin.BUtah exchanges only with Denmark.CBerlin exchanges with Denmark, Utah, and Paris.DParis exchanges only with Denmark.EDenmark exchanges with only Paris and Utah.

考题 多选题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 are types of functions available in SQL? ()AstringBcharacterCintegerDcalendarEnumericFtranslationGdateHconversion

考题 单选题Which of the following statements describes the functions of a reservoir used in a hydraulic system?()A Dissipate heatB Trap foreign matterC Separate air from the oilD All of the above

考题 多选题Which three statements correctly describe the functions and use of constraints? ()AConstraints provide data independence.BConstraints make complex queries easy.CConstraints enforce rules at the view level.DConstraints enforce rules at the table level.EConstraints prevent the deletion of a table if there are dependencies.FConstraints prevent the deletion of an index if there are dependencies.

考题 多选题Which two statements correctly describe characteristics of the PortFast feature? ()ASTP will be disabled on the port.BPortFast can also be configured on trunk ports.CPortFast is required to enable port-based BPDU guard.DPortFast is used for both STP and RSTP host ports.EPortFast is used for STP-only host ports.

考题 多选题Which of the following correctly describe the various functions and virtues of a router?()APacket switchingBCollision prevention on a LAN segment.CPacket filteringDBroadcast domain enlargementEBroadcast forwardingFInternetwork communication