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

参考答案和解析

正确答案:A

更多“The EMPLOYEES table contains th”相关问题

第1题

设置表格边框色彩的亮度的HTML代码是（）A、<th bordercolorlight=#> B、<table bordercolor=#> C、<th bordercolor=#> D、<table bordercolorlight=#>

点击查看答案
第2题

Which two statements complete a transaction?（）A、DELETE employees;B、DESCRIBE employees;C、ROLLBACK TO SAVE POINT C;D、GRANT SELECT ON employees TO SCOTHE、ALTER TABLE employees SET UNUSED COLUMN sal;F、Select MAX(sal) FROM employees WHERE department _ id 20;

点击查看答案
第3题

Which two statements complete a transaction? （）A、DELETE employees;B、DESCRIBE employees;C、ROLLBACK TO SAVEPOINT C;D、GRANT SELECT ON employees TO SCOTT;E、ALTER TABLE employees SET UNUSED COLUMN sal;F、SELECT MAX(sal) FROM employees WHERE department_id = 20;

点击查看答案
第4题

You added a PHONE_NUMBER column of NUMBER data type to an existing EMPLOYEES table. The EMPLOYEES table already contains records of 100 employees. Now, you want to enter the phone numbers of each of the 100 employees into the table. Some of the employees may not have a phone number available. Which data manipulation operation do you perform?（）A、MERGEB、INSERTC、UPDATED、ADDE、ENTERF、You cannot enter the phone numbers for the existing employee records.

点击查看答案
第5题

表格语法格式正确的是（）。A、〈table〉〈tr〉〈td〉内容〈/td〉〈/tr〉〈/table〉B、〈table〉〈tr〉内容〈/tr〉〈td〉内容〈/td〉〈/table〉C、〈table〉〈tr〉〈th〉内容〈/th〉〈td〉内容〈/td〉〈/tr〉〈/table〉D、〈table〉〈tr〉〈td〉〈th〉内容〈/th〉〈/td〉〈/tr〉〈/table〉

点击查看答案
第6题

Which two operations can be flashed back using the Flashback technology？（）A、DROP USER SMITH；B、DROP TABLE EMPLOYEES；C、DROP TABLESPACE USERS；D、ALTER TABLE SALES_REP DROP PARTITION P1；E、ALTER TABLE EMPLOYEES DROP COLUMN DESIG_ID；

点击查看答案
第7题

User Scott has updated the salary of one of the employees in the EMPLOYEES table and has not committed the transaction. What are the two types of locks that this scenario would lead to？（）A、null lock on the row being updatedB、null lock on the table containing the rowC、ROW SHARE lock for the row being updatedD、ROW EXCLUSIVE lock for the row being updatedE、shared row-exclusive lock for the row being updatedF、a shareable table lock for the table containing the rowG、exclusive table-level lock for the table containing the row

点击查看答案

Oracle认证考试

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 th”相关问题

第1题

第2题

第3题

第4题

第5题

第6题

第7题

相关内容