OCA certification (Developer)

[Trevisolli]

personal, good afternoon.

We set up this topic (certification) , in order to enable the exchange of ideas / experience
for those who think to make sure.

Quest of about 20 days ago, I provided the 1Z0-001 test, which is part of the mandatory "script" to become a hollow (aiming at OCP Developer).

The next test is 1Z0-147 (which I am currently studying).

I set an attachment to the book I studied (1Z0-001) neste Ink and, I am available for clarification.

[szpak88]

I have to get a certificate but I do not know what material should I study where to find a good material and I do not know how much it costs to take this certification someone can help me ...?

grateful ...

[Trevisolli]

Then Brother,

* What certification? To become a developer or DBA?

on the percentage of necessary correctness and the value of the test, this depends on which proof desires to provide.

In my case, I am taking certification for OCP Developer .

I will detail below that way I am treaded:

* The first certification, to reach OCP (Developer or DBA), is the OCA.
* To acquire this certification, two tests must be carried out:
- 1Z0-001 or 1Z0-007 (You choose one of the two, I made 1Z0 -001)
plus:
- 1Z0-147 .

That is, you choose one of the two, as the first proof and necessarily have to go through 1Z0-147 to achieve hollow certification.

All information, such as values, evidence, etc., are at this link below, on Oracle's own website.

There you find the required percentage, test time, proof value etc ... Below is the link of Oracle :

]


To mark / schedule a proof, you may be using the Prometrical site www.prometric.com Adastrar and, schedule in a Authorized location closer to your residence.

In the first topic, I placed the book I studied, to provide 1Z0-001.

My study method (as a tip only) was the following: I read and performed the exercises with the answers and then I eliminated all the answers and made all the questions again.

Any questions, post there.

Success!

[paulochagas]

What is the difference between these two tests ????

[Trevisolli]

Paulo, you say between 1Z0-001 and 1Z0-007, correct?
A 01 is more PL / SQL While 07 is more SQL ...
I believe that, 01 is a bit more "difficult" but prepares more for 1Z0-147.

Whatever, send it there.

[Renan Orati]

Trevisolli, but kara ... these tests are the same for everyone who provides ???

And how can you pass the test links ???

And I'm forced to buy those Self-Study CD's ??? Do you have any other way to study ??


rsrs ... I already filled too much ne ????

vlw !!

[Trevisolli]

Brother, beleza guy?

Next:

Trevisolli, but Kara ... These evidence is the same for everyone who renders ???
The tests are held at the authorized center and, I believe to be the same for all, not in the same order. I provided 1Z0-001 and, you could also be scheduling this test.

and how can you pass the links of the evidences???
The links of evidence, brother, with all the necessary information, is above, is a link from Oracle itself.
Link: b] http://education.oracle.com/pls/web_pro ... age_id=155

and I am required to buy those Self-Study CD's ??? Do you have any other way to study ??
No need not brother, I for example, I studied for this book I posted in this topic too.

]
Anything I can help you, just speak Brother.

.

[Renan Orati]

Well ... then let's go! ... rsrs

question 2

Answer: C, E, F

c. INSERT INTO EMPLOYEES
Values ??( ' 1000 ' , 'John', NULL)

Would not it be wrong ????
As soon as employee_id is of the number
and it is inserting a data type varchar ???

[Trevisolli]

Brother,

This question is correct.
I took a test here:

Select all

 
INSERT INTO emp (empno, ename, job) 
VALUES ('1000', 'Trevisolli', NULL) ; 

Probably, Oracle checks what is inside the quotation marks (in the case above) in the validation of the insertion.

This below goes wrong (invalid number):

Select all

 
INSERT INTO emp (empno, ename, job) 
VALUES ('A', 'Trevisolli', NULL) ; 

[rodfbar]

Well manero this topic ...

Trevi, do you remember any questions in the test of quando you render ??



Abrçs

[Breno]

Very good friend this topic.Valeu for the tips. I intend if God wants to do certification test (OCA) in 2008 and before taking an official course of Oracle. Another material or tip can dispose here in the topic do not be ashamed heheheheheh.
a hug and even more.

[Trevisolli]

Hmmm brother, to be honest, I think there's a lot of tank saw guy .. But, this example of the 1000 in quotation marks, no longer ceases to be .. rs ... we hardly remember these things ...

remember something, I'm posting here, beleza?

