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. The compiler directive governing conditional compilation.






2. Types: One of the scalar data types specific to PL/SQL: b_____.






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






4. A value that is neither represented by an identifier nor calculated from other values.






5. I/O: This package has hypertext functions that generate HTML tags






6. You can use the BULK COLLECT INTO clause in a SELECT or a ______.






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






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






9. IDs: How an ordinary user-defined identifier must begin.






10. Term for a character literal with zero characters.






11. Triggers: On a non-editioning view - you can only define __________ triggers.






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






13. A basic PL/SQL datatype that SQL does not have.






14. Types: One of the scalar data types specific to PL/SQL: B_______






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






16. Exceptions: Start of the range of error codes for RAISE_APPLICATION_ERROR.






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






18. A result-cached function caches its results in the _____ _____ ____ (SGA)






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






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






21. Triggers: You (can/cannot) explicitly invoke a trigger.






22. How to reference a variable V declared in a block labelled L: ____.






23. Conversion: Implicit conversion is not always predictable; it is _______-sensitive. And its rules might change.






24. A __________ can have an AUTHID property






25. Triggers: The clause to make a trigger run before inserting or updating table EMPS.






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






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






28. Subprograms are stored in __________ form.






29. Advantage: PL/SQL gives SCALABILITY because stored procedures are executed on the _______.






30. Declare an associative array type - t - whose elements are of type rPerson - and whose index is PLS_INTEGER.






31. A unit with AUTHID = DEFINER is a ________ rights unit.

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


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






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






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






35. Official acronym for PL/SQL's runtime engine.






36. Exceptions: The ________ function returns the current error code.






37. An incomplete type only has a ____.






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






39. Cursors: The statement that closes a cursor.






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






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






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






43. The 2 characters that begin all inquiry directives.






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






45. Cursors: Give the statement for getting out of a FETCH loop for cursor CV.






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






47. Triggers: An INSTEAD OF trigger is (always/never) a row-level trigger.






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






49. Declare an output NUMBER parameter - v1 - that defaults to 10.






50. Default value of PLSQL_OPTIMIZE_LEVEL.







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