By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,686 Members | 2,770 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,686 IT Pros & Developers. It's quick & easy.

Exam 700 Query--pls help(Urgent)

P: n/a
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..

Jun 8 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
<cr*****@gmail.com> wrote in message
news:11*********************@h76g2000cwa.googlegro ups.com...
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

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

Don't know this one.
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.

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

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?
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?


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.
Jun 9 '06 #2

P: n/a
See the add ons to Mark's replies.
Question 2
--
Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515
"Mark A" <no****@nowhere.com> a écrit dans le message de news:
uI******************************@comcast.com...
<cr*****@gmail.com> wrote in message
news:11*********************@h76g2000cwa.googlegro ups.com...
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

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


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

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


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.

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?
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?


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.

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.

Jun 9 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.