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. Conversion: Implicit conversion is not always predictable; it is _______-sensitive. And its rules might change.






2. Exceptions: The built-in procedure for raising an application-defined error.






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






4. _____ arrays cannot be used as the type of an Oracle table column.






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






6. A (simple / searched) CASE statement begins with CASE WHEN <boolean expression>.






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






8. Cursors: An explicit cursor (can/cannot) accept parameters.






9. TCL: Undo changes back to savepoint ab.






10. Characters that end a multi-line comment.






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






12. When a parameter is passed by reference - changes made to it inside the procedure cannot be undone. True/False.






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






14. Types: In addition to the SQL data types - PL/SQL has ___ more scalar data types.






15. Exceptions: The ________ function returns the current error code.






16. Delimiters: The assignment operator.






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






18. Define a collection type - tA - which is an associative array of NUMBERS - indexed with varchar2(20) values.






19. Cursors: The Oracle predefined REF CURSOR type.






20. A ___________ behaves like a table column - but it is not stored in the table.






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


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






23. _________ exceptions can not be trapped with an error handler






24. Declare a package procedure P with no arguments - and give it definer's rights.






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






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






27. Types: PL/SQL has all the _____ data types.






28. Triggers: An INSTEAD OF trigger (can/cannot) be conditional.






29. Delimiters: Single-line comment marker.






30. If a procedure fails - an OUT parameter passed to it by value (will / will not) be passed back with changes.






31. The DECLARE keyword is only required in an _______ _______.






32. Where an external subprogram is stored.






33. Cursors: You cannot use cursor attributes in _______ statements.






34. ______ SQL is a PL/SQL feature that allows SQL syntax directly in a PL/SQL statement.






35. Fundamental: Which one of these is a compound symbol: = - :=






36. DynSQL: The colon-prefixed names used in EXECUTE IMMEDIATE are called ________.






37. Clause added to a cursor to use it with WHERE CURRENT OF.






38. The BETWEEN operator is (inclusive / exclusive).






39. Cursors: The values plugged into the DML in a FORALL must come from existing - populated _________.






40. Searchable CASE statement: Each WHEN has its own _______ condition.






41. An incomplete type only has a ____.






42. Cursors: If no SELECT or DML statement has run - the value of SQL%ROWCOUNT is what?






43. Types: The only Oracle datetime type that doesn't begin with TIMESTAMP is ________.






44. Delimiters: Item separator.






45. For a collection - the NEXT method gets the next higher (element / index).






46. Labels for blocks and statements are enclosed in '__' brackets.






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






48. The lowest index of a nested table is ___.






49. Types: A ______ has the same valid operations as its base type.






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