单选题Which of the following SQL statements will return the year and average salary for all employees hired within a given year that have a salary greater than $30,000?（）A SELECT * FROM t1 UNION SELECT * FROM t2B SELECT * FROM t1 UNION DISTINCT SELECT * FROM

题目

单选题

Which of the following SQL statements will return the year and average salary for all employees hired within a given year that have a salary greater than $30,000?（）

SELECT * FROM t1 UNION SELECT * FROM t2

SELECT * FROM t1 UNION DISTINCT SELECT * FROM t2

SELECT * FROM t1 INTERSECT SELECT * FROM t2

SELECT * FROM t1 WHERE (c1,c2)= (SELECT c1,c2 FROM t2)

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

相似问题和答案

第1题：

Your database interface is running. A user SCOTT starts a SQL *Plus session, and issues the following query:SQL> SELECT * FROM sales;Which process would retrieve the result from the database and return it to the client program?（）

A. User process

B. Server process

C. System Monitor (SMON)

D. Process Monitor (PMON)

E. Checkpoint process (CKPT)

参考答案：B

第2题：

Which of the following objects contains control structures that are considered the bound form of SQL statements?()

A.UDT

B.Trigger

C.Package

D.Access plan

参考答案：C

第3题：

Which of the following statements about ORACLE is (are) correct?

Ⅰ.ORACLE follows SQL standard

Ⅱ.ORACLE database defines two logical types: table and view

A．Ⅰonly

B．Ⅱ only

C．Ⅰ and Ⅱ

D．none of the above

正确答案：C

第4题：

Which of the following SQL statements will return the year and average salary for all employees hired within a given year that have a salary greater than $30,000?（）

A、SELECT * FROM t1 UNION SELECT * FROM t2
B、SELECT * FROM t1 UNION DISTINCT SELECT * FROM t2
C、SELECT * FROM t1 INTERSECT SELECT * FROM t2
D、SELECT * FROM t1 WHERE (c1,c2)= (SELECT c1,c2 FROM t2)

正确答案:B

第5题：

Which of the following objects contains control structures that are considered the bound form of SQL statements?（）

A、UDT
B、Trigger
C、Package
D、Access plan

正确答案:C

第6题：

You enabled an audit policy by issuing the following statements:SQL> AUDIT POLICY ORA_DATABASE_PARAMETER BY SCOTT;SQL> AUDIT POLICY ORA_DATABASE_PARAMETER BY SYS, SYSTEM;For which database users and for which executions is the audit policy now active? （）

A. SYS, SYSTEM

B. SCOTT

C. Only for successful executions

D. Only for failed executions

E. Both successful and failed executions

参考答案：A, E

第7题：

Which of the following is the proper pronunciation of "this year" as a result of assimilation?

答案：B

解析：

第8题：

Merchandise inventory at the end of the year was understated. Which of the following statements correctly states the effect of the error.()

A.net income is understated

B.net income is overstated

C.merchandise inventory reported on the balance sheet is overstated

D.cost of merchandise sold is understated

正确答案：A

第9题：

An administrator determines that performance has degraded for a WebSphere Commerce database. Which of the following steps should be performed to correct this problem？（）

A、Cleanup obsolete data
B、Clear the WebSphere Commerce cache
C、Enable WebSphere Commerce Accelerator
D、Reindex the database tables
E、Run Performance Monitor to monitor SQL statements

正确答案:A,D

第10题：

Which statement is true when you run the SQL Tuning Advisor with limited scope？（）

A、Access path analysis is not performed for the SQL statements.
B、SQL structure analysis is not performed for the SQL statements.
C、SQL Profile recommendations are not generated for the SQL statements.
D、The staleness and absence of the statistics are not checked for the objects in the query supplied to the SQL Tuning Advisor.

正确答案:C

Which of the following SQL statements will return the year a

题目

相似问题和答案

更多相关问题

相关内容