题目内容（请给出正确答案）

[主观题]

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.

查看答案

如搜索结果不匹配，请联系老师获取答案

您可能会需要：

重置密码查看订单联系客服

安装赏学吧APP，拍照搜题省时又省心！

更多“Evaluate these two SQL stateme…”相关的问题

第1题

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

点击查看答案

第2题

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.

点击查看答案

第3题

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.

点击查看答案

第4题

The EMPLOYEES table contains these columns:LAST_NAME VARCHAR2 （25)SALARY NUMBER （6,2)COMMI

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 EMPLOYEESWHERE COMMISSION_PCT IS NOT NULL;What does the statement provide？（）

A. All of the desired results

B. Two of the desired results

C. One of the desired results

D. An error statement

点击查看答案

第5题

Evaluate these two SQL statements: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.

点击查看答案

第6题

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‘;

点击查看答案

第7题

You need to display the last names of those employees who have the letter "A" as the second character in their names. Which SQL statement displays the required results？（）

A. SELECT last_name FROM EMP WHERE last_ name LIKE ‘_A%‘;

B. SELECT last_name FROM EMP WHERE last name =‘*A%‘

C. SELECT last_name FROM EMP WHERE last name =‘_A%‘;

D. SELECT last_name FROM EMP WHERE last name LIKE ‘*A%‘

点击查看答案

第8题

The EMPLOYEE tables has these columns:You want to display the name and annual salary multi

plied 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;

点击查看答案

第9题

The EMPLOYEES table contains these columns:EMPLOYEE_ID NUMBER（4)LAST_NAME VARCHAR2 （25)JOB

The EMPLOYEES table contains these columns:EMPLOYEE_ID NUMBER(4)LAST_NAME VARCHAR2 (25)JOB_ID VARCHAR2(10)You want to search for strings that contain ‘SA_‘ in the JOB_ID column. Which SQL statement do you use？（）

A. SELECT employee_id, last_name, job_id FROM employees WHERE job_id LIKE ‘%SA\_%‘ESCAPE‘\‘;

B. SELECT employee_id, last_name, job_id FROM employees WHERE job_id LIKE ‘%SA_‘;

C. SELECT employee_id, last_name, job_id FROM employees WHERE job_id LIKE ‘%SA_‘ESCAPE‘\‘;

D. SELECT employee_id, last_name, job_id FROM employees WHERE job_id ‘%SA_‘;

点击查看答案

第10题

The EMPLOYEE tables has these columns:LAST_NAME VARCHAR2（35)SALARY NUMBER（8,2)COMMISSION_P

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;

点击查看答案