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. The PL/SQL ________ evaluates compiler directives.






2. I/O: The string table type in DBMS_OUTPUT for holding lines of text.






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






4. Advantage: PL/SQL gives SCALABILITY because stored procedures are executed on the _______.






5. Conversion: Just about everything will implicitly convert to _____ or _________.






6. DynSQL: Maximum string length to pass to EXECUTE IMMEDIATE.






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






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






9. _____ arrays cannot be used as the type of an Oracle table column.






10. The declaration section is (optional/mandatory).






11. Cursors: You can just declare a cursor at first - then _______ it later.






12. Type: An ________ subtype has all the values of its base type.






13. How many PL/SQL collection types are there?






14. Triggers: In a DML trigger - the phrase that makes the trigger run for every affected record.






15. Delimiters: The component indicator/selector.






16. Records are one of the two kinds of PL/SQL _______ data types.






17. Pkgs: This procedure de-instantiates/resets all packages in this session.






18. Cursors: The Oracle predefined REF CURSOR type.






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






20. Delimiters: Host variable indicator.






21. IDs: The type of words that cannot be user-defined identifiers.






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






23. TCL: Undo changes back to savepoint ab.






24. From a block nested inside a procedure P - reference variable V of the outer procedure.






25. An ordinary character literal is composed of characters in the ________ character set.






26. The lowest index of a nested table is ___.






27. Triggers: An INSTEAD OF trigger (can/cannot) be conditional.






28. You can have many autonomous transactions in ___________.






29. An incomplete type only has a ____.






30. Conversion: It is best to use (implicit / explicit) conversion.






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






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






33. I/O: Max number of bytes to pass in a call to DBMS_OUTPUT.PUT_LINE.






34. Exceptions: User-defined exceptions must have _______.






35. The LIMIT method is only meaningful for _______.






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






37. Language that PL/SQL is derived from.






38. After the RESULT_CACHE clause - you can put a _________ clause to enable dependency-checking.






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






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






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






42. Which two collection types are unbounded?






43. Cursors: A session cursor that is automatically created and managed by PL/SQL.






44. The FORALL statement to loop over a collection MyList using index i.






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






46. Characters that begin a multi-line comment.






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






48. To exit an active autonomous transaction without causing an exception - you must issue _____ or ______.






49. With conditional compilation you can avoid compiling debug code in the _______ environment.






50. Characters that begin a single-line comment.







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