更多"Which SELECT statement should you u"的相关试题:
[单项选择]Which SELECT statement should you use to extract the year from the system date and display it in the format "1998"?（）
A. SELECT TO_CHAR(SYSDATE,'yyyy') FROM dual;
B. SELECT TO_DATE(SYSDATE,'yyyy') FROM dual;
C. SELECT DECODE(SUBSTR(SYSDATE, 8), 'YYYY') FROM dual;
D. SELECT DECODE(SUBSTR(SYSDATE, 8), 'year') FROM dual;
E. SELECT TO_CHAR(SUBSTR(SYSDATE, 8,2),'yyyy') FROM dual;
[单项选择]Which component should you use to reduce collision issues on a large LAN?（）
A. Host
B. Switch
C. Printer
D. Repeater
[单项选择]Which IGP should you use to achieve scalability in a large enterprise network using Juniperenterprise routers?（）
A. RIP
B. BGP
C. OSPF
D. EIGRP
[单项选择]Which clause should you use to exclude group results?（）
A. WHERE
B. HAVING
C. RESTRICT
D. GROUP BY
E. ORDER BY
[单项选择]Which command should you use to verify what networks are being routed by a given OSPF process（）
A. show ip ospf
B. show ip route
C. show ip protocol
D. show ip ospfdatabase
E. None of the other alternatives apply
[单项选择]Which of these tools should you use to compress VoIP packets on a low-speed Frame Replay circuit?（）
A. Cisco Proprietary payload compression
B. Predictor payload compression
C. RTP header compression
D. TCP header compression
[单项选择]Which major J-Web menu should you use to upgrade the JUNOS soft ware on the router？（）
A. Monitor
B. Maintain
C. Diagnose
D. Configuration
[单项选择]Which clause would you use in a SELECT statement to limit the display to those employees whose salary is greater then 5000?（）
A. ORDER BY SALARY > 5000
B. GROUP BY SALARY > 5000
C. HAVING SALARY > 5000
D. WHERE SALARY > 5000
[单项选择]Which command should an administrator use to view files and volume group backup information from a mksysb called server1.mksysb that is found in /backups?（）
A. lsmksysb -l /backups/server1.mksysb
B. showmksysb -f /backups/server1.mksysb
C. listvgbackup -f /backups/server1.mksysb
D. showvgbackup -l /backups/server1.mksysb
