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. Dbms_sql: This DBMS_SQL function opens a new cursor.






2. Exceptions: User-defined exceptions must have _______.






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






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






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






6. Searchable CASE statement: Each WHEN has its own _______ condition.






7. The variable showing the user id that is automatically prepended to object names.






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






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






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






11. Package for getting the postprocessed source of a program.






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






13. Which two of these built-in SQL functions can be used in procedural (PL/SQL) statements: DECODE - CORR - UPPER - SUM - COALESCE - DEREF.






14. Cursors: The statement where you pass the parameters to a cursor.






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






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






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






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






19. The four keywords that define a PL/SQL block.






20. Characters that end a multi-line comment.






21. I/O: This package does email.






22. I/O: This package lets PL/SQL programs read and write OS files.






23. The lowest index of a VARRAY is ___.






24. Triggers: There are __ types of triggers.






25. Fundamental: What is the exponentiation operator?






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






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






28. The command used to populate PLSQL_CCFLAGS.






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






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






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






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






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






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






35. Cursors: The value of SQL%ISOPEN is always ______.






36. SIMPLE_INTEGER is like PLS_INTEGER - but it does not allow ____ values - and it does not raise overflow exceptions.






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






38. The statement that is used to execute most (native) dynamic SQL.






39. The best candidates for result-caching are functions that are invoked frequently but depend on __________________ or never.






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






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






42. With static typing - type checking is done at ______ time.






43. IDs: Predefined identifiers are declared in this package.






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






45. The SET TRANSACTION statement affects only the ____________.






46. Assignment of PLSQL_CCFLAGS (cannot / can) be included in ALTER PROCEDURE ... COMPILE ...






47. The method to add one or more elements to a nested table or VARRAY is ______.






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






49. For a collection - the NEXT method returns ____ when there is no next index value.






50. Java - C or other program called directly in PL/SQL.