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. Where an external subprogram is stored.






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






3. A pointer to a private SQL area that stores information about processing a specific SELECT or DML statement.






4. If none of a CASE expression's conditions are TRUE - it returns _____.






5. Triggers: In a DML trigger - the phrase that makes the trigger run for every affected record.






6. Types: The only PL/SQL type for which you can specify a range constraint.






7. Conversion: If the specific value is suitable - ____ or _______ values can convert to almost any datatype






8. A national character literal is composed of characters in the ________ character set.






9. The FIRST method gets the first (element / index) of a collection.






10. IDs: The type of words that cannot be user-defined identifiers.






11. Triggers: You (can/cannot) explicitly invoke a trigger.






12. Exceptions: An exception raised inside an _______ _______ propagates immediately to the enclosing block






13. I/O: This package has hypertext procedures that generate HTML tags






14. Cursors: Give the first 3 words to open a cursor variable called cv.






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






16. Collections are one of the two kinds of PL/SQL _______ data types.






17. A CASE statement (can / cannot) execute more than one group of statements.






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






19. Web: PL/SQL ______ ______ (PSPs) let you develop web pages with dynamic content.






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






21. $$PLSQL_LINE and $$PLSQL_UNIT are ______-ly defined inquiry directives.






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






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






24. An INSTEAD OF trigger is used - e.g - when you want to insert into a complex _____.






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






26. Characters that begin a multi-line comment.






27. Dbms_sql: The DBMS_SQL procedure that closes a cursor.






28. I/O: One of the 3 types of data stored in the DBMS_OUTPUT buffer.






29. 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.






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






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






32. Pkgs: RESET_PACKAGE only takes effect after the outermost PL/SQL proc that called it ________.






33. To enable result-caching for a function - use the _____________ clause.






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






35. If you are in a procedure inside a package - the compilation unit is the _______.






36. You can put a label before any executable PL/SQL _________.






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






38. Advantage: PL/SQL is PORTABLE to any OS where ________ runs.






39. Two types of stored subprograms.






40. IDs: Maximum number of bytes in a user-defined identifier.






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






42. Fundamental: One of the 4 types of lexical units: i_____






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






44. When a session starts - CURRENT_SCHEMA has the value of the schema owned by ___________.






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






46. How many types of compiler directives are there?






47. Clause added to a cursor to use it with WHERE CURRENT OF.






48. The attribute used to get the type of a column or variable without knowing what it is.






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






50. A (simple / searched) CASE statement begins with CASE <expression>.