aliensbrain
  • Home
  • Study
  • Quizzes
  • 🎤AI Practicefree
  • Notebooks
  • Community
  • Sign in
  • Oracle Database and PL/SQL Fundamentals
  • In PL/SQL if we write select statement with INTO clause w...
Multiple choice technology databases

In PL/SQL if we write select statement with INTO clause which of the following exceptions are returned

  1. NO_DATA_FOUND

  2. ROWTYPE_MISMATCH

  3. TOO_MANY_ROW

  4. DUP_VAL_ON_INDEX

Reveal answer Fill a bubble to check yourself
A,C Correct answer

Keep practicing — related questions

  • PL/SQL raises an exception, in which TWO of the following cases:
  • PL/SQL raises an exception, in which TWO of the following cases:
  • PL/SQL raises an exception, in which TWO of the following cases:
  • PL/SQL raises an exception in which of the following scenarios
  • PL/SQL raises an exception, in which TWO of the following cases?
  • PL/SQL raises the predefined exception NO_DATA_FOUND if a SELECT INTO statement returns no rows
  • Which of the following exceptions is raised in PL/SQL when a select statement returns zero rows?
  • The INTO clause is mandatory for SELECT statements within PL/SQL blocks.
Play the full quiz 🎤 Practise this topic out loud
Advertisement
© Aliensbrain | all rights reserved
  • About
  • Contact
  • Terms and Condition
  • Privacy Policy