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. Give the ANSI Date literal for December 25 - 2005.

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


2. The _____ utility turns PL/SQL source code into unreadable text.






3. Advantage: PL/SQL programs are stored centrally - making them more ______.






4. Which collection type is bounded?






5. Triggers: In a per-row trigger - the ____ record shows you the changed state of an affected row.






6. Give the clause you add to a CREATE TABLE statement - when there is a collection column myColl - that you want to be stored in a table called myCollTab.






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






8. Types: ________ data types have internal components.






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






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






11. Advantage: PL/SQL is PORTABLE to any OS where ________ runs.






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






13. Declare an unconstrained subtype of NUMBER called NUMB.






14. Triggers: INSTEAD OF triggers only run on ______ views.






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






16. Triggers: Unlike a stored procedure - you can enable and _____ a trigger.






17. The PL/SQL ________ evaluates compiler directives.






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






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






20. Give the first line of the FOR loop with index i going from 1 to 10 in reverse.






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






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






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






24. Cursors: Only a _____ _____ cursor can appear in the CURRENT OF clause of an UPDATE or DELETE statement.






25. The RESULT_CACHE clause has to be in both the declaration and in the ______ of the function.






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






27. Bulk: The keywords of a bulk collect FETCH statement.






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






29. Cursors: How many DML statements can a FORALL statement contain?






30. Fundamental: One of the 4 types of lexical units: d_____






31. Are good for logging table DML operations.






32. Cursors: An explicit cursor (can/cannot) accept parameters.






33. Delimiters: The component indicator/selector.






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






35. IDs: List the two types of user-defined identifiers.






36. To get the current value of CURRENT_SCHEMA - CURRENT_USER - or SESSION_USER - use the ____ function.






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






38. Triggers: When using the NEW or OLD pseudo-records in the body of the trigger - they must be prefixed with a _______.






39. An anonymous block is a(n) ____ statement.






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






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






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






43. Triggers: A compound trigger can fire at more than one ______ point.






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






45. I/O: One of the 3 types of data that can be passed to the DBMS_OUTPUT buffer.






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






47. An autonomous program runs in its own __________.






48. VARRAYs are (always / never) sparse.






49. By default - OUT and IN OUT parameters are passed by _____.






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