单项选择题
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_';
相关考题
-
单项选择题
What does the FORCE option for creating a view do?（）
A.creates a view with constraints
B.creates a view even if the underlying parent table has constraints
C.creates a view in another schema even if you don't have privileges
D.creates a view regardless of whether or not the base tables exist -
单项选择题
What is true about updates through a view?（）
A.You cannot update a view with group functions.
B.When you update a view group functions are automatically computed.
C.When you update a view only the constraints on the underlying table will be in effect.
D.When you update a view the constraints on the views always override the constraints on the underlying tables. -
单项选择题
Click the Exhibit button and examine the data from the ORDERS and CUSTOMERS tables. Evaluate the SQL statement: SELECT * FROM orders WHERE cust_id = (SELECT cust_id FROM customers WHERE cust_name = Smith); What is the result when the query is executed?（）
A.A
B.B
C.C
D.D
E.E
