分类：
2010-03-22 09:44:33
认证考试中的ICAP(应用开发）DB2 9其中一门考试代号为：
认证名称：IBM DB2 udb v8.1 family fundamentals
1.A table called EMPLOYEE has the following columns: NAME DEPARTMENT PHONE_NUMBER
Which of the following will allow USER1 to modify the PHONE_NUMBER column?
A.GRANT INDEX (phone_number) ON TABLE employee TO user1
B.GRANT ALTER (phone_number) ON TABLE employee TO user1
C.GRANT UPDATE (phone_number) ON TABLE employee TO user1
D.GRANT REFERENCES (phone_number) ON TABLE employee TO user1
Correct:C
2.Which of the following tools is used to create subscription sets and add subscription-set
members to subscription sets?
A.Journal
B.License Center
C.Replication Center
D.Development Center
Correct:C
3.Which of the following DB2 data types CANNOT be used to contain the date an employee was
hired?
A.CLOB
B.TIME
C.VARCHAR
D.TIMESTAMP
Correct:B
4.Given the following table definition: STAFF id INTEGER name CHAR(20) dept INTEGER job
CHAR(20) years INTEGER salary DECIMAL(10,2) comm DECIMAL(10,2) Which of the following
SQL statements will return a result set that satisfies these conditions: -Displays the department ID
and total number of employees in each department. -Includes only departments with at least one
employee receiving a commission (comm) greater than 5000. -Sorted by the department employee
count from greatest to least.
A.SELECT dept, COUNT(*) FROM staff GROUP BY dept HAVING comm > 5000 ORDER BY 2 DESC B.SELECT dept, COUNT(*) FROM staff WHERE comm > 5000 GROUP BY dept, comm ORDER BY 2 DESC
C.SELECT dept, COUNT(*) FROM staff GROUP BY dept HAVING MAX(comm) > 5000 ORDER BY 2 DESC
D.SELECT dept, comm, COUNT(id) FROM staff WHERE comm > 5000 GROUP BY dept, comm ORDER
BY 3 DESC
Correct:C
5.Which two of the following SQL data types should be used to store a small binary image?
A.CLOB
B.BLOB
C.VARCHAR
D.GRAPHIC
E.VARCHAR FOR BIT DATA
Correct:B E
6.A unit of work is using an isolation level of Read Stability. An entire table is scanned twice within
the unit of work. Which of the following can be seen on the second scan of the table?
A.Rows removed by other processes
B.Rows added to a result set by other processes
C.Rows changed in a result set by other processes
D.Rows with uncommitted changes made by other processes
Correct:B
7.Given the following two tables: TAB1 TAB2 C1 C2 CX CY ------ ----- ----- ------ A 11 A 21 B 12 C 22 C
13 D 23 The following results are desired: C1 C2 CX CY ------ ----- ----- ------ A 11 A 21 B 12 - - C 13 C
22 Which of the following joins will yield the desired results?
A.SELECT * FROM tab1 INNER JOIN tab2 ON c1=cx
B.SELECT * FROM tab2 LEFT OUTER JOIN tab1 ON c1=cx
C.SELECT * FROM tab2 FULL OUTER JOIN tab1 ON c1=cx
D.SELECT * FROM tab1 LEFT OUTER JOIN tab2 ON c1=cx
Correct:D
8.Given the following statements from two embedded SQL programs: Program 1: CREATE TABLE
mytab (col1 INT, col2 CHAR(24)) COMMIT Program 2: INSERT INTO mytab VALUES( 20989,'Joe
Smith') COMMIT INSERT INTO mytab VALUES( 21334,'Amy Johnson') DELETE FROM mytab
COMMIT INSERT INTO mytab VALUES( 23430,'Jason French') ROLLBACK INSERT INTO mytab
VALUES( 20993,'Samantha Jones') COMMIT DELETE FROM mytab WHERE col1=20993
ROLLBACK Assuming Program 1 ran to completion and then Program 2 ran to completion, which
of the following records would be returned by the statement: SELECT * FROM mytab?
A.20989, Joe Smith
B.21334, Amy Johnson
C.23430, Jason French
D.20993, Samantha Jones
E.No records are returned.
Correct:D
如果你现在正在准备考，并打算考到这张证，那么你可以到题库网下载更多的免费的资料。
