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. To enable result-caching for a function - use the _____________ clause.






2. Exceptions: Some internal exceptions have ________ names.






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






4. PL/SQL does not automatically create bind variables in ________ SQL.






5. Bytecode is _______ _______ code.






6. Delimiters: the attribute indicator.






7. DynSQL: Maximum string length to pass to EXECUTE IMMEDIATE.






8. Fundamental: One of the 4 types of lexical units: c_____.






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






10. Cursors: WHERE _______ ______ makes an UPDATE or DELETE apply to the current row of a cursor.






11. VARRAYs are (always / never) sparse.






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






13. The two kinds of CASE statements are simple and ________.






14. Cursors: How many DML statements can a FORALL statement contain?






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






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






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






18. A unit with AUTHID = CURRENT_USER is an ________ rights unit.

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


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






20. Language that PL/SQL is derived from.






21. The command used to populate PLSQL_CCFLAGS.






22. A GOTO statement can branch from an exception handler into...






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






24. Wrap iname=xxxx _____=zzzzz






25. A (simple / searched) CASE statement begins with CASE <expression>.






26. Fundamental: identifiers (include/do not include) reserved words.






27. PLSQL_CCFLAGS hold a comma-separated list of ______ pairs (hyphenated).






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






29. The values defined in PLSQL_CCFLAGS can be referenced as _____ directives.






30. Cursors: The four cursor attributes - in alphabetical order.






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






32. Cursors: A cursor variable's type must be a ____ ______ type.






33. Bulk: The keywords of a bulk collect FETCH statement.






34. Fundamental: Which one of these is a simple symbol: a - = - !=






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






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






37. A value that is neither represented by an identifier nor calculated from other values.






38. Cursors: A cursor that lives in session memory until the session ends.






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






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






41. Delimiters: The component indicator/selector.






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






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






44. Command to delete a procedure.






45. You have to use _______ SQL to run DDL statements n PL/SQL.






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






47. This is a CASE (expression / statement): CASE num WHEN 1 THEN goto LABEL1 WHEN 2 THEN var := 2 END CASE;






48. The three sorts of date/time types are DATE - INTERVAL and _________.






49. Delimiters: The association operator.






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