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. Types: ________ data types have no internal components.






2. Abbreviation for Abstract Data Type.






3. Records are one of the two kinds of PL/SQL _______ data types.






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






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






6. In Native Mode - PL/SQL code is compiled into ______ ______.






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






8. Fundamental: Labels furnish targets for GOTO and _____ statements.






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






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






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






12. The Wrap utility (does / does not) encrypt source code.






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






14. Types: One of the 4 PL/SQL things that have a data type (begins with 'c').






15. Dbms_sql: The return type DBMS_SQL.open_cursor.






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






17. Command used to execute dynamic SQL.






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






19. Exceptions: Start of the range of error codes for RAISE_APPLICATION_ERROR.






20. Cursors: Opening keyword of a cursor FETCH loop.






21. Cursors: Give the statement for getting out of a FETCH loop for cursor CV.






22. A CASE expression ends with _____.






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






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






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






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






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






28. Nested tables can become sparse via ______.






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






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






31. How many times are a FOR loop's index bounds evaluated?






32. Delimiters: The component indicator/selector.






33. I/O: The most basic PL/SQL way to give output to the user.






34. Types: The PL/SQL type that is identical to PLS_INTEGER.






35. Triggers: When using the NEW or OLD pseudo-records in the body of the trigger - they must be prefixed with a _______.






36. The DECLARE keyword is only required in an _______ _______.






37. Delimiters: The assignment operator.






38. Advantage: Performance: Stored subprograms are ______ in memory.






39. In a collection - the internal components always have the _____ data type.






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






41. I/O: This package sends text output to SQLPlus






42. Associative arrays (do / do not) have to be initialized with a constructor.






43. Exceptions: The package that defines pre-defined exceptions.






44. DynSQL: The clause that receives single-row query output from EXECUTE IMMEDIATE.






45. Define a record type REC with number num and varchar2(10) name.






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






47. Exceptions: If there is no handler for an exception - PL/SQL returns an ________ exception error to the invoker or host environment.






48. Cursors: The two keywords in a mere cursor declaration (one is optional).






49. Data dictionary view that shows the compiler settings for each compiled object.






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