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: The three words that can be used to guarantee all exceptions will be handled.






2. Conditional ______ allows backward compability with older database versions.






3. Associative arrays (do / do not) have to be initialized with a constructor.






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






5. Declare an input/output NUMBER parameter - v3.






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






7. To enable result-caching for a function - use the _____________ clause.






8. Command to create a procedure.






9. What clause makes a compilation default to the PLSQL_CCFLAGS settings from the last compilation?






10. A collection is an ordered group of ________ - all of the same ____






11. The valid values of the AUTHID property.






12. Exceptions: When an exception is raised inside a cursor FOR loop - the cursor is _______ implicitly.






13. To use a TYPE declared in the database - a PL/SQL block has to have _______ privilege on the type.






14. NAN stands for _________.






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






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






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






18. You (can/cannot) put a label before an END LOOP statement.






19. Cursors: The FOR UPDATE phrase goes at the (beginning/end) of the cursor definition.






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






21. The three types of compiler warnings.






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






23. True encryption is done with package __________.






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






25. Mode designation for an input/output parameter.






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






27. Cursors: The SQL%BULK_ROWCOUNT attribute is an _________ -






28. Cursors: WHERE _______ ______ makes an UPDATE or DELETE apply to the current row of a cursor.






29. DynSQL: Native Dynamic SQL






30. To recompile a procedure - use the _____ ______ command.






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






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






33. Cursors: Give the statement to open cursor C that takes parameter p.






34. The RESULT_CACHE clause comes (before / after) the RETURN clause.






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






36. Cursors: Give the statement to open cursor C.






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


38. You can have many autonomous transactions in ___________.






39. The default value of the AUTHID property.






40. Exceptions: You cannot GOTO from an exception handler back into the __________ block.






41. Pkgs: The _______ package gives access to such SQL things as ALTER SESSION.






42. I/O: The DBMS_OUTPUT procedure that sets the size of the output buffer.






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






44. DynSQL: The main command for Native Dynamic SQL.






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






46. Data dictionary view that shows the compiler settings for each compiled object.






47. The $ERROR directive is used to make compilation ____.






48. Fundamental: Which one of these is a simple symbol: a - = - !=






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






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







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