[kaique]

Goodnight. I was very interested in Oracle's developer certification. As you are preparing, I would like to take some doubts, can it?

1 -> I heard rumors that to become an Oracle certificate, it was necessary to have at least 1 official course of them. Does this proceed?

2 -> Studying alone Just to get approval in the exams?

3 -> I found a lot of official material, for example, PL / SQL of version 10G. If I study for them, will I have complications in the evidence? If I'm not mistaken, the tests are turned to version 9i.

I think for now it's just.

Thanks.
[] 's.

[Trevisolli]

Good morning, brother.
Is everything okay?

follow answers below:


1 -> I heard a rumors that to become an Oracle certificate, it was necessary to have, in the Minimum 1 of them official course. Does this proceed?
It is no longer necessary, I honestly do not know for sure the period in which this situation occurred but today it is not necessary to have this course.
I myself, studied only by the handout of this topic and carried out the test.

2 -> Studying alone Just to get approval in the exams?
Tranquil, no problems. There are on the Internet simulators, examples example etc.

3 -> I found very official material, for example, PL / SQL of version 10G. If I study for them, will I have complications in the evidence? If I'm not mistaken, the tests are turned to version 9i.
I believe you will not have problems. What happens is that you will study a little more because new objects that have been incorporated in 10G, which for example did not exist in previous versions.
Any questions, send there .

[Porto]

Opa beleza?

Kaique you said you found a lot of material for study of version 10g. Can you make them available?

I am interested in taking my certification as well, work just over a year as a PL / SQL Oracle 9i programmer. I started without knowing anything with a stage opportunity, today I'm not an expert, but I already understand much about language.

Seeing the first test "01" for the hollow did not seem very difficult to me, but as I will provide for version 10g I want to see the material focused on this version. To see the news of the 10G version I do not know.

Note: Could someone indicate a good tunning course for PL / SQL?

Thanks and good luck to all.

[kaique]

The material I succeeded is not aimed at certification, but covers all content on PL / SQL of version 10G. If you still want the material, send me your email that I send you ...

[].

[Porva]

Paulão, that is, then that this certification is not as expensive as I imagined, as long as the guy has the mates of studying alone, without having to do the courses?


Number exam: 1Z0-001
Price exam.: $ 125.00 USD
http://education.oracle.com/pls/web_pro ... xam_id=1Z0_ Egocution is raling a while, and starting the English soon, to help in the interpretation of the texts of the test: S


on the values, I read something around R $ 4,000.00!, but should be the preparatory courses, proceeds ?

[Trevisolli]

So Brother,

You can grate alone to do the tests.
It is no longer necessary official course, which is usually expensive.

on the value of the test, the ones I did (1Z0-001 and 1Z0-147) were worth $ 125.00.

Whatever, send me brother.

[Porva]

Just another curiosity, the tests were where, in SP?

[Trevisolli]

