Which SQL statement generates the alias Annual Salary for the calculated column SALARY*12?（）A、SELECT ename, salary*12 'Annual Salary' FROM employees;B、SELECT ename, salary*12 "Annual Salary" FROM employees;C、SELECT ename, salary*12 AS Annual Salary FROM e

题目

Which SQL statement generates the alias Annual Salary for the calculated column SALARY*12?（）

A、SELECT ename, salary*12 'Annual Salary' FROM employees;
B、SELECT ename, salary*12 "Annual Salary" FROM employees;
C、SELECT ename, salary*12 AS Annual Salary FROM employees;
D、SELECT ename, salary*12 AS INITCAP("ANNUAL SALARY") FROM employees

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

相似问题和答案

第1题：

The OPTIMIZER_USE_PLAN_BASELINES parameter is set to TRUE. The optimizer generates a plan for a SQL statement but does not find a matching plan in the SQL plan baseline.Which two operations are performed by the optimizer in this scenario?（）

A. The optimizer adds the new plan to the plan history.

B. The optimizer selects the new plan for the execution of the SQL statement.

C. The optimizer adds the new plan to the SQL plan baseline as an accepted plan.

D. The optimizer adds the new plan to the SQL plan baseline but not in the ENABLED state.

E. The optimizer costs each of the accepted plans in the SQL plan baseline and picks the one with the lowest cost.

参考答案：A, E

第2题：

Evaluate this SQL statement:In the statement, which capabilities of a SELECT statement are performed?()

A. Selection, projection, join

B. Difference, projection, join

C. Selection, intersection, join

D. Intersection, projection, join

E. Difference, projection, product

参考答案：A

第3题：

View the Exhibit to examine the Automatic SQL Tuning result details.Which action would you suggest for the selected SQL statement in the Exhibit?()

A. Accept the recommended SQL profile.

B.Collect statistics for the related objects.

C. Run the Access Advisor for the SQL statement.

D. Run the Segment Advisor for recommendations.

参考答案：C

第4题：

Which three features work together, to allow a SQL statement to have different cursors for the samestatement based on different selectivity ranges?（）

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,C,E

第5题：

Which three features work together, to allow a SQL statement to have different cursors for the samestatement based on different selectivity ranges?()

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, C, E

第6题：

Which of the following cannot be used as input to the SQL Tuning Advisor?() (Choose all that apply.)

A. A single SQL statement provided by a user

B. An existing SQL Tuning Set (STS)

C. A preprocessed Database Replay workload

D. A schema name

E. SQL statement identified in EM as using excessive resources

参考答案：C, D

第7题：

Examine the structure of the EMPLOYEES and DEPARTMENTS tables:Evaluate this SQL statement:Which SQL statement is equivalent to the above SQL statement?()

参考答案：C

第8题：

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.

参考答案：C

第9题：

You issue this statement：ALTER DATABASE BACKUP CONTROLFILE TO TRACE； What does the statement generate？（）

A、A text copy of the control file.
B、A binary copy of the control file.
C、A file containing a SQL statement which will re-create the database.
D、A file containing a SQL statement which will re-create the control file.

正确答案:D

第10题：

Which statement about the DVS engine is true？（）

A、the DVS engine can useWebroot and McAfee scanning in parallel
B、the DVS engine generates the WBRS
C、the DVS engine never inspects the client HTTP request
D、the DVS engine is only used for Layer 4 traffic monitoring

正确答案:A

Which SQL statement generates th

题目

相似问题和答案

更多相关问题

相关内容