Section 4
					
		1. 	In the following code fragment, you want to exit from the outer loop at Line A if v_number = 6. Which statement would you write on Line A?

<<big_loop>>
WHILE condition_1 LOOP
    <<small_loop>>
    FOR i IN 1..10 LOOP
       DBMS_OUTPUT.PUT_LINE(i);
       -- Line A
    END LOOP;
END LOOP;
	Mark for Review 
(1) Points
					
			
	IF v_number = 6 THEN EXIT;
	
			
	EXIT outer_loop WHEN v_number = 6;
	
			
	EXIT big_loop WHEN v_number = 6; (*)
	
			
	EXIT small_loop WHEN v_number = 6;
	
					
				
Correct		Correct
	
					
		2. 	You want to display multiplication tables for numbers up to 12. The display should look like this:
1 x 1 = 1
1 x 2 = 2
.....
1 x 12 = 12
2 x 1 = 2
2 x 2 = 4
.....
2 x 12 = 24
3 x 1 = 3
.....
.....
12 x 12 = 144
Which of the following is an efficient way to do this in PL/SQL? 	Mark for Review 
(1) Points
					
			
	Use two nested FOR loops. (*)
	
			
	Store all the numbers from 1 to 144 in a table, then fetch and display them using a cursor.
	
			
	Create a function which accepts two numbers as IN parameters and returns their product. Invoke the function 144 times.
	
			
	Write an anonymous block which contains 144 calls to DBMS_OUTPUT, each looking like: DBMS_OUTPUT.PUT_LINE('7 x 9 = 63');
	
					
				
Correct		Correct
	
					
		3. 	What kinds of loops can be nested? 	Mark for Review 
(1) Points
					
			
	BASIC loops
	
			
	WHILE loops
	
			
	FOR loops
	
			
	All of the above (*)
	
					
				
Correct		Correct
	
					
		4. 	Examine the following code:
BEGIN
FOR i IN 1..5 LOOP
FOR j IN 1..8 LOOP
EXIT WHEN j = 7;
DBMS_OUTPUT.PUT_LINE(i || j);
END LOOP;
END LOOP;
END;
How many lines of output will be displayed when this code is executed? 	Mark for Review 
(1) Points
					
			
	35
	
			
	6
	
			
	30 (*)
	
			
	40
	
					
				
Incorrect		Incorrect. Refer to Section 4.
	
					
		5. 	What is the correct form of a simple IF statement? 	Mark for Review 
(1) Points
					
			
	IF condition THEN statement;

	
			
	IF condition THEN statement;
END IF; (*)
	
			
	IF condition;
THEN statement;
END IF;

	
			
	IF condition
THEN statement
ENDIF;

	
					
				
Incorrect		Incorrect. Refer to Section 4.
	
					
		6. 	Examine the following code:
DECLARE
    a BOOLEAN := TRUE;
    b BOOLEAN := FALSE;
    c BOOLEAN := TRUE;
    d BOOLEAN := FALSE;
    game char(4) := 'lost';
BEGIN
    IF ((a AND b) AND (c OR d))
    THEN game := 'won';
    END IF;
What is the value of GAME at the end of this block?

	Mark for Review 
(1) Points
					
			
	NULL
	
			
	won'
	
			
	lost' (*)
	
			
	False
	
					
				
Correct		Correct
	
					
		7. 	What is the correct form of a compound IF statement? 	Mark for Review 
(1) Points
					
			
	IF condition
THEN statement1
ELSE statement 2;

	
			
	IF condition
THEN statement1
ELSE statement 2;
END IF;

	
			
	IF condition;
THEN statement1;
ELSE statement2;
END IF;

	
			
	IF condition THEN statement1;
ELSE statement2;
END IF;

(*)
	
					
				
Correct		Correct
	
					
		8. 	You need to execute a set of statements 10 times, increasing a counter by 1 each time. Which of the following PL/SQL constructs can do this? (Choose three) 	Mark for Review 
