 Posted 7/14/2010 3:01:19 AM
|
|
|
|
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
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
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
help you p***any it certifications,100% Ensure Making you P***the IT Certification!
|
|
|
|