Help with Exam 1Z0-001 3

[Deepti]

Hi All,
I'm going to take the 1Z0-001 SQL & PL/SQL exam next month.I'm using the Exam Cram and Couchman book.I want to know where I can find free practice exams on the internet.I'm aware of STS but I don't think I can afford it.So please help me with any links and resources I can use.
Thanks,
Deepti.

 

[kangs]

Hi Deepti,
I am also started preparing for the same test.
I would suggest you look the following URL which gives Tips.

http://www.whizlabs.com/ocp/ocp-1Z0-001-tips.html

The following URL gives the learning curve for the same test.

http://www.hot-oracle.com/

In case if you end up with some other site. Please do inform me too. :->

Regards
Kangeyan.

 

[sweetleaf]

Hi guys I too am going to take the exam in about a month. i've been using the following site to get up to speed:

http://www.orakle.com/

good luck!

 

[lhugh]

I just took the exam and I can't recall of any questions regarding PCTFree and PCTincrease - the topics which covered in the Admin + Architecture course.

 

[sweetleaf]

Hi,

Does the exam have questions on Data Dictionary Views and on
scoping of grants etc?
I'm a bit confused about the scope of the exam as well..

Thanks

 

[lhugh]

the exam does not have anything about Data Dictionary Views but it does have some questions about priviledges

 

[lhugh]

Here are the topics that being test in my exam:

writing a basic sql statement
restricting and sorting data
single row function
dsipalying data from multiple tables
aggregating data using group functins
writing sub queries
multi column subqueries
producing readable output with sql plus
manipulating data
creating and managing tables
including constraints
creating views
orther database objects
controlling user access
oracle data dictionary
declaring variables
writing executable statements
interacting with the oracle server
writing control structures
working with composite datatypes
writing explicit cursors
advance explicit cursor concepts
handling exception

 

[orin76]

Have any of you had a look at the candidate guides on the Oracle website. I've only written two exams so far, but in both cases the syllabus specified in the candidate guides was right on the money.