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. Cursors: Statement to end a loop when MyCur is used up: _____ ______ MyCur%NOTFOUND.






2. How many times are a FOR loop's index bounds evaluated?






3. The compiler directive governing conditional compilation.






4. Exceptions: Pragma that links an exception to an Oracle error code.






5. Fundamental: Which one of these is a compound symbol: = - :=






6. A numeric FOR loop cannot _________ by other than 1?






7. An autonomous program runs in its own __________.






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






9. Cursors: A cursor FOR loop can use an explicit or an _______ cursor.






10. I/O: The string table type in DBMS_OUTPUT for holding lines of text.






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






12. I/O: The output from DBMS_OUTPUT will display (during/after) program execution.






13. Into nested table ex - put elements of tbl1 that are not in tbl2.






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






15. Set flag bb true: ALTER SESSION SET PLSQL_CCFLAGS= '____'






16. Declare an input NUMBER parameter - v2 - that defaults to 20.






17. Abbreviation of invoker's rights






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






19. Static typing is also called _____ typing.






20. Value of PLSQL_OPTIMIZE_LEVEL that prevents optimization.






21. The variable showing the user id of the session owner.






22. Keyword for doing assignment to a variable with SELECT.






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






24. The _______ package lets you wrap dynamically generated PL/SQL.






25. ______ SQL is a PL/SQL feature that allows SQL syntax directly in a PL/SQL statement.






26. Triggers: In a trigger - you cannot issue a COMMIT or a ______.






27. Advantage: PL/SQL supports ______-oriented programming.






28. Name the two types of FOR loop.






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






30. Command to assign to variables from a cursor.






31. Are good for logging table DML operations.






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






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






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






35. I/O: This package lets two or more sessions in the same instance communicate.






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






37. Two types of stored subprograms.






38. TCL: Create a savepoint called ab






39. Abbreviation for Abstract Data Type.






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






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






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






43. Cursors: The first two keywords of a basic fetch statement.






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






45. The AUTHID property applies to PL/SQL objects that contain _____.






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






47. Fundamental: One of the 4 types of lexical units: L_____






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






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






50. $$PLSQL_LINE and $$PLSQL_UNIT are ______-ly defined inquiry directives.







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