PRO - PL SQL Programming - Theory

Which of the following SQLAttribute can be used to determine the exit condition of the loop while fetching data from an explicit cursor?

1 Mark(s)

%FOUND
%ISOPEN
%ROWCOUNT
%NOTFOUND 3.3 RESULT SET PROCESSING

Which of the following operations of a cursor checks for the validity of a SQL statement?

1 Mark(s)

OPEN
BIND
FETCH
PARSE

Which of the following is not true about keywords ?

1 Mark(s)

Reserved words and keywords are identifiers that have special meaning in PL/SQL.
The difference between reserved words and keywords is that reserved words cannot be used as identifiers
Keywords can be used as identifiers, but it is not recommended
Reserved keywords can be used as ordinary user-defined identifiers.

When should a column fetched in an explicit cursor have an alias?

1 Mark(s)

An alias should never be used
Always an alias should be used for columns in an explicit cursor
When the query includes a virtual column or an expression and that is referenced in the query
The cursor is used to fetch into a record that was declared with %ROWTYPE

What is the scope of the index of the CURSOR FOR LOOP?

1 Mark(s)

Local to the loop
Global
Local to the loop and enclosing loops
Block scope (in the entire Pl/SQL block)

Which of the following is an example of Pre-defined identifier?

1 Mark(s)

The exception INVALID_NUMBER
EXCEPTION keyword
BEGIN and END keywords
lastName

When is an implicit cursor used?

1 Mark(s)

PL/SQL opens an implicit cursor every time a SELECT or DML statement is run and the statements are not associated with any cursor variable.
PL/SQL opens an implicit cursor only every time a SELECT statement is run even if the statements are associated with any explicit cursor.
PL/SQL opens an implicit cursor every time a DDL statement is run and the statements are not associated with any explicit cursor.
PL/SQL opens an implicit cursor every time a SELECT or DML statement is run and the statements are not associated with any explicit cursor.

What is the name of the cursor written and maintained by a database user?

1 Mark(s)

User cursor
Explicit cursor
Implicit cursor
User-defined cursor

Which of the following statements about a cursor declaration and definition is true?

1 Mark(s)

An explicit cursor should be declared and defined at the same time in the execution block.
An explicit cursor can be declared first and then defined later or both can happen at the same time in the declaration block.
An explicit cursor should be declared and defined at the same time in the declaration block.
Cursor declaration and definition are the same and is a single step

Which of the following statements about opening and closing an explicit cursor is false?

1 Mark(s)

An explicit cursor is closed with the CLOSE statement
A cursor once closed cannot be re-opened.
Open statement identifies the result set and positions the cursor before the first row of the result set
Optionally arguments can be passed to the open statement to open a cursor

Which of the following is false about an IF statement?

1 Mark(s)

The condition of an IF statement can be a comparison expression or combination of multiple comparison expressions.
In an IF statement, two variables of the same type or different types can be compared or two literals can be compared.
Using an IF condition, only a portion of code can be executed depending on whether certain criteria are met.
An else statement cannot have another if statement inside.

How many ELSE clauses can an IF statement have?

1 Mark(s)

0 or 1
always 1
1 or 2
1 to 10

Why is the WHERE CURRENT OF CLAUSE used in Cursors?

1 Mark(s)

The WHERE CURRENT OF clause allows the user to easily make changes to the least recently fetched row of data
The WHERE CURRENT OF clause allows the user to easily make changes to all the rows of a table.
The WHERE CURRENT OF clause allows the user to easily make changes to the most recently fetched row of data
The WHERE CURRENT OF clause allows the user to easily make changes to the data not fetched by the recent query

What happens if the none of the selector values match the selector in a simple case expression?

1 Mark(s)

The CASE statement returns NULL
An error is thrown.
It looks for an else statement. If no else clause is there, it returns NULL
It looks for an else statement. If no else clause is there, it throws an error.

Which of the following is a not a user defined constrained datatype?

1 Mark(s)

SUBTYPE Balance IS NUMBER;
SUBTYPE Balance IS NUMBER(8,2);
SUBTYPE Name is VARCHAR2(10);
SUBTYPE Counter IS NATURAL;

What can the value of the INTO clause be while fetching data in an explicit cursor?

1 Mark(s)

PL/SQL scalar variables only
PL/SQL variables or records
Collections or records only
Records only

How many rows can a cursor hold?

1 Mark(s)

One only
Zero only
One or more
One to ten

When should a CLOSE statement be used in PL/SQL?

1 Mark(s)

For both implicit and explicit cursors
Only for explicit cursors
Only for implicit cursors
Only for cursor expressions

Which type of cursor does an implicit and explicit cursor belong to?

1 Mark(s)

System cursor
Session cursor
Database cursor
Operating System cursor

What is the value of %ROWCOUNT after the explicit cursor is opened but before the first row is fetched?

1 Mark(s)

1
Zero
-1
NULL

PRO - PL SQL Programming - Theory - 7 : Question 1 of 20