题目详情
当前位置:首页 > 职业培训考试
题目详情:
发布时间:2023-12-03 22:17:51

[单项选择] Management has asked you to calculate the value 12*salary* commission_pct for all the employees in the EMP table. The EMP table contains these columns: LAST NAME VARCNAR2(35) NOT NULL SALARY NUMBER(9,2) NOT NULL COMMISION_PCT NUMBER(4,2) Which statement ensures that a value is displayed in the calculated columns for all employees? ()
A. SELECT last_name, 12*salary* commission_pct FROM emp;
B. SELECT last_name, 12*salary* (commission_pct,0) FROM emp;
C. SELECT last_name, 12*salary*(nvl(commission_pct,0)) FROM emp;
D. SELECT last_name, 12*salary*(decode(commission_pct,0)) FROM emp;

更多"Management has asked you to calcula"的相关试题:

[单项选择] Management has asked you to calculate the value 12*salary* commission_pct for all the employees in the EMP table. The EMP table contains these columns: LAST NAME VARCNAR2(35) NOT NULL SALARY NUMBER(9,2) NOT NULL COMMISION_PCT NUMBER(4,2) Which statement ensures that a value is displayed in the calculated columns for all employees?()
A. SELECT last_name, 12*salary* commission_pct FROM emp;
B. SELECT last_name, 12*salary* (commission_pct,0) FROM emp;
C. SELECT last_name, 12*salary*(nvl(commission_pct,0)) FROM emp;
D. SELECT last_name, 12*salary*(decode(commission_pct,0)) FROM emp;
[单项选择]Your network administrator has asked you to view the real-time interface usage on ge-0/0/0, Which command whould be used?()
A. monitor interface ge0/0/0
B. traceoptions interface ge-0/0/0
C. debug interface ge0/0/0
D. monitor usage ge-0/0/0
[单项选择]The network administrator has asked you to check the status of the workstation’s IP stack by pinging the loopback address.Which address would you ping to perform this task?()
A. 10.1.1.1
B. 127.0.0.1
C. 192.168.0.1
D. 239.1.1.1
[单项选择]A customers has asked you to investigate their current x86 server environment to determinate if they can achieve a reduction in power and rack consumption. They plan to implement VMware and the local storage shared. Which of the following consolidation proposals meets these needs?()
A. BladeCenter S
B. BladeCenter H
C. BladeCenter E
D. BladeCenter HT
[多项选择]You are asked to free up disk space so you can update your version of the Junos OS.Which two commands display the files that will be removed?()
A. user@router> request system storage cleanup
B. user@router> show system storage
C. user@router> request system storage cleanup dry-run
D. user@router> show system storage detail
[多项选择]the network administrator has been asked to give reasons for moving from ipv4 to ipv6. what are two valid reasons for adopting ipv6 over ipv4?()
A. telnet access does not require a password
B. nat
C. no broadcast
D. chanage of destination address in the ipv6 header
E. chanage of source address in the ipv6 header
F. autoconfiguration
[单项选择] A senior DBA asked you to execute the following command to improve performance: SQL> ALTER TABLE subscribe log STORAGE (BUFFER_POOL recycle); You checked the data in the SUBSCRIBE_LOG table and found that it is a large table containing one million rows. What could be a reason for this recommendation?()
A. The keep pool is not configured.
B. Automatic Workarea Management is not configured.
C. Automatic Shared Memory Management is not enabled.
D. The data blocks in the SUBSCRIBE_LOG table are rarely accessed.
E. All the queries on the SUBSCRIBE_LOG table are rewritten to a materialized view
[单项选择]A customer has asked for the ability to operate dual digital monitors. Which of the following is the BEST solution for accomplishing this?()
A. Split the onboard video port.
B. Update the video drivers to allow for multiple monitors.
C. Add an adaptor to the onboard VGA port.
D. Install a video card with multiple DVI ports.
[单项选择]The President has asked for budget cuts, and Congress has indicated () willingness to legislate some of them.
A. its
B. their
C. it’s
D. his
[单项选择]An operator has been asked if a system was rebooted. Which of the following commands should be used to determine if a reboot has occurred?()
A. The name?command.The ?name?command.
B. The ptime?command.The ?ptime?command.
C. The hutdown ast?command.The ?hutdown ?ast?command.
D. The ?etc/rc.shutdown?command.
[多项选择]You are asked to configure the configuration archival feature on your Junos devices.Which two transfer methods are available?()
A. TFTP
B. FTP
C. SCP
D. SFTP
[单项选择]The director has been asked to state the company's position, but so far he has refused to _________himself on this issue.
A. perform
B. assign
C. commit
D. undertake
[单项选择]A technician has been asked to ensure a PC is supplied with power for a short time, during apower failure. The technician should install which of the following devices to ensure thisrequirement is easily met?()
A. Backup power generator
B. Uninterruptable power supply
C. Power line conditioners
D. Surge protectors

我来回答:

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

订单号:

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