IBM DB2 9 Family Fundamentals Sample Questions:
1. Given the following two tables:
NAMES
NAME NUMBER
Wayne Gretzky 99 Jaromir Jagr 68 Bobby Orr 4 Bobby Hull 23 Mario Lemieux 66
POINTS
NAME POINTS
Wayne Gretzky 244 Bobby Orr 129 Brett Hull 121 Mario Lemieux 189 Joe Sakic 94
How many rows would be returned using the following statement?
SELECT name FROM names, points
A) 5
B) 0
C) 25
D) 10
2. The following SQL statements were executed in sequence:
CREATE DISTINCT TYPE salary AS decimal(7,2) WITH COMPARISONS;
CREATE TABLE staffsalary(empid INT, empsalary salary);
INSERT INTO staffsalary VALUES (10, 50000), (20, 50000.00);
UPDATE staffsalary SET empsalary = 60000
WHERE salary(50000) = empsalary;
What is the current content of the staffsalary table?
A) ID | EMPSALARY ----------------- 10 | 60000.00 20 | 50000.00 ----------------
B) ID | EMPSALARY ----------------- 10 | 60000 20 | 50000.00 ----------------
C) ID | EMPSALARY ----------------- 10 | 60000.00 20 | 60000.00 ----------------
D) ID | EMPSALARY ----------------- 10 | 50000.00 20 | 50000.00 ----------------
3. If DB2 detects a deadlock between application A and application B (each waiting for a lock held by the other one), what action will DB2 take?
A) Send a message to let the administrator know of the situation and decide which application or applications should be terminated.
B) Rollback the transaction in one of the two applications.
C) Decrease the lock timeout value for both applications, thereby causing a lock timeout situation.
D) Rollback the transaction in both applications.
4. Which of the following CANNOT be used to restrict specific values from being inserted into a column in a particular table?
A) Default constraint
B) Referential constraint
C) Check constraint
D) Index
5. In which situation is shredding XML data recommended?
A) When thenumber of nodes are volatile
B) When the data is of low volume and requires a complex star-schema topology
C) When the data by nature has sparse attributes
D) When the data is naturally tabular
Solutions:
| Question # 1 Answer: C | Question # 2 Answer: C | Question # 3 Answer: B | Question # 4 Answer: A | Question # 5 Answer: D |
1096 Customer Reviews
Quality and ValueITCertKing Practice Exams are written to the highest standards of technical accuracy, using only certified subject matter experts and published authors for development - no all study materials.
Tested and ApprovedWe are committed to the process of vendor and third party approvals. We believe professionals and executives alike deserve the confidence of quality coverage these authorizations provide.
Easy to PassIf you prepare for the exams using our ITCertKing testing engine, It is easy to succeed for all certifications in the first attempt. You don't have to deal with all dumps or any free torrent / rapidshare all stuff.
Try Before BuyITCertKing offers free demo of each product. You can check out the interface, question quality and usability of our practice exams before you decide to buy.
