单选题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 =
题目
SELECT &1, &2 FROM &3 WHERE last_name = '&8';
SELECT &1, '&2' FROM &3 WHERE '& last_name = '&8';
SELECT &1, &2 FROM &3 WHERE last_name = '&8';
SELECT &1, '&2' FROM EMP WHERE last_name = '&8';
相似考题
参考答案和解析
更多“单选题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题：
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 -
第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;
正确答案:C -
第3题：
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 -
第4题：
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 name = 'carrey');
正确答案:C -
第5题：
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';
正确答案:C -
第6题：
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 -
第7题：
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 -
第8题：
下列哪些SQL语句可以查询出User表中name为张三的记录（）。
- A、SELECT * FROM User WHERE name = ’张三’
- B、SELECT * FROM User WHERE name = ’张三’ LIMIT 0，1
- C、SELECT * FROM User WHERE name LIKE ’张三’
- D、SELECT * FROM User WHERE name LIKE ’%张三%’
正确答案:A,B,C,D -
第9题：
单选题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?（）ADELETE FROM employees WHERE employee_id = (SELECT employee_id FROM employees);
BDELETE * FROM employees WHERE employee_id = (SELECT employee_id FROM new_ employees);
CDELETE FROM employees WHERE employee_id IN (SELECT employee_id FROM new_employees WHERE name = 'carrey');
DDELETE * FROM employees WHERE employee_id IN (SELECT employee_id FROM new_employees WHERE name = 'carrey');
正确答案： C解析： 暂无解析 -
第10题：
单选题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? （）ADELETE FROM employees WHERE employee_id = (SELECT employee_id FROM employees);
BDELETE * FROM employees WHERE employee_id = (SELECT employee_id FROM new_ employees);
CDELETE FROM employees WHERE employee_id IN (SELECT employee_id FROM new_employees WHERE name = ('Carrey')'
DDELETE * FROM employees WHERE employee_id IN (SELECT employee_id FROM new_employees WHERE last_ name = ('Carrey')'
正确答案： A解析： 暂无解析 -
第11题：
单选题Which SQL statement accepts user input for the columns to be displayed, the table name, and WHERE condition? （）ASELECT &1, &2 FROM &3 WHERE last_name = '&8';
BSELECT &1, '&2' FROM &3 WHERE '& last_name = '&8';
CSELECT &1, &2 FROM &3 WHERE last_name = '&8';
DSELECT &1, '&2' FROM EMP WHERE last_name = '&8';
正确答案： A解析： 暂无解析 -
第12题：
单选题Which SQL statement accepts user input for the columns to be displayed, the table name, and the WHERE condition?（）ASELECT &1, &2 FROM &3 WHERE last_name = '&4';
BSELECT &1, '&2' FROM &3 WHERE '&last_name = '&4'';
CSELECT &1, &2 FROM &3 WHERE last_name = '&4';
DSELECT &1, '&2' FROM EMP WHERE last_name = '&4';
正确答案： B解析： 暂无解析 -
第13题：
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 -
第14题：
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 -
第15题：
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 -
第16题：
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 -
第17题：
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;
正确答案:C -
第18题：
Examine the data in the EMPLOYEES table: LAST_NAME DEPARTMENT_ID SALARY Getz 10 3000 Davis 20 1500 Bill 20 2200 Davis 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 -
第19题：
Which SQL statement accepts user input for the columns to be displayed, the table name, and the WHERE condition?（）
- A、SELECT &1, "&2" FROM &3 WHERE last_name = '&4';
- B、SELECT &1, '&2' FROM &3 WHERE '&last_name = '&4'';
- C、SELECT &1, &2 FROM &3 WHERE last_name = '&4';
- D、SELECT &1, '&2' FROM EMP WHERE last_name = '&4';
正确答案:C -
第20题：
单选题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?（）ASELECT last_name FROM EMP WHERE last_name LIKE ‘_A%’;
BSELECT last_name FROM EMP WHERE last name =’*A%’
CSELECT last_name FROM EMP WHERE last name =’_A%’;
DSELECT last_name FROM EMP WHERE last name LIKE ‘*A%’
正确答案： B解析： 暂无解析 -
第21题：
多选题Examine the data in the EMPLOYEES table: Which three subqueries work? （）ASELECT * FROM employees where salary > (SELECT MIN(salary) FROM employees GROUP BY department _ id);
BSELECT * FROM employees WHERE salary = (SELECT AVG(salary) FROM employees GROUP BY department _ id);
CSELECT distinct department_id FROM employees Where salary > ANY (SELECT AVG(salary) FROM employees GROUP BY department _ id);
DSELECT department_id FROM employees WHERE SALARY > ALL (SELECT AVG(salary) FROM employees GROUP BY department _ id);
ESELECT last_name FROM employees Where salary > ANY (SELECT MAX(salary) FROM employees GROUP BY department _ id);
FSELECT department_id FROM employees WHERE salary > ALL (SELECT AVG(salary) FROM employees GROUP BY ANG (SALARY));
正确答案： D,E解析： 暂无解析 -
第22题：
单选题The EMP table contains these columns: LAST_NAME VARCHAR2 (25) SALARY NUMBER (6,2) DEPARTMENT_ID NUMBER (6) You need to display the employees who have not been assigned to any department. You write the SELECT statement: SELECT LAST_NAME, SALARY, DEPARTMENT_ID FROM EMP WHERE DEPARTMENT_ID = NULL; What is true about this SQL statement ?（）AThe SQL statement displays the desired results.
BThe column in the WHERE clause should be changed to display the desired results.
CThe operator in the WHERE clause should be changed to display the desired results.
DThe WHERE clause should be changed to use an outer join to display the desired results.
正确答案： C解析： 暂无解析 -
第23题：
单选题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?（）ADELETE FROM employees WHERE employee_id = (SELECT employee_id FROM employees);
BDELETE * FROM employees WHERE employee_id = (SELECT employee_id FROM new_employees);
CDELETE FROM employees WHERE employee_id IN (SELECT employee_id FROM new_employees WHERE name ='Carrey');
DDELETE * FROM employees WHERE employee_id IN (SELECT employee_id FROM new_employees WHERE last_name ='Carrey');
正确答案： B解析： 暂无解析 -
第24题：
多选题Examine the data in the EMPLOYEES table: LAST_NAME DEPARTMENT_ID SALARY Getz 10 3000 Davis 20 1500 Bill 20 2200 Davis 30 5000 ... Which three subqueries work? （）ASELECT * FROM employees where salary > (SELECT MIN(salary) FROM employees GROUP BY department _ id);
BSELECT * FROM employees WHERE salary = (SELECT AVG(salary) FROM employees GROUP BY department _ id);
CSELECT distinct department_id FROM employees Where salary > ANY (SELECT AVG(salary) FROM employees GROUP BY department _ id);
DSELECT department_id FROM employees WHERE SALARY > ALL (SELECT AVG(salary) FROM employees GROUP BY department _ id);
ESELECT last_name FROM employees Where salary > ANY (SELECT MAX(salary) FROM employees GROUP BY department _ id);
FSELECT department_id FROM employees WHERE salary > ALL (SELECT AVG(salary) FROM employees GROUP BY ANG (SALARY));
正确答案： D,B解析： 暂无解析