Given the following two tables:
NAMES NAME NUMBER
Wayne Gretzky 99 Jaromir Jagr 68 Bobby Orr 4 Bobby Hull 23 Brett Hull 16 Mario Lemieux 66 Mark Messier 11 POINTS NAME POINTS
Wayne Gretzky 244 Jaromir Jagr 168 Bobby Orr 129 Brett Hull 121 Mario Lemieux 189 Joe Sakic 94
Which of the following statements will display the player name, number, and points for all players that have scored points?
A. SELECT p.name,n.number, p.points FROM names n LEFT OUTER JOIN points p ON n.name = p.name
B. SELECT p.name,n.number, p.points FROM names n INNER JOIN points p ON n.name = p.name
C. SELECT p.name,n.number, p.points FROM names n RIGHT OUTER JOIN points p ON n.name = p.name
D. SELECT p.name,n.number, p.points FROM names n FULL OUTER JOIN points p ON n.name = p.name
正解:C
質問 2:
Given the following query:
SELECT last_name, first_name, age, hire_date
FROM employee WHERE age > 40 Which of the following clauses must be added to return the rows sorted by AGE, oldest first, and by LAST_NAME, from A to Z?
A. ORDER BY age DESC,last_name
B. SORT BY age DESC,last_name
C. SORT BY age ASC,last_name
D. ORDER BY age ASC,last_name
正解:A
質問 3:
Which of the following is true about XML columns?
A. XML columns must be altered to accommodate additional parent/child relationships if they are used in referential constraints
B. XML columns are used to store XML documents as a hierarchical set of entities
C. In order to access any portion of an XML document stored in an XML column, the entire document must be retrieved
D. OnlyXQuery can be used to retrieve an XML document from an XML column
正解:B
質問 4:
Application A is running under the Repeatable Read isolation level and holds an Update lock on table TAB1. Application B wants to query table TAB1 and cannot wait for Application A to release its lock. Which isolation level should Application B run under to achieve this objective?
A. Repeatable Read
B. Uncommitted Read
C. Cursor Stability
D. Read Stability
正解:B
質問 5:
Which of the following tools can make recommendations for indexes and/or MQTs to improve the performance of DB2 applications?
A. Visual Explain
B. Design Advisor
C. Configuration Assistant
D. Performance Advisor
正解:B
質問 6:
When does a view get populated?
A. Any time an executable SQL statement references it
B. When it is created
C. When it is referenced in an INSERT statement
D. The first time any executable SQL statement references it
正解:A



0 お客様のコメント