Oracle/PLSQL

by

  1. What does %FOUND attribute indicate?
    A. Cursor opened
    B. Row fetched successfully
    C. Cursor closed
    D. Error occurred
    Answer: B
  2. Which clause is used to handle multiple exceptions?
    A. WHEN OTHERS
    B. IF ELSE
    C. CASE
    D. LOOP
    Answer: A
  3. Which keyword defines record type?
    A. RECORD
    B. TYPE
    C. STRUCT
    D. ROWTYPE
    Answer: B
  4. What is a mutating table error?
    A. Table deleted
    B. Table being modified by trigger
    C. Table locked
    D. Table renamed
    Answer: B
  5. Which trigger is fired after DML event?
    A. BEFORE
    B. AFTER
    C. INSTEAD OF
    D. DURING
    Answer: B
  6. What is NOCOPY hint used for?
    A. Faster parameter passing
    B. Copy data
    C. Delete data
    D. Loop optimization
    Answer: A
  7. Which collection has fixed size?
    A. Nested Table
    B. Associative Array
    C. VARRAY
    D. Record
    Answer: C
  8. What is PIPELINED function?
    A. Returns multiple rows incrementally
    B. Returns single value
    C. Executes loop
    D. Creates cursor
    Answer: A
  9. Which clause prevents deadlock in SELECT?
    A. FOR UPDATE NOWAIT
    B. LOCK
    C. WAIT
    D. HOLD
    Answer: A
  10. Which is TRUE about implicit cursor?
    A. User defined
    B. Automatically created
    C. Needs OPEN
    D. Needs CLOSE
    Answer: B
  11. Which statement is used for exception propagation?
    A. THROW
    B. RAISE
    C. PROPAGATE
    D. ERROR
    Answer: B
  12. Which keyword is used to define subprogram?
    A. FUNCTION
    B. PROCEDURE
    C. BOTH
    D. NONE
    Answer: C
  13. Which trigger works on views?
    A. BEFORE
    B. AFTER
    C. INSTEAD OF
    D. DURING
    Answer: C
  14. Which clause limits fetched rows?
    A. WHERE
    B. HAVING
    C. ROWNUM
    D. ORDER BY
    Answer: C
  15. What is overloading in PL/SQL?
    A. Multiple functions with same name
    B. Multiple tables
    C. Multiple cursors
    D. Multiple loops
    Answer: A
  16. Which keyword handles null values?
    A. NVL
    B. NULLIF
    C. COALESCE
    D. ALL
    Answer: D
  17. Which package is used for dynamic SQL?
    A. DBMS_SQL
    B. DBMS_OUTPUT
    C. DBMS_JOB
    D. DBMS_ALERT
    Answer: A
  18. Which datatype stores binary data?
    A. BLOB
    B. CLOB
    C. CHAR
    D. NUMBER
    Answer: A
  19. What is cursor variable?
    A. Static cursor
    B. REF CURSOR
    C. Loop cursor
    D. Function cursor
    Answer: B
  20. Which keyword is used for bulk insert?
    A. FORALL
    B. INSERT ALL
    C. BULK INSERT
    D. MULTI INSERT
    Answer: A
  21. Which clause is used in hierarchical query?
    A. CONNECT BY
    B. GROUP BY
    C. ORDER BY
    D. WHERE
    Answer: A
  22. What is scalar subquery?
    A. Returns one column, one row
    B. Multiple rows
    C. Multiple columns
    D. No result
    Answer: A
  23. Which keyword is used in recursive query?
    A. WITH
    B. CONNECT
    C. LOOP
    D. RECURSIVE
    Answer: A
  24. What is database link?
    A. Link between tables
    B. Link between databases
    C. Link between views
    D. Link between cursors
    Answer: B
  25. Which command removes table completely?
    A. DELETE
    B. TRUNCATE
    C. DROP
    D. REMOVE
    Answer: C
  26. What is a materialized view?
    A. Virtual view
    B. Stored result of query
    C. Cursor
    D. Function
    Answer: B
  27. Which clause filters groups?
    A. WHERE
    B. HAVING
    C. GROUP BY
    D. ORDER BY
    Answer: B
  28. Which constraint ensures uniqueness?
    A. NOT NULL
    B. PRIMARY KEY
    C. FOREIGN KEY
    D. CHECK
    Answer: B
  29. Which constraint enforces relationship?
    A. UNIQUE
    B. CHECK
    C. FOREIGN KEY
    D. NOT NULL
    Answer: C
  30. Which operator checks null?
    A. = NULL
    B. IS NULL
    C. NULL =
    D. == NULL
    Answer: B
  31. Which join returns all rows from both tables?
    A. INNER JOIN
    B. LEFT JOIN
    C. FULL OUTER JOIN
    D. RIGHT JOIN
    Answer: C
  32. Which clause sorts result?
    A. GROUP BY
    B. ORDER BY
    C. SORT BY
    D. ARRANGE
    Answer: B
  33. Which function returns system date?
    A. GETDATE
    B. SYSDATE
    C. CURRENT_DATE
    D. NOW
    Answer: B
  34. Which keyword creates index?
    A. MAKE INDEX
    B. CREATE INDEX
    C. ADD INDEX
    D. NEW INDEX
    Answer: B
  35. Which index improves performance?
    A. B-Tree
    B. Hash
    C. Bitmap
    D. All
    Answer: D
  36. Which clause removes duplicates?
    A. UNIQUE
    B. DISTINCT
    C. DIFFERENT
    D. SINGLE
    Answer: B
  37. Which keyword defines synonym?
    A. CREATE SYNONYM
    B. MAKE SYNONYM
    C. ADD SYNONYM
    D. NEW SYNONYM
    Answer: A
  38. Which function converts to number?
    A. TO_CHAR
    B. TO_DATE
    C. TO_NUMBER
    D. TO_INT
    Answer: C
  39. Which function converts to string?
    A. TO_CHAR
    B. TO_STRING
    C. STR
    D. CHAR
    Answer: A
  40. Which clause groups rows?
    A. WHERE
    B. GROUP BY
    C. ORDER BY
    D. HAVING
    Answer: B
  41. Which keyword grants privilege?
    A. GIVE
    B. GRANT
    C. ALLOW
    D. PERMIT
    Answer: B
  42. Which keyword removes privilege?
    A. REMOVE
    B. DELETE
    C. REVOKE
    D. CANCEL
    Answer: C
  43. Which command renames table?
    A. CHANGE
    B. MODIFY
    C. RENAME
    D. ALTER
    Answer: C
  44. Which clause restricts rows?
    A. WHERE
    B. GROUP BY
    C. HAVING
    D. ORDER BY
    Answer: A
  45. Which datatype stores date?
    A. TIME
    B. DATE
    C. DATETIME
    D. TIMESTAMP
    Answer: B
  46. Which keyword is used in subquery?
    A. SELECT
    B. FROM
    C. WHERE
    D. ALL
    Answer: D
  47. Which operator checks existence?
    A. IN
    B. EXISTS
    C. ANY
    D. ALL
    Answer: B
  48. Which clause limits result rows in modern Oracle?
    A. LIMIT
    B. FETCH FIRST
    C. TOP
    D. RANGE
    Answer: B
  49. Which function returns user name?
    A. USER
    B. USERNAME
    C. CURRENT_USER
    D. SESSION_USER
    Answer: A
  50. Which clause is used with aggregate functions?
    A. WHERE
    B. HAVING
    C. GROUP BY
    D. ALL
    Answer: C
Pages: 1 2

Leave a Comment