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. Exceptions: An unhandled exception ________ to the enclosing block.






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






3. An INSTEAD OF trigger is used - e.g - when you want to insert into a complex _____.






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






5. What do you FETCH from?






6. Set flag bb true: ALTER SESSION SET PLSQL_CCFLAGS= '____'






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






8. Clause added to a cursor to use it with WHERE CURRENT OF.






9. Type: A __________ subtype has only a subset of the values of its base type.






10. Kind of datatypes that support object-oriented programming in PL/SQL.






11. Triggers: INSTEAD OF triggers only run on ______ views.






12. Exceptions: Declare an exception called E.






13. Delimiters: Statement terminator.






14. Which collection type is bounded?






15. Exceptions: A GOTO statement cannot branch into an _______ ________.






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






17. 5 types of events that can have triggers: DML - DDL - INSTEAD OFs - database events - and ________ statements.






18. To use a TYPE declared in the database - a PL/SQL block has to have _______ privilege on the type.






19. Cursors: The SQL%FOUND attribute has how many possible values?






20. The FOR UPDATE OF clause references a (table / column).






21. If an initialized collection has no elements - FIRST and LAST return _____.






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






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






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






25. Triggers: Unlike a stored procedure - you can enable and _____ a trigger.






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






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






28. Cursors: Closing keywords of a cursor FETCH loop.






29. The BEGIN section is (optional/mandatory)






30. Cursors: Give the statement for getting out of a FETCH loop for cursor CV.






31. I/O: Max number of bytes DBMS_OUTPUT can handle in a session.






32. Associative array types (can / cannot) be defined in the database.






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


34. The names of Java objects in Oracle can be up to __ characters in length.






35. A national character literal is composed of characters in the ________ character set.






36. Exceptions: The ________ function returns the current error code.






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






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






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






40. When a session starts - CURRENT_SCHEMA has the value of the schema owned by ___________.






41. Cursors: The first two keywords of a basic fetch statement.






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






43. You (can / cannot) wrap trigger source code.






44. IDs: The type of words that cannot be user-defined identifiers.






45. The source for wrapping begins with the word ______.






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






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






48. Triggers: When using the NEW or OLD pseudo-records in the body of the trigger - they must be prefixed with a _______.






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






50. A GOTO statement cannot branch from an exception handler back into the...