Passed 1z1-043

[Nicholas Cheung]

Just check from the website of Prometric that I got passed in the beta exam of 1z1-043.

It is a tough exam I felt, 3 hours for 215 questions. Much much more questions that we need to handle but with less time, compare to SCJP Tiger beta.

Anyway, that's a good experience.

Nick

[Marcelo Sousa Ancelmo]

Congrats Nicholas, great job!



Regards,

[Mikalai Zaikin]

Congrats, Nick !



What's next ?



regards,
MZ

[Nicholas Cheung]

The next will be IBM 257 and IBM 399.

Nick

[John Ewing]

I don't see either of these tests listed on IBM's site. Are these the correct test numbers?

[Nicholas Cheung]

These exams are going to be released before June 2005. Please check for the link of "New Tests in 2005".

IBM 257 is WSAD 6.0 (known as IBM 287 for WSAD 5.0).

IBM 399 is Portal Development 5.1 (known as IBM 348 for WSAD 5.0)

Nick

[Tong Chen]

good job, Nick! congratulations!

[Ping She]

Hi,Nic:

I understand that you passed IBM cert 700 exam.
I have a question here for you:

SQL source statements for which two of the following are stored in the system catalog?

Views
Tables
Indexes
Triggers
Constraints

I did some research and found all of them are stored in the syscat.
Can you please tell me the answer and source of your reference?

Thanks and regards!

ping

[Nicholas Cheung]

I also feel that all of them should be stored in syscat.

Where is the source of the questions?

I believe there is not much mock exam for DB2 certs.

Nick

[Ping She]

Hi, Nick:

I have the same feeling as you. However, the answer is views and triggers.
The source of the exam is http://www.selftestsoftware.com/Assessments/DB2.aspx

It is free. You are welcome to take the exam and give me your thoughts.

Thanks!

[Ping She]

Hi, Nick:

From the test source, I got another question for you:

Given a read-only application that requires consistent data for every query, which of the following isolation levels should it use to provide the most concurrency with other applications doing updates?

Read Stability
Repeatable Read
Cursor Stability
Uncommitted Read

which one is the answer?

[Nicholas Cheung]

I have figured out what we might miss in the previous question. It stated that: SQL source statements for which two of the following are stored in the system catalog?

For source statement, I believe it means the raw SQL statement, e.g. SELECT * FROM TABLE_A, hence, only view and trigger will be stored in such format. All other options are in database specific format.

Do you think that this is reasonable?

Nick

[Nicholas Cheung]

Given a read-only application that requires consistent data for every query, which of the following isolation levels should it use to provide the most concurrency with other applications doing updates?

Read Stability
Repeatable Read
Cursor Stability
Uncommitted Read

I guess the answer is Uncommitted Read.

Nick

[Ping She]

No, the answer is Cursor Stability

[Ping She]

For this one:

_________________________________________________________________________
I have figured out what we might miss in the previous question. It stated that: SQL source statements for which two of the following are stored in the system catalog?

For source statement, I believe it means the raw SQL statement, e.g. SELECT * FROM TABLE_A, hence, only view and trigger will be stored in such format. All other options are in database specific format.

Do you think that this is reasonable?

Nick
__________________________________________________________________________


Cannot SQL like create index/table... be stored in the syscat?

[Ping She]

Nick:

Anyway, you did not see those odd questions in the 700 exam, right?
Are the exam 700 questions similar to the exercises in the book that you recommended: DB2 UDB V8.1 Certification Exam 700 Study Guide
by Roger E. Sanders ?

thanks!

yan

[Nicholas Cheung]

Are the exam 700 questions similar to the exercises in the book?

Yes, most of the questions are very very similiar, if not the same.

Roger's DB2 cert. series are very good for preparing DB2 exams.

Nick

[Nicholas Cheung]

Originally posted by Ping She:
No, the answer is Cursor Stability

Oh, I overlooked the question. I just mis-thought that the application is read only, but then, in fact, there are some other applications that will update the database.

In such, we need to make sure that there cannot be uncommitted read because this might violate the serializability theory.

Also, you dont need to have repeatable read, because the application is for read only, not updatable.

Hence, Cursor stability seems more reasonable, but I sometime get mixed up between cursor stability and repeatable read.

There will be 1-2 questions in such format.

Nick

[Nicholas Cheung]

Cannot SQL like create index/table... be stored in the syscat?

I dont think so. For example, for view, you wont store any data for this, because you might need to update it, when your base table is updated. However, if I query the DB every time when the view is used, we dont need to have that update. So, the raw SQL (for retrieving that view) is directly stored.

However, for index, we wont store the SQL (create index ....) because what we need is NOT to query the table, but to have a "faster" mechanism to query the table. If we just store the SQL, no performance gain.

I believe that's what the question asking for. All 5 objects are stored in syscat, however, only views and triggers will in raw SQL format. Others are of database specific format (depends on how the DB implement them).

Nick