Pay attention on Pass-king A2090-730 Practice Materials, clear exam 100% for sure

IBM A2090-730 Exam Syllabus Topics:

IBM Assessment: DB2 9 Family Fundamentals Sample Questions:

1. Given the following table definition:
EMPLOYEES
EMPID INTEGER
NAME CHAR(20)
SALARY DECIMAL(10,2)
If the following SQL statement is executed:
CREATE UNIQUE INDEX empid_ui ON employees (empid)
Which two of the following statements are true?

A) No other unique indexes can be created on the EMPLOYEES table.
B) No null values are allowed in the EMPID column of the EMPLOYEES table.
C) Every value found in the EMPID column of the EMPLOYEES table will be different.
D) Multiple null values are allowed in the EMPID column of the EMPLOYEES table.
E) One (and only one) null value is allowed in the EMPID column of the EMPLOYEES table.

2. Which of the following will begin a new unit of work?

A) The first FETCH of a cursor
B) The CONNECT statement
C) The first executable SQL statement
D) The BEGIN TRANSACTION statement

3. Assuming USER1 has no authorities or privileges, which of the following will allow USER1 to create a view named VIEW1 that references two tables named TAB1 and TAB2?

A) SELECT privilege on TAB1 and TAB2
B) REFERENCES privilege on TAB1 and TAB2
C) CREATEIN privilege on the database
D) CREATE_TAB privilege on the database

4. 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 RIGHT OUTER JOIN points p ON n.name = p.name
C) SELECT p.name,n.number, p.points FROM names n INNER 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

5. A table contains a list of all seats available at a football stadium. A seat consists of a section number, a seat number, and whether or not the seat has been assigned. A ticket agent working at the box office generates a list of all unassigned seats. When the agent refreshes the list, it should only change if another agent assigns one or more unassigned seats. Which of the following is the best isolation level to use for this application?

A) Repeatable Read
B) Cursor Stability
C) Uncommitted Read
D) Read Stability

Solutions: