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 FOR-loop counter is defined only within the _____.






2. Command to create a procedure.






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






4. Web: PL/SQL _______ enables a Web browser to invoke a PL/SQL stored subprogram through an HTTP listener.






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






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






7. Nested tables can become sparse via ______.






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






9. The names of Java objects in Oracle can be up to __ characters in length.






10. DBMS_DDL.CREATE_WRAPPED: wraps and _______ the source code passed to it.






11. Advantage: PL/SQL runs anywhere Oracle runs - so it is very ________.






12. I/O: This package has hypertext procedures that generate HTML tags






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






14. DynSQL: The colon-prefixed names used in EXECUTE IMMEDIATE are called ________.






15. Wrap iname=xxxx _____=zzzzz






16. IDs: List the two types of user-defined identifiers.






17. The RESULT_CACHE clause has to be in both the declaration and in the ______ of the function.






18. The command used to populate PLSQL_CCFLAGS.






19. _______ arrays can be sparse or dense - depending on how you fill them.






20. Labels for blocks and statements are enclosed in '__' brackets.






21. The Wrap utility ________ the source code.






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






23. An INSTEAD OF trigger is used - e.g - when you want to insert into a complex _____.






24. VARRAYs are (always / never) sparse.






25. TCL: Create a savepoint called ab






26. Wrapping can be done with the ____ executable.






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






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






29. DBMS_DDL.WRAP returns a string containing wrapped _____ _____.






30. Triggers: If two or more triggers are defined with the same timing point - then you can control the firing order using the ________ clause.






31. INSTEAD OF triggers are alternatives to ___ triggers






32. What do you FETCH from?






33. Fundamental: Maximum string length of a PL/SQL variable.






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






35. When a session starts - CURRENT_SCHEMA has the value of the schema owned by ___________.






36. Web: Abbreviation of PL/SQL Server Page.






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






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






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






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






41. In a FORALL loop - you (can / cannot) use the index variable for purposes other than indexing into the collection.






42. Default file extension of wrap's input file.






43. What are the starting and ending keywords of a simple loop?






44. Triggers: Programmers (as opposed to DBAs) mostly make use of _____ triggers.






45. Abbreviation of invoker's rights






46. Default value of PLSQL_OPTIMIZE_LEVEL.






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






48. When an autonomous routine begins execution - the main transaction is ________.






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






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







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