Oracle/PLSQL

by

  1. Which PL/SQL block section is mandatory?
    A. Exception
    B. Declare
    C. Begin-End
    D. Cursor
    Answer: C
  2. What is the default mode of parameters in PL/SQL?
    A. IN
    B. OUT
    C. IN OUT
    D. NONE
    Answer: A
  3. Which cursor is created automatically by Oracle?
    A. Static Cursor
    B. Explicit Cursor
    C. Implicit Cursor
    D. Dynamic Cursor
    Answer: C
  4. Which exception is raised when NO rows are returned?
    A. TOO_MANY_ROWS
    B. NO_DATA_FOUND
    C. INVALID_CURSOR
    D. ZERO_ROWS
    Answer: B
  5. What is %TYPE used for?
    A. Declare constant
    B. Define datatype from variable
    C. Loop control
    D. Exception handling
    Answer: B
  6. Which keyword is used to exit loop?
    A. STOP
    B. BREAK
    C. EXIT
    D. CLOSE
    Answer: C
  7. What does %ROWTYPE return?
    A. Single column value
    B. Entire row structure
    C. Cursor name
    D. Table name
    Answer: B
  8. Which statement is used to open a cursor?
    A. START
    B. EXECUTE
    C. OPEN
    D. FETCH
    Answer: C
  9. Which clause handles errors in PL/SQL?
    A. ERROR
    B. EXCEPTION
    C. HANDLE
    D. CATCH
    Answer: B
  10. What is a trigger?
    A. Stored variable
    B. PL/SQL block executed automatically
    C. Loop structure
    D. Cursor
    Answer: B
  11. Which trigger fires before insert?
    A. AFTER INSERT
    B. BEFORE INSERT
    C. INSTEAD OF INSERT
    D. DURING INSERT
    Answer: B
  12. What is COMMIT used for?
    A. Save changes permanently
    B. Undo changes
    C. Delete rows
    D. Lock table
    Answer: A
  13. Which command rolls back transaction?
    A. CANCEL
    B. REVERSE
    C. ROLLBACK
    D. STOP
    Answer: C
  14. Which keyword is used for conditional logic?
    A. IF
    B. LOOP
    C. CASE
    D. SWITCH
    Answer: A
  15. What is a package in PL/SQL?
    A. Variable group
    B. Collection of procedures/functions
    C. Table
    D. Cursor
    Answer: B
  16. Which is not a PL/SQL datatype?
    A. NUMBER
    B. VARCHAR2
    C. BOOLEAN
    D. STRING
    Answer: D
  17. Which loop executes at least once?
    A. FOR LOOP
    B. WHILE LOOP
    C. LOOP-END LOOP
    D. NONE
    Answer: C
  18. What is BULK COLLECT used for?
    A. Delete multiple rows
    B. Fetch multiple rows at once
    C. Insert rows
    D. Update rows
    Answer: B
  19. Which keyword is used to raise exception manually?
    A. THROW
    B. RAISE
    C. ERROR
    D. ALERT
    Answer: B
  20. What is cursor FOR loop?
    A. Loop using implicit cursor
    B. Loop using explicit cursor automatically
    C. Infinite loop
    D. Conditional loop
    Answer: B
  21. What is autonomous transaction?
    A. Independent transaction
    B. Nested loop
    C. Trigger
    D. Package
    Answer: A
  22. Which object stores SQL queries permanently?
    A. Procedure
    B. Function
    C. View
    D. Index
    Answer: C
  23. What is a function in PL/SQL?
    A. Returns value
    B. Does not return value
    C. Loop
    D. Cursor
    Answer: A
  24. Which keyword declares variable?
    A. VAR
    B. DECLARE
    C. DEFINE
    D. SET
    Answer: B
  25. Which statement fetches cursor data?
    A. GET
    B. FETCH
    C. READ
    D. OPEN
    Answer: B
  26. What is dynamic SQL?
    A. Static query
    B. Runtime SQL execution
    C. Loop query
    D. Trigger query
    Answer: B
  27. Which keyword closes cursor?
    A. STOP
    B. CLOSE
    C. END
    D. EXIT
    Answer: B
  28. What is nested block?
    A. Loop inside loop
    B. Block inside another block
    C. Cursor inside loop
    D. Trigger inside procedure
    Answer: B
  29. Which exception occurs when too many rows fetched?
    A. NO_DATA_FOUND
    B. TOO_MANY_ROWS
    C. VALUE_ERROR
    D. INVALID_CURSOR
    Answer: B
  30. What is SAVEPOINT?
    A. End transaction
    B. Partial rollback point
    C. Delete operation
    D. Insert command
    Answer: B
  31. Which collection type is unbounded?
    A. VARRAY
    B. Nested Table
    C. Array
    D. Record
    Answer: B
  32. Which is used for multiple row processing?
    A. Cursor
    B. Variable
    C. Function
    D. Trigger
    Answer: A
  33. Which trigger type replaces DML?
    A. BEFORE
    B. AFTER
    C. INSTEAD OF
    D. DURING
    Answer: C
  34. What is pragma?
    A. SQL command
    B. Compiler directive
    C. Loop
    D. Cursor
    Answer: B
  35. Which keyword is used in CASE statement?
    A. WHEN
    B. IF
    C. LOOP
    D. THEN
    Answer: A
  36. What is DBMS_OUTPUT.PUT_LINE?
    A. Input command
    B. Output display
    C. Error handler
    D. Cursor
    Answer: B
  37. Which operator concatenates strings?
    A. +
    B. ||
    C. &
    D. CONCAT
    Answer: B
  38. Which keyword skips iteration?
    A. EXIT
    B. CONTINUE
    C. BREAK
    D. SKIP
    Answer: B
  39. What is REF CURSOR?
    A. Static cursor
    B. Pointer to result set
    C. Loop
    D. Function
    Answer: B
  40. Which block part is optional?
    A. BEGIN
    B. END
    C. DECLARE
    D. NONE
    Answer: C
  41. Which keyword handles multiple conditions?
    A. IF
    B. CASE
    C. LOOP
    D. EXIT
    Answer: B
  42. Which SQL statement is used in PL/SQL?
    A. DML
    B. DDL
    C. TCL
    D. ALL
    Answer: D
  43. Which clause locks rows?
    A. LOCK
    B. FOR UPDATE
    C. HOLD
    D. FREEZE
    Answer: B
  44. What is a synonym?
    A. Alias for object
    B. Variable
    C. Loop
    D. Cursor
    Answer: A
  45. Which datatype stores large text?
    A. VARCHAR2
    B. CHAR
    C. CLOB
    D. NUMBER
    Answer: C
  46. Which exception for datatype conversion error?
    A. VALUE_ERROR
    B. INVALID_NUMBER
    C. NO_DATA_FOUND
    D. TOO_MANY_ROWS
    Answer: B
  47. Which keyword defines constant?
    A. FINAL
    B. CONST
    C. CONSTANT
    D. FIXED
    Answer: C
  48. Which command deletes all rows permanently?
    A. DELETE
    B. TRUNCATE
    C. DROP
    D. REMOVE
    Answer: B
  49. What is sequence used for?
    A. Sorting
    B. Unique numbers
    C. Loop
    D. Cursor
    Answer: B
  50. Which keyword ends PL/SQL block?
    A. STOP
    B. CLOSE
    C. END
    D. EXIT
    Answer: C
Pages: 1 2

Leave a Comment