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. In the IF syntax - is if ENDIF or END IF?






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






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






4. IDs: What a quoted user-defined identifier is enclosed in.






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






6. Declare a cursor c with no parameters or return type.






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






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






9. Cursors: The index variable in a cursor FOR loop (does/does not) need to be declared.






10. Kind of comment not to put in a PL/SQL block to be processed dynamically by an Oracle Precompiler program.






11. Advantage: PL/SQL gives SCALABILITY because stored procedures are executed on the _______.






12. Abbreviation of invoker's rights






13. Exceptions: PL/SQL exceptions are of two types: internal and _________.






14. Types: The only PL/SQL type for which you can specify a range constraint.






15. Declare an output NUMBER parameter - v1 - that defaults to 10.






16. Fundamental: Character used to escape a single quote inside a literal.

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


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






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






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






20. An incomplete type only has a ____.






21. Cursors: The two keywords in a mere cursor declaration (one is optional).






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






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






24. Fundamental: One of the 4 types of lexical units: L_____






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






26. Statement to exit a cursor loop on cursor cGo when there are no more records.






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

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


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






29. The first SQL statement in an autonomous routine begins a _______.






30. Characters that begin a multi-line comment.






31. Wrap ______=xxxx oname=zzzzz






32. Types of blocks: Procedures and functions are _______ blocks.






33. Command to create a procedure.






34. Collections are one of the two kinds of PL/SQL _______ data types.






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






36. The SET TRANSACTION statement affects only the ____________.






37. Conversion: Implicit conversion can be (faster / slower) than explicit conversion.






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






39. Triggers: The clause to make a trigger run after inserting into table EMPS.






40. In 11g you can directly reference _____________ in PL/SQL.






41. To run TCL or DDL statements - a trigger (must / must not) be autonomous .






42. Cursors: A cursor FOR loop cannot use a _______ variable.






43. User-defined compiler directives are defined in this system compile parameter.






44. Command to assign to variables from a cursor.






45. Types: The predefined subtype of PLS_INTEGER that has the NOT NULL constraint.






46. Web: mod_plsql is an implementation of the PL/SQL _________.






47. I/O: This DBMS_OUTPUT proc retrieves one line from the buffer.






48. Give the clause you add to a CREATE TABLE statement - when there is a collection column myColl - that you want to be stored in a table called myCollTab.






49. True encryption is done with package __________.






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