Page 1 of 1

DB2 Certification

Posted: Fri Feb 17, 2006 1:13 pm
by Rupesh.KOthari

db2 certification

Posted: Sat Feb 18, 2006 4:03 am
by Guest
Thanks Rupesh. Information is useful.

Re: DB2 Certification

Posted: Fri Jan 23, 2009 11:56 am
by bata42
Does anybody has some sample questions for DB2 702 exam...

db2 certification sample questions

Posted: Fri Jan 23, 2009 12:16 pm
by Natarajan
Hi Bata,

Welcome to mainframegurukul.com.

You can take sample exam at following location on DB2 702 certification exam.
http://www-03.ibm.com/certify/tests/sam702.shtml

I have some questions with me...not sure these questions belong to which
db2 certification exam. may be userful to you.


A client application on OS/390 or OS/400 must access a DB2 server on Linux. At a minimum, which of the following products is required to be on the DB2 server?

A. DB2 Connect Enterprise Edition

B. DB2 UDB Enterprise Server Edition ********

C. DB2 Connect Enterprise Edition and DB2 UDB Workgroup Server Edition

D. DB2 Connect Enterprise Edition and DB2 UDB Enterprise Server Edition



Which of the following tools can be used to catalog a database?


A. Journal

B. Task Center

C. License Center

D. Configuration Assistant **********



Which of the following DB2 components allows references to Oracle and DB2 databases in a single query?


A. DB2 Query Patroller

B. DB2 Warehouse Manager

C. DB2 Relational Connect ***********

D. DB2 Connect Enterprise Edition



Which of the following is a valid wildcard character in a LIKE clause of a SELECT statement?

A. *

B. _ *********

C. @

D. ?



Given the table COUNTRY and the statements below:
COUNTRY

ID NAME PERSON_ID CITIES
1 Argentina 1 10
2 Canada 2 20
3 Cuba 2 10
4 Germany 1 0
5 France 7 5

DECLARE c1 CURSOR WITH HOLD FOR SELECT * FROM country ORDER BY person_id, name
OPEN c1
FETCH c1
FETCH c1
COMMIT
FETCH c1



Which of the following is the last name obtained from the table
?


A. Cuba

B. France

C. Canada

D. Germany

E. Argentina




Which of the following can duplicate the structure and related objects of a database table?
A. Copy table

B. Alter table

C. Export table

D. Generate DDL *************




What is the difference between a unique index and a primary key?

A. They are different terms for the same concept.

B. Unique indexes can be defined over multiple columns.Primary keys must have only one column.

C. Unique indexes can be defined in ascending or descending order. Primary keys must be ascending.

D. Unique indexes can be defined over a column or columns that allow nulls. Primary keys cannot contain nulls. ********




Which of the following statements eliminates all but one of each set of repeated rows in the final result table?

A. SELECT UNIQUE * FROM t1

B. SELECT DISTINCT * FROM t1 *********

C. SELECT * FROM DISTINCT T1

D. SELECT UNIQUE (*) FROM t1

E. SELECT DISTINCT (*) FROM t1




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 ***********