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. A CASE statement (can / cannot) execute more than one group of statements.






2. Subprograms are stored in __________ form.






3. DynSQL: The clause that supplies bind arguments to EXECUTE IMMEDIATE.






4. PL/SQL is a ________ typed programming language.






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






6. Triggers: When using the NEW or OLD pseudo-records in the body of the trigger - they must be prefixed with a _______.






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






8. DBMS_DDL.WRAP returns a string containing wrapped _____ _____.






9. Dbms_sql: The return type DBMS_SQL.open_cursor.






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






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






12. Are good for logging table DML operations.






13. GOTO branches to a ________.






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






15. %ROWTYPE gets the type of a table or _______.






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






17. Kind of comment not to put in a PL/SQL block to be processed dynamically by an Oracle Precompiler program.






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






19. In short-circuit evaluation - IF-conditions are only evaluated up to where the outcome ___________.






20. A record is a group of related data items stored in fields - each with its own...






21. The compiler directive governing conditional compilation.






22. 5 types of events that can have triggers: DML - DDL - INSTEAD OFs - database events - and ________ statements.






23. Advantage: PL/SQL runs anywhere Oracle runs - so it is very ________.






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






25. Exceptions: Some internal exceptions have ________ names.






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






27. Triggers: Programmers (as opposed to DBAs) mostly make use of _____ triggers.






28. DynSQL: In EXECUTE IMMEDIATE - the statement string can use either placeholders - or string ________.






29. A pointer to a private SQL area that stores information about processing a specific SELECT or DML statement.






30. Associative arrays (do / do not) have to be initialized with a constructor.






31. A kind of variable used as a placeholder.






32. PLS_INTEGER has its arithmetic implemented in ________ - so it is very fast.






33. Delimiters: The component indicator/selector.






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






35. What are the two sequence pseudo-columns?






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






37. How many types of compiler directives are there?






38. A basic PL/SQL datatype that SQL does not have.






39. I/O: This package has hypertext functions that generate HTML tags






40. An anonymous block always has _________ rights.

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


41. A SELECT statement with the FOR UPDATE clause puts a ______ on the selected rows.






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






43. $$PLSQL_LINE and $$PLSQL_UNIT are ______-ly defined inquiry directives.






44. I/O: SQLPlus command for turning on buffered output.






45. Fundamental: Maximum string length of a PL/SQL variable.






46. Triggers: There are __ types of triggers.






47. When a session starts - CURRENT_SCHEMA has the value of the schema owned by ___________.






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






49. Define a record variable r - of type tRec - initialized with values 9 and 'Jones' in its two fields.

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


50. A value that is neither represented by an identifier nor calculated from other values.