Thanks to all for the help and advice.

I cleared my second exam an hour ago. (49/57). It was much more difficult than I expected.

I was using Couchman's developer's guide for this exam and the breakup of questions was different in the exam. In the exam it was

Creating Procedures 8
Creating Functions 8
Creating Packages 8
More Packages Concepts 6
Oracle supplied Packages 6 (Four questions on Dynamic SQL)
Creating Database Triggers 7
More Trigger Concepts 5
Managing Subprograms and Triggers 5
Managing Dependencies 7.

My mistake, I was using the 1999 version of STS and found that the actual exam was totally different than the STS.

Around 6 questions had the options to choose 2 or 3 answes.

Surprisingly one question was repeated twice