网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
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
参考答案
参考解析
解析：
暂无解析
更多 “单选题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 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
考题
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 the SQL statement:SELECT LPAD (salary,10,*)FROM EMPWHERE EMP _ ID = 1001;If the employee with the EMP_ID 1001 has a salary of 17000, what is displayed?()
A. 17000.00B. 17000*****C. ****170.00D. **17000.00E. an error statement
考题
Evaluate this SQL statement: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.
考题
Click the Exhibit button and examine the data from the ORDERS and CUSTOMERS tables.Evaluate the SQL statement:SELECT *FROM ordersWHERE cust_id = (SELECT cust_idFROM customersWHERE cust_name = ‘Smith‘);What is the result when the query is executed?（）A.AB.BC.CD.DE.E
考题
Evaluate the SQL statement: SELECT LPAD(salary,10,*) FROM EMP WHERE EMP_ID = 1001; If the employee with the EMP_ID 1001 has a salary of 17000, what is displayed?（）A、17000.00B、17000*****C、****170.00D、**17000.00E、an error statement
考题
Evaluate the SQL statement: 1 SELECT a.emp_name, a.sal, a.dept_id, b.maxsal 2 FROM employees a, 3 (SELECT dept_id, MAX(sal) maxsal 4. FROM employees 5 GROUP BY dept_id) b 6 WHERE a.dept_id = b.dept_id 7 AND a. asl b. maxsal; 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.
考题
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 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.
考题
Which SQL statement accepts user input for the columns to be displayed, the table name, and WHERE condition? （）A、SELECT 1, "2" FROM 3 WHERE last_name = '8';B、SELECT 1, '2' FROM 3 WHERE ' last_name = '8';C、SELECT 1, 2 FROM 3 WHERE last_name = '8';D、SELECT 1, '2' FROM EMP WHERE last_name = '8';
考题
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 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
考题
Evaluate the SQL statement: SELECT LPAD (salary,10,*) FROM EMP WHERE EMP _ ID = 1001; If the employee with the EMP_ID 1001 has a salary of 17000, what is displayed?（）A、17000.00B、17000*****C、****170.00D、**17000.00E、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
考题
Which SELECT statement will the result ‘ello World’ from the string ‘Hello World’?（）A、SELECT SUBSTR( ‘Hello World’,1) FROM dual;B、SELECT INITCAP(TRIM (‘Hello World’, 1,1)) FROM dual;C、SELECT LOWER(SUBSTR(‘Hello World’, 1, 1) FROM dual;D、SELECT LOWER(SUBSTR(‘Hello World’, 2, 1) FROM dual;E、SELECT LOWER(TRIM (‘H’ FROM ‘Hello World’)) FROM dual;
考题
单选题Evaluate the SQL statement: SELECT LPAD(salary,10,*) FROM EMP WHERE EMP_ID = 1001; If the employee with the EMP_ID 1001 has a salary of 17000, what is displayed?（）A
17000.00B
17000*****C
****170.00D
**17000.00E
an error statement
考题
单选题Evaluate the SQL statement: SELECT LPAD (salary,10,*) FROM EMP WHERE EMP _ ID = 1001; If the employee with the EMP_ID 1001 has a salary of 17000, what is displayed?（）A
17000.00B
17000*****C
****170.00D
**17000.00E
an error statement
考题
单选题Evaluate these two SQL statements: SELECT last_name, salary , hire_date FROM EMPLOYEES ORDER BY salary DESC; SELECT last_name, salary , hire_date FROM EMPLOYEES ORDER BY 2 DESC; 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.
考题
单选题Evaluate the SQL statement: SELECT LPAD(salary,10,*) FROM EMP WHERE EMP_ID = 1001; If the employee with the EMP_ID 1001 has a salary of 17000, what is displayed?（）A
17000.00B
17000*****C
****170.00D
**17000.00E
an error statement
考题
单选题Evaluate the SQL statement: 1 SELECT a.emp_name, a.sal, a.dept_id, b.maxsal 2 FROM employees a, 3 (SELECT dept_id, MAX(sal) maxsal 4. FROM employees 5 GROUP BY dept_id) b 6 WHERE a.dept_id = b.dept_id 7 AND a. asl b. maxsal; 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: 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?（）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.
考题
单选题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
热门标签
最新试卷