PL SQL

• v_num is Null

• v_num is NOT Null

• compilation error

• runtime error

• v_num is not equal to v_char

• compilation error

• v_num is equal to v_char

• runtime error

Which error occurs while the program is running and cannot be detected by the PL/SQL compiler?

• Syntax error

• Runtime error

• Both A & B

• None of the above

Which keyword is used instead of the assignment operator to initialize variables?

• NOT NULL

• DEFAULT

• %TYPE

• %ROWTYPE

Which statements execute a sequence of statements multiple times?

• EXIT

• LOOP

• Both A & B

• None of the above

Oracle predefined errors are NOT associated with specific error codes.

• True

• False

Which of the following returns the current error message text?

• SQLERRM

• SQLCODE

• Both A & B

• None of the above

Which datatypes are PL/SQL-only datatypes that are more efficient than the

SQL datatypes NUMBER or INTEGER for integer arithmetic?

• PLS_INTEGER

• NUMBER

• Both A & B

• None of the above

How many rows will be inserted And what will be the value

• 0,No value

• 99, 2 in all rows

• 1,2 

• 99,2 to 99

PL/SQL has two types of subprograms, procedures and functions. Which subprogram is used to compute a value?

• Procedure

• Function

• Both A & B

• None of the above