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. The command used to populate PLSQL_CCFLAGS.






2. Static typing is also called _____ typing.






3. For a collection - the NEXT method gets the next higher (element / index).






4. The BEGIN section is (optional/mandatory)






5. Fundamental: One of the 4 types of lexical units: d_____






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






7. Type: An ________ subtype has all the values of its base type.






8. Kind of code created by the PL/SQL compiler.






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






10. TCL: Undo changes back to savepoint ab.






11. Command to create a procedure.






12. To exit an active autonomous transaction without causing an exception - you must issue _____ or ______.






13. IDs: Predefined identifiers are declared in this package.






14. Cursors: The second keyword of a FETCH statement.






15. A unit with AUTHID = DEFINER is a ________ rights unit.

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


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






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






18. ______ SQL is a PL/SQL feature that allows SQL syntax directly in a PL/SQL statement.






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






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






21. I/O: The output from DBMS_OUTPUT will display (during/after) program execution.






22. The Wrap utility ________ the source code.






23. The DEFINITION of a cursor is the _____ that returns the records.






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






25. Default file extension of wrap's output file.






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






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






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






29. Declare an unconstrained subtype of NUMBER called NUMB.






30. Conversion: It is best to use (implicit / explicit) conversion.






31. What is the exception that is implicitly raised in a CASE statement with no ELSE clause?






32. PLS_INTEGER has its arithmetic implemented in ________ - so it is very fast.






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






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






35. A null string and a BOOLEAN null are _______ (same/not the same).






36. Cursors: The value of SQL%ROWCOUNT after a SELECT INTO statement returns more than one row.






37. The EXTEND method is not used with ______ _______.






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






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






40. A result-cached function caches its results in the _____ _____ ____ (SGA)






41. The EXCEPTION section is (optional/mandatory).






42. Command to assign to variables from a cursor.






43. Cursors: The first two keywords in a Cursor FOR loop.






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






45. The three possible values of a BOOLEAN literal.






46. Exceptions: An unhandled exception ________ to the enclosing block.






47. Triggers: An INSTEAD OF trigger (can/cannot) be conditional.






48. An autonomous program runs in its own __________.






49. Define a collection type - tV - which is a varray of 100 NUMBERs.






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