DB2 Certification

Ask question on - DataBase Concepts, IBM Mainframe DB2, DB2/UDB, DB2 Tools, SQL , DB2 programming with languages like COBOL, PL1.

Moderators: Kalicharan, Moderator Group

Post Reply
User avatar
Rupesh.KOthari
Member
Posts: 17
Joined: Thu Feb 16, 2006 5:27 pm

DB2 Certification

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

------------------------
Thanks & Regards
Rupesh
-----------------------
Sun Shines Everywhere

Guest

db2 certification

Post by Guest » Sat Feb 18, 2006 4:03 am

Thanks Rupesh. Information is useful.

bata42
Member
Posts: 2
Joined: Fri Jan 23, 2009 11:54 am

Re: DB2 Certification

Post by bata42 » Fri Jan 23, 2009 11:56 am

Does anybody has some sample questions for DB2 702 exam...
Never under-estimate the bandwidth of a station wagon full of tapes hurtling down the highway

User avatar
Natarajan
Moderator
Posts: 537
Joined: Fri Oct 10, 2008 12:57 pm
Location: chennai
Contact:

db2 certification sample questions

Post by Natarajan » Fri Jan 23, 2009 12:16 pm

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

Post Reply

FREE TUTORIALS

Tutorials
Free tutorials from mainframegurukul
  • JCL Tutorial
    Covers all important JCL concepts.
  • Cobol Tutorial
    This tutorials covers all Cobol Topics from STRING to COMP-3.
  • DB2 Tutorial
    DB2 Tutorial focuses on DB2 COBOL Programming.
  • SORT Tutorial
    This Tutorial covers all important aspects of DFSORT with examples
  • CICS Tutorial
    This CICS tutorial covers CICS concepts and CICS Basics, CICS COBOL Programming.
Interview
Mainframe Interview questions



Other References
Mainframe Tools and others