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 two kinds of CASE statements are simple and ________.






2. The EXCEPTION section is (optional/mandatory).






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






4. The command used to populate PLSQL_CCFLAGS.






5. Assignment of PLSQL_CCFLAGS (cannot / can) be included in ALTER PROCEDURE ... COMPILE ...






6. In interpreted mode - PL/SQL code is run in a _______ _______.






7. What are the 3 values of the BOOLEAN data type?






8. Setting CURRENT_SCHEMA only changes what is prepended to __________ references.






9. Exceptions: When an exception is raised inside a cursor FOR loop - the cursor is _______ implicitly.






10. Exceptions: A GOTO statement CAN branch from an exception handler into an ________ block.






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






12. PL/SQL is a ________ typed programming language.






13. An incomplete type only has a ____.






14. Types of blocks: A pl/sql block that is not stored in the database.






15. In a collection - the internal components are called _______.






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






17. I/O: The most basic PL/SQL way to give output to the user.






18. I/O: SQLPlus command for turning on buffered output.






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






20. PL/SQL lets you define two kinds of composite data types: _______ and _______






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






22. The variable showing the user id of the session owner.






23. IDs: The 3 non-alphanumeric characters that can be in an ordinary user-defined identifier.






24. A CASE expression ends with _____.






25. The AUTHID property applies to PL/SQL objects that contain _____.






26. In a record - the internal components are called ______.






27. The 2 characters that begin all inquiry directives.






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






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






30. When an autonomous routine begins execution - the main transaction is ________.






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






32. Loops: What is the index range operator in a FOR loop?






33. An INSTEAD OF trigger specifies what to do instead of a ___ statement.






34. The method to add one or more elements to a nested table or VARRAY is ______.






35. _______ arrays can be sparse or dense - depending on how you fill them.






36. Cursors: The second keyword of a FETCH statement.






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






38. Declare an associative array type - t - whose elements are of type rPerson - and whose index is PLS_INTEGER.






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






40. Web: mod_plsql is an implementation of the PL/SQL _________.






41. A FOR-loop counter is defined only within the _____.






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






43. Cursors: Give the statement to fetch data from cursor C into variable V.






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






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






46. The NOCOPY option on an OUT or IN OUT parameter - causes it to be passed by ______.






47. The BEGIN section is (optional/mandatory)






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






49. What is the simplest statement for conditionally getting out of simple loop?






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