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. Command used to execute dynamic SQL.






2. Subprograms are stored in __________ form.






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






4. Cursors: The keyword that makes a ref cursor type STRONG.






5. Types: ________ data types have internal components.






6. In a collection - the internal components always have the _____ data type.






7. With an sparse - integer-indexed associative array - you (can / cannot) use a regular FOR loop.






8. Fundamental: One of the 4 types of lexical units: d_____






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






10. Into nested table ex - put elements of tbl1 that are not in tbl2.






11. A FOR-loop counter is defined only within the _____.






12. The exception raised when a SELECT INTO statement returns more than one row.






13. Cursors: An explicit cursor (can/cannot) accept parameters.






14. Cursors: If no SELECT or DML statement has run - the value of SQL%ROWCOUNT is what?






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






16. Cursors: Opening keyword of a cursor FETCH loop.






17. In interpreted mode - the PL/SQL VM interprets the _________.






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






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






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






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






22. Cursors: How many DML statements can a FORALL statement contain?






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






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






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






26. Triggers: INSTEAD OF triggers only run on ______ views.






27. Keyword for doing assignment to a variable with SELECT.






28. Declaration of a varchar2 constant - called vname - with value 'x'.

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


29. _________ exceptions can not be trapped with an error handler






30. I/O: This DBMS_OUTPUT proc retrieves one line from the buffer.






31. Cursors: If you use an EXIT statement to exit a cursor FOR loop prematurely - the cursor (is / is not) closed automatically.






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






33. Dbms_sql: A cursor opened with OPEN_CURSOR (can/cannot) be reused for multiple queries without first closing it.






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






35. Conversion: Implicit conversion is not always predictable; it is _______-sensitive. And its rules might change.






36. Characters that begin a single-line comment.






37. DynSQL: The clause that receives single-row query output from EXECUTE IMMEDIATE.






38. The command used to populate PLSQL_CCFLAGS.






39. A PL/SQL extension to the WHERE clause of the SQL statements UPDATE and DELETE






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






41. Name the two types of FOR loop.






42. Associative array types (can / cannot) be defined in the database.






43. Command to make a no-op (omit semicolon).






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






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






46. Exceptions: The maximum length of an Oracle error message is ____ characters






47. Characters that begin a multi-line comment.






48. Command to assign to variables from a cursor.






49. Define a collection type - tV - which is a varray of 100 NUMBERs.






50. Triggers: If two or more triggers are defined with the same timing point - then you can control the firing order using the ________ clause.