下列关于我国调解原则的说法，正确的是()。

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

Evaluate this SQL statement:SELECT e.employee_id, (.15* e.salary) + (.5 * e.commission_pct) + (s.sales amount * (.35 * e.bonus)) AS CALC_VALUEFROM employees e, sales sWHERE e.employee_id = s.emp_id;What will happen if you remove all the parentheses from the calculation？ （）

A. The value displayed in the CALC_VALUE column will be lower.

B. The value displayed in the CALC_VALUE column will be higher.

C. There will be no difference in the value displayed in the CALC_VALUE column.

D. An error will be reported.

s of only the employees that are working for departments 10 or 20. Which SQL statement would you use to create the view EMP_VU？ （）

A. CREATE VIEW emp_vu AS SELECT * FROM employees WHERE department _ id IN (10,20);

B. CREATE VIEW emp_vu AS SELECT * FROM employees WHERE department_id IN (10,20) WITH READ ONLY;

C. CREATE VIEW emp_vu AS SELECT * FROM employees WHERE department_id IN (10,20) WITH CHECK OPTION;

D. CREATE FORCE VIEW emp_vu AS SELECT * FROM employees WITH department_id IN (10,20);

E. CREATE FORCE VIEW emp_vu AS SELECT * FROM employees WHERE department_id IN (10,20) NO UPDATE;

s of only the employees that are working for departments 10 or 20.Which SQL statement would you use to create the view EMP_VU？（）

A. CREATE VIEW emp_vu AS SELECT * FROM employees WHERE department_id IN (10,20);

B. CREATE VIEW emp_vu AS SELECT * FROM employees WHERE department_id IN (10,20) WITH READ ONLY;

C. CREATE VIEW emp_vu AS SELECT * FROM employees WHERE department_id IN (10,20) WITH CHECK OPTION;

D. CREATE FORCE VIEW emp_vu AS SELECT * FROM employees WHERE department_id IN (10,20);

E. CREATE FORCE VIEW emp_vu AS SELECT * FROM employees WHERE department_id IN (10,20) NO UPDATE;

the monthly salary of the employee. Which change must be made to the abovesyntax to calculate the annual compensation as "monthly salary plus a monthly bonus of $100, multiplied by 12"？ （）

A. No change is required to achieve the desired results.

B. SELECT ename, sal, 12* (sal+100) FROM emp;

C. SELECT ename, sal, (12* sal)+100 FROM emp;

D. SELECT ename, sal +100,*12 FROM emp;

A．SELECT TO_DATE(SYSDATE, ‘FMDAY, DD Month, YYYY‘) FROM dual;

B． SELECT TO_CHAR(SYSDATE, ‘FMDD, DY Month, ‘YYYY‘) FROM dual;

C． SELECT TO_CHAR(SYSDATE, ‘FMDay, DD Month, YYYY‘) FROM dual;

D． SELECT TO_CHAR(SYSDATE, ‘FMDY, DDD Month, YYYY‘) FROM dual;

E． SELECT TO_DATE(SYSDATE, ‘FMDY, DDD Month, YYYY‘) FROM dual;

plied 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;

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