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. Pkgs: This procedure de-instantiates/resets all packages in this session.






2. In the special IF syntax - is it ELSIF - or ELSEIF?






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






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






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






6. Language that PL/SQL is derived from.






7. GOTO branches to a ________.






8. Declare a package procedure P with no arguments - and give it definer's rights.






9. A CASE statement ends with ____ ____.






10. Triggers: INSTEAD OF triggers only run on ______ views.






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






12. A subprogram defined within another subprogram is a _______ subprogram.






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






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






15. Types: The only PL/SQL type for which you can specify a range constraint.






16. Delimiters: the attribute indicator.






17. VARRAYs are (always / never) sparse.






18. Default value of PLSQL_OPTIMIZE_LEVEL.






19. An anonymous block always has _________ rights.

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


20. A CASE statement (can / cannot) execute more than one group of statements.






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






22. DynSQL: EXECUTE IMMEDIATE does both dynamic SQL and dynamic _______.






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






24. Exceptions: Type ______ to re-raise the current exception.






25. In a sparse collection - the indexes of defined elements (do / do not) run in consecutive order.






26. Cursors: A Cursor FOR loop does not use a ______ statement.






27. User-defined compiler directives are defined in this system compile parameter.






28. What is the simplest statement for conditionally getting out of simple loop?






29. What are the 3 values of the BOOLEAN data type?






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






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






32. Types: The predefined subtype of PLS_INTEGER that has the NOT NULL constraint.






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






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






35. For a collection - the NEXT method gets the next higher (element / index).






36. TCL: Undo changes back to savepoint ab.






37. Triggers: The clause to make a trigger run after inserting into table EMPS.






38. An incomplete type only has a ____.






39. In 11g you can directly reference _____________ in PL/SQL.






40. Advantage: Performance: Stored subprograms are ______ in memory.






41. A nested table has to be initialized using a ________ - named the same as the type.






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






43. The statement that is used to execute most (native) dynamic SQL.






44. Pkgs: RESET_PACKAGE only takes effect after the outermost PL/SQL proc that called it ________.






45. A FOR loop can be indexed by numbers or by a ______.






46. Cursors: A cursor variable's type must be a ____ ______ type.






47. The FOR UPDATE OF clause references a (table / column).






48. Define a collection type - tA - which is an associative array of NUMBERS - indexed with varchar2(20) values.






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






50. Cursors: The index variable in a cursor FOR loop (does/does not) need to be declared.







Sorry!:) No result found.

Can you answer 50 questions in 15 minutes?


Let me suggest you:

Browse all subjects

Browse all tests

Most popular tests



Major Subjects

Tests & Exams


AP
CLEP
DSST
GRE
SAT
GMAT

Browse all subjects

Browse all tests

Most popular tests