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. In a cursor loop - the clause added to an INSERT or UPDATE to point at the current record.






2. You can have many autonomous transactions in ___________.






3. What are two categories of SQL functions that cannot be used in procedural statements?






4. The allowed data types of user-defined conditional compilation directives are boolean and _______.






5. Term for a character literal with zero characters.






6. The compiler directive used to select which code to compile.






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






8. Conditional compilation is useful for compiling a program under different ______ of Oracle.






9. VARRAYs are (always / never) sparse.






10. Web: Abbreviation of PL/SQL Server Page.






11. Triggers: On a non-editioning view - you can only define __________ triggers.






12. Cursors: The four cursor attributes - in alphabetical order.






13. Declare a package procedure P with no arguments - and give it definer's rights.






14. Advantage: PL/SQL programs are stored centrally - making them more ______.






15. Bulk: The implicit cursor attribute that gives the number of rows affected by each DML statement in a FORALL statement.






16. Give the ANSI Date literal for December 25 - 2005.

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


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






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






19. Cursors: If an exception is raised inside a cursor loop - the cursor (is / is not) also closed automatically.






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






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






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






23. Types: ________ data types have no internal components.






24. The SET TRANSACTION statement affects only the ____________.






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






26. Cursors: Give the statement to close cursor C.






27. A unit with AUTHID = CURRENT_USER is an ________ rights unit.

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


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






29. In short-circuit evaluation - IF-conditions are only evaluated up to where the outcome ___________.






30. A GOTO cannot branch into a...






31. TCL: Create a savepoint called ab






32. A FOR-loop counter is defined only within the _____.






33. Triggers: A compound trigger can fire at more than one ______ point.






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






35. The variable showing the user id of the session owner.






36. Web: PL/SQL _______ enables a Web browser to invoke a PL/SQL stored subprogram through an HTTP listener.






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


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






39. Default file extension of wrap's input file.






40. The $ERROR directive is used to make compilation ____.






41. In the IF syntax - is if ENDIF or END IF?






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






43. Parameter that controls how much Oracle optimizes your PL/SQL code on compilation.






44. What do you FETCH from?






45. A pointer to a private SQL area that stores information about processing a specific SELECT or DML statement.






46. DynSQL: The three modes of arguments in the USING clause of EXECUTE IMMEDIATE.






47. With conditional compilation you can avoid compiling debug code in the _______ environment.






48. The three sorts of date/time types are DATE - INTERVAL and _________.






49. Which collection type is bounded?






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