Test your basic knowledge |

Oracle PL - SQL

Subjects : oracle, it-skills
Instructions:
  • Answer 50 questions in 15 minutes.
  • If you are not ready to take this test, you can study here.
  • Match each statement with the correct term.
  • Don't refresh. All questions and answers are randomly picked and ordered every time you load a test.

This is a study tool. The 3 wrong answers for each question are randomly chosen from answers to other questions. So, you might find at times the answers obvious, but you will see it re-enforces your understanding as you take the test each time.
1. Exceptions: A GOTO statement cannot branch into an _______ ________.






2. Dbms_sql: A cursor opened with OPEN_CURSOR (can/cannot) be reused for multiple queries without first closing it.






3. The Wrap utility (does / does not) encrypt source code.






4. Labels for blocks and statements are enclosed in '__' brackets.






5. Exceptions: PL/SQL exceptions are of two types: internal and _________.






6. An anonymous block is a(n) ____ statement.






7. I/O: One of the 3 types of data stored in the DBMS_OUTPUT buffer.






8. Name the two types of FOR loop.






9. I/O: This DBMS_OUTPUT proc retrieves one line from the buffer.






10. Cursors: What implicit cursor attribute gives row counts for a FORALL statement?






11. Bulk: The use of FORALL statements cuts down on ______ traffic.






12. Cursors: An implicit cursor is also called a/n ________ ________ -






13. The allowed data types of user-defined conditional compilation directives are boolean and _______.






14. Cursors: The SQL%BULK_ROWCOUNT attribute is an _________ -






15. Mode designation for an output parameter.






16. Cursors: SYS_REFCURSOR is a predefined type based on _____ ______.






17. Give the statement to make a program autonomous.






18. In 11g you can directly reference _____________ in PL/SQL.






19. The PL/SQL virtual machine turns bytecode into system ______.






20. GOTO branches to a ________.






21. You can use the BULK COLLECT INTO clause in a SELECT or a ______.






22. The DEFINITION of a cursor is the _____ that returns the records.






23. A subprogram created inside a block is a _________ subprogram.






24. Exceptions: An exception in the declarations section does not go to the __________ section.






25. Triggers: An INSTEAD OF trigger (can/cannot) be conditional.






26. ______ SQL is a PL/SQL feature that allows SQL syntax directly in a PL/SQL statement.






27. What are the two sequence pseudo-columns?






28. Types: One of the scalar data types specific to PL/SQL: B_______






29. DBMS_DDL.CREATE_WRAPPED: wraps and _______ the source code passed to it.






30. Command to create a procedure.






31. A CASE expression ends with _____.






32. The attribute used to get the type of a column or variable without knowing what it is.






33. Cursors: A cursor FOR loop can use an explicit or an _______ cursor.






34. Cursors: What are the 3 possible values of SQL%FOUND and SQL%NOTFOUND?






35. Exceptions: User-defined exceptions must have _______.






36. The FOR UPDATE OF clause references a (table / column).






37. Advantage: Caching of programs and sharing among users lowers _______ requirements.






38. Conversion: Implicit conversion can be (faster / slower) than explicit conversion.






39. Searchable CASE statement: Each WHEN has its own _______ condition.






40. Exceptions: The _________ package defines the PL/SQL environment.






41. Define a record type REC with number num and varchar2(10) name.






42. The BETWEEN operator is (inclusive / exclusive).






43. Types: The PL/SQL type that is identical to PLS_INTEGER.






44. Cursors: A session cursor that is automatically created and managed by PL/SQL.






45. Triggers: When using the NEW or OLD pseudo-records in the body of the trigger - they must be prefixed with a _______.






46. Triggers: You (can/cannot) explicitly invoke a trigger.






47. Command to make a no-op (omit semicolon).






48. Parameter that controls how much Oracle optimizes your PL/SQL code on compilation.






49. Pkgs: The _______ package gives access to such SQL things as ALTER SESSION.






50. Term for a character literal with zero characters.