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. When a session starts - CURRENT_SCHEMA has the value of the schema owned by ___________.






2. Cursors: The statement where you pass the parameters to a cursor.






3. I/O: SQLPlus command for turning on buffered output.






4. Exceptions: An exception in the declarations section does not go to the __________ section.






5. I/O: This package does email.






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






7. Types: In addition to the SQL data types - PL/SQL has ___ more scalar data types.






8. The first SQL statement in an autonomous routine begins a _______.






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






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






11. Delimiters: The association operator.






12. Abbreviation for Abstract Data Type.






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






14. Wrap ______=xxxx oname=zzzzz






15. The values defined in PLSQL_CCFLAGS can be referenced as _____ directives.






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






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






18. How many PL/SQL collection types are there?






19. Labels for blocks and statements are enclosed in '__' brackets.






20. Web: mod_plsql is an _______ module.






21. Command to create a procedure.






22. Fundamental: One of the 4 types of lexical units: i_____






23. Cursors: Give the statement to close cursor C.






24. Java - C or other program called directly in PL/SQL.






25. Triggers: In a DML trigger - the phrase that makes the trigger run for every affected record.






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






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






28. Triggers: There are __ types of triggers.






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






30. Pkgs: RESET_PACKAGE only takes effect after the outermost PL/SQL proc that called it ________.






31. Advantage: Performance: PL/SQL automatically creates ______ variables for variables in WHERE and VALUES clauses.






32. Bytecode is _______ _______ code.






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






34. Records are one of the two kinds of PL/SQL _______ data types.






35. TCL: Create a savepoint called ab






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






37. The 2 characters that begin all inquiry directives.






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






39. The method to add one or more elements to a nested table or VARRAY is ______.






40. Exceptions: The three words that can be used to guarantee all exceptions will be handled.






41. Types: ________ data types have internal components.






42. To get the current value of CURRENT_SCHEMA - CURRENT_USER - or SESSION_USER - use the ____ function.






43. The 4 keywords in the $IF compiler directive.






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






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






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






47. You can put a label before any executable PL/SQL _________.






48. The RESULT_CACHE clause has to be in both the declaration and in the ______ of the function.






49. To enable result-caching for a function - use the _____________ clause.






50. Define a nested table type - tN - which is a table NUMBERs.