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. Declare an input/output NUMBER parameter - v3.






2. A SELECT statement with the FOR UPDATE clause puts a ______ on the selected rows.






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






4. Command to assign to variables from a cursor.






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






6. The source for wrapping begins with the word ______.






7. Cursors: Give the statement to fetch data from cursor variable CV into MyVar.






8. The FIRST method gets the first (element / index) of a collection.






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






10. Types: One of the scalar data types specific to PL/SQL: P________






11. An anonymous block always has _________ rights.

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


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






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






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






15. Triggers: By default - a trigger is created in the ______ state.






16. I/O: To make sure the DBMS_OUTPUT buffer will be flushed - put a WHEN ______ clause in the EXCEPTION section of your outer block.






17. An autonomous program runs in its own __________.






18. Cursors: A session cursor that is automatically created and managed by PL/SQL.






19. Which two collection types are unbounded?






20. To use a TYPE declared in the database - a PL/SQL block has to have _______ privilege on the type.






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






22. The 4 keywords in the $IF compiler directive.






23. IDs: You can use a reserved word as a _______ user-defined identifier.






24. Types: The predefined subtype of PLS_INTEGER that has the NOT NULL constraint.






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






26. With conditional compilation you can avoid compiling debug code in the _______ environment.






27. Default file extension of wrap's input file.






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






29. An INSTEAD OF trigger is used - e.g - when you want to insert into a complex _____.






30. A user-defined TYPE can have...






31. Give the statement to make a program autonomous.






32. Cursors: Give the statement to open cursor C.






33. Exceptions: PL/SQL exceptions are of two types: internal and _________.






34. What do you FETCH from?






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






36. Cursors: The first two keywords of a basic fetch statement.






37. Where an external subprogram is stored.






38. Unlike the CASE statement - the CASE expression does not have the...






39. DBMS_DDL.CREATE_WRAPPED: wraps and _______ the source code passed to it.






40. Exceptions: The ________ handler must always be the last handler.






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






42. Triggers: In a DML trigger - the phrase that makes the trigger run for every affected record.






43. Data dictionary view giving the AUTHID values on a user's objects.






44. Advantage: Having procedures stored and executed on the server makes PL/SQL ________.






45. Delimiters: The left label delimiter.






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






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






48. (from inside a package) Declare a function f - that takes a number n - returns a number - and caches results - depending on table EMPS.






49. The inquiry directive that gives the current line number in the procedure.






50. The SET TRANSACTION statement affects only the ____________.