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. Triggers: Programmers (as opposed to DBAs) mostly make use of _____ triggers.






2. Bulk: The keywords of a bulk collect FETCH statement.






3. NAN stands for _________.






4. The meaning of 'FGA'.






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






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






7. An anonymous block is a(n) ____ statement.






8. The _______ package lets you wrap dynamically generated PL/SQL.






9. Records are one of the two kinds of PL/SQL _______ data types.






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






11. Declare an associative array type - t - whose elements are of type rPerson - and whose index is PLS_INTEGER.






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






13. TCL: Undo changes back to savepoint ab.






14. For an associative array - the FIRST method gets the (lowest / first-created) index.






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






16. The BEGIN section is (optional/mandatory)






17. Triggers: If two or more triggers are defined with the same timing point - then you can control the firing order using the ________ clause.






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






19. How many types of compiler directives are there?






20. Types: A data type family consists of a ______ type and its subtypes.






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






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






23. Dbms_sql: This DBMS_SQL function opens a new cursor.






24. The command used to populate PLSQL_CCFLAGS.






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






26. Triggers: The clause to make a trigger run once for every affected row.






27. In interpreted mode - the PL/SQL VM interprets the _________.






28. IDs: How an ordinary user-defined identifier must begin.






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






30. An autonomous program runs in its own __________.






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


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






33. Triggers: There are __ types of triggers.






34. The NOCOPY option on an OUT or IN OUT parameter - causes it to be passed by ______.






35. Cursors: The type definition of a WEAK ref cursor type has no _______ clause.






36. Bulk: The two features that comprise Bulk SQL are:






37. Cursors: What is the 'name' of the implicit cursor?






38. Fundamental: What is the range operator?






39. Types: The storage size of a NUMBER value is based on the number of ______ digits.






40. A subprogram defined within another subprogram is a _______ subprogram.






41. After the RESULT_CACHE clause - you can put a _________ clause to enable dependency-checking.






42. I/O: SQLPlus command for turning on buffered output.






43. Wrap iname=xxxx _____=zzzzz






44. Fundamental: A label can only go directly before an _______ statement.






45. Bulk: The use of FORALL statements cuts down on ______ traffic.






46. DynSQL: The clause that receives single-row query output from EXECUTE IMMEDIATE.






47. In PL/SQL - what the variables in DML statements are turned into.






48. Advantage: Performance: Stored subprograms are ______ in memory.






49. To create a collection type - use the TYPE command in PL/SQL and the ______ _____ command in SQL.






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