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. DynSQL: The standard package that does dynamic SQL.






2. A CASE statement ends with ____ ____.






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






4. The collection method that tells the number of elements in the collection.






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






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






7. If none of a CASE expression's conditions are TRUE - it returns _____.






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






9. IDs: What a quoted user-defined identifier is enclosed in.






10. Cursors: An implicit cursor is also called a/n ________ ________ -






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






12. DynSQL: EXECUTE IMMEDIATE does both dynamic SQL and dynamic _______.






13. Triggers: To simulate having triggers on SELECT statements - you can try ___ (3-letter acronym).






14. Triggers: Unlike a stored procedure - you can enable and _____ a trigger.






15. A FOR loop can be indexed by numbers or by a ______.






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






17. Statement to exit a cursor loop on cursor cGo when there are no more records.






18. Exceptions: Some internal exceptions have ________ names.






19. A GOTO cannot branch into a...






20. The PL/SQL preprocessor passes ______ code to the compiler.






21. VARRAYs are (always / never) sparse.






22. Default value of PLSQL_OPTIMIZE_LEVEL.






23. Cursors: The SQL%FOUND attribute has how many possible values?






24. A type of compiler directive - begins with 'i'.






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






26. Types: A data type family consists of a ______ type and its subtypes.






27. In a sparse collection - the indexes of defined elements (do / do not) run in consecutive order.






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






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






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






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






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






33. A subprogram created inside a block is a _________ subprogram.






34. Exceptions: The ________ function returns the error message associated with an error code.






35. I/O: The DBMS_OUTPUT buffer will not be flushed until it is full or until the current PL/SQL block _________.






36. This is a CASE (expression / statement): myvar := CASE num WHEN 1 THEN 'good' WHEN 2 THEN 'bad' END;






37. To insert or update on a table that has a collection column - you have to have _______ privilege on the collection type.






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






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






40. An INSTEAD OF trigger is used - e.g - when you want to insert into a complex _____.






41. For a collection - the NEXT method gets the next higher (element / index).






42. Characters that begin a single-line comment.






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






44. Conversion: If the specific value is suitable - ____ or _______ values can convert to almost any datatype






45. Setting CURRENT_SCHEMA only changes what is prepended to __________ references.






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






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






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






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






50. The PL/SQL ________ evaluates compiler directives.







Sorry!:) No result found.

Can you answer 50 questions in 15 minutes?


Let me suggest you:

Browse all subjects

Browse all tests

Most popular tests



Major Subjects

Tests & Exams


AP
CLEP
DSST
GRE
SAT
GMAT

Browse all subjects

Browse all tests

Most popular tests