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. Web: mod_plsql is an implementation of the PL/SQL _________.






2. The two kinds of CASE statements are simple and ________.






3. Cursors: A cursor FOR loop cannot use a _______ variable.






4. Cursors: If no SELECT or DML statement has run - the value of SQL%ROWCOUNT is what?






5. Language that PL/SQL is derived from.






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






7. The _____ utility turns PL/SQL source code into unreadable text.






8. Cursors: A cursor that lives in session memory until the session ends.






9. DynSQL: Native Dynamic SQL






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






11. Types: ________ data types have no internal components.






12. If an initialized collection has no elements - FIRST and LAST return _____.






13. Value of PLSQL_OPTIMIZE_LEVEL that prevents optimization.






14. _________ exceptions can not be trapped with an error handler






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






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






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






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






19. Types: The only Oracle datetime type that doesn't begin with TIMESTAMP is ________.






20. IDs: You (can/cannot) use keywords as ordinary user-defined identifiers.






21. Exceptions: The ________ function returns the error message associated with an error code.






22. Web: mod_plsql is an _______ module.






23. Fundamental: Which one of these is a compound symbol: = - :=






24. Cursors: The value of SQL%ISOPEN is always ______.






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






26. Mode designation for an input parameter.






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






28. Cursors: The type definition of a WEAK ref cursor type has no _______ clause.






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






30. User-defined compiler directives are defined in this system compile parameter.






31. Wrap iname=xxxx _____=zzzzz






32. Which two collection types are unbounded?






33. For a collection - the NEXT method gets the next higher (element / index).






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






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






36. You (can/cannot) put a label before an END LOOP statement.






37. A numeric FOR loop cannot _________ by other than 1?






38. Types: Which type of arithmetic does PLS_INTEGER use - library or hardware?






39. NAN stands for _________.






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






41. Exceptions: An unhandled exception ________ to the enclosing block.






42. Command used to execute dynamic SQL.






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






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






45. Delimiters: The remote access symbol.






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






47. INSTEAD OF triggers are alternatives to ___ triggers






48. Exceptions: When an exception is raised inside a cursor FOR loop - the cursor is _______ implicitly.






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






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