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 (simple / searched) CASE statement begins with CASE WHEN <boolean expression>.






2. Triggers and views always have _________ rights.

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


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






4. Kind of code created by the PL/SQL compiler.






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






6. Bulk: The use of FORALL statements cuts down on ______ traffic.






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






8. Exceptions: Write the call (2 args) to associate message 'Bad' with error code -20 -100.

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


9. Cursors: The statement where you pass the parameters to a cursor.






10. Triggers: You (can/cannot) explicitly invoke a trigger.






11. Advantage: Caching of programs and sharing among users lowers _______ requirements.






12. 5 types of events that can have triggers: DML - DDL - INSTEAD OFs - database events - and ________ statements.






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






14. Advantage: PL/SQL is tightly _______ with Oracle SQL.






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






16. An $ERROR directive ends with _____.






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






18. I/O: This package does email.






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






20. Cursors: What are the 3 possible values of SQL%FOUND and SQL%NOTFOUND?






21. Triggers: The clause to make a trigger run once for every affected row.






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






23. What word is in a function header but not in a procedure header?






24. When a parameter is passed by reference - changes made to it inside the procedure cannot be undone. True/False.






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






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






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






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






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






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






31. An editioning view is like an ____ for a table.






32. The _____ utility turns PL/SQL source code into unreadable text.






33. The three sorts of date/time types are DATE - INTERVAL and _________.






34. Delimiters: Statement terminator.






35. (from inside a package) Declare a function f - that takes a number n - returns a number - and caches results - depending on table EMPS.






36. Bytecode is _______ _______ code.






37. Exceptions: Each internal exception has an Oracle ______ _______.






38. The PL/SQL ________ evaluates compiler directives.






39. Declare a variable r whose type is that of the records in table t.






40. IDs: You (can/cannot) use keywords as ordinary user-defined identifiers.






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






42. Declare a package procedure P with no arguments - and give it invoker's rights.






43. What do you FETCH from?






44. To get the current value of CURRENT_SCHEMA - CURRENT_USER - or SESSION_USER - use the ____ function.






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






46. Fundamental: What is the exponentiation operator?






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






48. Exceptions: Declare an exception called E.






49. Triggers: You create a trigger with the _______ ________ statement.






50. With dynamic typing - type checking is done at ______time.







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