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. Which two of these built-in SQL functions can be used in procedural (PL/SQL) statements: DECODE - CORR - UPPER - SUM - COALESCE - DEREF.






2. FOR-Looping over a collection from FIRST to LAST only works if the collection is _______.






3. By default - OUT and IN OUT parameters are passed by _____.






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






5. Mode designation for an input parameter.






6. The NOCOPY option on an OUT or IN OUT parameter - causes it to be passed by ______.






7. DynSQL: The colon-prefixed names used in EXECUTE IMMEDIATE are called ________.






8. DynSQL: Maximum string length to pass to EXECUTE IMMEDIATE.






9. Types: The only PL/SQL type for which you can specify a range constraint.






10. From a block nested inside a procedure P - reference variable V of the outer procedure.






11. Cursors: Opening keyword of a cursor FETCH loop.






12. Triggers: The clause to make a trigger run after inserting into table EMPS.






13. _______ arrays can be sparse or dense - depending on how you fill them.






14. Wrapped code (is / is not) not backward compatible.






15. The attribute used to get the type of a row without knowing what it is.






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






17. Advantage: PL/SQL programs are stored centrally - making them more ______.






18. Native compilation turns bytecode into ________ code.






19. In a cursor loop - the clause added to an INSERT or UPDATE to point at the current record.






20. An $ERROR directive ends with _____.






21. Cursors: A cursor with a name is an _________ cursor.






22. Assigning values to PL/SQL variables that appear in SQL statements is called _______.






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






24. The PL/SQL preprocessor passes ______ code to the compiler.






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






26. With Edition-based Redefinition enabled - the unique specification of an object requires OWNER - OBJECT_NAME and ___________.






27. Cursors: A session cursor that a PL/SQL user creates and manages.






28. Internally - the NUMBER type is stored as ______. Therefore - decimal numbers (such as prices) are stored exactly - with no rounding.






29. Where an external subprogram is stored.






30. An incomplete type is a type created by a ______ type definition.






31. Exceptions: When an exception is raised inside a cursor FOR loop - the cursor is _______ implicitly.






32. Value of PLSQL_OPTIMIZE_LEVEL that prevents optimization.






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






34. Term for a character literal with zero characters.






35. Loops: What is the index range operator in a FOR loop?






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






37. Exceptions: The ________ handler must always be the last handler.






38. What are two categories of SQL functions that cannot be used in procedural statements?






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






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






41. The collection method that tells the number of elements in the collection.






42. The 2 characters that begin all inquiry directives.






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






44. Types: The only Oracle datetime type that doesn't begin with TIMESTAMP is ________.






45. Types: ______ data types are those storing values with no internal components.






46. An ordinary character literal is composed of characters in the ________ character set.






47. With a result-cached function - it uses a cached value when the function is called again with the...






48. This is a CASE (expression / statement): CASE num WHEN 1 THEN goto LABEL1 WHEN 2 THEN var := 2 END CASE;






49. Exceptions: An exception in the declarations section propagates to the enclosing _______.






50. A CASE statement (can / cannot) execute more than one group of statements.