单选题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_ - 搜考题

违法和不良信息举报联系客服

免费注册登录

题目

单选题

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

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

相似问题和答案

第1题：

You own a table called EMPLOYEES with this table structure: EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2(25) LAST_NAME VARCHAR2(25) HIRE_DATE DATE What happens when you execute this DELETE statement? DELETE employees;（）

A、You get an error because of a primary key violation.
B、The data and structure of the EMPLOYEES table are deleted.
C、The data in the EMPLOYEES table is deleted but not the structure.
D、You get an error because the statement is not syntactically correct.

正确答案:C

第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 name = 'carrey');

正确答案:C

第3题：

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

第4题：

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

A、The SQL statement displays the desired results.
B、The column in the WHERE clause should be changed to display the desired results.
C、The operator in the WHERE clause should be changed to display the desired results.
D、The WHERE clause should be changed to use an outer join to display the desired results.

正确答案:C

第5题：

Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2(25) LAST_NAME VARCHAR2(25) HIRE_DATE DATE Which UPDATE statement is valid?（）

A、UPDATE employees SET first_name = 'John' SET last_name ='Smith' WHERE employee_id = 180;
B、UPDATE employees SET first_name = 'John', SET last_name ='Smith' WHERE employee_id = 180;
C、UPDATE employees SET first_name = 'John' AND last_name ='Smith' WHERE employee_id = 180;
D、UPDATE employees SET first_name = 'John', last_name ='Smith' WHERE employee_id = 180;

正确答案:D

第6题：

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

第7题：

Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER NOT NULL, Primary Key EMP_NAME VARCHAR2(30) JOB_ID NUMBER/ SAL NUMBER MGR_ID NUMBER References EMPLOYEE_ID column DEPARTMENT_ID NUMBER Foreign key to DEPARTMENT_ID column of the DEPARTMENTS table You created a sequence called EMP_ID_SEQ in orderto populate sequential values for the EMPLOYEE_ID column of the EMPLOYEES table. Which two statements regarding the EMP_ID_SEQ sequence are true? （）

A、You cannot use the EMP_ID_SEQ sequence to populate the JOB_ID column.
B、The EMP_ID_SEQ sequence is invalidated when you modify the EMPLOYEE_ID column.
C、The EMP_ID_SEQ sequence is not affected by modifications to the EMPLOYEES table.
D、Any other column of NUMBER data type in your schema can use the EMP_ID_SEQ sequence.
E、The EMP_ID_SEQ sequence is dropped automatically when you drop the EMPLOYEES table.
F、The EMP_ID_SEQ sequence is dropped automatically when you drop the EMPLOYEE_ID column.

正确答案:C,D

第8题：

Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2(25) LAST_NAME VARCHAR2(25) Which three statements inserts a row into the table? （）

A、INSERT INTO employees VALUES (NULL, 'JOHN','Smith');
B、INSERT INTO employees( first_name, last_name) VALUES ('JOHN','Smith');
C、INSERT INTO employees VALUES ('1000','JOHN','NULL');
D、INSERT INTO employees(first_name,last_name, employee_id) VALUES ('1000, 'john','Smith');
E、INSERT INTO employees (employee_id) VALUES (1000);
F、INSERT INTO employees (employee_id, first_name, last_name) VALUES ( 1000, 'john',");

正确答案:C,E,F

第9题：

Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2 (25) LAST_NAME VARCHAR2 (25) HIRE_DATE DATE Which UPDATE statement is valid? （）

A、UPDATE employees SET first_name = 'John' SET last_name = 'Smith' WHERE employee_id = 180;
B、UPDATE employees SET first_name = 'John', SET last_name = 'Smoth' WHERE employee_id = 180;
C、UPDATE employee SET first_name = 'John' AND last_name = 'Smith' WHERE employee_id = 180;
D、UPDATE employee SET first_name = 'John', last_name = 'Smith' WHERE employee_id = 180;

正确答案:D

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

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

更多相关问题

相关内容