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. IDs: The type of words that cannot be user-defined identifiers.






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






3. Exceptions: The package that defines pre-defined exceptions.






4. Types: The PL/SQL type that is identical to PLS_INTEGER.






5. The valid values of the AUTHID property.






6. Mode designation for an output parameter.






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






8. Conversion: It is best to use (implicit / explicit) conversion.






9. Native compilation turns bytecode into ________ code.






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






11. Delimiters: Single-line comment marker.






12. A record is a group of related data items stored in fields - each with its own...






13. Fundamental: One of the 4 types of lexical units: i_____






14. A GOTO statement can branch from an exception handler into...






15. Where an external subprogram is stored.






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






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






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






19. A CASE expression ends with _____.






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






21. You can define PL/SQL collections using TYPEs defined in the _______.






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






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






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






25. An editioning view can only select a subset of the columns from the base table and provide ________ for them






26. For an associative array - the FIRST method gets the (lowest / first-created) index.






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






28. An incomplete type only has a ____.






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






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






31. FOR-Looping over a collection from FIRST to LAST only works if the collection is _______.






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






33. Exceptions: The keyword that begins an exception handler.






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






35. I/O: The DBMS_OUTPUT procedure that sets the size of the output buffer.






36. A GOTO cannot branch into an...






37. Cursors: A cursor with a name is an _________ cursor.






38. DynSQL: The three modes of arguments in the USING clause of EXECUTE IMMEDIATE.






39. Cursors: How many implicit cursors can you access?






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






41. A CASE statement ends with ____ ____.






42. I/O: If the current (outermost) PL/SQL block ends with an unhandled exception - the output buffer will not be ___________.






43. The Wrap utility (does / does not) encrypt source code.






44. Types: ________ data types have internal components.






45. Cursors: Give the first 3 words to open a cursor variable called cv.






46. A PL/SQL extension to the WHERE clause of the SQL statements UPDATE and DELETE






47. Bytecode is _______ _______ code.






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






49. I/O: The buffered output of dbms_output.put_line is retrieved by _______.






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