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. Exceptions: The three words that can be used to guarantee all exceptions will be handled.






2. Data dictionary view that shows the compiler settings for each compiled object.






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






4. In a collection - the internal components are called _______.






5. Cursors: A Cursor FOR loop does not use a ______ statement.






6. I/O: This package does email.






7. What are the 3 values of the BOOLEAN data type?






8. Web: PL/SQL _______ enables a Web browser to invoke a PL/SQL stored subprogram through an HTTP listener.






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






10. Exceptions: Some internal exceptions have ________ names.






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






12. The PL/SQL virtual machine turns bytecode into system ______.






13. Triggers: In a trigger - you cannot issue a COMMIT or a ______.






14. Characters that end a multi-line comment.






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






16. Cursors: If you use an EXIT statement to exit a cursor FOR loop prematurely - the cursor (is / is not) closed automatically.






17. Give the statement to make a program autonomous.






18. The BETWEEN operator is (inclusive / exclusive).






19. You cannot bulk collect into an ARRAY OF RECORDS. You can into a ________________ (3 words).






20. The three types of compiler warnings.






21. Default value of PLSQL_OPTIMIZE_LEVEL.






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






23. To use a TYPE declared in the database - a PL/SQL block has to have _______ privilege on the type.






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






25. %ROWTYPE gets the type of a table or _______.






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






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






28. Fundamental: One of the 4 types of lexical units: L_____






29. Cursors: A session cursor that a PL/SQL user creates and manages.






30. Triggers: An INSTEAD OF trigger is (always/never) a row-level trigger.






31. Give the first line of the FOR loop with index i going from 1 to 10 in reverse.






32. The variable showing the user id that is automatically prepended to object names.






33. Exceptions: Associate exception E with error code -1.






34. An editioning view is like an ____ for a table.






35. _______ arrays can be sparse or dense - depending on how you fill them.






36. Fundamental: identifiers (include/do not include) reserved words.






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






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






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






40. I/O: This package handles HTTP.






41. DBMS_DDL.WRAP returns a string containing wrapped _____ _____.






42. DBMS_DDL.CREATE_WRAPPED: wraps and _______ the source code passed to it.






43. With a result-cached function - it uses a cached value when the function is called again with the...






44. In a collection - the internal components always have the _____ data type.






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






46. Delimiters: the attribute indicator.






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






48. The default value of the AUTHID property.






49. Two types of stored subprograms.






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