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 collection type is bounded?






2. Cursors: You can just declare a cursor at first - then _______ it later.






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






4. Exceptions: The package that defines pre-defined exceptions.






5. Cursors: The two keywords in a mere cursor declaration (one is optional).






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






7. By default - an IN parameter is passed by ______.






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






9. Triggers: Unlike a stored procedure - you can enable and _____ a trigger.






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






11. Types: The predefined subtype of PLS_INTEGER that has the NOT NULL constraint.






12. Wrap ______=xxxx oname=zzzzz






13. I/O: The PL/SQL I/O packages (can/cannot) accept input directly from the keyboard.






14. Fundamental: Maximum string length of a PL/SQL variable.






15. TCL: Undo changes back to savepoint ab.






16. The default value of the AUTHID property.






17. A large OUT or IN OUT parameter will waste a lot of space and CPU if it is passed by _____.






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






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






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






21. Declare an unconstrained subtype of NUMBER called NUMB.






22. Cursors: Statement to end a loop when MyCur is used up: _____ ______ MyCur%NOTFOUND.






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






24. (from inside a package) Declare a function f - that takes a number n - returns a number - and caches results - depending on table EMPS.






25. Packaged constants can synchronize programs through use in _______ directives.






26. Exceptions: Type ______ to re-raise the current exception.






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






28. Exceptions: If there is no handler for an exception - PL/SQL returns an ________ exception error to the invoker or host environment.






29. Value of a character literal with zero characters.






30. Type: An ________ subtype has all the values of its base type.






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






32. A record is a group of related data items stored in fields - each with its own...






33. Characters that end a multi-line comment.






34. Fundamental: Which one of these is a simple symbol: a - = - !=






35. An incomplete type only has a ____.






36. The three possible values of a BOOLEAN literal.






37. A type of compiler directive - begins with 'e'.






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






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






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






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






42. For an associative array - the FIRST method gets the (lowest / first-created) index.






43. Fundamental: One of the 4 types of lexical units: c_____.






44. Term for a character literal with zero characters.






45. The DEFINITION of a cursor is the part after the keyword __.






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






47. Set flag bb true: ALTER SESSION SET PLSQL_CCFLAGS= '____'






48. To exit an active autonomous transaction without causing an exception - you must issue _____ or ______.






49. Exceptions: Some internal exceptions have ________ names.






50. Unlike the CASE statement - the CASE expression does not have the...