(1) Points
					
			(Choose all correct answers)	
					
			
	IF ... THEN ... ELSE
	
			
	A WHILE loop (*)
	
			
	CASE ... WHEN ... THEN
	
			
	A FOR loop (*)
	
			
	A basic loop (*)
	
					
				
Correct		Correct
	
					
		9. 	What is the correct name for CASE, LOOP, WHILE, and IF-THEN-ELSE structures ? 	Mark for Review 
(1) Points
					
			
	Control structures (*)
	
			
	Array structures
	
			
	Memory structures
	
			
	Cursor structures
	
					
				
Correct		Correct
	
					
		10. 	Which kind of loop is this?

v_count := 1;
LOOP
    v_count := v_count + 1;
    EXIT WHEN i > 20;
END LOOP;
	Mark for Review 
(1) Points
					
			
	FOR loop
	
			
	IF-THEN loop
	
			
	Basic loop (*)
	
			
	WHILE loop
	
			
	CASE loop
	
					
				
Correct		Correct 
	11. 	What kind of statement is best suited for displaying the multiplication table for "sixes": 6x1=6, 6x2=12 ... 6x12=72? 	Mark for Review 
(1) Points
					
			
	CASE expression
	
			
	IF statement
	
			
	CASE statement
	
			
	LOOP statement (*)
	
					
				
Correct		Correct
	
					
		12. 	Examine the following block:

DECLARE
    v_counter PLS_INTEGER := 1;
BEGIN
    LOOP
       DBMS_OUTPUT.PUT_LINE(v_counter);
       v_counter := v_counter + 1;
    EXIT WHEN v_counter = 5;
    END LOOP;
END;

What is the last value of V_COUNTER that is displayed?
	Mark for Review 
(1) Points
					
			
	5
	
			
	6
	
			
	4 (*)
	
			
	This is an infinite loop; the loop will never finish.
	
					
				
Correct		Correct
	
					
		13. 	A PL/SQL block contains the following code:

v_counter := 1;
LOOP
EXIT WHEN v_counter = 5;
    v_counter := v_counter + 1;
END LOOP;

What is the value of V_COUNTER after the loop is finished?
	Mark for Review 
(1) Points
					
			
	5 (*)
	
			
	6
	
			
	1
	
			
	This is an infinite loop; the loop will never finish.
	
					
				
Correct		Correct
	
					
		14. 	Which one of these tasks is best done using a LOOP statement? 	Mark for Review 
(1) Points
					
			
	Assigning a letter grade to a numerical score
	
			
	Calculating and displaying the sum of all integers from 1 to 100 (*)
	
			
	Testing if a condition is true, false or null
	
			
	Fetching and displaying an employee's last name from the database
	
					
				
Correct		Correct
	
					
		15. 	You want to display a message which depends on the value of v_grade: if v_grade = 'A' display 'Very Good', if v_grade = 'B' then display 'Good', and so on.

DECLARE
    v_grade CHAR(1);
BEGIN
    CASE v_grade

The next line should be
	Mark for Review 
(1) Points
					
			
	WHEN 'A' THEN (*)
	
			
	WHEN v_grade = 'A' THEN
	
			
	WHEN 'A' THEN;
	
			
	IF 'A' THEN
	
					
				
Incorrect		Incorrect. Refer to Section 4.
	
					
		16. 	You want to assign a value to v_result which depends on the value of v_grade: if v_grade = 'A' set v_result to 'Very Good' and so on.

DECLARE
    v_grade CHAR(1);
    v_result VARCHAR2(10);
BEGIN
    v_result :=
       CASE v_grade

The next line should be
	Mark for Review 
(1) Points
					
			
	WHEN v_grade = 'A' THEN 'Very Good'
	
			
	WHEN 'A' THEN 'Very Good';
	
			
	WHEN 'A' THEN v_result := 'Very Good';
	
			
	WHEN 'A' THEN 'Very Good' (*)
	
					
				
