• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Passed 1z1-043

 
Nicholas Cheung
Ranch Hand
Posts: 4982
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 498
Eclipse IDE Fedora Firefox Browser
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Congrats Nicholas, great job!



Regards,
 
Mikalai Zaikin
Ranch Hand
Posts: 3334
10
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Congrats, Nick !



What's next ?



regards,
MZ
 
Nicholas Cheung
Ranch Hand
Posts: 4982
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
The next will be IBM 257 and IBM 399.

Nick
 
John Ewing
Ranch Hand
Posts: 72
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I don't see either of these tests listed on IBM's site. Are these the correct test numbers?
 
Nicholas Cheung
Ranch Hand
Posts: 4982
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 1011
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
good job, Nick! congratulations!
 
Ping She
Greenhorn
Posts: 16
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 4982
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Greenhorn
Posts: 16
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Greenhorn
Posts: 16
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 4982
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 4982
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

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
Greenhorn
Posts: 16
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
No, the answer is Cursor Stability
 
Ping She
Greenhorn
Posts: 16
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Greenhorn
Posts: 16
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 4982
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

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
Ranch Hand
Posts: 4982
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 4982
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic