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. Cursors: A cursor FOR loop can use an explicit or an _______ cursor.






2. An ordinary character literal is composed of characters in the ________ character set.






3. Types: PL/SQL has all the _____ data types.






4. The four keywords that define a PL/SQL block.






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






6. The PL/SQL ________ evaluates compiler directives.






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






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






9. Static typing is also called _____ typing.






10. Characters that begin a single-line comment.






11. A type of compiler directive - begins with 'i'.






12. You can have many autonomous transactions in ___________.






13. TCL: Create a savepoint called ab






14. Command to assign to variables from a cursor.






15. A pointer to a private SQL area that stores information about processing a specific SELECT or DML statement.






16. A user-defined TYPE can have...






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






18. DynSQL: In EXECUTE IMMEDIATE - the statement string can use either placeholders - or string ________.






19. Web: The gateway that allows a web browser to invoke a PL/SQL procedure through an HTTP listener.






20. I/O: One of the 3 types of data stored in the DBMS_OUTPUT buffer.






21. Web: PL/SQL _____ _______ lets you to develop Web applications made of PL/SQL procedures.






22. A (simple / searched) CASE statement begins with CASE WHEN <boolean expression>.






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






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






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






26. You can put a label before any executable PL/SQL _________.






27. VARRAYs are (always / never) sparse.






28. Define a record variable r - of type tRec - initialized with values 9 and 'Jones' in its two fields.

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


29. A subprogram created inside a block is a _________ subprogram.






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






31. You (can / cannot) wrap trigger source code.






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






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






34. How many times are a FOR loop's index bounds evaluated?






35. Cursors: The statement that closes a cursor.






36. INSTEAD OF triggers are alternatives to ___ triggers






37. Exceptions: If there is no handler for an exception - PL/SQL returns an ________ exception error to the invoker or host environment.






38. Cursors: The statement where you pass the parameters to a cursor.






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






40. NAN stands for _________.






41. Conversion: Implicit conversion can be (faster / slower) than explicit conversion.






42. The DEFINITION of a cursor is the part after the keyword __.






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






44. You cannot bulk collect into an ARRAY OF ________.






45. Associative arrays (do / do not) have to be initialized with a constructor.






46. I/O: The DBMS_OUTPUT function that writes output without a newline character.






47. IDs: The two types of words that can - but should not - be used as user-defined identifiers.






48. Type: An ________ subtype has all the values of its base type.






49. Conversion: Just about everything will implicitly convert to _____ or _________.






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