1Z0-007
单选题Evaluate this SQL statement: SELECT ename, sal, 12* sal+100 FROM emp; 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 "monthly salary plus a monthly bonus o
题目
No change is required to achieve the desired results.
SELECT ename, sal, 12* (sal+100) FROM emp;
SELECT ename, sal, (12* sal)+100 FROM emp;
SELECT ename, sal +100,*12 FROM emp;
相似问题和答案
第1题：
执行如下两个查询，结果为（） Select ename name，sal salary from emp order by salary Select ename name，sal“salary”from emp order by sal asc
- A、两个查询结果完全相同
- B、第一个查询正确，第二个查询错误
- C、两个查询结构不同
- D、第二个查询正确，第一个查询错误
正确答案:A
第2题：
The EMPLOYEE tables has these columns: LAST_NAME VARCHAR2(35) SALARY NUMBER(8,2) COMMISSION_PCT NUMBER(5,2) You want to display the name and annual salary multiplied by the commission_pct for all employees. For records that have a NULL commission_pct, a zero must be displayed against the calculated column. Which SQL statement displays the desired results?（）
- A、SELECT last_name, (salary * 12) * commission_pct FROM EMPLOYEES;
- B、SELECT last_name, (salary * 12) * IFNULL(commission_pct, 0) FROM EMPLOYEES;
- C、SELECT last_name, (salary * 12) * NVL2(commission_pct, 0) FROM EMPLOYEES;
- D、SELECT last_name, (salary * 12) * NVL(commission_pct, 0) FROM EMPLOYEES;
正确答案:D
第3题：
Examine the following commands and their output:SQL> SELECT ename, sal FROM emp WHERE ename=‘JAMES‘; ENAME SAL JAMES 1050QL> UPDATE emp SET sal=sal+sal*1.2 WHERE ename=‘JAMES‘;1 row updated.SQL> SELECT ename, sal FROM emp WHERE ename=‘JAMES‘; ENAME SAL JAMES 2310View the exhibit and examine the Flashback Version Query that was executed after the preceding commands.What could be the possible cause for the query not displaying any row?（）
A. Flashback logging is not enabled for the database.
B. The changes made to the table are not committed.
C. Supplemental logging is not enabled for the database.
D. The database is not configured in ARCHIVELOG mode.
第4题：
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.
正确答案:A
第5题：
Management has asked you to calculate the value 12*salary* commission_pct for all the employees in the EMP table. The EMP table contains these columns: LAST NAME VARCNAR2(35) NOT NULL SALARY NUMBER(9,2) NOT NULL COMMISION_PCT NUMBER(4,2) Which statement ensures that a value is displayed in the calculated columns for all employees?（）
- A、SELECT last_name, 12*salary* commission_pct FROM emp;
- B、SELECT last_name, 12*salary* (commission_pct,0) FROM emp;
- C、SELECT last_name, 12*salary*(nvl(commission_pct,0)) FROM emp;
- D、SELECT last_name, 12*salary*(decode(commission_pct,0)) FROM emp;
正确答案:C
第6题：
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.00
- B、17000*****
- C、****170.00
- D、**17000.00
- E、an error statement
正确答案:E
第7题：
Evaluate this SQL statement: SELECT ename, sal, 12* sal+100 FROM emp; 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 "monthly salary plus a monthly bonus of $100, multiplied by 12"? （）
- A、No change is required to achieve the desired results.
- B、SELECT ename, sal, 12* (sal+100) FROM emp;
- C、SELECT ename, sal, (12* sal)+100 FROM emp;
- D、SELECT ename, sal +100,*12 FROM emp;
正确答案:B
第8题：
A. 17000.00
B. 17000*****
C. ****170.00
D. **17000.00
E. an error statement
第9题：
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.
正确答案:E
第10题：
Which SQL statement generates the alias Annual Salary for the calculated column SALARY*12?（）
- A、SELECT ename, salary*12 'Annual Salary' FROM employees;
- B、SELECT ename, salary*12 "Annual Salary" FROM employees;
- C、SELECT ename, salary*12 AS Annual Salary FROM employees;
- D、SELECT ename, salary*12 AS INITCAP("ANNUAL SALARY") FROM employees
正确答案:B