Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

DB2 Exam 700 Questions answers needed..

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> Mainframe Interview Questions
View previous topic :: :: View next topic  
Author Message
pkmurali
Warnings : 1

Active User


Joined: 15 Dec 2005
Posts: 236

PostPosted: Thu Jul 05, 2007 11:43 am    Post subject: DB2 Exam 700 Questions answers needed..
Reply with quote

1) A client application on OS/390 or OS/400 must access a DB2 server on AIX. At a minimum, which of the following products is required to provide DRDA Application Server functionality on the DB2 server?
A. DB2 Connect Enterprise Edition
B. DB2 UDB Workgroup Server Edition
C. DB2 Connect Enterprise Edition and DB2 UDB Workgroup Server Edition
D. DB2 Connect Enterprise Edition and DB2 UDB Enterprise Server Edition}

2)A developer is building a Windows embedded SQL application that will access DB2 UDB for OS/390 or OS/400 servers. Which of the following products is required to be installed on the Windows system in order to build the application?
A. DB2 UDB Personal Edition
B. DB2 Connect Personal Edition
C. DB2 Personal Developer's Edition
D. DB2 UDB Workgroup Server Edition

3) Which two of the following types of storage management methods are supported by DB2 OLAP Server?
A. Object
B. Network
C. Relational
D. Hierachical
E. Multi-dimensional

4) 3. 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
Back to top
View user's profile Send private message

skkp2006

New User


Joined: 14 Jul 2006
Posts: 93
Location: Chennai,India

PostPosted: Thu Jul 05, 2007 1:53 pm    Post subject: Re: DB2 Exam 700 Questions answers needed..
Reply with quote

I did google search .... thats all :-)


1.DB2 Connect implements the DRDA(R) architecture to reduce the cost and complexity of accessing data stored in DB2(R) UDB for iSeries, DB2 UDB for OS/390(R) and z/OS, DB2 Server for VSE & VM, and other DRDA-compliant database servers.

http://publib.boulder.ibm.com/infocenter/db2luw/v8//index.jsp


2.When applications on Linux, UNIX, and Windows require access to DB2 data on OS/390 and z/OS and iSeries a DB2 Connect server is usually required.

http://www.ibm.com/developerworks/db2/zones/java/bigpicture.html


3.The current version of DB2 OLAP Server, built on DB2 UDB, provides both multidimensional and relational data storage.

http://www.ibm.com/developerworks/db2/library/techarticle/0301jones/0301jones.html

4.DB2 Relational Connect Version 7.2 adds data access to these database management systems:

* Oracle databases from DB2 and DB2 Connect on the Solaris Operating Environment and Linux
* Sybase databases from DB2 and DB2 Connect on AIX and the Solaris Operating Environment
* Microsoft SQL Server databases from DB2 and DB2 Connect on AIX and Windows NT

http://publib.boulder.ibm.com/infocenter/db2v7luw/index.jsp?topic=/com.ibm.db2v7.doc/db2q0/db2q019.htm
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> Mainframe Interview Questions All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Viewing executing process in NDM .. q... Debb.Brant IBM Tools 0 Wed Dec 14, 2016 10:55 pm
No new posts Help Needed with View Direct shailesh_do CA Products 2 Wed Jul 13, 2016 10:39 am
No new posts INCLUDE condition questions van bui DFSORT/ICETOOL 1 Thu Jun 30, 2016 9:52 am
No new posts SAS Programming - Basic Questions Techelm All Other Mainframe Topics 3 Fri Mar 18, 2016 10:53 pm
No new posts Where can i find Interview questions ... Elixir Mainframe Interview Questions 4 Sat Feb 20, 2016 12:38 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us