If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > Exam 700 Query--pls help(Urgent)

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 06-08-06, 19:05
cryon cryon is offline
Registered User
 
Join Date: Mar 2006
Posts: 1
Exam 700 Query--pls help(Urgent)

Hi To All,
I am relatively new to Db2.I took up the IBM sample test for Exam 700 today and I have the test tomorrow,I have some questions for which Iam not sure about the right answer,can anyone please guide me as to what is the right answer for these questions are.This would mean a lot to me.

1..A developer is building an embedded SQL application on AIX that will
access DB2 UDB for OS/390 or OS/400 servers. Which of the following
products is required to be installed on the AIX system in order to
build the application?
a. DB2 Connect Personal Edition
b. DB2 Personal Developer's Edition
c. DB2 UDB Workgroup Server Edition
d. DB2 Universal Developer's Edition

2. 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

Iam guessing DB2 Relational Connect for it,correct me if iam wrong.

3. 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

I had gone for choice "D",again correct me if iam wrong.

4.A unit of work is using an isolation level of Uncommitted Read, and
allows scanning through the table more than once within the unit of
work. Which of the following can occur during processing of this unit
of work?
a. It can access uncommitted changes made by other transactions
It can update uncommitted changes made by other transactions
b. It can update rows and have those updated rows be changed by other
transactions from one scan to the next
c. It can update rows and have those updated rows be committed by other
transactions from one scan to the next

I had gone for A..was not sure again.

5.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

I had guessed A..I am I right?As export is used to dump it to a file
and alter is a DDL stmt..Was not sure wheather..it was generate or
copy?

Can u pls reply to this topic as early as possible,as my exam is
tomorrow morning.Thanks in advance..
Reply With Quote
  #2 (permalink)  
Old 06-09-06, 06:42
grofaty grofaty is offline
Registered User
 
Join Date: Jan 2003
Posts: 1,570
1.a
2.c
3.b
5.a
Reply With Quote
  #3 (permalink)  
Old 06-09-06, 09:48
Marcus_A Marcus_A is offline
Registered User
 
Join Date: May 2003
Location: USA
Posts: 5,196
5.d. This 8.2 Control Center command executes db2look online.

Question 4 is probably missing the correct response (d). Answers a and b are defintiely wrong, and I don't understand c.
__________________
M. A. Feldman
IBM Certified DBA on DB2 for Linux, UNIX, and Windows
IBM Certified DBA on DB2 for z/OS and OS/390
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On