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: If there is no handler for an exception - PL/SQL returns an ________ exception error to the invoker or host environment.






2. An anonymous block always has _________ rights.

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


3. I/O: This package handles HTTP.






4. INSTEAD OF triggers are alternatives to ___ triggers






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






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






7. Cursors: SYS_REFCURSOR is a predefined type based on _____ ______.






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






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






10. I/O: SQLPlus command for turning on buffered output.






11. Exceptions: Some internal exceptions have ________ names.






12. VARRAYs are (always / never) sparse.






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






14. Advantage: PL/SQL supports ______-oriented programming.






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






16. A subprogram defined within another subprogram is a _______ subprogram.






17. Wrapping can be done with the ____ executable.






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






19. Declare a cursor c with no parameters or return type.






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






21. The RESULT_CACHE clause comes (before / after) the RETURN clause.






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






23. The Wrap utility ________ the source code.






24. What is the simplest statement for conditionally getting out of simple loop?






25. Characters that end a multi-line comment.






26. Characters that begin a multi-line comment.






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






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






29. A __________ can have an AUTHID property






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






31. Triggers: The code in a trigger is actually an ________ block.






32. Cursors: Give the statement to fetch data from cursor C into variable V.






33. With conditional compilation you can avoid compiling debug code in the _______ environment.






34. What are two categories of SQL functions that cannot be used in procedural statements?






35. Types: PL/SQL has all the _____ data types.






36. Characters that begin a single-line comment.






37. Cursors: A cursor FOR loop can use an explicit or an _______ cursor.






38. Web: The gateway that allows a web browser to invoke a PL/SQL procedure through an HTTP listener.






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






40. Official acronym for PL/SQL's runtime engine.






41. Exceptions: The three words that can be used to guarantee all exceptions will be handled.






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






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






44. Kind of comment not to put in a PL/SQL block to be processed dynamically by an Oracle Precompiler program.






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






46. Associative array types (can / cannot) be defined in the database.






47. In the special IF syntax - is it ELSIF - or ELSEIF?






48. Give the clause you add to a CREATE TABLE statement - when there is a collection column myColl - that you want to be stored in a table called myCollTab.






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






50. A FOR-loop counter is defined only within the _____.







Sorry!:) No result found.

Can you answer 50 questions in 15 minutes?


Let me suggest you:

Browse all subjects

Browse all tests

Most popular tests



Major Subjects

Tests & Exams


AP
CLEP
DSST
GRE
SAT
GMAT

Browse all subjects

Browse all tests

Most popular tests