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. Cursors: A cursor that lives in session memory until the session ends.






2. Bulk: The implicit cursor attribute that gives the number of rows affected by each DML statement in a FORALL statement.






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






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






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






6. Declare a variable r whose type is that of the records in table t.






7. Cursors: What implicit cursor attribute gives row counts for a FORALL statement?






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






9. Keyword for doing assignment to a variable with SELECT.






10. In a sparse collection - the indexes of defined elements (do / do not) run in consecutive order.






11. I/O: This DBMS_OUTPUT proc retrieves multiple lines from the buffer.






12. PLSQL_CCFLAGS hold a comma-separated list of ______ pairs (hyphenated).






13. Triggers: You create a trigger with the _______ ________ statement.






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






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






16. Triggers: The clause to make a trigger run before inserting or updating table EMPS.






17. Cursors: Give the statement to open cursor C.






18. Cursors: A session cursor that is automatically created and managed by PL/SQL.






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






20. The 2 characters that begin all inquiry directives.






21. Default value of PLSQL_OPTIMIZE_LEVEL.






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






23. I/O: If the current (outermost) PL/SQL block ends with an unhandled exception - the output buffer will not be ___________.






24. Which two collection types are unbounded?






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






26. Delimiters: Single-line comment marker.






27. Statement to exit a cursor loop on cursor cGo when there are no more records.






28. By default - OUT and IN OUT parameters are passed by _____.






29. Wrap ______=xxxx oname=zzzzz






30. Abbreviation of invoker's rights






31. IDs: The 3 non-alphanumeric characters that can be in an ordinary user-defined identifier.






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






33. In the IF syntax - is if ENDIF or END IF?






34. I/O: Max number of bytes to pass in a call to DBMS_OUTPUT.PUT_LINE.






35. Abbreviation for Abstract Data Type.






36. Cursors: Which cursor attribute is not meaningful for an implicit cursor?






37. Wrap iname=xxxx _____=zzzzz






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






39. SIMPLE_INTEGER is like PLS_INTEGER - but it does not allow ____ values - and it does not raise overflow exceptions.






40. What word is in a function header but not in a procedure header?






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






42. I/O: This package lets PL/SQL programs read and write OS files.






43. Fundamental: What are the 3 compound symbols for 'not equal to'?






44. A __________ can have an AUTHID property






45. FOR-Looping over a collection from FIRST to LAST only works if the collection is _______.






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






47. I/O: The most basic PL/SQL way to give output to the user.






48. Delimiters: Statement terminator.






49. The four keywords that define a PL/SQL block.






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