ORACLE ACDEMY SEMISTER2
TOTAL 50 QUESTIONS Test: PL/SQL Database Programming Semester 1 Final Exam Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer. Section 5 (Answer all questions in this section) 1. Examine the following code. To display the salary of an employee, what must be coded at Point A? DECLARE CURSOR emp_curs IS SELECT * FROM employees; BEGIN FOR emp_rec IN emp_curs LOOP DBMS_OUTPUT.PUT_LINE( -- what goes here ? ); END LOOP; END; Mark for Review (1) Points emp_rec.salary IN emp_curs emp_curs.salary salary emp_rec.salary (*) employees.salary Correct 2. There are no employees in department_id 75. Which of the following is NOT a valid cursor FOR loop with a subquery? Mark for Review (1) Points FOR emp_rec IN (SELECT last_name, salary FROM employees) LOOP ... None of these. They are all valid. (*) FOR...