Hi Friends
Please find the all details for DB2 Certification....
IBM Available Certifications:
http://www-03.ibm.com/certify/certs/dm_index.shtml
IBM Test Information:
http://www-03.ibm.com/certify/tests/test_index.shtml
Exam 700 Guidelines:
http://www-03.ibm.com/certify/tests/obj700.shtml
http://www-03.ibm.com/certify/tests/edu700.shtml
Exam 702 Guidelines:
http://www-03.ibm.com/certify/tests/obj702.shtml
http://www-03.ibm.com/certify/tests/edu702.shtml
DB2 - Certification - Everything you need to Know http://www-106.ibm.com/developerworks/d ... sdick.html
Hope this helps
DB2 Certification
Moderators: Kalicharan, Moderator Group
- Rupesh.KOthari
- Member
- Posts: 17
- Joined: Thu Feb 16, 2006 5:27 pm
DB2 Certification
------------------------
Thanks & Regards
Rupesh
-----------------------
Sun Shines Everywhere
Thanks & Regards
Rupesh
-----------------------
Sun Shines Everywhere
Re: DB2 Certification
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
db2 certification sample questions
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 ***********
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
Chennai
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
- Cobol Interview Questions
50+ Interview Questions - JCL Interview Questions
50+ Interview Questions - DB2 Interview Questions
100+ Interview Questions - CICS Interview Questions
70+ Interview Questions - VSAM Interview Questions
27 Interview Questions
Other References
Mainframe Tools and others
- XPEDITER Reference
Explains how we can debug a program - FILEAID Reference
Explains how to browse , edit and delete datasets - Change Man Reference
Quick Start tutorial on Changeman - Abend Reference
Important Abend codes explained - FaceBook Page
MainframeGurukul FaceBook Page - LinkedIn Page
MainframeGurkul Linkedin Page