PLSQL Chapter 5 Quiz

Welcome to your PLSQL Chapter 5 Quiz

How can you declare an explicit cursor?

cursor_name IS select_query;

cursor_name := select_query;

cursor_name IS TYPE OF explicit_cursor;

You can't, because explicit cursors are created automatically by Oracle.

What does the %FOUND attribute of a cursor do?

Returns the data from the cursor.

Returns the number of rows found by the cursor

Nothing, it won't work because it needs to be written in lowercase.

Returns true if at least one row is impacted by the query, otherwise it shows false

What does this code do?

TYPE id_arraytype IS VARRAY(10) OF NUMBER(4);
id_array id_arraytype;

Nothing, it will show an error

It will declare a new type of an array of numbers, and a new variable of that type

It declares a new type of array but does not declare a variable of that type

It creates a new table with two columns, one as an array and the other as a number.

How can you get the number of rows impacted by an INSERT statement in your PL/SQL code?

Use the sql%ROWCOUNT attribute.

SELECT from the table to find rows inserted today.

You can't.

Use the sql%NUMROWS attribute.

Time is Up!

Time's up

Post navigation