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. The source for wrapping begins with the word ______.






2. TCL: Create a savepoint called ab






3. Cursors: The FOR UPDATE phrase goes at the (beginning/end) of the cursor definition.






4. The PL/SQL virtual machine turns bytecode into system ______.






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






6. Exceptions: An exception in the declarations section propagates to the enclosing _______.






7. Delimiters: Single-line comment marker.






8. I/O: This package sends text output to SQLPlus






9. One good use of bind variables is to guard against SQL _______.






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






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






12. The attribute used to get the type of a row without knowing what it is.






13. Internally - the NUMBER type is stored as ______. Therefore - decimal numbers (such as prices) are stored exactly - with no rounding.






14. Exceptions: The _________ package defines the PL/SQL environment.






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






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






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






18. Dbms_sql: A cursor opened with OPEN_CURSOR (can/cannot) be reused for multiple queries without first closing it.






19. With an sparse - integer-indexed associative array - you (can / cannot) use a regular FOR loop.






20. A CASE expression ends with _____.






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






22. I/O: This DBMS_OUTPUT proc retrieves one line from the buffer.






23. From a block nested inside a procedure P - reference variable V of the outer procedure.






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






25. The best candidates for result-caching are functions that are invoked frequently but depend on __________________ or never.






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






27. In a collection - the internal components always have the _____ data type.






28. An autonomous program runs in its own __________.






29. Delimiters: the attribute indicator.






30. I/O: The string table type in DBMS_OUTPUT for holding lines of text.






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






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






33. 5 types of events that can have triggers: DML - DDL - INSTEAD OFs - database events - and ________ statements.






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






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






36. Kind of code created by the PL/SQL compiler.






37. With a result-cached function - it uses a cached value when the function is called again with the...






38. Exceptions: Each internal exception has an Oracle ______ _______.






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






40. A collection is an ordered group of ________ - all of the same ____






41. You can use the BULK COLLECT INTO clause in a SELECT or a ______.






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


43. To run a PIPE ROW statement in your autonomous routine - you must close any _____________.






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






45. The allowed data types of user-defined conditional compilation directives are boolean and _______.






46. Declare a variable r whose type is that of the records in table t.






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






48. Types: One of the scalar data types specific to PL/SQL: b_____.






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






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