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: Declare an exception called E.






2. Types: In addition to the SQL data types - PL/SQL has ___ more scalar data types.






3. An autonomous program runs in its own __________.






4. Exceptions: The _________ package defines the PL/SQL environment.






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






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






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






8. Web: PL/SQL ______ ______ (PSPs) let you develop web pages with dynamic content.






9. Cursors: The first two keywords in a Cursor FOR loop.






10. Cursors: The values plugged into the DML in a FORALL must come from existing - populated _________.






11. Cursors: Give the first 3 words to open a cursor variable called cv.






12. Triggers: The code in a trigger is actually an ________ block.






13. Delimiters: The component indicator/selector.






14. Cursors: How many implicit cursors can you access?






15. An INSTEAD OF trigger specifies what to do instead of a ___ statement.






16. PL/SQL lets you define two kinds of composite data types: _______ and _______






17. Data dictionary view giving the AUTHID values on a user's objects.






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


19. Where an external subprogram is stored.






20. I/O: This package handles HTTP.






21. Cursors: What implicit cursor attribute gives row counts for a FORALL statement?






22. Dbms_sql: DBMS_SQL package is compiled with _______ rights.

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


23. Give the first line of the FOR loop with index i going from 1 to 10 in reverse.






24. DynSQL: EXECUTE IMMEDIATE can be used for any SQL statement or PL/SQL block - except for ________ queries.






25. Bulk: The keywords of a bulk collect FETCH statement.






26. To create a collection type - use the TYPE command in PL/SQL and the ______ _____ command in SQL.






27. The source for wrapping begins with the word ______.






28. To run TCL or DDL statements - a trigger (must / must not) be autonomous .






29. Fundamental: identifiers (include/do not include) reserved words.






30. The Wrap utility (does / does not) encrypt source code.






31. Make a FOR loop that executes NULL 10 times counting in reverse - using index i.






32. A PL/SQL block that is not stored.






33. Cursors: The three keywords in a full cursor declaration/definition (before the SELECT).






34. Unlike the CASE statement - the CASE expression does not have the...






35. Which two of these built-in SQL functions can be used in procedural (PL/SQL) statements: DECODE - CORR - UPPER - SUM - COALESCE - DEREF.






36. Delimiters: Host variable indicator.






37. NAN stands for _________.






38. Wrap ______=xxxx oname=zzzzz






39. Cursors: SYS_REFCURSOR is a predefined type based on _____ ______.






40. Exceptions: The package that defines pre-defined exceptions.






41. Cursors: Statement to end a loop when MyCur is used up: _____ ______ MyCur%NOTFOUND.






42. Exceptions: A GOTO statement cannot branch into an _______ ________.






43. Mode designation for an output parameter.






44. I/O: This package does email.






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






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






47. FOR-Looping over a collection from FIRST to LAST only works if the collection is _______.






48. Types: ________ data types have no internal components.






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






50. The LIMIT method is only meaningful for _______.