IBM DB2 9 Family Fundamentals Sample Questions:
1. Application A is designed to execute the following SQL statements within a single Unit of Work
(UOW).
UPDATE employee SET salary = salary * 1.1 WHERE empno='000010'
UPDATE department SET deptname = 'NEW dept' WHERE deptno='A00'
Application B is designed to execute the following SQL statements within a single Unit of Work
(UOW).
UPDATE department SET deptname = 'OLD DEPT' WHERE deptno='A00'
UPDATE employee SET salary = salary * 0.5 WHERE empno='000010'
Application A and application B execute their first SQL statement at the same time. When
application A and application B try to execute their second SQL statement, a deadlock occurs.
What will happen?
A) The database managerwill rollback the transaction in both applications.
B) Application B will successfully update the EMPLOYEE and DEPARTMENT tables; Application A will be placed in a lock wait state.
C) The database managerwill rollback the transaction in one of the two applications.
D) Application A will successfully update the EMPLOYEE and DEPARTMENT tables; Application B will terminate when the lock timeout value is reached.
2. A number of applications issue the following SQL statement: SELECT d.deptno, e.empno, e.salary FROM department d INNER JOIN employee e ON d.deptno = e.deptno A database administrator wishes to store this query within the database. Which of the following database objects can be used to accomplish this?
A) Schema
B) Trigger
C) Alias
D) View
3. Given the following table:
TAB1
COL1 COL2
A 10 B 20 C 30 A 10 D 40 C 30
Assuming the following results are desired:
TAB1
COL1 COL2
A 10 B 20 C 30 D 40
Which of the following statements will produce the desired results?
A) SELECTUNIQUE(*) FROM tab1
B) SELECTDISTINCT(*) FROM tab1
C) SELECT UNIQUE * FROM tab1
D) SELECT DISTINCT * FROM tab1
4. Given the following statements:
CREATE TABLE t1 (c1 INTEGER, c2 CHAR(5));
CREATE TABLE t1audit (user VARCHAR(20), date DATE, action
VARCHAR(20));
CREATE TRIGGER trig1 AFTER INSERT ON t1
FOR EACH ROW
MODE DB2SQL
INSERT INTO t1audit VALUES (CURRENT USER, CURRENT DATE,
'Insert');
If user USER1 executes the following statements:
INSERT INTO t1 VALUES (1, 'abc');
INSERT INTO t1 (c1) VALUES (2);
UPDATE t1 SET c2 = 'ghi' WHERE c1 = 1;
How many new records will be written to the database?
A) 4
B) 2
C) 0
D) 3
5. Which of the following DB2 data types does NOT have a fixed length?
A) XML
B) INT
C) DOUBLE
D) CHAR
Solutions:
| Question # 1 Answer: C | Question # 2 Answer: D | Question # 3 Answer: D | Question # 4 Answer: A | Question # 5 Answer: A |
0 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.
