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. Kind of datatypes that support object-oriented programming in PL/SQL.






2. The PL/SQL ________ evaluates compiler directives.






3. Types: A ______ has the same valid operations as its base type.






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






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






6. Exceptions: You can pass an ______ ________ to SQLERRM.






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






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






9. Exceptions: Associate exception E with error code -1.






10. Define a record variable r - of type tRec - initialized with values 9 and 'Jones' in its two fields.

Warning: Invalid argument supplied for foreach() in /var/www/html/basicversity.com/show_quiz.php on line 183


11. Fundamental: Which one of these is a simple symbol: a - = - !=






12. Keyword for doing assignment to a variable with SELECT.






13. Where an external subprogram is stored.






14. Types: The only Oracle datetime type that doesn't begin with TIMESTAMP is ________.






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






16. I/O: To make sure the DBMS_OUTPUT buffer will be flushed - put a WHEN ______ clause in the EXCEPTION section of your outer block.






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






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






19. Loops: What is the index range operator in a FOR loop?






20. How many types of compiler directives are there?






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






22. A __________ can have an AUTHID property






23. Triggers: Programmers (as opposed to DBAs) mostly make use of _____ triggers.






24. Delimiters: The assignment operator.






25. Types: One of the scalar data types specific to PL/SQL: B_______






26. From a block nested inside a procedure P - reference variable V of the outer procedure.






27. A value that is neither represented by an identifier nor calculated from other values.






28. The FORALL statement to loop over a collection MyList using index i.






29. IDs: You cannot use reserved words as ______ user-defined identifiers.






30. Declare a cursor c with no parameters - and return type rC.






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






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






33. Cursors: You can just declare a cursor at first - then _______ it later.






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






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






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






37. In interpreted mode - PL/SQL code is run in a _______ _______.






38. Statement to set current schema to x: _____ _____ SET CURRENT_SCHEMA = 'x';






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






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






41. Exceptions: The ________ handler must always be the last handler.






42. %ROWTYPE gets the type of a table or _______.






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






44. Fundamental: Character used to escape a single quote inside a literal.

Warning: Invalid argument supplied for foreach() in /var/www/html/basicversity.com/show_quiz.php on line 183


45. In a FORALL loop - you (can / cannot) use the index variable for purposes other than indexing into the collection.






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






47. Fundamental: What is the range operator?






48. A subprogram created inside a block is a _________ subprogram.






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






50. Exceptions: Declare an exception called E.