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 inquiry directive that gives the current line number in the procedure.






2. Abbreviation of definer's rights






3. The four keywords that define a PL/SQL block.






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






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






6. DynSQL: Native Dynamic SQL






7. Web: mod_plsql is an _______ module.






8. A GOTO statement can branch from an exception handler into...






9. The 4 keywords in the $IF compiler directive.






10. The compiler directive governing conditional compilation.






11. A national character literal is composed of characters in the ________ character set.






12. Web: mod_plsql is an implementation of the PL/SQL _________.






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






14. An incomplete type is a type created by a ______ type definition.






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






16. A type of compiler directive - begins with 's'.






17. Dbms_sql: The DBMS_SQL procedure that closes a cursor.






18. I/O: The DBMS_OUTPUT function that writes output without a newline character.






19. Triggers: A compound trigger can fire at more than one ______ point.






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






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






22. An anonymous block is a(n) ____ statement.






23. CREATE TYPE cannot be used for _______ array types.






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






25. Triggers: In a per-row trigger - the ____ record shows you the changed state of an affected row.






26. IDs: The 3 non-alphanumeric characters that can be in an ordinary user-defined identifier.






27. Triggers: The clause to make a trigger run before inserting or updating table EMPS.






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






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






30. Delimiters: The left label delimiter.






31. A result-cached function caches its results in the _____ _____ ____ (SGA)






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






33. You cannot bulk collect into an ARRAY OF RECORDS. You can into a ________________ (3 words).






34. A GOTO cannot branch into an...






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






36. Fundamental: Which one of these is a compound symbol: = - :=






37. Cursors: The value of SQL%ISOPEN is always ______.






38. The two main parts of a package are the ____ and the _____.






39. In a FORALL loop - you (can / cannot) use the index variable for purposes other than indexing into the collection.






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






41. Triggers: The clause to make a trigger run after inserting into table EMPS.






42. To run a PIPE ROW statement in your autonomous routine - you must close any _____________.






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






44. For a collection - the NEXT method returns ____ when there is no next index value.






45. IDs: Maximum number of bytes in a user-defined identifier.






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






47. Parameter that controls how much Oracle optimizes your PL/SQL code on compilation.






48. List the transaction control statements.






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






50. PL/SQL does not automatically create bind variables in ________ SQL.







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