Correct		Correct
	
					
		17. 	What will be the value of variable c after the following code is executed?

DECLARE
    a BOOLEAN := TRUE;
    b BOOLEAN := NULL;
    c NUMBER;
BEGIN
    IF a AND b THEN c := 2;
       ELSIF a OR b THEN c := 0;
       ELSE c := 1;
    END IF;
END;
	Mark for Review 
(1) Points
					
			
	1
	
			
	Null
	
			
	0 (*)
	
			
	2
	
					
				
Correct		Correct
	
					
		18. 	What will be the value of v_result after the following code is executed?

DECLARE
    v_grade CHAR(1) := NULL;
    v_result VARCHAR2(10);
BEGIN
    CASE v_grade
       WHEN 'A' THEN v_result := 'Very Good';
       WHEN 'F' THEN v_result := 'Poor';
       ELSE v_result := 'In Between';
    END;
END;
	Mark for Review 
(1) Points
					
			
	Poor
	
			
	In Between (*)
	
			
	Null
	
			
	Very Good
	
					
				
Correct		Correct
	
					
		19. 	What will be the value of v_sal_desc after the following code is executed?

DECLARE
    v_salary NUMBER(6,2) := NULL;
    v_sal_desc VARCHAR2(10);
BEGIN
    CASE
       WHEN v_salary < 10000 THEN v_sal_desc := 'Low Paid';
       WHEN v_salary >= 10000 THEN v_sal_desc := 'High Paid';
    END CASE;
END;
	Mark for Review 
(1) Points
					
			
	High Paid
	
			
	Low Paid
	
			
	Null
	
			
	The code will fail and return an exception (*)
	
					
				
Incorrect		Incorrect. Refer to Section 4.
	
					
		20. 	Which statement best describes when a WHILE loop shouild be used? 	Mark for Review 
(1) Points
					
			
	When the number of iterations is known
	
			
	When repeating a sequence of statements until the controlling condition is no longer true (*)
	
			
	When assigning a value to a Boolean variable
	
			
	When testing whether a variable is null
	
					
				
Correct		Correct 
21. 	Examine the following code:

DECLARE
v_bool BOOLEAN := FALSE;
v_counter NUMBER(4) := 0;
BEGIN
... Line A
?
END;
Which of the following is NOT valid at line A?
	Mark for Review 
(1) Points
					
			
	WHILE NOT v_boolean LOOP
	
			
	WHILE v_boolean AND v_counter < 6 LOOP
	
			
	WHILE v_counter > 8 LOOP
	
			
	WHILE v_counter IN 1..5 LOOP (*)
	
					
				
Correct		Correct
	
					
		22. 	In a FOR loop, an implicitly declared counter automatically increases or decreases with each iteration. True or False? 	Mark for Review 
(1) Points
					
			
	True (*)
	
			
	False
	
					
				
Correct		Correct
	
					
		23. 	What will happen when the following code is executed?

BEGIN
FOR i in 1 ..3 LOOP
    DBMS_OUTPUT.PUT_LINE (i);
    i := i + 1;
END LOOP;
END;
	Mark for Review 
(1) Points
					
			
	It will display 1, 2, 3.
	
			
	It will display 2, 3, 4.
	
			
	It will result in an error because you cannot modify the counter in a FOR loop. (*)
	
			
	It will result in an error because the counter was not explicitly declared.
	
					
				
Correct		Correct
	
					
		24. 	When using a counter to control a FOR loop, which of the following is true ? 	Mark for Review 
(1) Points
					
			
	You must have exactly one counter but it is implicitly declared. (*)
	
			
	You must have exactly one counter and you must explicitly declare it.
	
			
	You can have multiple counters, but you need at least one.
	
			
	You don't need a counter; you can test for anything (for example, whether a BOOLEAN is TRUE or FALSE).
	
					
				
