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

题目

单选题

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"?（）

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题：

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 abovesyntax 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

第2题：

The EMP table has these columns:ENAME VARCHAR2(35)SALARY NUMBER(8,2)HIRE_DATE DATEManagement 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;

参考答案：C

第3题：

以下语句不正确的是( )

A.select * from emp;

B.select ename,hiredate,sal from emp;

C.select * from emp order deptno;

D.select * from where deptno=1 and sal<300;

正确答案：C

第4题：

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

第5题：

Evaluate this SQL statement:In the statement, which capabilities of a SELECT statement are performed?()

A. Selection, projection, join

B. Difference, projection, join

C. Selection, intersection, join

D. Intersection, projection, join

E. Difference, projection, product

参考答案：A

第6题：

Evaluate the SQL statement:SELECT ROUND(45.953, －1), TRUNC(45.936, 2)FROM dual;Which values are displayed? ()

A. 46 and 45

B. 46 and 45.93

C. 50 and 45.93

D. 50 and 45.9

E. 45 and 45.93

F. 45.95 and 45.93

参考答案：C

第7题：

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.00

B. 17000*****

C. ****170.00

D. **17000.00

E. an error statement

参考答案：D

第8题：

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.

参考答案：B

第9题：

Examine the structure of the EMPLOYEES and DEPARTMENTS tables:Evaluate this SQL statement:Which SQL statement is equivalent to the above SQL statement?()

参考答案：C

第10题：

The EMPLOYEES table contains these columns: EMPLOYEE_ID NUMBER(4) ENAME VARCHAR2 (25) JOB_ID VARCHAR2(10) Which SQL statement will return the ENAME, length of the ENAME, and the numeric position of the letter "a" in the ENAME column, for those employees whose ENAME ends with a the letter "n"?（）

A、SELECT ENAME, LENGTH(ENAME), INSTR(ENAME, 'a') FROM EMPLOYEES WHERE SUBSTR (ENAME, -1,1) = 'n';
B、SELECT ENAME, LENGTH(ENAME), INSTR(ENAME, ,-1,1) FROM EMPLOYEES WHERE SUBSTR (ENAME, -1,1) = 'n';
C、SELECT ENAME, LENGTH(ENAME), SUBSTR(ENAME, -1,1) FROM EMPLOYEES WHERE INSTR (ENAME, 1,1) = 'n';
D、SELECT ENAME, LENGTH(ENAME), SUBSTR(ENAME, -1,1) FROM EMPLOYEES WHERE INSTR (ENAME, -1,1) = 'n';

正确答案:A

Evaluate this SQL statement: SELECT ename, sal, 12*sal+100 F

题目

相似问题和答案

更多相关问题

相关内容