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. Characters that end a multi-line comment.






2. Exceptions: The ________ function returns the error message associated with an error code.






3. The first SQL statement in an autonomous routine begins a _______.






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






5. A PL/SQL block that is not stored.






6. Mode designation for an input/output parameter.






7. Cursors: The Oracle predefined REF CURSOR type.






8. The PL/SQL ________ evaluates compiler directives.






9. IDs: The 3 non-alphanumeric characters that can be in an ordinary user-defined identifier.






10. IDs: The two types of words that can - but should not - be used as user-defined identifiers.






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






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






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






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






15. I/O: The buffered output of dbms_output.put_line is retrieved by _______.






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






17. Delimiters: Item separator.






18. A type of compiler directive - begins with 'i'.






19. I/O: The DBMS_OUTPUT function that writes output WITH a newline character.






20. Triggers: There are __ types of triggers.






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






22. Setting CURRENT_SCHEMA only changes what is prepended to __________ references.






23. The Wrap utility ________ the source code.






24. Fundamental: identifiers (include/do not include) reserved words.






25. Are good for logging table DML operations.






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






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






28. Internally - the NUMBER type is stored as ______. Therefore - decimal numbers (such as prices) are stored exactly - with no rounding.






29. IDs: What a quoted user-defined identifier is enclosed in.






30. To use a TYPE declared in the database - a PL/SQL block has to have _______ privilege on the type.






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






32. Web: mod_plsql is an implementation of the PL/SQL _________.






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






34. A GOTO statement can branch from an exception handler into...






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






36. Exceptions: The maximum length of an Oracle error message is ____ characters






37. Data dictionary view giving the AUTHID values on a user's objects.






38. Exceptions: Pragma that links an exception to an Oracle error code.






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






40. Cursors: Which cursor attribute is not meaningful for an implicit cursor?






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






42. With a result-cached function - it uses a cached value when the function is called again with the...






43. Cursors: Closing keywords of a cursor FETCH loop.






44. Cursors: Give the statement to fetch data from cursor variable CV into MyVar.






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






46. Exceptions: An exception in the declarations section does not go to the __________ section.






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






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






49. Fundamental: What is the range operator?






50. What do you FETCH from?







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