Exam 700 Query--pls help(Urgent)

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

cryon.b@gmail.com - 08 Jun 2006 23:53 GMT

Hi To All,
I took up the IBM sample testfor 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 to this Message

Mark A - 09 Jun 2006 01:15 GMT

> Hi To All,
> I took up the IBM sample testfor Exam 700 today and I have the test
[quoted text clipped - 10 lines]
> c. DB2 UDB Workgroup Server Edition
> d. DB2 Universal Developer's Edition

a. DB2 Connect Personal Edition - This is required to access DB2 UDB for
OS/390 or OS/400 servers from Linux, UNIX, or Windows clients. It is
included in DB2 ESE, but not included in DB2 WSE (Workgroup Server Edition).

> 2. Which of the following DB2 components allows references to Oracle
> and DB2 databases in a single query?
[quoted text clipped - 4 lines]
>
> Iam guessing DB2 Relational Connect for it,correct me if iam wrong.

Don't know this one.

> 3. Cataloging a remote database server from a Linux, UNIX, or Windows
> gateway is:
[quoted text clipped - 8 lines]
>
> I had gone for choice "D",again correct me if iam wrong.

b. performed to identify the server the DB2 database manager is on

The question and possible answers are very poorly worded, but (d) suggests
that each database does not need to be individually catalogued, which is not
true.

> 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
[quoted text clipped - 8 lines]
>
> I had gone for A..was not sure again.

Another very poorly worded question and anwers.

c. It can update rows and have those updated rows be committed by other
transactions from one scan to the next

UR ignores locking on Selects, but UR has no effect on update locking, so
updates do normal locking (blocking others) and updates will lockwait on
locks held by other transactions. So that rules out a and b. I really don't
know for sure what is meant by c, but I would choose it by default.

> 5.Which of the following can duplicate the structure and related
> objects of a database table?
[quoted text clipped - 6 lines]
> and alter is a DDL stmt..Was not sure wheather..it was generate or
> copy?

d. Generate DDL

This is a Control Center GUI function that executes db2look online for an
individual object. This is kind of a cheap shot, since very few DBA's use
this Control Center GUI feature, even though most knowledgeable DBA's use
db2look.

Reply to this Message

Pierre Saint-Jacques - 09 Jun 2006 03:08 GMT

See the add ons to Mark's replies.
Question 2

Signature

Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515

>> Hi To All,
>> I took up the IBM sample testfor Exam 700 today and I have the test
[quoted text clipped - 26 lines]
>
> Don't know this one.

It is Relational Connect. However, tthat was (is?) a product shipped for
DB2 V7.x With V8 and I suppose V9, one would use Websphere Information
Integrator (which may or may not get a new name soon???).

>> 3. Cataloging a remote database server from a Linux, UNIX, or Windows
>> gateway is:
[quoted text clipped - 37 lines]
> locks held by other transactions. So that rules out a and b. I really
> don't know for sure what is meant by c, but I would choose it by default.

I'd agree with Mark. Very badly worded. Choice C doesn't make any sense to
me either. Did you post all choices, most questions have 4 choices. I'd go
for D) It can read uncommitted data and commit its own changes but not have
its changes committed by others (at least I always thought that one commits
its own stuff but never have somone commit my stuff).

>> 5.Which of the following can duplicate the structure and related
>> objects of a database table?
[quoted text clipped - 13 lines]
> this Control Center GUI feature, even though most knowledgeable DBA's use
> db2look.

Somebody needs to get in touch with the test writers. I haven't taken them
since V??? but they use to be better than what I've seen lately!
Regards, Pierre.

Reply to this Message