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. The variable showing the user id of the session owner.






2. Exceptions: Start of the range of error codes for RAISE_APPLICATION_ERROR.






3. Set flag bb true: ALTER SESSION SET PLSQL_CCFLAGS= '____'






4. Delimiters: The association operator.






5. Fundamental: Which one of these is a simple symbol: a - = - !=






6. Web: PL/SQL _______ enables a Web browser to invoke a PL/SQL stored subprogram through an HTTP listener.






7. Fundamental: Labels furnish targets for GOTO and _____ statements.






8. Where an external subprogram is stored.






9. IDs: You cannot use reserved words as ______ user-defined identifiers.






10. A (simple / searched) CASE statement begins with CASE WHEN <boolean expression>.






11. A type of compiler directive - begins with 'i'.






12. The DECLARE keyword is only required in an _______ _______.






13. Cursors: Give the statement to open cursor C.






14. A national character literal is composed of characters in the ________ character set.






15. The LIMIT method is only meaningful for _______.






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






17. TCL: Undo changes back to savepoint ab.






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






19. The valid values of the AUTHID property.






20. I/O: To make sure the DBMS_OUTPUT buffer will be flushed - put a WHEN ______ clause in the EXCEPTION section of your outer block.






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






22. Cursors: A Cursor FOR loop does not use a ______ statement.






23. To run TCL or DDL statements - a trigger (must / must not) be autonomous .






24. IDs: The type of words that cannot be user-defined identifiers.






25. In interpreted mode - PL/SQL code is run in a _______ _______.






26. Cursors: What is the 'name' of the implicit cursor?






27. The statement that is used to execute most (native) dynamic SQL.






28. PL/SQL does not automatically create bind variables in ________ SQL.






29. A FOR loop can be indexed by numbers or by a ______.






30. Types: One of the scalar data types specific to PL/SQL: P________






31. _________ exceptions can not be trapped with an error handler






32. Cursors: Give the first 3 words to open a cursor variable called cv.






33. If a procedure fails - an OUT parameter passed to it by value (will / will not) be passed back with changes.






34. Fundamental: Maximum string length of a PL/SQL variable.






35. I/O: This package has hypertext procedures that generate HTML tags






36. In interpreted mode - the PL/SQL VM interprets the _________.






37. Dbms_sql: The DBMS_SQL procedure that will execute a DDL or DML statement.






38. Fundamental: One of the 4 types of lexical units: c_____.






39. DynSQL: The main command for Native Dynamic SQL.






40. In Native Mode - PL/SQL code is compiled into ______ ______.






41. Fundamental: One of the 4 types of lexical units: d_____






42. Mode designation for an input/output parameter.






43. Advantage: PL/SQL gives SCALABILITY because stored procedures are executed on the _______.






44. In a FORALL loop - you (can / cannot) use the index variable for purposes other than indexing into the collection.






45. Exceptions: You can pass an ______ ________ to SQLERRM.






46. The variable showing the user id that is automatically prepended to object names.






47. Types: ________ data types have internal components.






48. Exceptions: An unhandled exception ________ to the enclosing block.






49. Declare an input/output NUMBER parameter - v3.






50. Bytecode is _______ _______ code.