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. An autonomous program runs in its own __________.






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


3. Cursors: If an exception is raised inside a cursor loop - the cursor (is / is not) also closed automatically.






4. Exceptions: User-defined exceptions must have _______.






5. Command to delete a procedure.






6. A ___________ behaves like a table column - but it is not stored in the table.






7. NAN stands for _________.






8. When a parameter is passed by reference - changes made to it inside the procedure cannot be undone. True/False.






9. Exceptions: The three words that can be used to guarantee all exceptions will be handled.






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






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






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






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






14. DynSQL: EXECUTE IMMEDIATE can be used for any SQL statement or PL/SQL block - except for ________ queries.






15. A kind of variable used as a placeholder.






16. The DECLARE keyword is only required in an _______ _______.






17. Name the two types of FOR loop.






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






19. If you are in a procedure inside a package - the compilation unit is the _______.






20. Exceptions: Declare an exception called E.






21. DynSQL: The three modes of arguments in the USING clause of EXECUTE IMMEDIATE.






22. IDs: Maximum number of bytes in a user-defined identifier.






23. The first SQL statement in an autonomous routine begins a _______.






24. Delimiters: Single-line comment marker.






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






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






27. The _____ and ____ _____ collection types can be used in database table columns.






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






29. Delimiters: The association operator.






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






31. An $ERROR directive ends with _____.






32. IDs: You cannot use reserved words as ______ user-defined identifiers.






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






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






35. An incomplete type only has a ____.






36. The values defined in PLSQL_CCFLAGS can be referenced as _____ directives.






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






38. _____ arrays cannot be used as the type of an Oracle table column.






39. The 2 characters that begin all inquiry directives.






40. Cursors: If you use an EXIT statement to exit a cursor FOR loop prematurely - the cursor (is / is not) closed automatically.






41. Cursors: What are the 3 possible values of SQL%FOUND and SQL%NOTFOUND?






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






43. Cursors: The FOR UPDATE phrase goes at the (beginning/end) of the cursor definition.






44. What is the exception that is implicitly raised in a CASE statement with no ELSE clause?






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






46. The BEGIN section is (optional/mandatory)






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






48. Exceptions: Some internal exceptions have ________ names.






49. I/O: Max number of bytes DBMS_OUTPUT can handle in a session.






50. After the RESULT_CACHE clause - you can put a _________ clause to enable dependency-checking.