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. Declare an unconstrained subtype of NUMBER called NUMB.






2. The Wrap utility (does / does not) encrypt source code.






3. Delimiters: the attribute indicator.






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






5. How many times are a FOR loop's index bounds evaluated?






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






7. Package for getting the postprocessed source of a program.






8. Command to delete a procedure.






9. Exceptions: If there is no handler for an exception - PL/SQL returns an ________ exception error to the invoker or host environment.






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






11. Command to make a no-op (omit semicolon).






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






13. Types: One of the 4 PL/SQL things that have a data type (begins with 'v').






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






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






16. Cursors: The FOR UPDATE phrase goes at the (beginning/end) of the cursor definition.






17. The RESULT_CACHE clause comes (before / after) the RETURN clause.






18. I/O: dbms_output.put_line puts output into a _______.






19. When an autonomous routine begins execution - the main transaction is ________.






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






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






22. Wrap ______=xxxx oname=zzzzz






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






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






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






26. Fundamental: What is the exponentiation operator?






27. Cursors: Opening keyword of a cursor FETCH loop.






28. How to reference a variable V declared in a block labelled L: ____.






29. Two types of stored subprograms.






30. Which collection type is bounded?






31. Assignment of PLSQL_CCFLAGS (cannot / can) be included in ALTER PROCEDURE ... COMPILE ...






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






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






34. Triggers and views always have _________ rights.


35. Exceptions: Write the call (2 args) to associate message 'Bad' with error code -20 -100.


36. Cursors: What implicit cursor attribute gives row counts for a FORALL statement?






37. IDs: You cannot use reserved words as ______ user-defined identifiers.






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






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






40. I/O: This package sends text output to SQLPlus






41. Statement to set current schema to x: _____ _____ SET CURRENT_SCHEMA = 'x';






42. Exceptions: Type ______ to re-raise the current exception.






43. You (can/cannot) put a label before an END LOOP statement.






44. A collection is an ordered group of ________ - all of the same ____






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






46. What clause makes a compilation default to the PLSQL_CCFLAGS settings from the last compilation?






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






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






49. A basic PL/SQL datatype that SQL does not have.






50. Cursors: A pointer to a cursor is called a ______ _______.