网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
SQL中，SALARYIN(1000，2000)的语义是______。
A．SALARY≤2000 AND SALARY≥1000
B．SALARY＜2000 AND SALARY＞1000
C．SALARY=1000 AND SALARY=2000
D．SALARY=1000 OR SALARY=2000
参考答案
更多 “ SQL中，SALARYIN(1000，2000)的语义是______。A．SALARY≤2000 AND SALARY≥1000B．SALARY＜2000 AND SALARY＞1000C．SALARY=1000 AND SALARY=2000D．SALARY=1000 OR SALARY=2000 ” 相关考题
考题
You are the administrator of SQL Server computers. One server is named SQL7, and other is named SQL2000. SQL7 is running SQL Server 7.O and SQL2000 is running SQL Server 2000.The net-libraries on SQL2000 are configured as shown in the exhibit.SQL7 is configured so that it has the named pipes, TCP/IP, NWlink, IPX/SPX and multiprotocol Net Libraries.SQL2000 and SQL7 exchange confidential company information. You need to ensure that unauthorized users cannot access this information.Which two actions should you take? (Each correct answer presents part of the solution. Choose two)A．On SQL2000, enable the multiprotocol net library.B．On SQL2000, select the force protocol encryption check box.C．On SQL7, select the force protocol encryption check box.D．On SQL2000, install a secure sockets layer (SSL) encryption certificate.E．On SQL2000 and SQL7, enable multiprotocol encryption.
考题
Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER Primary KeyFIRST_NAME VARCHAR2(25)LAST_NAME VARCHAR2(25)DEPARTMENT_ID NUMBERSALARY NUMBERWhat is the correct syntax for an inline view? （）A. SELECT a.last_name, a.salary, a.department_id, b.maxsal FROM employees a, (SELECT department_id, max(salary)maxsal FROM employees GROUP BY department_id) b WHERE a.department_id = b.department_id AND a.salary b.maxsal;B. SELECT a.last name, a.salary, a.department_id FROM employees a WHERE a.department_id IN (SELECT department_id FROM employees b GROUP BY department_id having salary = (SELECT max(salary) from employees))C. SELECT a.last_name, a.salary, a.department_id FROM employees a WHERE a.salary = (SELECT max(salary) FROM employees b WHERE a.department _ id = b.department _ id);D. SELECT a.last_name, a.salary, a.department_id FROM employees a WHERE (a.department_id, a.salary) IN (SELECT department_id, a.salary) IN (SELECT department_id max(salary) FROM employees b GROUP BY department_id ORDER BY department _ id);
考题
（33）如果对关系 emp（eno, ename, salary）成功执行下面的SQL语句：CREATE CLUSTER INDEX name_index ON emp（salary）其结果是A）在 emp表上按sal娜升序创建了一个聚簇索引B）在 emp表上按salary降序创建了一个聚簇索引C）在 emp表上按salary升序创建了一个唯一索引D）在 emp表上按salary降序创建了一个唯一索引
考题
SQL中，“SALARY IN（1000，2000）”的语义是（)。A．SALARY＜=2000 AND SALARY＞=1000B．SALARY＜2000 AND SALARY＞1000C．SALARY=1000 AND SALARY=2000D．SALARY=1000 OR SALARY=2000
考题
salary的语义“薪水”和词根-sal-之间的隐喻联系的认知基础是（）。A．salary是-sal-的本义单词。B．由salary产生了词根-sal-。C．古罗马用食盐来支付士兵的军饷。D．以上都不是。
考题
1、salary的语义“薪水”和词根-sal-之间的隐喻联系的认知基础是（）。A．salary是-sal-的本义单词。B．由salary产生了词根-sal-。C．古罗马用食盐来支付士兵的军饷。D．以上都不是。
考题
将变量salary重新赋值为原来取值的3倍的语句是 （）A．salary=salary*2.00;B．salary=salary+(salary*3.00);C．salary=salary*3;D．salary=*3;
热门标签
最新试卷
