比较半夏泻心汤、生姜泻心汤、甘草泻心汤在用药、功用、主治上的异同。

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;

the monthly salary of the employee. Which change must be made to the above syntax 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．A.select ename， sal*12 ’Annual Salary' from emp

B．B.select ename， sal*12 “Annual Salary” from emp

C．C.select ename， sal*12 as Annual Salary from emp

D．D.select ename， sal*12 as initcap(“ANNUAL SALARY”)from emp;

You run the SQL Tuning Advisor (STA) to tune a SQL statement that is part of a fixed SQL plan baseline. The STA generates a SQL profile for the SQL statement, which recommends that you accept the profile. Which statement is true when you accept the suggested SQL profile？（）

A. The tuned plan is not added to the SQL plan baseline.

B. The tuned plan is added to the fixed SQL plan baseline as a fixed plan.

C. The tuned plan is added to the fixed SQL plan baseline as a nonfixed plan.

D. The tuned plan is added to a new nonfixed SQL plan baseline as a nonfixed plan.

dUSING (department_id)WHERE d.department_id NOT IN (10,40)ORSER BY dept_name;The statement fails when executed. Which change fixes the error？ （）

A. remove the ORDER BY clause

B. remove the table alias prefix from the WHERE clause

C. remove the table alias from the SELECT clause

D. prefix the column in the USING clause with the table alias

E. prefix the column in the ORDER BY clause with the table alias

F. replace the condition "d.department_id NOT IN (10,40)" in the WHERE clause with "d.department_id <> 10 AND d.department_id <> 40"

dUSING (department_id)WHERE d.department_id NOT IN (10,40)ORSER BY dept_name;The statement fails when executed. Which change fixes the error？（）

A. remove the ORDER BY clause

B. remove the table alias prefix from the WHERE clause

C. remove the table alias from the SELECT clause

D. prefix the column in the USING clause with the table alias

E. prefix the column in the ORDER BY clause with the table alias

F. replace the condition "d.department_id NOT IN (10,40)" in the WHERE clause with "d.department_id <> 10 AND d.department_id <> 40"

A．

B．

C．

D．

A. Bind Variable Peeking

B. SQL Plan Baselines

C. Adaptive Cursor Sharing

D. Bind variable used in a SQL statement

E. Literals in a SQL statement

A.The CONNECT statement

B.The first FETCH of a cursor

C.The BEGIN TRANSACTION statement

D.The first executable SQL statement