违法和不良信息举报 联系客服
免费注册 登录

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

题目
单选题
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';

如果没有搜索结果或未解决您的问题，请直接 联系老师 获取答案。
相似问题和答案

第1题：

Examine the data in the EMPLOYEES table:LAST_NAME DEPARTMENT_ID SALARYGetz 10 3000Davis 20 1500Bill 20 2200Davis 30 5000...Which three subqueries work? ()

A. SELECT * FROM employees where salary > (SELECT MIN(salary) FROM employees GROUP BY department _ id);

B. SELECT * FROM employees WHERE salary = (SELECT AVG(salary) FROM employees GROUP BY department _ id);

C. SELECT distinct department_id FROM employees Where salary > ANY (SELECT AVG(salary) FROM employees GROUP BY department _ id);

D. SELECT department_id FROM employees WHERE SALARY > ALL (SELECT AVG(salary) FROM employees GROUP BY department _ id);

E. SELECT last_name FROM employees Where salary > ANY (SELECT MAX(salary) FROM employees GROUP BY department _ id);

F. SELECT department_id FROM employees WHERE salary > ALL (SELECT AVG(salary) FROM employees GROUP BY ANG (SALARY));


参考答案：C, D, E

第2题：

Examine the structure of the EMPLOYEES and NEW_EMPLOYEES tables: EMPLOYEES EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2 (25) LAST_NAME VARCHAR2 (25) HIRE_DATE DATE NEW EMPLOYEES EMPLOYEE_ID NUMBER Primary Key NAME VARCHAR2 (60) Which DELETE statement is valid? （）

  • A、DELETE FROM employees WHERE employee_id = (SELECT employee_id FROM employees);
  • B、DELETE * FROM employees WHERE employee_id = (SELECT employee_id FROM new_ employees);
  • C、DELETE FROM employees WHERE employee_id IN (SELECT employee_id FROM new_employees WHERE name = ('Carrey')'
  • D、DELETE * FROM employees WHERE employee_id IN (SELECT employee_id FROM new_employees WHERE last_ name = ('Carrey')'

正确答案:C

第3题：

与 “ SELECT DISTINCT 歌手号 FROM 歌手 WHERE 最后得分＞ = ALL ;(SELECT 最后得分 FROM 歌手 WHERE SUBSTR( 歌手号 ,1,1)="2") ” 等价的 SQL 语句是

A)SELECT DISTINCT 歌手号 FROM 歌手 WHERE 最后得分＞ = ;

(SELECT MAX( 最后得分 ) FROM 歌手 WHERE SUBSTR( 歌手号 ,1,1)="2")

B)SELECT DISTINCT 歌手号 FROM 歌手 WHERE 最后得分＞ = ;

(SELECT MIN( 最后得分 ) FROM 歌手 WHERE SUBSTR( 歌手号 ,1,1)="2")

C)SELECT DISTINCT 歌手号 FROM 歌手 WHERE 最后得分＞ =ANY ;

(SELECT 最后得分 FROM 歌手 WHERE SUBSTR( 歌手号 ,1,1)="2")

D)SELECT DISTINCT 歌手号 FROM 歌手 WHERE 最后得分＞ =SOME ;

(SELECT 最后得分 FROM 歌手 WHERE SUBSTR( 歌手号 ,1,1)="2")


正确答案：A

第4题：

Examine the description of the EMPLOYEES table: EMP_ID NUMBER(4) NOT NULL LAST_NAME VARCHAR2(30) NOT NULL FIRST_NAME VARCHAR2(30) DEPT_ID NUMBER(2) Which statement produces the number of different departments that have employees with last name Smith?（）

  • A、SELECT COUNT(*) FROM employees WHERE last_name='Smith';
  • B、SELECT COUNT(dept_id) FROM employees WHERE last_name='Smith';
  • C、SELECT DISTINCT(COUNT(dept_id)) FROM employees WHERE last_name='Smith';
  • D、SELECT COUNT(DISTINCT dept_id) FROM employees WHERE last_name='Smith';
  • E、SELECT UNIQUE(dept_id) FROM employees WHERE last_name='Smith';

正确答案:D

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

Click the Exhibit button and examine the data in the EMPLOYEES table.Which three subqueries work? ()

A.SELECT * FROM employees where salary > (SELECT MIN(salary) FROM employees GROUP BY department_id);

B.SELECT * FROM employees WHERE salary = (SELECT AVG(salary) FROM employees GROUP BY department_id);

C.SELECT distinct department_id FROM employees WHERE salary > ANY (SELECT AVG(salary) FROM employees GROUP BY department_id);

D.SELECT department_id FROM employees WHERE salary > ALL (SELECT AVG(salary) FROM employees GROUP BY department_id);

E.SELECT last_name FROM employees WHERE salary > ANY (SELECT MAX(salary) FROM employees GROUP BY department_id);

F.SELECT department_id FROM employees WHERE salary > ALL (SELECT AVG(salary) FROM employees GROUP BY AVG(SALARY));


参考答案：C, D, E

第7题：

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

第8题：

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

第9题：

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_';

正确答案:A

第10题：

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%'

正确答案:A

更多相关问题
相关内容