Q.1
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
Q.2
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
Q.3
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
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
  • Predefined Exception
  • Internal Exception
  • User defined Exception
  • None of the above
Q.5
For a user-defined exception, SQLCODE returnsand SQLERRM returns ___________.
  • “User-defined Exception”
  • SQLCODE
  • 0
  • Both A & B
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.
  • A runtime error
  • A syntax error
  • Both A & B
  • None of the above
Q.7
To handle raised exceptions, you write separate routines called exception handlers.
  • Yes
  • No
Q.8
Which keyword is used instead of the assignment operator to initialize variables?
  • NOT NULL
  • DEFAULT
  • %TYPE
  • %ROWTYPE
Q.9
Which statements execute a sequence of statements multiple times?
  • EXIT
  • LOOP
  • Both A & B
  • None of the above
Q.10
Which of the following returns the current error message text?
  • SQLERRM
  • SQLCODE
  • Both A & B
  • None of the above
0 h : 0 m : 1 s