FranklinFaces.com - Oracle & SQL Server Database Forums for all IT Professionals / Oracle Forum / Oracle Certification

OCP 1Z0-001 Practice Test

nowexam — Wed, 14 Jul 2010 03:01:19 GMT

Read the question and then click on the checkbox that contains the correct answer(s). The small field to the immediate right of the question will either display "Yes" if you are correct or "No" if you have selected the wrong answer.
Click on the "Explanation" button to find out more about the answer and click "Next Question" to continue the OCP Practice Test.
Your answers are not graded, so keep track of the topics which with you had difficulty.
There is a poll and additional Oracle resources on the final page of the OCP Practice test so be sure to finish. Good luck!

OCP 1Z0-001 Practice Test

1.Which should you do after each FETCH statement in a PL/SQL block?
A.Open the cursor.
B.Close the cursor.
C.Initialize the loop.
D.Test for rows using a cursor attribute.
Correct:D
2.Given this executable section of a PL/SQL block: BEGIN FOR employee_record IN salary_cursor LOOP employee_id_table(employee_id) := employee_record.last_name; END LOOP; CLOSE salary_cursor; END; Why does this section cause an error?
A.The cursor needs to be opened.
B.No FETCH statements were issued.
C.Terminating conditions are missing.
D.The cursor does not need to be closed.
Correct:D
3.The structure of the DEPT table is as follows: Name Null? Type ------------------------------- -------- ------- DEPTNO NOT NULL NUMBER(2) DNAME VARCHAR2(14) LOC VARCHAR2(13) Examine the code: DECLARE TYPE dept_record_type IS RECORD (dno NUMBER, name VARCHAR2(20)); dept_rec dept_record_type; BEGIN SELECT deptno, dname INTO dept_rec FROM dept WHERE deptno = 10; END; Which statement displays the name of the selected department?
A.DBMS_OUTPUT.PUT_LINE(name);
B.DBMS_OUTPUT.PUT_LINE(dname);
C.DBMS_OUTPUT.PUT_LINE(dept_rec.name);
D.DBMS_OUTPUT.PUT_LINE(dept_rec.dname);
E.DBMS_OUTPUT.PUT_LINE(dept_rec(name));
Correct:C

http://pdf.nowexam.com/1Z0-001.pdf

Database Certification Spotlight: OCP Oracle Database Administrator Certified Profesional

nowexam1 — Tue, 06 Jul 2010 05:21:09 GMT

Database Certification Spotlight: OCP Oracle Database Administrator Certified Profesional
The Oracle Certified Professional credential provides database professionals a chance to prove their mettle when it comes to Oracle database administration or development. Until recently, the Oracle certification program was somewhat confusing and there were a large number of tracks to reaching OCP status. Recent exam/track retirement announcements consolidated these options into two specific programs, the Database Administrator track and the Application Developer track.
In this article, we'll take a brief look at the Database Administrator track and the three possible certifications you can earn on your way to Master status. Our next article will examine the Application Developer track. As with most vendor-specific certifications, the OCP program provides version-specific examinations. Currently, there are three active certification programs: Oracle 9i, Oracle 10g and Oracle 11g. I'd strongly encourage you to certify on the most recent version of Oracle in order to maintain your credential as long as possible.
The first step on the 11g Administrator path is the Oracle 11g Database Administrator Certified Associate credential which requires passing two examinations:
Any one of the following SQL exams: Introduction to Oracle9i SQL (1Z0-007), Oracle Database 11g: SQL Fundamentals I (1Z0-051), or Oracle Database SQL Expert (1Z0-047).
Oracle Database 11g: Administration I. This exam (1Z0-052) is only available through Oracle University or a Prometric testing center.
Once you've achieved your Associate credential, you may move on to achieve the Oracle 11g Database Administrator Certified Professional credential which has the following requirements:
You must first hold the Oracle 11g Database Administrator Certified Associate credential.
You must take at least one instructor-led Oracle-approved training course (online or in-class).
Oracle 11g Database: Administration II Exam. This exam, (1Z0-053) requires you to answer between 180-220 questions in a 3-3.5 hour exam. The exam format will likely change at the conclusion of the beta period in December 2008.
The Professional certification is the normal stopping point for most Oracle certification candidates. However, if you really want to prove your skills, you may attempt the prestigious Oracle 11g Database Administrator Certified Master credential. This program requires you to successfully complete a two-day hands-on examination at Oracle's testing center in Chicago.
Best of luck in your certification quest!

NowExam Oracle OCA Certification

nowexam — Tue, 22 Jun 2010 04:24:02 GMT

The Oracle Certified Associate (OCA) certification is the first level of certification for Oracle Database Administrators (DBA). Individuals who hold this credential have demonstrated that they have mastered introductory Oracle skills and can perform foundation level tasks. It is necessary to hold this certification before moving on to the Oracle Certified Professional (OCP) level and ultimately the Oracle Certified Master (OCM) level.
Target audience
The target audience for the OCA certification is individuals who want to demonstrate their skill level and commitment to their careers as Oracle DBAs. Entry-level DBA's and individuals looking for a job as a DBA are prime candidates for the OCA credential.
Exam details and overview
Candidates must complete two exams in order to complete the requirements for the OCA credential. They have a choice of three exams for their first exam:
Introduction to Oracle9i SQL
Oracle Database SQL Expert
Oracle Database 11g SQL Fundamentals I
Each of these exams has its own specific requirements which can be found on the Oracle Training website.
All candidates must then sit for the Oracle Database Administration I exam. This exam is a 90 minute exam consisting of 70 questions. Candidates must correctly answer 66% of the questions for a passing score, however Oracle clearly states that the passing score may change without notice. Exam topics include Preparing the Database Environment, Create an Oracle Database, Implementing Database Security, Database Maintenance and many others. The complete list can be found on the exam's web page.
Retake policy
Candidates must wait 14 days before retaking a failed OCA exam. Candidates cannot retake a passed exam or a beta exam at any time.
Cost
The cost for the first OCA exam varies according to which exam you choose while the cost for the Oracle Database I exam is $125 USD (although there may be local currency variations depending on the candidate's location). The exams can be taken at any Oracle Testing Center worldwide. Candidates can find their local testing center by registering through the Oracle website but make sure to check with your local testing center for up-to-date price information. Keep a look out for promotional exam discounts from Oracle or for third-party exam voucher specialists to help you save on the cost of the exam.