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. I/O: dbms_output.put_line puts output into a _______.






2. Exceptions: The keyword that begins an exception handler.






3. Command to assign to variables from a cursor.






4. _______ arrays can be sparse or dense - depending on how you fill them.






5. Dbms_sql: The integer returned by OPEN_CURSOR is a _____ _____.






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






7. I/O: This DBMS_OUTPUT proc retrieves multiple lines from the buffer.






8. Cursors: If no SELECT or DML statement has run - the value of SQL%ROWCOUNT is what?






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






10. I/O: The string table type in DBMS_OUTPUT for holding lines of text.






11. Advantage: PL/SQL is PORTABLE to any OS where ________ runs.






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






13. In a cursor loop - the clause added to an INSERT or UPDATE to point at the current record.






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






15. The BEGIN section is (optional/mandatory)






16. Web: mod_plsql is an _______ module.






17. The lowest index of a nested table is ___.






18. Triggers and views always have _________ rights.

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


19. In a sparse collection - the indexes of defined elements (do / do not) run in consecutive order.






20. Cursors: Give the statement to open cursor C that takes parameter p.






21. A FOR loop can be indexed by numbers or by a ______.






22. DynSQL: The colon-prefixed names used in EXECUTE IMMEDIATE are called ________.






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






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






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






26. I/O: The DBMS_OUTPUT buffer will not be flushed until it is full or until the current PL/SQL block _________.






27. I/O: The DBMS_OUTPUT procedure that sets the size of the output buffer.






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






29. TCL: Undo changes back to savepoint ab.






30. A __________ can have an AUTHID property






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






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






33. This is a CASE (expression / statement): myvar := CASE num WHEN 1 THEN 'good' WHEN 2 THEN 'bad' END;






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






35. Exceptions: When an exception is raised inside a cursor FOR loop - the cursor is _______ implicitly.






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






37. DBMS_DDL.CREATE_WRAPPED: wraps and _______ the source code passed to it.






38. The PL/SQL ________ evaluates compiler directives.






39. Command to create a procedure.






40. In a collection - the internal components are called _______.






41. Exceptions: PL/SQL exceptions are of two types: internal and _________.






42. Exceptions: You cannot GOTO from an exception handler back into the __________ block.






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






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






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






46. What are the two sequence pseudo-columns?






47. You can define PL/SQL collections using TYPEs defined in the _______.






48. Cursors: A cursor variable's type must be a ____ ______ type.






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






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