Correct		Correct
	
					
		25. 	Which of the following blocks produces the same output as this block?

BEGIN
    FOR i in 1 .. 3 LOOP
       DBMS_OUTPUT.PUT_LINE(i);
    END LOOP;
END;
	Mark for Review 
(1) Points
					
			
	DECLARE
    i PLS_INTEGER := 0;
BEGIN
    WHILE i<3 LOOP
       DBMS_OUTPUT.PUT_LINE(i);
       i := i + 1;
    END LOOP;
END;

	
			
	DECLARE
    i PLS_INTEGER := 0;
BEGIN
    WHILE i<3 LOOP
       i := i + 1;
       DBMS_OUTPUT.PUT_LINE(i);
    END LOOP;
END;

(*)
	
			
	DECLARE
    i PLS_INTEGER := 0;
BEGIN
    WHILE i<3 LOOP
       DBMS_OUTPUT.PUT_LINE(i);
    END LOOP;
    i := i+ 1;
END;

	
					
				
Correct		Correct
	
					
					
	Section 5
					
		26. 	A cursor has been declared as:
CURSOR c_curs (p_param VARCHAR2) IS
SELECT * FROM mytable
WHERE mycolumn = p_param.
Which of the following will open the cursor successfully? 	Mark for Review 
(1) Points
					
			
	OPEN c_curs(p_param = 'ABC');
	
			
	OPEN c_curs('ABC'); (*)
	
			
	OPEN c_curs USING ('ABC');
	
			
	p_param := 'ABC';
OPEN c_curs(p_param);
	
					
				
Correct		Correct
	
					
		27. 	Examine the following declaration of a cursor with a parameter. What should be coded at Point A? DECLARE
CURSOR emp_curs(-- Point A --) IS
SELECT * FROM employees
WHERE job_id = p_job_id;
	Mark for Review 
(1) Points
					
			
	p_job_id
	
			
	ST_CLERK'
	
			
	p_job_id VARCHAR2(25)
	
			
	p_job_id VARCHAR2 (*)
	
			
	job_id VARCHAR2
	
					
				
Correct		Correct
	
					
		28. 	You want to declare a cursor which locks each row fetched by the cursor. Examine the following code:
DECLARE
CURSOR emp_curs IS
SELECT * FROM employees
FOR -- Point A
Which of the following can NOT be coded at Point A? 	Mark for Review 
(1) Points
					
			
	UPDATE;
	
			
	UPDATE OF salary;
	
			
	UPDATE OF employees; (*)
	
			
	UPDATE NOWAIT;
	
					
				
Correct		Correct
	
					
		29. 	User MARY has locked a row of the EMPLOYEES table. Now, user SAEED tries to open the following cursor:
CURSOR c IS
SELECT * FROM employees
FOR UPDATE WAIT 5;
What will happen when SAEED's session tries to fetch the row that MARY has locked? 	Mark for Review 
(1) Points
					
			
	SAEED's session successfully fetches the first 5 rows and then waits indefinitely to fetch the 6th row.
	
			
	SAEED's session waits for 5 seconds, and then raises an exception if MARY has not unlocked the row. (*)
	
			
	SAEED's session waits for 5 seconds, then SAEED is disconnected from the database.
	
			
	SAEED's session waits for 5 seconds, then MARY's session is rolled back.
	
			
	SAEED's session waits for 5 minutes, and then raises an exception if MARY has not unlocked the row.
	
					
				
Correct		Correct
	
					
		30. 	User TOM has locked a row in the WORKERS table. Now, user DICK wants to open the following cursor:
CURSOR c IS
SELECT * FROM workers FOR UPDATE NOWAIT;
What will happen when DICK opens the cursor and tries to fetch rows? 	Mark for Review 
(1) Points
					
			
	TOM's session is rolled back. DICK's session successfully fetches rows from the cursor.
	
			
	DICK's session waits indefinitely.
	
			
	Both sessions wait for a few seconds; then the system breaks all locks and both sessions raise an exception.
	
			
	DICK's session immediately raises an exception. (*)
	
			
	The c%NOWAIT attribute is set to TRUE.
	
					
				
