Q.1.
Which error occurs while the program is running and cannot be detected by the PL/SQL compiler?
Q.2.
Which datatypes are PL/SQL-only datatypes that are more efficient than the SQL datatypes NUMBER or INTEGER for integer arithmetic?
Q.3.
PL/SQL has two types of subprograms, procedures and functions. Which subprogram is used to compute a value?
Q.4.
________ does not correlate with an oracle error, instead, user_defineexceptions usually enforce business rules in situationsin which an oracle error would not necessarily occur
Q.5.
For a user-defined exception, SQLCODE returnsand SQLERRM returns ___________.
Q.6.
Which of the following is handled with the help of exception-handling section in an PL/SQL block.For eg, SELECT INTO statement, which does not return any rows.
Q.7.
To handle raised exceptions, you write separate routines called exception handlers.
Q.8.
Which keyword is used instead of the assignment operator to initialize variables?
Q.9.
Which statements execute a sequence of statements multiple times?
Q.10.
Which of the following returns the current error message text?