题目详情
当前位置:首页 > 职业培训考试
题目详情:
发布时间:2023-11-30 18:55:08

[多项选择]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 four statements correctly des"的相关试题:

[多项选择]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 three statements correctly describe the features of the I/O calibration process?()
A. Only one I/O calibration process can run at a time.
B. It automates the resource allocation for the Automated Maintenance Tasks.
C. It improves the performance of the performance-critical sessions while running.
D. It can be used to estimate the maximum number of I/Os and maximum latency time for the system.
E. The latency time is computed only when the TIMED_STATISTICS initialization parameter is set to TRUE.
[多项选择]Which three statements correctly describe the Cisco Validated Designs program? ()(Choose three.)
A. includes three design levels
B. incorporates products and technologies into enterprise, service provider, and commercial systems
C. extends the value of designs through a sustained development plan
D. does not factor customer input design process
E. facilitates faster and more reliable customer deployments
F. 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 correctly identify considerations to take into account when deciding on Campus QoS Design elements?()
A. Voice needs to be assigned to the hardware priority queue.
B. Voice needs to be assigned to the software priority queue.
C. Call signaling must have guaranteed bandwidth service.
D. Strict-priority queuing should be limited to 50 percent of the capacity of the link.
E. At least 33 percent of the link bandwidth should be reserved for default best-effort class.
[多项选择]Which of the following statements correctly describes the characteristics of a Frame Relay point-to-point subinterface?()
A. Needs to use Inverse ARP.
B. Maps a single IP subnet per DLCI.
C. Maps a single IP subnet across multiple DLCIs.
D. Resolves NBMA (non broadcast multi access) split horizon issues.
E. Requires use of the frame-relay map command.
F. None of the above
[多项选择]Which three of the statements below correctly describe the characteristics of Autonomous Systems in routed networks?()
A. Within an AS, all routers must run either BGP or IBGP.
B. An AS uses exterior gatew ay protocols (EGPs) to exchange information with other autonomous systems.
C. An AS is a group of routers under the same technical administration.
D. Within an AS, routes learned through BGP can be redistributed using interior gateway protocols.
E. Wi thin an AS, routes learned through an interior protocol cannot be redistributed using BGP to other autonomous systems.
[多项选择]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
[多项选择]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

我来回答:

购买搜题卡查看答案
[会员特权] 开通VIP, 查看 全部题目答案
[会员特权] 享免全部广告特权
推荐91天
¥36.8
¥80元
31天
¥20.8
¥40元
365天
¥88.8
¥188元
请选择支付方式
  • 微信支付
  • 支付宝支付
点击支付即表示同意并接受了《购买须知》
立即支付 系统将自动为您注册账号
请使用微信扫码支付

订单号:

请不要关闭本页面,支付完成后请点击【支付完成】按钮
恭喜您,购买搜题卡成功
重要提示:请拍照或截图保存账号密码!
我要搜题网官网:https://www.woyaosouti.com
我已记住账号密码