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. Fundamental: One of the 4 types of lexical units: L_____






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






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






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






5. An editioning view can only select a subset of the columns from the base table and provide ________ for them






6. To run DDL statements - a trigger must be autonomous and must use ______ ______ SQL.






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






8. FOR-Looping over a collection from FIRST to LAST only works if the collection is _______.






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






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






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






12. Web: The gateway that allows a web browser to invoke a PL/SQL procedure through an HTTP listener.






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






14. By default - an IN parameter is passed by ______.






15. Data dictionary view that shows the compiler settings for each compiled object.






16. Conversion: If the specific value is suitable - ____ or _______ values can convert to almost any datatype






17. Types: ________ data types have internal components.






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






19. Advantage: Caching of programs and sharing among users lowers _______ requirements.






20. Cursors: Give the statement to open cursor C.






21. You cannot bulk collect into an ARRAY OF ________.






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






23. Triggers: Programmers (as opposed to DBAs) mostly make use of _____ triggers.






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






25. Wrapping can be done with the ____ executable.






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






27. The 2 characters that begin all inquiry directives.






28. Java - C or other program called directly in PL/SQL.






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






30. Exceptions: Start of the range of error codes for RAISE_APPLICATION_ERROR.






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






32. Triggers: The code in a trigger is actually an ________ block.






33. A numeric FOR loop cannot _________ by other than 1?






34. A SELECT statement with the FOR UPDATE clause puts a ______ on the selected rows.






35. I/O: This package has hypertext procedures that generate HTML tags






36. The Wrap utility ________ the source code.






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






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






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






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






41. Associative arrays (do / do not) have to be initialized with a constructor.






42. Cursors: The value of SQL%ISOPEN is always ______.






43. Types: One of the scalar data types specific to PL/SQL: R_________.






44. Advantage: PL/SQL supports ______-oriented programming.






45. The $ERROR directive is used to make compilation ____.






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






47. To get the current value of CURRENT_SCHEMA - CURRENT_USER - or SESSION_USER - use the ____ function.






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






49. What are two categories of SQL functions that cannot be used in procedural statements?






50. The inquiry directive that gives the current line number in the procedure.