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. Types: In addition to the SQL data types - PL/SQL has ___ more scalar data types.






2. Dbms_sql: The integer returned by OPEN_CURSOR is a _____ _____.






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






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






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






6. Kind of datatypes that support object-oriented programming in PL/SQL.






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


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






9. Cursors: What is the 'name' of the implicit cursor?






10. Fundamental: Which one of these is a compound symbol: = - :=






11. Conditional ______ allows backward compability with older database versions.






12. Exceptions: The ________ function returns the error message associated with an error code.






13. The variable showing the user id that is automatically prepended to object names.






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






15. Triggers: If two or more triggers are defined with the same timing point - then you can control the firing order using the ________ clause.






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






17. The BEGIN section is (optional/mandatory)






18. Value of a character literal with zero characters.






19. The RESULT_CACHE clause comes (before / after) the RETURN clause.






20. Characters that end a multi-line comment.






21. Delimiters: The component indicator/selector.






22. Cursors: A cursor FOR loop can use an explicit or an _______ cursor.






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






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






25. The command used to populate PLSQL_CCFLAGS.






26. The collection method that tells the number of elements in the collection.






27. Triggers: You create a trigger with the _______ ________ statement.






28. The declaration section is (optional/mandatory).






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






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






31. DBMS_DDL.WRAP returns a string containing wrapped _____ _____.






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






33. Cursors: If no SELECT or DML statement has run - the value of SQL%ROWCOUNT is what?






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






35. Kind of comment not to put in a PL/SQL block to be processed dynamically by an Oracle Precompiler program.






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






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






38. SIMPLE_INTEGER is like PLS_INTEGER - but it does not allow ____ values - and it does not raise overflow exceptions.






39. IDs: The type of words that cannot be user-defined identifiers.






40. I/O: This package lets two or more sessions in the same instance communicate.






41. What are the two sequence pseudo-columns?






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






43. Advantage: Performance: Stored subprograms are ______ in memory.






44. A basic PL/SQL datatype that SQL does not have.






45. For a collection - the NEXT method returns ____ when there is no next index value.






46. When a session starts - CURRENT_SCHEMA has the value of the schema owned by ___________.






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






48. Exceptions: The maximum length of an Oracle error message is ____ characters






49. A PL/SQL block that is not stored.






50. Types: Which type of arithmetic does NUMBER use - library or hardware?