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. Delimiters: The remote access symbol.






2. The lowest index of a nested table is ___.






3. An $ERROR directive ends with _____.






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






5. Types: The storage size of a NUMBER value is based on the number of ______ digits.






6. User-defined compiler directives are defined in this system compile parameter.






7. Cursors: If no SELECT or DML statement has run - the value of SQL%ROWCOUNT is what?






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






9. An INSTEAD OF trigger specifies what to do instead of a ___ statement.






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






11. Cursors: A cursor that lives in session memory until the session ends.






12. Cursors: The first two keywords of a basic fetch statement.






13. With static typing - type checking is done at ______ time.






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






15. Exceptions: The keyword that begins an exception handler.






16. Triggers: An INSTEAD OF trigger is (always/never) a row-level trigger.






17. Cursors: How many implicit cursors can you access?






18. Types: One of the scalar data types specific to PL/SQL: R_________.






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






20. Cursors: The SQL%FOUND attribute has how many possible values?






21. Triggers: If two or more triggers are defined with the same timing point - then you can control the firing order using the ________ clause.






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






23. Into nested table ex - put elements of tbl1 that are not in tbl2.






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






25. The valid values of the AUTHID property.






26. Delimiters: The component indicator/selector.






27. I/O: This package handles HTTP.






28. An editioning view is like an ____ for a table.






29. Which two of these built-in SQL functions can be used in procedural (PL/SQL) statements: DECODE - CORR - UPPER - SUM - COALESCE - DEREF.






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






31. A FOR-loop counter is defined only within the _____.






32. DynSQL: In EXECUTE IMMEDIATE - the statement string can use either placeholders - or string ________.






33. Exceptions: The ________ function returns the current error code.






34. Where an external subprogram is stored.






35. Triggers: There are __ types of triggers.






36. To recompile a procedure - use the _____ ______ command.






37. What is the simplest statement for getting out of simple loop?






38. Triggers: In a per-row trigger - the ____ record shows you the original state of an affected row.






39. The exception raised when a SELECT INTO statement returns more than one row.






40. Pkgs: This procedure de-instantiates/resets all packages in this session.






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






42. The SET TRANSACTION statement affects only the ____________.






43. Nested tables can become sparse via ______.






44. Cursors: The values plugged into the DML in a FORALL must come from existing - populated _________.






45. Cursors: Give the statement for getting out of a FETCH loop for cursor CV.






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






47. Declare a constrained subtype of NUMBER called N that is not null.






48. Web: PL/SQL _____ _______ lets you to develop Web applications made of PL/SQL procedures.






49. Types: A data type family consists of a ______ type and its subtypes.






50. Declare a package procedure P with no arguments - and give it invoker's rights.