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. A large OUT or IN OUT parameter will waste a lot of space and CPU if it is passed by _____.






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






3. This is a CASE (expression / statement): myvar := CASE num WHEN 1 THEN 'good' WHEN 2 THEN 'bad' END;






4. Types: The only Oracle datetime type that doesn't begin with TIMESTAMP is ________.






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






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






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






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






9. A unit with AUTHID = CURRENT_USER is an ________ rights unit.


10. An $ERROR directive ends with _____.






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






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






13. A national character literal is composed of characters in the ________ character set.






14. With dynamic typing - type checking is done at ______time.






15. The BETWEEN operator is (inclusive / exclusive).






16. A (simple / searched) CASE statement begins with CASE <expression>.






17. The EXTEND method is not used with ______ _______.






18. Command used to execute dynamic SQL.






19. Which two of these built-in SQL functions can be used in procedural (PL/SQL) statements: DECODE - CORR - UPPER - SUM - COALESCE - DEREF.






20. Cursors: The SQL%FOUND attribute has how many possible values?






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






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






23. Exceptions: Some internal exceptions have ________ names.






24. A type of compiler directive - begins with 's'.






25. Cursors: You give an explicit cursor a name and associate it with a _______.






26. A GOTO statement cannot branch from an exception handler back into the...






27. Data dictionary view giving the AUTHID values on a user's objects.






28. Bulk: The implicit cursor attribute that gives the number of rows affected by each DML statement in a FORALL statement.






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






30. The _______ package lets you wrap dynamically generated PL/SQL.






31. Exceptions: An unhandled exception ________ to the enclosing block.






32. In short-circuit evaluation - IF-conditions are only evaluated up to where the outcome ___________.






33. Cursors: The SQL%BULK_ROWCOUNT attribute is an _________ -






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






35. Cursors: The type definition of a WEAK ref cursor type has no _______ clause.






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






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






38. Cursors: WHERE _______ ______ makes an UPDATE or DELETE apply to the current row of a cursor.






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






40. To exit an active autonomous transaction without causing an exception - you must issue _____ or ______.






41. In Native Mode - PL/SQL code is compiled into ______ ______.






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






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






44. Native compilation turns bytecode into ________ code.






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






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






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






48. %ROWTYPE gets the type of a table or _______.






49. Triggers: The code in a trigger is actually an ________ block.






50. The SET TRANSACTION statement affects only the ____________.