SampleTest700hust.docVIP

Pre-Assessment/Sample Test for Test 700 Exam 700 - DB2 UDB V8.1 Family Fundamentals Duration 75 minutes Total questions 30 Questions required for a pass 18 ( 60% ) 1. Cataloging a remote database server from a Linux, UNIX, or Windows gateway is: A. performed to identify the location of the clients. B. performed to identify the server the DB2 database manager is on. C. never performed in DB2, as only one database per node is allowed, so cataloging a node automatically catalogs the database at that node. D. performed on a Linux, UNIX, or Windows machine to open the catalogs in the DB2 database server and present a user with a list of all accessible tables in that database. 2. Which of the following will give USER6 the ability to give SELECT privilege on table T.T1 to other users? A. GRANT SELECT ON TABLE t.t1 TO user6 B. GRANT ALL PRIVILEGES ON TABLE t.t1 TO user6 * C. GRANT USE ON TABLE t.t1 TO user6 WITH GRANT OPTION D. GRANT ALL PRIVILEGES ON TABLE t.t1 TO user6 WITH GRANT OPTION 3. USER3 is running a program A.APP1 that calls stored procedure P.PROC1. As an administrator, which of the following statements should be executed to give USER3 the appropriate privilege to be able to execute the code found in stored procedure P.PROC1? A. GRANT EXECUTE ON PACKAGE a.app1 TO user3 B. GRANT EXECUTE ON PROCEDURE a.app1 TO user3 C. GRANT EXECUTE ON FUNCTION p.proc1 TO user3 * D. GRANT EXECUTE ON PROCEDURE p.proc1 TO user3 4. Given a SELECT statement that has a GROUP BY clause. The HAVING clause uses the same syntax as which other clause? A. WHERE B. UNION * C. SUBQUERY D. ORDER BY 5. Given the following tables: NAMES Name Number Wayne Gretzky 99 Jaromir Jagr 68 Bobby Orr 4 Bobby Hull 23 Brett Hull 16 Mario Lemieux 66 Steve Yzerman 19 Claude Lemieux 19 Mark