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. Conversion: Implicit conversion can be (faster / slower) than explicit conversion.






2. Triggers and views always have _________ rights.


3. I/O: This package does email.






4. Exceptions: Declare an exception called E.






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






6. Name the two types of FOR loop.






7. Types of blocks: A pl/sql block that is not stored in the database.






8. The statement that is used to execute most (native) dynamic SQL.






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






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






11. Triggers: On a non-editioning view - you can only define __________ triggers.






12. Define a record variable r - of type tRec - initialized with values 9 and 'Jones' in its two fields.


13. Exceptions: An exception raised inside an _______ _______ propagates immediately to the enclosing block






14. Wrap ______=xxxx oname=zzzzz






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






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






17. A pointer to a private SQL area that stores information about processing a specific SELECT or DML statement.






18. A subprogram defined within another subprogram is a _______ subprogram.






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






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






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






22. Associative array types (can / cannot) be defined in the database.






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






24. Advantage: Performance: Storing and runnng procedures on the server minimizes ______ traffic.






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






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






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






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






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






30. Exceptions: Write the call (2 args) to associate message 'Bad' with error code -20 -100.


31. To run DDL statements - a trigger must be autonomous and must use ______ ______ SQL.






32. Mode designation for an input parameter.






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






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






35. The names of Java objects in Oracle can be up to __ characters in length.






36. In a FORALL loop - you (can / cannot) use the index variable for purposes other than indexing into the collection.






37. Cursors: The value of SQL%ROWCOUNT after a SELECT INTO statement returns more than one row.






38. The inquiry directive that gives the current line number in the procedure.






39. Give the statement to make a program autonomous.






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






41. A SELECT statement with the FOR UPDATE clause puts a ______ on the selected rows.






42. Exceptions: Some internal exceptions have ________ names.






43. The 2 characters that begin all inquiry directives.






44. An autonomous program runs in its own __________.






45. An INSTEAD OF trigger is used - e.g - when you want to insert into a complex _____.






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






47. Official acronym for PL/SQL's runtime engine.






48. The meaning of 'FGA'.






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






50. Cursors: What are the 3 possible values of SQL%FOUND and SQL%NOTFOUND?