单选题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

第1题：

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;

第2题：

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;

第3题：

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.

第4题：

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;

第5题：

User SCOTT executes the following command on the EMP table but has not issued COMMIT， ROLLBACK， orany data definition language （DDL） command： SQL> SELECT ename FROM emp WHERE job=’CLERK’ FOR UPDATE OF empno； SCOTT has opened another session to work with the database instance.  Which three operations would waitwhen issued in SCOTT’s second session（）

• A、LOCK TABLE emp IN SHARE MODE；
• B、LOCK TABLE emp IN EXCLUSIVE MODE；
• C、UPDATE emp SET sal=sal*1.2 WHERE job=ANAGER？UPDATE emp SET sal=sal*1.2 WHERE job=？ANAGER？
• D、INSERT INTO emp（empno，ename） VALUES （1289，’Harry’）；
• E、SELECT ename FROM emp WHERE job=’CLERK’ FOR UPDATE OF empno

第6题：

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;

第7题：

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

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;

第14题：

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.

第15题：

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

第16题：

The EMP table has these columns: ENAME VARCHAR2(35) SALARY NUMBER(8,2) HIRE_DATE DATE Management wants a list of names of employees who have been with the company for more than five years. Which SQL statement displays the required results? （）

• A、SELECT ENAME FROM EMP WHERE SYSDATE-HIRE_DATE >5;
• B、SELECT ENAME FROM EMP WHERE HIRE_DATE-SYSDATE >5;
• C、SELECT ENAME FROM EMP WHERE (SYSDATE_HIRE_DATE)/365 >5;
• D、SELECT ENAME FROM EMP WHERE (SYSDATE_HIRE_DATE)*/365 >5;

第17题：

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

第18题：

Evaluate these two SQL statements:SELECT last_name, salary, hire_dateFROM EMPLOYEES ORDRE BY salary DESC; SELECT last_name, salary, hire_dateFROM EMPOLYEES 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.

第19题：

第20题：

第21题：

第22题：

第23题：

第24题：