aspose file tools*
The moose likes Product and Other Certifications and the fly likes Passed 1z1-043 Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Certification » Product and Other Certifications
Bookmark "Passed 1z1-043" Watch "Passed 1z1-043" New topic
Author

Passed 1z1-043

Nicholas Cheung
Ranch Hand

Joined: Nov 07, 2003
Posts: 4982
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


SCJP 1.2, OCP 9i DBA, SCWCD 1.3, SCJP 1.4 (SAI), SCJD 1.4, SCWCD 1.4 (Beta), ICED (IBM 287, IBM 484, IBM 486), SCMAD 1.0 (Beta), SCBCD 1.3, ICSD (IBM 288), ICDBA (IBM 700, IBM 701), SCDJWS, ICSD (IBM 348), OCP 10g DBA (Beta), SCJP 5.0 (Beta), SCJA 1.0 (Beta), MCP(70-270), SCBCD 5.0 (Beta), SCJP 6.0, SCEA for JEE5 (in progress)
Marcelo Sousa Ancelmo
Ranch Hand

Joined: Jan 17, 2002
Posts: 497

Congrats Nicholas, great job!



Regards,


Marcelo Sousa Ancelmo - Brazil
Mikalai Zaikin
Ranch Hand

Joined: Jun 04, 2002
Posts: 3231
    
    6
Congrats, Nick !



What's next ?



regards,
MZ


Free SCDJWS 5.0 Study Guide - SCDJWS 5.0 Quiz (How to get SCDJWS 5.0 Quiz)
Java Platform, Enterprise Edition 6 Web Services Developer Certified Expert Exam Study Guide and Quiz
Nicholas Cheung
Ranch Hand

Joined: Nov 07, 2003
Posts: 4982
The next will be IBM 257 and IBM 399.

Nick
John Ewing
Ranch Hand

Joined: Dec 19, 2003
Posts: 72
I don't see either of these tests listed on IBM's site. Are these the correct test numbers?


John E.<br /> <br />SCJP (1.4, 5.0), SCJD, SCWCD (1.3, 1.4), SCBCD, SCDJWS, SCSA (Solaris 9), SCNA, SCSecA, MCP, MCAD, MCSD.NET, MCDBA, IBM 815, IBM XML, ICSD (IBM 288), XML Master (Basic), OCA (9i PL/SQL dev, 10g DBA), OCP (10g DBA), OMG UML Fundamental & Intermediate, MySQL 4 Core & Professional, MySQL 5 Developer & DBA, A+, Network+, Security+
Nicholas Cheung
Ranch Hand

Joined: Nov 07, 2003
Posts: 4982
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

Joined: Apr 26, 2002
Posts: 1011
good job, Nick! congratulations!


Tong Chen (Seattle USA)<br />SCJP,SCWCD,SCDJWS,IBM XML,MCP.NET,MCAD.NET,MCSD.NET
Ping She
Greenhorn

Joined: Sep 28, 2004
Posts: 16
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

Joined: Nov 07, 2003
Posts: 4982
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

Joined: Sep 28, 2004
Posts: 16
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

Joined: Sep 28, 2004
Posts: 16
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

Joined: Nov 07, 2003
Posts: 4982
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

Joined: Nov 07, 2003
Posts: 4982

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

Joined: Sep 28, 2004
Posts: 16
No, the answer is Cursor Stability
Ping She
Greenhorn

Joined: Sep 28, 2004
Posts: 16
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

Joined: Sep 28, 2004
Posts: 16
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

Joined: Nov 07, 2003
Posts: 4982

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

Joined: Nov 07, 2003
Posts: 4982
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

Joined: Nov 07, 2003
Posts: 4982

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
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Passed 1z1-043