The EMP table has these columns: ENAME VARCHAR2(35) SALARY NUMBER(8,2) HIRE_DATE DATE Management wants a list of names of employees who have been with the company for more than five years. Which SQL statement displays the required results?()
A、SELECT ENAME FROM EMP WHERE SYSDATE-HIRE_DATE >5;
B、SELECT ENAME FROM EMP WHERE HIRE_DATE-SYSDATE >5;
C、SELECT ENAME FROM EMP WHERE (SYSDATE_HIRE_DATE)/365 >5;
D、SELECT ENAME FROM EMP WHERE (SYSDATE_HIRE_DATE)*/365 >5;
在WinXP下,下列哪一种常常被保留在计算机的当前系统配置中?()
A、创建垃圾文件处理的DrWatson
B、备份所有系统文件信息的MSCONFIG
C、创建系统恢复断点的SystemRestore
D、穿件设置备份的文件尺寸和设置传输尺寸
The ORDERS table has these columns: The ORDERS table tracks the Order number, the order total, and the customer to whom the Order belongs. Which two statements retrieve orders with an inclusive total that ranges between 100.00 and 2000.00 dollars?()
ASELECT customer_id, order_id, order_total FROM orders RANGE ON order_total (100 AND 2000) INCLUSIVE;
BSELECT customer_id, order_id, order_total FROM orders HAVING order_total BETWEEN 100 and 2000;
CSELECT customer_id, order_id, order_total FROM orders WHERE order_total BETWEEN 100 and 2000;
DSELECT customer_id, order_id, order_total FROM orders WHERE order_total >= 100 and <= 2000;
ESELECT customer_id, order_id, order_total FROM orders WHERE order_total >= 100 and order_total <= 2000;
You are asked to change the cable on interface ge-0/2/1.Which statement is correct?()
A、The cable is found on slot 2, port 0, and FPC 1.
B、The cable is found on FPC 0, slot 1, and port 2.
C、The cable is found on port 1, slot 0, and FPC 2.
D、The cable is found on slot 2, port 1, and FPC 0.
如果对一张幻灯片使用系统提供的版式,对其中各个对象的占位符()
A、能用具体内容去替换,不可删除
B、能移动位置,也不能改变格式
C、可以删除不用,也可以在幻灯片中插入新的对象
D、可以删除不用,但不能在幻灯片中插入新的对象
你想把系统设置为从CD-ROM启动,应该怎么做()。
A、禁用主硬盘驱动器
B、把CD-ROM设置为主驱动器
C、设置CD-ROM为BIOS引导
D、在BIOS中改变引导顺序