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. Value of PLSQL_OPTIMIZE_LEVEL that prevents optimization.






2. Fundamental: A label can only go directly before an _______ statement.






3. Name the two types of FOR loop.






4. The command used to populate PLSQL_CCFLAGS.






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






6. Exceptions: A GOTO statement CAN branch from an exception handler into an ________ block.






7. Types: ________ data types have internal components.






8. I/O: SQLPlus command for turning on buffered output.






9. Exceptions: Some internal exceptions have ________ names.






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






11. Kind of comment not to put in a PL/SQL block to be processed dynamically by an Oracle Precompiler program.






12. Cursors: A session cursor that a PL/SQL user creates and manages.






13. Types: Which type of arithmetic does NUMBER use - library or hardware?






14. In PL/SQL - what the variables in DML statements are turned into.






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






16. Wrapped code (is / is not) not backward compatible.






17. The Wrap utility ________ the source code.






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






19. The three types of compiler warnings.






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






21. Give the statement to make a program autonomous.






22. Simple CASE statement checks for different values of a single _________






23. What are the two sequence pseudo-columns?






24. Cursors: You give an explicit cursor a name and associate it with a _______.






25. What is the exception that is implicitly raised in a CASE statement with no ELSE clause?






26. Exceptions: An unhandled exception ________ to the enclosing block.






27. Types: One of the scalar data types specific to PL/SQL: P________






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






29. Dbms_sql: This DBMS_SQL function opens a new cursor.






30. What do you FETCH from?






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






32. A GOTO cannot branch into an...






33. Conditional compilation is useful for compiling a program under different ______ of Oracle.






34. I/O: This package sends text output to SQLPlus






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






36. I/O: To make sure the DBMS_OUTPUT buffer will be flushed - put a WHEN ______ clause in the EXCEPTION section of your outer block.






37. Bulk: The implicit cursor attribute that gives the number of rows affected by each DML statement in a FORALL statement.






38. Collections are one of the two kinds of PL/SQL _______ data types.






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






40. Give the ANSI Date literal for December 25 - 2005.

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


41. Exceptions: The built-in procedure for raising an application-defined error.






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






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






44. Delimiters: Statement terminator.






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






46. DynSQL: Native Dynamic SQL






47. The allowed data types of user-defined conditional compilation directives are boolean and _______.






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






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






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