Correct		Correct 
31. 	What is wrong with the following code?

BEGIN
    FOR emp_rec IN
       (SELECT * FROM employees WHERE ROWNUM < 10
          FOR UPDATE NOWAIT) LOOP
        DBMS_OUTPUT.PUT_LINE(emp_rec%ROWCOUNT || emp_rec.last_name):
    END LOOP;
END;
	Mark for Review 
(1) Points
					
			
	You cannot use FOR UPDATE NOWAIT with a cursor FOR loop using a subquery.
	
			
	You cannot reference %ROWCOUNT with a cursor FOR loop using a subquery. (*)
	
			
	The field EMP_REC.LAST_NAME does not exist.
	
			
	You cannot use ROWNUM with a cursor FOR loop.
	
			
	The cursor has not been opened.
	
					
				
Incorrect		Incorrect. Refer to Section 5
	
					
		32. 	When using a cursor FOR loop, OPEN, CLOSE and FETCH statements should not be explicitly coded. True or False? 	Mark for Review 
(1) Points
					
			
	True (*)
	
			
	False
	
					
				
Correct		Correct
	
					
		33. 	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 ...

	
			
	FOR emp_rec IN
    (SELECT * FROM employees) LOOP ...

	
			
	FOR emp_rec IN
    (SELECT last_name, salary FROM employees ORDER BY last_name) LOOP ...

	
			
	FOR emp_rec IN
    (SELECT * FROM employees WHERE department_id = 75) LOOP ...

	
			
	None of the above. They are all valid. (*)
	
					
				
Correct		Correct
	
					
		34. 	What is wrong with the following code?
DECLARE
CURSOR emp_curs(p_dept_id NUMBER) IS
SELECT * FROM employees WHERE department_id = p_dept_id;
BEGIN
FOR dept_rec IN (SELECT * FROM departments) LOOP
DBMS_OUTPUT.PUT_LINE(dept_rec.department_name);
FOR emp_rec IN emp_curs(dept_rec.department_id) LOOP
DBMS_OUTPUT.PUT_LINE(emp_rec.last_name);
END LOOP;
END LOOP;
END;
	Mark for Review 
(1) Points
					
			
	The DEPARTMENTS cursor must be declared with a parameter.
	
			
	You cannot use a cursor with a subquery in nested loops.
	
			
	You cannot use two different kinds of loop in a single PL/SQL block.
	
			
	EMP_CURS should not be DECLAREd explicitly; it should be coded as a subquery in a cursor FOR loop.
	
			
	Nothing is wrong. The block will execute successfully and display all departments and the employees in those departments. (*)
	
					
				
Correct		Correct
	
					
		35. 	How many explicit cursors can be declared and used in a single PL/SQL block? 	Mark for Review 
(1) Points
					
			
	One or two.
	
			
	Only one.
	
			
	As many as needed. (*)
	
			
	Up to eight cursors.
	
			
	None of the above.
	
					
				
Correct		Correct
	
					
		36. 	Which of the following is a good reason to declare and use multiple cursors in a single PL/SQL block? 	Mark for Review 
(1) Points
					
			
	Multiple cursors improve performance. They are faster than using a single cursor.
	
			
	Multiple cursors use less memory than a single cursor.
	
			
	Multiple cursors allow us to fetch rows from two or more related tables without using a JOIN. (*)
	
			
	Multiple cursors are the only way to use cursors with parameters.
	
			
	Multiple cursors can be opened many times, while a single cursor can be opened only once.
	
					
				
Correct		Correct
	
					
		37. 	The employees table contains 11 columns. The following block declares a cursor and a record based on the cursor:

DECLARE
    CURSOR emp_curs IS
       SELECT * FROM employees;
    v_emp_rec emp_curs%ROWTYPE;

