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. With an sparse - integer-indexed associative array - you (can / cannot) use a regular FOR loop.






2. The compiler directive used to select which code to compile.






3. Triggers: To simulate having triggers on SELECT statements - you can try ___ (3-letter acronym).






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






5. This is a CASE (expression / statement): myvar := CASE num WHEN 1 THEN 'good' WHEN 2 THEN 'bad' END;






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






7. I/O: If the current (outermost) PL/SQL block ends with an unhandled exception - the output buffer will not be ___________.






8. Simple CASE statement checks for different values of a single _________






9. Types: ________ data types have no internal components.






10. The SET TRANSACTION statement affects only the ____________.






11. Web: mod_plsql is an implementation of the PL/SQL _________.






12. What are the starting and ending keywords of a simple loop?






13. By default - an IN parameter is passed by ______.






14. TCL: Create a savepoint called ab






15. Delimiters: The association operator.






16. PL/SQL lets you define two kinds of composite data types: _______ and _______






17. IDs: You can use a reserved word as a _______ user-defined identifier.






18. A collection is an ordered group of ________ - all of the same ____






19. Conversion: If the specific value is suitable - ____ or _______ values can convert to almost any datatype






20. What is the exception that is implicitly raised in a CASE statement with no ELSE clause?






21. I/O: The DBMS_OUTPUT function that writes output without a newline character.






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






23. What are the two sequence pseudo-columns?






24. Command to create a procedure.






25. Cursors: You can just declare a cursor at first - then _______ it later.






26. Cursors: A cursor variable's type must be a ____ ______ type.






27. Exceptions: If there is no handler for an exception - PL/SQL returns an ________ exception error to the invoker or host environment.






28. IDs: Maximum number of bytes in a user-defined identifier.






29. Delimiters: The assignment operator.






30. I/O: The string table type in DBMS_OUTPUT for holding lines of text.






31. Web: Abbreviation of PL/SQL Server Page.






32. Fundamental: What is the exponentiation operator?






33. A GOTO statement can branch from an exception handler into...






34. Triggers: By default - a trigger is created in the ______ state.






35. Triggers: A compound trigger can fire at more than one ______ point.






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






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






38. Conversion: Just about everything will implicitly convert to _____ or _________.






39. PLS_INTEGER has its arithmetic implemented in ________ - so it is very fast.






40. The _____ and ____ _____ collection types can be used in database table columns.






41. A (simple / searched) CASE statement begins with CASE <expression>.






42. Triggers: Programmers (as opposed to DBAs) mostly make use of _____ triggers.






43. DynSQL: EXECUTE IMMEDIATE can be used for any SQL statement or PL/SQL block - except for ________ queries.






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






45. Types: One of the 4 PL/SQL things that have a data type (begins with 'c').






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






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






48. How many types of compiler directives are there?






49. DynSQL: The clause that supplies bind arguments to EXECUTE IMMEDIATE.






50. A ___________ behaves like a table column - but it is not stored in the table.