0
1
0.00
An error statement
单选题Evaluate the SQL statement: SELECT ROUND(45.953, -1), TRUNC(45.936, 2) FROM dual; Which values are displayed?()A 46 and 45B 46 and 45.93C 50 and 45.93D 50 and 45.9E 45 and 45.93F 45.95 and 45.93
点击查看答案
单选题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.
单选题Evaluate this SQL statement: SELECT e.employee_id, (.15* e.salary) + (.5 * e.commission_pct) + (s.sales amount * (.35 * e.bonus)) AS CALC_VALUE FROM employees e, sales s WHERE e.employee_id = s.emp_id; What will happen if you remove all the parentheses from the calculation? ()A The value displayed in the CALC_VALUE column will be lower.B The value displayed in the CALC_VALUE column will be higher.C There will be no difference in the value displayed in the CALC_VALUE column.D An error will be reported.
单选题Evaluate the SQL statement:SELECT ROUND(TRUNC(MOD(1600,10),-1),2)FROM dual;What will be displayed?()A 0B 1C 0.00D an error statement
单选题Evaluate this SQL statement: What will happen if you remove all the parentheses from the calculation?()AThe value displayed in the CALC_VALUE column will be lower.BThe value displayed in the CALC_VALUE column will be higher.CThere will be no difference in the value displayed in the CALC_VALUE column.DAn error will be reported.
单选题The EMPLOYEES table contains these columns: LAST_NAME VARCHAR2 (25) SALARY NUMBER (6,2) COMMISSION_PCT NUMBER (6) You need to write a query that will produce these results: 1. Display the salary multiplied by the commission_pct. 2. Exclude employees with a zero commission_pct. 3. Display a zero for employees with a null commission value. Evaluate the SQL statement: SELECT LAST_NAME, SALARY*COMMISSION_PCT FROM EMPLOYEES WHERE COMMISSION_PCT IS NOT NULL; What does the statement provide? ()A All of the desired resultsB Two of the desired resultsC One of the desired resultsD An error statement
单选题Evaluate the following query: SQL> SELECT TRUNC(ROUND(156.00,-1),-1)FROM DUAL; What would be the outcome?()A 16 B 100 C 160 D 200 E 150