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. 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


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






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






4. The best candidates for result-caching are functions that are invoked frequently but depend on __________________ or never.






5. A GOTO cannot branch into an...






6. If none of a CASE expression's conditions are TRUE - it returns _____.






7. CREATE TYPE cannot be used for _______ array types.






8. With static typing - type checking is done at ______ time.






9. Conversion: Just about everything will implicitly convert to _____ or _________.






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






11. Advantage: Performance: PL/SQL automatically creates ______ variables for variables in WHERE and VALUES clauses.






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






13. Delimiters: Item separator.






14. In the IF syntax - is if ENDIF or END IF?






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






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






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






18. A FOR-loop counter is defined only within the _____.






19. What word is in a function header but not in a procedure header?






20. Triggers: In a per-row trigger - the ____ record shows you the original state of an affected row.






21. Cursors: The type definition of a WEAK ref cursor type has no _______ clause.






22. The _____ and ____ _____ collection types can be used in database table columns.






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






24. Exceptions: The maximum length of an Oracle error message is ____ characters






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






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






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






28. A subprogram created inside a block is a _________ subprogram.






29. Value of a character literal with zero characters.






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






31. An editioning view is like an ____ for a table.






32. Exceptions: Associate exception E with error code -1.






33. In the special IF syntax - is it ELSIF - or ELSEIF?






34. INSTEAD OF triggers are alternatives to ___ triggers






35. Give the statement to make a program autonomous.






36. From a block nested inside a procedure P - reference variable V of the outer procedure.






37. With an sparse - integer-indexed associative array - you (can / cannot) use a regular FOR loop.






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






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






40. PL/SQL lets you define two kinds of composite data types: _______ and _______






41. Cursors: Give the first 3 words to open a cursor variable called cv.






42. DynSQL: EXECUTE IMMEDIATE can be used for any SQL statement or PL/SQL block - except for ________ queries.






43. An incomplete type is a type created by a ______ type definition.






44. A nested table has to be initialized using a ________ - named the same as the type.






45. Dbms_sql: The DBMS_SQL procedure that closes a cursor.






46. The FORALL statement to loop over a collection MyList using index i.






47. Command to create a procedure.






48. Cursors: The statement where you pass the parameters to a cursor.






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






50. Dbms_sql: The return type DBMS_SQL.open_cursor.