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

Evaluate the SQL statement:<br /> <img src="https://nimg.ppkao.com/2018-08/yiyu/2018080115100724106.jpg?sign=1159baf89d07ab2ab239961518ddac04&t=62d1cc40" /><br /> What is the result of the statement?（）

A、The statement produces an error at line 1.

B、The statement produces an error at line 3.

C、The statement produces an error at line 6.

D、The statement returns the employee name, salary, department ID, and maximum salary earned in the department of the employee for all departments that pay less salary then the maximum salary paid in the company.

E、The statement returns the employee name, salary, department ID, and maximum salary earned in the department of the employee for all employees who earn less than the maximum salary in their department.

查看正确答案
更多“ Evaluate the SQL statement:<br /> <img src="https://nimg.ppkao.com/2018-08/yiyu/2018080115100724106.jpg?sign=1159baf89d07ab2ab239961518ddac04&t=62d1cc40" /><br /> What is the result of the statement?（）”相关的问题
第1题
[] Evaluate the set of SQL statements: What is true about the set?（） Evaluate the set of SQL statements: What is true about the set?（）

A、A. The DESCRIBE DEPT statement displays the structure of the DEPT table.  B、B. The ROLLBACK statement frees the storage space occupies by the DEPT table.  C、C. The DESCRIBE DEPT statement returns an error ORA-04043: object DEPT does not exist.  D、D. The DESCRIBE DEPT statement displays the structure of the DEPT table only if there is a COMMIT statement introduced before the ROLLBACK statement.  

点击查看答案
第2题
[] Examine the data from the ORDERS and CUSTOMERS tables. Evaluate the SQL statement: What is the result when the query is executed?（） Examine the data from the ORDERS and CUSTOMERS tables. Evaluate the SQL statement: What is the result when the query is executed?（）

A、A.
B.
C.
D. The query fails because the subquery returns more than one row.
E. The query fails because the outer query and the inner query are using different tables.  

点击查看答案
第3题
[] 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  

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

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

点击查看答案
第5题
[] Click the Exhibit button and examine the data from the ORDERS and CUSTOMERS tables. Evaluate the SQL statement: SELECT * FROM orders WHERE cust_id = (SELECT cust_id FROM customers WHERE cust_name = 'Smith'); What is the result when the query is executed?（） Click the Exhibit button and examine the data from the ORDERS and CUSTOMERS tables. Evaluate the SQL statement: SELECT * FROM orders WHERE cust_id = (SELECT cust_id FROM customers WHERE cust_name = 'Smith'); What is the result when the query is executed?（）

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

点击查看答案
第6题
[] 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.  

点击查看答案
第7题
[单选题] 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.  

点击查看答案
第8题
[单选题] 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.  

点击查看答案
第9题
[单选题] Evaluate these two SQL statements: What is true about them?（）

A、The two statements produce identical results.  B、The second statement returns a syntax error.  C、There is no need to specify DESC because the results are sorted in descending order by default.  D、The two statements can be made to produce identical results by adding a column alias for the salary column in the second SQL statement.  

点击查看答案
第10题
[单选题] Evaluate the SQL statement:SELECT ROUND(TRUNC(MOD(1600,10),-1),2)FROM dual;What will be displayed?（）

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

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

请使用微信扫码支付

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