IBM认证考试
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 t2
题目
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)
相似问题和答案
第1题：
A.View
B.Table
C.Routine
D.Package
第2题：
Which of the following is used to periodically multicast by DIS on a LAN to ensure IS-IS link state databaseaccuracy？（）
- A、CSNP
- B、LSP
- C、ISH
- D、Hello
- E、IIH
- F、PSNP
正确答案:A
第3题：
A. The Memory Advisor
B. The SQL Tuning Advisor
C. The Undo Advisor
D. The SQL Access Advisor
第4题：
Which of the following database objects is considered executable using SQL?（）
- A、View
- B、Table
- C、Routine
- D、Package
正确答案:C
第5题：
Which of the following servers would execute SQL？（）
- A、 Database Server
- B、 DNS Server
- C、 NAS Server
- D、 Web Server
正确答案:A
第6题：
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
第7题：
Which of the following routing protocols is a link state and uses a backbone called area 0？（）
- A、OSPF
- B、EIGRP
- C、BGP
- D、IS-IS
正确答案:A
第8题：
A. System image
B. Incremental backup
C. System state restore
D. Differential backup
第9题：
Which of the following are considered link state protocols?（）
- A、RIPv2 and EIGRP
- B、EGP and IGP
- C、OSPF and IS-IS
- D、RIP and BGP
正确答案:C
第10题：
A System x administrator is considering new storage subsystems. Which of the following is a benefit of SAS over Solid State? （）
- A、Higher transfer speeds
- B、Increased power consumption with Solid State
- C、Increased bandwidth
- D、Cost per MB
正确答案:D