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. Parameter that controls how much Oracle optimizes your PL/SQL code on compilation.






2. Cursors: A pointer to a cursor is called a ______ _______.






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






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






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






6. True encryption is done with package __________.






7. Abbreviation for Abstract Data Type.






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






9. Command to assign to variables from a cursor.






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






11. How to reference a variable V declared in a block labelled L: ____.






12. I/O: This package does email.






13. Collections are one of the two kinds of PL/SQL _______ data types.






14. Delimiters: The assignment operator.






15. How many times are a FOR loop's index bounds evaluated?






16. TCL: Create a savepoint called ab






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






18. In short-circuit evaluation - IF-conditions are only evaluated up to where the outcome ___________.






19. In a record - the internal components are called ______.






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






21. A type of compiler directive - begins with 's'.






22. Exceptions: The built-in procedure for raising an application-defined error.






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






24. Abbreviation of definer's rights






25. What do you FETCH from?






26. Nested tables are multisets - meaning that there is no inherent _____ of their elements.






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






28. Web: PL/SQL ______ ______ (PSPs) let you develop web pages with dynamic content.






29. Advantage: Having procedures stored and executed on the server makes PL/SQL ________.






30. DynSQL: The three modes of arguments in the USING clause of EXECUTE IMMEDIATE.






31. For a collection - the NEXT method gets the next higher (element / index).






32. A nested table has to be initialized using a ________ - named the same as the type.






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






34. Cursors: An explicit cursor (can/cannot) accept parameters.






35. Declaration of a varchar2 constant - called vname - with value 'x'.

Warning: Invalid argument supplied for foreach() in /var/www/html/basicversity.com/show_quiz.php on line 183


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






37. A CASE expression ends with _____.






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






39. I/O: The DBMS_OUTPUT function that writes output WITH a newline character.






40. Bulk: The two features that comprise Bulk SQL are:






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






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






43. The EXCEPTION section is (optional/mandatory).






44. Advantage: PL/SQL is PORTABLE to any OS where ________ runs.






45. I/O: The DBMS_OUTPUT buffer will not be flushed until it is full or until the current PL/SQL block _________.






46. 5 types of events that can have triggers: DML - DDL - INSTEAD OFs - database events - and ________ statements.






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






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






49. Delimiters: Host variable indicator.






50. The source for wrapping begins with the word ______.