I provided in Ribeirão Preto, Brother, in the Center courses ([url=http://www.centercursos.com.br]www.centercursos.com.br . The Prometric website ([url=http://www.prometric.com]Prometric , when you go schedule, you select the nearest location available.

In Sampa I know you have a lot of authorized center.

gives a researched brother, if you register on the prometric website, and whatever doubt, send it there.

[gokden]

About these Oca evidence ...
Would you know if there is any difference between them from Portuguese to English ??

Because I was told that it changes some things in the tests ....

Brigado ...

[Trevisolli]

Then brother,

a friend provided one in Portuguese but, particularly, I prefer proof in English.

I'vê heard, that the translation was not the best but, there goes the taste and preparation of the student ...

Whatever, send there .

[Renan Orati]

Good morning ... kara ... you do not have iz-001 without the answers ???

= D

vlw !!!

[Trevisolli]

Brother,

I have this doc ai, which I convert from PDF to Word.

Baixar OC

Whatever, send it there.

[caduribeiro13]

Trevisolli,
always wanted to start a certification in Oracle Developer and this topic encouraged me, I'vê been working with PL / SQL for some time. A friend from work once told me that the best material to study for Oracle certification, are the docs made available by Oracle itself on your site. Do you agree? The guy is certified in DBA and is very fierce.

Embrace.

[NaPraia]

Thanks for the handouts and tips.

From what I am understanding the tests are basically pl / sql,
does not the person need not even know the forms and reports?

I'm going to make this simulation that was posted without answering and seeing how I get out. What is the percentage of necessary hits ??

[Trevisolli]

Brother,

on Forms and Reports, in the OCA (Developer, I believe that in the DBA also not), nothing falls.

As for the issue of the quantity of correctness, on page 1 of this same topic, that you can consult in Oracle itself, the proof you want (link below):

] Rune page, has enough information and link to other websites, including Oracle itself, for percentage consultation etc.

Whatever, send us.

[NaPraia]

Funny that I am in Question 10 (I have not yet consulted the feedback)
I think there is no right question.
And when I did the test to enter the company I am, this question fell and remember that I also thought I had no answer.
I think I'll find more questions I made on the test to enter the company.

What are you waiting for to do OCP?

[ricardorauber]

Hello everyone,

I did at the beginning of the year the tests 007 and 147 successfully!

I studied for myself by downloading hundreds of thousands of pdfs and simulator programs on the internet but what I actually used were one or two of these PDFs.

I want to prevent you from taking good care of these evidence in P2P programs because I found issues corrected with wrong answers and researching the Internet I discovered that some companies do this so that the student bought the original Instead of downloading a pirate.

in relation to evidence, I made 007 in Portuguese and 147 in English. Particularly, would not have a problem doing 007 in English but I decided to do in Portuguese to give more focus of the studies in 147.
The tests are quite simple but with many handle-raton, the most difficult in the test is to observe mere Details like quotation marks in numbers, as an example they cited in previous answers here in this topic.

An interesting tip is to start the test by passing the eyes quickly for all the questions by the end and then return to actually start because so all the questions will already be downloaded and, according to legend, there will not be Dowload issues according to your performance.

As for the issues employed in the tests, it is worth looking at the Oracle website where it says what contents will be studied because it falls exactly there just that applied in example tables (after the tests I did not want more Listen to Table Employees hehehe)

[NaPraia]

Well, I'm taking the test that Trevisolli posted from the first proof
I have 60% set without having read the PDF before, just by Word (without answers).
Some commands I never used there I do not even know what to do.
I think by installing Oracle at home and redoing the questions one by one in the micro and see what the mistakes and hits it gives.

is that you can not do in the trap, lack access.

I think after that I am apt





In case I decide to make the first proof for certification, what is the first step I should do?
Who should I contact to pay, mark test time, etc ???

Thanks

[Trevisolli]

Brother,

Take a look at the initial pages of this topic.
If I'm not mistaken on page 1 has the information.

to schedule, pay etc, can be by prometric: www.prometric.com OSA, send it there.

[NaPraia]

I'm already half an hour on the site, I'vê already been able to select the test, and when I'm going to select the location it gives you a registration error. Then I'm trying to register but I can not. It's harder to register than to do the test. hehehe
I think it might be a problem with Firefox, I'll try through the IE.
Strange that the two centers that showed are locations of Microsoft official courses. That I did not understand.

I'll fuck a little more

[Tupi]

OBS> Prometric reports a thousand types of tests, so the centers will be micro $ of.

[bruno.almeida]

I am thinking of taking the hollow certification, but I have some doubts:

1 - I do not have any knowledge in the database, I have only in programming (Java and c / C ++). Is this a very big problem? Well I was thinking of taking a course, and I do not know if they teach since the basics or already needs to have a base.

2 - I walked looking at some courses and there is a big price difference between the courses that are registered on the Oracle website and those who are not there (that at least in são Paulo). Well I read that you do not need an official course to take out the certification, but will the difference in quality is great as the price?

Thanks from now on

[Trevisolli]

Then Brother, follow below:

1- I do not have any knowledge in the database, I have only in programming (Java and C / C ++). Is this a very big problem? Well I was thinking of taking a course, and I do not know if they teach since the basics or already needs to have a base.

Brother, honestly? It's a problem.
Oracle Certification Questions, both for Developer and DBA, are directly related to the database, especially Oracle.
Taking as a parameter A hollow , you interact directly with object creation, search for information, so it is indicated that you have contact with database, to face certification.

2- I walked looking at some courses and there is a great price difference between the courses that are registered on the Oracle website and those who are not there (that at least in São Paulo) . Well I read that you do not need an official course to take out the certification, but will the difference in quality is great as the price?

Based on the objective of taking the OCP Developer [/b], which I took about 15 days ago, I did not require any officer.
Yes, a search on Oracle's own website, and check if for the proof you want to provide (if not OCP Developer), you need the course or not.

In this same topic, on the first page, I put some information that I found essential for those who are in the path of certification: http://en.glufke.net/oracle/viewtopic.php?t=1898 Obre the first, as the second test (from the OCA): http://en.glufke.net/oracle/viewtopic.php?t=2335 MA handles in these two topics and, any questions will send us to us.

Good luck!

[bruno.almeida]

Oracle Certification Questions, both for Developer and DBA, are directly related to the database, especially Oracle.
Taking up as a parameter to hollow, you interact directly with object creation, search for information, so I indicate that you have contact with database, to face certification.

But what you commented on was the test, right? Because said "certification issues ...". Does I even take a course I will not be able to accompany and try to take the hollow after?

[Trevisolli]

Brother,

If you take a course, if you engage, and study, you sure can, and if you need something, tell us about the forum here.

[bruno.almeida]

Oops! valeu!

I'm almost sure I'm going to take the course yes ... but unfortunately not this year ($$$) ... but I'm already researching to see if it's worth it, and these things.

[Tupi]

bruno.almeida

If POA is a tip for IT of official training center that is very reduced prices.

If you want a touch tip.

[klaus]

The exams 1Z0-042 and 1Z0-043

are for which certification

[gokden]

Face .... a question ....
a 1Z0-001 does it use 8i pl / sql for evaluation ??

because my proof is marked for October 31, and I took some mistakes in this simulated, and in Oracle, they recommend studying the 8i PL / SQL

Recommended Training and Preparation
Introduction to Oracle 8i: SQL and PL / SQL - ILO

Introduction to Oracle8i: SQL and PL / SQL Self-Study CD Course (NETG)
Self-Study CD-ROMs Are An Excellent Tool to Help You prepare for your exam. Sscds Reinforce The Course Material and Allow You to Focus On Sections That You Need To Review. Note: The Sscds do Not Count Towns Your Course Requirements for Certification and Should Be Used A Study Aid Only.

grateful ...

[wagner-morais]

I made the proof of 1Z0-001 today.
Of the two hours available I only used 1:20 asking questions calmly.
I studied this book here: http://en.glufke.net/oracle/download/Ex ... 005.01.rar Judou and soooo.

Another source of research was the book:
dominating the Oracle 9i of the author Damaris Fanderuff. http://www.linuxmall.com.br/index.php?product_id=1348 Ivro, I recommend to all.

Now post a good book for 1Z0-147 to take the hollow certificate.
Thanks!

[Trevisolli]

Brother, congratulations on the certification and thanks for the tips.

About the book for certification 1Z0-147 , I provided and, I made available this material here as well.

Take a look at this link (OCA 2A. Proof):
http://en.glufke.net/oracle/viewtopic.p ... 35&start=0 Equity, count on us.

[Darlei]

Brother, ball show, try to 147 now, I studied with the materials of the Oracle University in English, the book you studied is in Portuguese, I never studied in Portuguese but I believe that the technical terms change, for example I speak join and Here in the trap they speak joints, I have heard that in the race also change these terms, the best way to prepare for 147 is studying in English, I believe ...
Hugs .. . Hope this helps

[wagner-morais]

Thanks for the answers.
Darlei, the book is well translated, since the technical terms remain in English.
This is the best book I'vê ever seen, so much so that at work everyone asks him.

I'm going to study for 147, have you ever done the test?

[Trevisolli]

So Brother,

I made the handout that is in the link above that I passed you and, from right, without crisis.

Anything, send us.

[Darlei]

I did these days at 147, it was even easy in view of how much I studied, it fell a lot about libraries and dbms and administering Large Objects, but it was Sussa, studies a lot and handles a pdfs to make simulated you pass, I wanted to know if In this book there are pl and web tips, would you know how to inform me? I know there is HTP.Print and HTP.Script and etc, however I would like to read a book with JavaScript and PL / SQL integration and etc =)

[wagner-morais]

Dude, I'll get the book at night and put it here, but I'll remember it does not have PL / web.
After taking the test 001 the status in Prometic changes? For mine is:
Pending

[bride]

Personal you know where I get Sumiado from "Oracle Database 10g: Administration I 1Z0-042" in Portuguese to study?

[Darlei]

Simulated in Portuguese I find it kind of difficult and not effective ...