Quiz  /  Oracle Gate & PSU MCQ Questions With Answers

  • 1. 
    It is raised when a program attempts to log on to the database with an invalid username or password.

  • LOGIN_INVALID
  • LOGIN_FAILED
  • LOGIN_DENIED
  • None of the above

  • 2. 
    Which of the following is not true about the exception handling section of a PL/SQL block?

  • This section starts with the EXCEPTION keyword.
  • It is a mandatory section.
  • It contains exception(s) that handle errors in the program.
  • None of the above.

  • 3. 
    Which exception name is used, When you open a cursor that is already open?

  • CURSOR_OPEN
  • CURSOR_IS_OPEN
  • CURSOR_ALREADY_OPEN
  • None of these

  • 4. 
    Which of the following subprogram is stored in the database?

  • Standalone subprogram
  • Nested subprogram in an anonymous block
  • Package subprogram
  • Standalone and nested subprogram

  • 5. 
    When a SELECT...INTO clause does not return any row from a table.

  • TOO_MANY_ROWS
  • NO_DATA_FOUND
  • DATA_FOUND
  • None of these

  • 6. 
    A way to handle unnamed system exception is using

  • WHEN exception THEN exception;
  • WHEN OTHERS THEN statement;
  • WHEN OTHERS statement;
  • All of the above

  • 7. 
    Which of the following is not a type of exception?

  • user defined exception
  • pre defined exception
  • non pre-defined exception
  • server specific exception

  • 8. 
    When you perform an invalid operation on a cursor like closing a cursor, fetch data from a cursor that is not opened. Which exception is used?

  • INVALID_CURSOR
  • OPEN_CURSOR
  • ISOPEN_CURSOR
  • None of these

  • 9. 
    What is the syntax for exception handlers within an exception section?

  • WHEN (exception) THEN (action);
  • IF (exception) THEN (action);
  • WHEN (exception) statement;
  • WHEN (exception) (Action);

  • 10. 
    Statement used to change the value of a column in table

  • CHANGE
  • UPDATE
  • INSERT
  • SELECT

  • 11. 
    Which of the following is not a subprogram?

  • Procedure
  • Function
  • Package
  • Anonymous PL/SQL block

  • 12. 
    Which of the following is not among the types of PL/SQL records?

  • Table-based
  • View-based
  • Cursor-based records
  • User-defined records
Report Question
warning
access_time
  Time