|
|
|
|
|
|
| Author |
Message |
cryon.b@gmail.com
*nix forums beginner
Joined: 08 Jun 2006
Posts: 1
|
 Posted: Thu Jun 08, 2006 10:53 pm Post subject:
Exam 700 Query--pls help(Urgent)
|
|
|
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.. |
|
| Back to top |
|
 |
Vincent M
*nix forums Guru
Joined: 22 Feb 2005
Posts: 1332
|
| Posted: Fri Jun 09, 2006 12:15 am Post subject:
Re: Exam 700 Query--pls help(Urgent)
|
|
|
<cryon.b@gmail.com> wrote in message
news:1149807185.052721.10800@h76g2000cwa.googlegroups.com...
| Quote: | 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).
| Quote: | 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.
| Quote: | 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.
| Quote: | 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.
| Quote: | 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. |
|
| Back to top |
|
|
Pierre Saint-Jacques
*nix forums Guru Wannabe
Joined: 29 May 2005
Posts: 217
|
| Posted: Fri Jun 09, 2006 2:08 am Post subject:
Re: Exam 700 Query--pls help(Urgent)
|
|
|
See the add ons to Mark's replies.
Question 2
--
Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515
"Mark A" <nobody@nowhere.com> a écrit dans le message de news:
uIWdnRSHKd09IBXZnZ2dnUVZ_rWdnZ2d@comcast.com...
| Quote: | cryon.b@gmail.com> wrote in message
news:1149807185.052721.10800@h76g2000cwa.googlegroups.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???).
| Quote: |
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).
| Quote: |
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. |
|
| Back to top |
|
|
Google
|
|
| Back to top |
|
|
|
|
The time now is Fri Nov 21, 2008 12:43 am | All times are GMT
|
|
Credit Counseling | Home Insurance | Samsung | Mobile Phones | Loans
|
|
Copyright © 2004-2005 DeniX Solutions SRL
|
|
|
|
Other DeniX Solutions sites:
Unix/Linux blog |
electronics forum |
medicine forum |
science forum |
|
|
Privacy Policy
|
Powered by phpBB © 2001, 2005 phpBB Group
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
Forum index
»
Databases
»
IBM DB2
