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. SIMPLE_INTEGER is like PLS_INTEGER - but it does not allow ____ values - and it does not raise overflow exceptions.






2. Where an external subprogram is stored.






3. Cursors: Opening keyword of a cursor FETCH loop.






4. The compiler directive used to select which code to compile.






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






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






7. An incomplete type only has a ____.






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






9. Exceptions: Pragma that links an exception to an Oracle error code.






10. Triggers: When using the NEW or OLD pseudo-records in the body of the trigger - they must be prefixed with a _______.






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






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






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






14. Web: PL/SQL _____ _______ lets you to develop Web applications made of PL/SQL procedures.






15. Triggers: A compound trigger can fire at more than one ______ point.






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






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






18. Delimiters: The left label delimiter.






19. Delimiters: The association operator.






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






21. Declare an input/output NUMBER parameter - v3.






22. The three types of compiler warnings.






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






24. Triggers: The clause to make a trigger run before inserting or updating table EMPS.






25. Dbms_sql: The return type DBMS_SQL.open_cursor.






26. The two main parts of a package are the ____ and the _____.






27. How many types of compiler directives are there?






28. Packaged constants can synchronize programs through use in _______ directives.






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






30. Cursors: Closing keywords of a cursor FETCH loop.






31. Type: An ________ subtype has all the values of its base type.






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






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






34. DynSQL: EXECUTE IMMEDIATE does both dynamic SQL and dynamic _______.






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






36. I/O: One of the 3 types of data stored in the DBMS_OUTPUT buffer.






37. Triggers: The clause to make a trigger run once for every affected row.






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






39. Advantage: PL/SQL runs anywhere Oracle runs - so it is very ________.






40. Types: Which type of arithmetic does PLS_INTEGER use - library or hardware?






41. Are good for logging table DML operations.






42. Command to create a procedure.






43. The _______ package lets you wrap dynamically generated PL/SQL.






44. Bulk: The use of FORALL statements cuts down on ______ traffic.






45. Delimiters: Single-line comment marker.






46. IDs: Maximum number of bytes in a user-defined identifier.






47. GOTO branches to a ________.






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






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






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