PRO - PL SQL Programming - Theory

What is the correct syntax of using FOR UPDATE clause in CURSORS?

1 Mark(s)

CURSOR cr_name IS SELECT column_names FROM tbl FOR UPDATE;
CURSOR cr_name IS FOR UPDATE SELECT column_names FROM tbl ;
CURSOR cr_name IS SELECT column_names FOR UPDATE FROmtbl;
CURSOR cr_name IS SELECT FOR UPDATE column_names FROM tbl ;

Which of the following exception is globally available?

1 Mark(s)

Internal ,User-defined and Pre-defined exceptions
Pre-defined exceptions only
Internal and pre-defined exceptions
User defined exceptions only

When should an alias be used in a CURSOR FOR LOOP?

1 Mark(s)

Always
Only when virtual columns are used
Never
When the number of tables are more than one

Which of the following types of cursor variables has a RETURN clause?

1 Mark(s)

Strongly typed
Weakly typed
Both strongly and Weakly Typed
Neither. There is no RETURN clause in any cursor variable

What happens if an exception raised in a block has no exception handler for it?

1 Mark(s)

Exception reproduces itself in successive nested blocks.
Exception reproduces itself in successive invoking blocks.
Exception reproduces itself in successive enclosing blocks
Exception reproduces itself in successive enclosing programs

Which of these have same attributes?

1 Mark(s)

Implicit and explicit cursors
Implicit cursor, explicit cursor and cursor variables
Explicit cursors and cursor variables
Implicit cursors and cursor variable

What are exceptions in PL/SQL?

1 Mark(s)

Runtime errors
Runtime warnings
Compile time errors
Compile time warnings

What can a CURSOR FOR LOOP use?

1 Mark(s)

Explicit cursor only
Implicit cursor only
Explicit or Implicit cursors
Cursor variables only

Which function returns the error message associated with the most recently raised error exception?

1 Mark(s)

SQLERRM
SQL_ERRM
SQLERRMSG
SQL_MSG

Which of the following is the correct syntax for exception handlers?

1 Mark(s)

IF ex_nameTHENstmt
WHEN ex_name THEN stmt
WHERE ex_name THEN stmt
CASE ex_name THEN stmt

How can a user defined exception be raised?

1 Mark(s)

Using RAISE statement only
Using RAISE statement or RAISE_APPLICATIOn_ERROR function
Using INVOKE statement or RAISE statement
Using RAISE statement or RAISE_APPLICATIOn_ERROR procedure

Which of these is not a similarity between an explicit cursor and cursor variable?

1 Mark(s)

The way cursor is closed
The way data is fetched
The value of cursor attributes
The way cursor is opened

Where are exceptions used in PL/SQL?

1 Mark(s)

Only in an anonymous block
Only in the body of a subprogram
Only in a package
Only in an anonymous block and the body of a subprogram

Which of the following statements is FALSE?

1 Mark(s)

Integer is a subtype of Number
List is a subtype of List
List is not a subtype of List
Number is a subtype of Object

What is an implicit CURSOR FOR LOOP statement?

1 Mark(s)

SELECT statement specified outside the CURSOR FOR LOOP statement.
Cursor specified in the CURSOR FOR LOOP statement.
Cursor specified in any LOOP statement.
SELECT statement specified inside the CURSOR FOR LOOP statement.

What happens after an exception handler runs?

1 Mark(s)

The program exits
Control transfers to the last statement of the last block
Control transfers to the next statement of the enclosing block
Control transfers to the last statement of the current block

Which of the following statement for opening a cursor variable is correct?

1 Mark(s)

OPEN cursor_nameAsselect_statement
OPEN cursor_name
OPEN cursor_name FOR select_statement
OPEN cursor_name IS select_statement

Which of the following is incorrect about cursor variables?

1 Mark(s)

A cursor variable can be associated with different queries at different times in the program execution
A value can be assigned to a cursor variable and it can be used in an expression
Parameters can be passed to a cursor variable
Cursor variables can be used to reduce client-server network traffic

What are internally defined exceptions?

1 Mark(s)

The Oracle ORA errors
Exceptions which are already defined in the STANDARD package
Exceptions defined by a user
Any error that occurs in PL/SQL?

How can an exception name be associated with a error code of a internally defined exception?

1 Mark(s)

Using PRAGMA EXEC_INIT
Using PRAGMA EXECPTION_INIT
Using PRAGMA EXEC_INITIALIZE
Using PRAGMA EXECPTION_INITIALIZE

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