A twelfth column is now added to the employees table. Which of the following statements is true?
	Mark for Review 
(1) Points
					
			
	The declaration of emp_rec must be changed to add an extra field.
	
			
	The block will still work correctly without any changes to the PL/SQL code. (*)
	
			
	The block will fail and an INVALID_CURSOR exception will be raised.
	
			
	An extra scalar variable must be declared to correspond to the twelfth table column.
	
					
				
Correct		Correct
	
					
		38. 	Which of the following statements about the %ISOPEN cursor attribute is true? 	Mark for Review 
(1) Points
					
			
	You can issue the %ISOPEN cursor attribute only when a cursor is open.
	
			
	You can issue the %ISOPEN cursor attribute only when more than one record is returned.
	
			
	You can issue the %ISOPEN cursor attribute when a cursor is open or closed. (*)
	
			
	If a cursor is open, then the value of %ISOPEN is false.
	
					
				
Correct		Correct
	
					
		39. 	The following cursor has been declared:

    CURSOR emp_curs IS
       SELECT first_name, last_name, job_id, salary
       FROM employees;

Which of the following correctly declares a composite record with the same structure as the cursor?
	Mark for Review 
(1) Points
					
			
	emp_rec emp_rec%ROWTYPE;
	
			
	emp_rec emp_curs%TYPE;
	
			
	emp_rec emp_curs%ROWTYPE; (*)
	
			
	emp_rec cursor%ROWTYPE;
	
					
				
Correct		Correct
	
					
		40. 	The DEPARTMENTS table contains four columns. Examine the following code:

DECLARE
    CURSOR dept_curs IS
       SELECT * FROM departments;
    v_dept_rec dept_curs%ROWTYPE;
BEGIN
    OPEN dept_curs;
    FETCH dept_curs INTO v_dept_rec;
    ...

Which one of the following statements is true?
	Mark for Review 
(1) Points
					
			
	v_dept_rec contains the first four rows of the departments table.
	
			
	The FETCH will fail because the structure of v_dept_rec does not match the structure of the cursor.
	
			
	v_dept_rec contains the first row of the departments table. (*)
	
			
	The block will fail because the declaration of v_dept_rec is invalid.
	
					
				
Correct		Correct 
41. 	Which of the following cursor attributes is set to the total number of rows returned so far? 	Mark for Review 
(1) Points
					
			
	%ISOPEN
	
			
	%NOTFOUND
	
			
	%FOUND
	
			
	%ROWCOUNT (*)
	
					
				
Correct		Correct
	
					
		42. 	Assume that you have declared a cursor called C_EMP. Which of the following statements about C_EMP is correct? (Choose two.) 	Mark for Review 
(1) Points
					
			(Choose all correct answers)	
					
			
	You can use c_emp%NOTFOUND to exit a loop. (*)
	
			
	You can fetch rows when c_emp%ISOPEN evaluates to FALSE.
	
			
	You can use c_emp%ROWCOUNT to return the number of rows returned by the cursor so far. (*)
	
			
	You can use c_emp%FOUND after the cursor is closed.
	
					
				
Correct		Correct
	
					
		43. 	The employees table contains 20 rows. What will happen when the following code is executed?

DECLARE
  &nbspCURSOR emp_curs IS
     &nbspSELECT job_id FROM employees;
    v_job_id employees.job_id%TYPE;
BEGIN
    OPEN emp_curs;
    LOOP
       FETCH emp_curs INTO v_job_id;
       DBMS_OUTPUT.PUT_LINE(v_job_id);
       EXIT WHEN emp_curs%NOTFOUND;
    END LOOP;
    CLOSE emp_curs;
END;
	Mark for Review 
(1) Points
					
			
	20 job_ids will be displayed.
	
			
	The block will fail and an error message will be displayed.
	
			
	21 rows of output will be displayed; the first job_id will be displayed twice.
	
			
	21 rows of output will be displayed; the last job_id will be displayed twice. (*)
	
					
				
