搜题
用户您好， 请在下方输入框内搜索其它题目：
搜题
题目内容 （请给出正确答案）
提问人：网友 发布时间：
【单项选择题】

Evaluate this SQL statement:<br /> SELECT ename, sal, 12*sal+100<br /> FROM emp;<br /> The SAL column stores the monthly salary of the employee. Which change must be made to the above syntax to calculate the annual compensation as &quot;monthly salary plus a monthly bonus of $100, multiplied by 12&quot;?（）<p> Evaluate this SQL statement:<br /> SELECT ename, sal, 12*sal+100<br /> FROM emp;<br /> The SAL column stores the monthly salary of the employee. Which change must be made to the above syntax to calculate the annual compensation as &quot;monthly salary plus a monthly bonus of $100, multiplied by 12&quot;?（）</p>

A、A.No change is required to achieve the desired results.

B、B.SELECT ename, sal, 12*(sal+100) FROM emp;

C、C.SELECT ename, sal, (12*sal)+100 FROM emp;

D、D.SELECT ename, sal+100,*12 FROM emp;

查看正确答案
更多“Evaluate this SQL statement:<br /> SELECT ename, sal, 12*sal+100<br /> FROM emp;<br /> The SAL column stores the monthly salary of the employee. Which change must be made to the above syntax to calculate the annual compensation as &quot;monthly salary plus a monthly bonus of $100, multiplied by 12&quot;?（）<p> Evaluate this SQL statement:<br /> SELECT ename, sal, 12*sal+100<br /> FROM emp;<br /> The SAL column stores the monthly salary of the employee. Which change must be made to the above syntax to calculate the annual compensation as &quot;monthly salary plus a monthly bonus of $100, multiplied by 12&quot;?（）</p>”相关的问题
第1题
[] Evaluate the following SQL statement used to create the PRODUCTS table: Which statement is true regarding this command?（） Evaluate the following SQL statement used to create the PRODUCTS table: Which statement is true regarding this command?（）

A、A. It executes successfully but partition pruning cannot happen for this partition key.  B、B. It produces an error because the TOTAL_VALUE column cannot be used as a partition key.  C、C. It produces an error because compression cannot be used for the TOTAL_VALUE partition key.  D、D. It executes successfully but the values in the TOTAL_VALUE column would not be physically stored in the partitions.  

点击查看答案
第2题
[单选题] Evaluate this SQL statement: In the statement, which capabilities of a SELECT statement are performed?（）

A、Selection, projection, join  B、Difference, projection, join  C、Selection, intersection, join  D、Intersection, projection, join  E、Difference, projection, product  

点击查看答案
第3题
[单选题] The PRODUCTS table has these columns: PRODUCT_ID NUMBER(4) PRODUCT_NAME VARCHAR2(45) PRICE NUMBER(8,2) Evaluate this SQL statement: SELECT * FROM PRODUCTS ORDER BY price, product _ name; What is true about the SQL statement?（）

A、The results are not sorted.  B、The results are sorted numerically.  C、The results are sorted alphabetically.  D、The results are sorted numerically and then alphabetically.  

点击查看答案
第4题
[单选题] The PRODUCTS table has these columns: PRODUCT_ID NUMBER(4) PRODUCT_NAME VARCHAR2(45) PRICE NUMBER(8,2) Evaluate this SQL statement: SELECT * FROM PRODUCTS ORDER BY price, product _ name; What is true about the SQL statement? （）

A、The results are not sorted.  B、The results are sorted numerically.  C、The results are sorted alphabetically.  D、The results are sorted numerically and then alphabetically.  

点击查看答案
第5题
[] Evaluate the SQL statement: SELECT ROUND(45.953, -1), TRUNC(45.936, 2) FROM dual; Which values are displayed?（） Evaluate the SQL statement: SELECT ROUND(45.953, -1), TRUNC(45.936, 2) FROM dual; Which values are displayed?（）

A、A. 46 and 45  B、B. 46 and 45.93  C、C. 50 and 45.93  D、D. 50 and 45.9  E、E. 45 and 45.93  F、F. 45.95 and 45.93  

点击查看答案
第6题
[单选题] Evaluate the SQL statement: What will be displayed?（）

A、0  B、1  C、0.00  D、An error statement  

点击查看答案
第7题
[] Click the Exhibit button and examine the data from the ORDERS and CUSTOMERS tables. Evaluate this SQL statement: SELECT cust_id, ord_total FROM orders WHERE ord_total > ANY(SELECT ord_total FROM orders WHERE cust_id IN (SELECT cust_id FROM customers WHERE city LIKE'New York')); What is the result when the above query is executed?（） Click the Exhibit button and examine the data from the ORDERS and CUSTOMERS tables. Evaluate this SQL statement: SELECT cust_id, ord_total FROM orders WHERE ord_total > ANY(SELECT ord_total FROM orders WHERE cust_id IN (SELECT cust_id FROM customers WHERE city LIKE'New York')); What is the result when the above query is executed?（）

A、A.A  B、B.B  C、C.C  D、D.D  E、E.E  

点击查看答案
第8题
[单选题] The user Sue issues this SQL statement: GRANT SELECT ON sue. EMP TO alice WITH GRANT OPTION; The user Alice issues this SQL statement: GRANT SELECT ON sue. EMP TO reena WITH GRANT OPTION; The user Reena issues this SQL statement: GRANT SELECT ON sue. EMP TO timber; The user Sue issues this SQL statement: REVOKE select on sue. EMP FROM alice; For which users does the revoke command revoke SELECT privileges on the SUE.EMP table?（）

A、Alice only  B、Alice and Reena  C、Alice, Reena, and Timber  D、Sue, Alice, Reena, and Timber  

点击查看答案
第9题
[单选题] The user Sue issues this SQL statement: GRANT SELECT ON sue. EMP TO alice WITH GRANT OPTION; The user Alice issues this SQL statement: GRANT SELECT ON sue. EMP TO reena WITH GRANT OPTION; The user Reena issues this SQL statement: GRANT SELECT ON sue. EMP TO timber; The user Sue issues this SQL statement: REVOKE select on sue. EMP FROM alice; For which users does the revoke command revoke SELECT privileges on the SUE.EMP table?（）

A、Alice only  B、Alice and Reena  C、Alice, Reena, and Timber  D、Sue, Alice, Reena, and Timber  

点击查看答案
账号：
答题记录 我的收藏 我的题库
客服
TOP

请使用微信扫码支付

订单号：
遇到问题请联系在线客服