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: Maximum string length to pass to EXECUTE IMMEDIATE.






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






3. Cursors: You cannot use cursor attributes in _______ statements.






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






5. Exceptions: The built-in procedure for raising an application-defined error.






6. A __________ can have an AUTHID property






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






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






9. An INSTEAD OF trigger specifies what to do instead of a ___ statement.






10. Default file extension of wrap's input file.






11. Cursors: Define a ref cursor type called T.






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






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






14. DBMS_DDL.CREATE_WRAPPED: wraps and _______ the source code passed to it.






15. The Wrap utility (does / does not) encrypt source code.






16. Exceptions: An unhandled exception ________ to the enclosing block.






17. Types: One of the scalar data types specific to PL/SQL: b_____.






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






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






20. Types: ________ data types have no internal components.






21. Cursors: A pointer to a cursor is called a ______ _______.






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






23. Cursors: A cursor that lives in session memory until the session ends.






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






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






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






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






28. Labels for blocks and statements are enclosed in '__' brackets.






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






30. The _____ and ____ _____ collection types can be used in database table columns.






31. The compiler directive used to select which code to compile.






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






33. How many types of compiler directives are there?






34. In a record - the internal components are called ______.






35. If a result-cached function's data source (based on the RELIES_ON clause) is updated - any cached results become _______.






36. You can define PL/SQL collections using TYPEs defined in the _______.






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






38. Exceptions: Associate exception E with error code -1.






39. Declare an input NUMBER parameter - v2 - that defaults to 20.






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






41. I/O: To make sure the DBMS_OUTPUT buffer will be flushed - put a WHEN ______ clause in the EXCEPTION section of your outer block.






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






43. Web: PL/SQL _______ enables a Web browser to invoke a PL/SQL stored subprogram through an HTTP listener.






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






45. I/O: This package lets PL/SQL programs read and write OS files.






46. Fundamental: Labels furnish targets for GOTO and _____ statements.






47. To run TCL or DDL statements - a trigger (must / must not) be autonomous .






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






49. Cursors: The second keyword of a FETCH statement.






50. The values defined in PLSQL_CCFLAGS can be referenced as _____ directives.