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. Cursors: If an exception is raised inside a cursor loop - the cursor (is / is not) also closed automatically.






2. I/O: This package lets PL/SQL programs read and write OS files.






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






4. To create a collection type - use the TYPE command in PL/SQL and the ______ _____ command in SQL.






5. Type: A __________ subtype has only a subset of the values of its base type.






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






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






8. Cursors: Give the statement to close cursor C.






9. The PL/SQL ________ evaluates compiler directives.






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






11. Triggers: An INSTEAD OF trigger is (always/never) a row-level trigger.






12. Cursors: Give the statement to fetch data from cursor C into variable V.






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






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






15. A __________ can have an AUTHID property






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






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






18. Advantage: Performance: Stored subprograms are ______ in memory.






19. Conditional ______ allows backward compability with older database versions.






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






21. Triggers: On a non-editioning view - you can only define __________ triggers.






22. Abbreviation for Abstract Data Type.






23. Define a collection type - tV - which is a varray of 100 NUMBERs.






24. You cannot bulk collect into an ARRAY OF RECORDS. You can into a ________________ (3 words).






25. Wrapping can be done with the ____ executable.






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






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






28. I/O: Max number of bytes DBMS_OUTPUT can handle in a session.






29. What are the starting and ending keywords of a simple loop?






30. Loops: What is the index range operator in a FOR loop?






31. Language that PL/SQL is derived from.






32. Triggers: INSTEAD OF triggers only run on ______ views.






33. Delimiters: the attribute indicator.






34. Command to create a procedure.






35. DynSQL: In EXECUTE IMMEDIATE - the statement string can use either placeholders - or string ________.






36. Exceptions: An unhandled exception ________ to the enclosing block.






37. Dbms_sql: DBMS_SQL package is compiled with _______ rights.

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


38. GOTO branches to a ________.






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






40. Delimiters: The association operator.






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






42. I/O: This package has hypertext functions that generate HTML tags






43. Give the value list in the PLSQL_WARNINGS parameter to turn on SEVERE compiler warnings and make compiler warning 06002 be an error.

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


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






45. Value of PLSQL_OPTIMIZE_LEVEL that prevents optimization.






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






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






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






49. An INSTEAD OF trigger specifies what to do instead of a ___ statement.






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