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. Exceptions: Type ______ to re-raise the current exception.






2. The FORALL statement to loop over a collection MyList using index i.






3. The three types of compiler warnings.






4. Exceptions: An exception in the declarations section does not go to the __________ section.






5. Dbms_sql: The DBMS_SQL procedure that will execute a DDL or DML statement.






6. Cursors: A session cursor that a PL/SQL user creates and manages.






7. An incomplete type only has a ____.






8. Delimiters: The association operator.






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






10. Triggers: An INSTEAD OF trigger (can/cannot) be conditional.






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






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






13. Cursors: The two keywords in a mere cursor declaration (one is optional).






14. I/O: This package does email.






15. Characters that begin a multi-line comment.






16. Cursors: A cursor FOR loop cannot use a _______ variable.






17. With static typing - type checking is done at ______ time.






18. Cursors: You can just declare a cursor at first - then _______ it later.






19. Subprograms are stored in __________ form.






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






21. Types of blocks: Procedures and functions are _______ blocks.






22. Bulk: The two features that comprise Bulk SQL are:






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






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






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


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






27. Types: One of the scalar data types specific to PL/SQL: P________






28. Two types of stored subprograms.






29. Static typing is also called _____ typing.






30. Give the statement to make a program autonomous.






31. The attribute used to get the type of a row without knowing what it is.






32. I/O: This package lets PL/SQL programs read and write OS files.






33. Triggers: By default - a trigger is created in the ______ state.






34. DynSQL: The standard package that does dynamic SQL.






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






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






37. IDs: What a quoted user-defined identifier is enclosed in.






38. Characters that begin a single-line comment.






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






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






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






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






43. Assigning values to PL/SQL variables that appear in SQL statements is called _______.






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






45. Simple CASE statement checks for different values of a single _________






46. With conditional compilation you can avoid compiling debug code in the _______ environment.






47. VARRAYs are (always / never) sparse.






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






49. The 2 characters that begin all inquiry directives.






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







Sorry!:) No result found.

Can you answer 50 questions in 15 minutes?


Let me suggest you:



Major Subjects



Tests & Exams


AP
CLEP
DSST
GRE
SAT
GMAT

Most popular tests