Correct		Correct
	
					
		44. 	An implicit cursor can be used for a multiple-row SELECT statement. True or False? 	Mark for Review 
(1) Points
					
			
	True
	
			
	False (*)
	
					
				
Correct		Correct
	
					
		45. 	Examine the following code:

DECLARE
    CURSOR emp_curs IS
       SELECT last_name, salary
       FROM employees
       ORDER BY salary;
    v_last_name employees.last_name%TYPE;
    v_salary employees.salary%TYPE;
BEGIN
...
Which of the following statements successfully opens the cursor and fetches the first row of the active set?
	Mark for Review 
(1) Points
					
			
	OPEN emp_curs;
FETCH emp_curs INTO v_last_name, v_salary;

(*)
	
			
	OPEN emp_curs;
FETCH emp_curs INTO v_salary, v_last_name;

	
			
	OPEN emp_curs;
FETCH FIRST emp_curs INTO v_last_name, v_salary;

	
			
	OPEN emp_curs;
FETCH emp_curs;

	
					
				
Correct		Correct
	
					
		46. 	Which of these is NOT a valid cursor declaration? 	Mark for Review 
(1) Points
					
			
	CURSOR emp_curs IS
    SELECT salary
    FROM employees
    ORDER BY salary DESC;

	
			
	CURSOR emp_curs IS
    SELECT salary
    FROM employees
    WHERE last_name LIKE 'S%';

	
			
	CURSOR emp_dept_curs IS
    SELECT e.salary, d.department_name
    FROM employees e, departments d
    WHERE e.department_id = d.department_id;

	
			
	CURSOR emp_curs IS
    SELECT salary INTO v_salary
    FROM employees;

(*)
	
					
				
Correct		Correct
	
					
		47. 	What will happen when the following code is executed?

DECLARE CURSOR emp_curs IS
    SELECT salary FROM employees;
    v_salary employees.salary%TYPE;
BEGIN
    OPEN emp_curs;
    FETCH emp_curs INTO v_salary;
    CLOSE emp_curs;
    FETCH emp_curs INTO v_salary;
END;
	Mark for Review 
(1) Points
					
			
	The block will fail and an INVALID_CURSOR exception will be raised. (*)
	
			
	The first employee row will be fetched twice.
	
			
	The first two employee rows will be fetched.
	
			
	The block will fail and a TOO_MANY_ROWS exception will be raised.
	
					
				
Correct		Correct
	
					
		48. 	For which type of SQL statement must you use an explicit cursor? 	Mark for Review 
(1) Points
					
			
	DML statements that process more than one row.
	
			
	Queries that return more than one row. (*)
	
			
	Data Definition Language (DDL) statements.
	
			
	Queries that return a single row.
	
					
				
Correct		Correct
	
					
		49. 	Which of these statements about implicit cursors is NOT true? 	Mark for Review 
(1) Points
					
			
	They are declared automatically by Oracle for single-row SELECT statements.
	
			
	They are declared automatically by Oracle for all DML statements.
	
			
	They are declared by the PL/SQL programmer. (*)
	
			
	They are opened and closed automatically by Oracle.
	
					
				
Correct		Correct
	
					
		50. 	What will happen when the following code is executed?

DECLARE
    CURSOR emp_curs IS
       SELECT salary FROM employees;
    v_salary employees.salary%TYPE;
BEGIN
    FETCH emp_curs INTO v_salary;
    DBMS_OUTPUT.PUT_LINE(v_salary);
    CLOSE emp_curs;
END;
	Mark for Review 
(1) Points
					
			
	The first employee's salary will be fetched and displayed.
	
			
	All employees' salaries will be fetched and displayed.
	
			
	The execution will fail and an error message will be displayed. (*)
	
			
	The lowest salary value will be fetched and displayed.
	
					
				
Correct		Correct 