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. I/O: This DBMS_OUTPUT proc retrieves one line from the buffer.






2. Exceptions: The maximum length of an Oracle error message is ____ characters






3. Term for a character literal with zero characters.






4. Into nested table ex - put elements of tbl1 that are not in tbl2.






5. Default file extension of wrap's input file.






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






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






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






9. DynSQL: EXECUTE IMMEDIATE can be used for any SQL statement or PL/SQL block - except for ________ queries.






10. Give the ANSI Date literal for December 25 - 2005.

Warning: Invalid argument supplied for foreach() in /var/www/html/basicversity.com/show_quiz.php on line 183


11. Delimiters: Host variable indicator.






12. Cursors: If an exception is raised inside a cursor loop - the cursor (is / is not) also closed automatically.






13. Advantage: PL/SQL runs anywhere Oracle runs - so it is very ________.






14. Statement to set current schema to x: _____ _____ SET CURRENT_SCHEMA = 'x';






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






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






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






18. Cursors: Define a ref cursor type called T.






19. Triggers: Programmers (as opposed to DBAs) mostly make use of _____ triggers.






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






21. The source for wrapping begins with the word ______.






22. A GOTO cannot branch into an...






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






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






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






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






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






28. A __________ can have an AUTHID property






29. The default value of the AUTHID property.






30. I/O: The buffered output of dbms_output.put_line is retrieved by _______.






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






32. One good use of bind variables is to guard against SQL _______.






33. The valid values of the AUTHID property.






34. Which two collection types are unbounded?






35. Declare an input NUMBER parameter - v2 - that defaults to 20.






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






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






38. In interpreted mode - the PL/SQL VM interprets the _________.






39. You can use the BULK COLLECT INTO clause in a SELECT or a ______.






40. An editioning view can only select a subset of the columns from the base table and provide ________ for them






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






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






43. Conversion: It is best to use (implicit / explicit) conversion.






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






45. Value of PLSQL_OPTIMIZE_LEVEL that prevents optimization.






46. ______ SQL is a PL/SQL feature that allows SQL syntax directly in a PL/SQL statement.






47. A result-cached function caches its results in the _____ _____ ____ (SGA)






48. Exceptions: An exception in the declarations section propagates to the enclosing _______.






49. Data dictionary view giving the AUTHID values on a user's objects.






50. Cursors: The first two keywords of a basic fetch statement.