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. You (can/cannot) put a label before an END LOOP statement.






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






3. Abbreviation of invoker's rights






4. Triggers: By default - a trigger is created in the ______ state.






5. Web: mod_plsql is an _______ module.






6. The lowest index of a VARRAY is ___.






7. Define a collection type - tA - which is an associative array of NUMBERS - indexed with varchar2(20) values.






8. Types: Which type of arithmetic does NUMBER use - library or hardware?






9. The FOR UPDATE OF clause references a (table / column).






10. Dbms_sql: The return type DBMS_SQL.open_cursor.






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






12. Are good for logging table DML operations.






13. Pkgs: The _______ package gives access to such SQL things as ALTER SESSION.






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






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






16. An INSTEAD OF trigger specifies what to do instead of a ___ statement.






17. What clause makes a compilation default to the PLSQL_CCFLAGS settings from the last compilation?






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






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






20. Characters that begin a single-line comment.






21. The AUTHID property applies to PL/SQL objects that contain _____.






22. Cursors: A cursor with a name is an _________ cursor.






23. Abbreviation of definer's rights






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






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






26. Wrap iname=xxxx _____=zzzzz






27. Declare a number variable - A - initialized to 10.






28. Where an external subprogram is stored.






29. To get the current value of CURRENT_SCHEMA - CURRENT_USER - or SESSION_USER - use the ____ function.






30. Cursors: The values plugged into the DML in a FORALL must come from existing - populated _________.






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






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






33. Cursors: Only a _____ _____ cursor can appear in the CURRENT OF clause of an UPDATE or DELETE statement.






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






35. Packaged constants can synchronize programs through use in _______ directives.






36. Exceptions: A GOTO statement cannot branch into an _______ ________.






37. With dynamic typing - type checking is done at ______time.






38. DynSQL: The standard package that does dynamic SQL.






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






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






41. A type of compiler directive - begins with 's'.






42. The three possible values of a BOOLEAN literal.






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






44. Cursors: The FOR UPDATE phrase goes at the (beginning/end) of the cursor definition.






45. Cursors: What implicit cursor attribute gives row counts for a FORALL statement?






46. Type: A __________ subtype has only a subset of the values of its base type.






47. True encryption is done with package __________.






48. A PL/SQL extension to the WHERE clause of the SQL statements UPDATE and DELETE






49. I/O: The DBMS_OUTPUT function that writes output without a newline character.






50. An ordinary character literal is composed of characters in the ________ character set.