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 type of compiler directive - begins with 's'.






2. Define a collection type - tA - which is an associative array of NUMBERS - indexed with varchar2(20) values.






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






4. An $ERROR directive ends with _____.






5. Cursors: The first two keywords in a Cursor FOR loop.






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






7. Assigning values to PL/SQL variables that appear in SQL statements is called _______.






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






9. Delimiters: Host variable indicator.






10. Command to assign to variables from a cursor.






11. Advantage: PL/SQL is tightly _______ with Oracle SQL.






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






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






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






15. Fundamental: What is the range operator?






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






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






18. Exceptions: Some internal exceptions have ________ names.






19. A GOTO cannot branch into a...






20. Exceptions: PL/SQL exceptions are of two types: internal and _________.






21. TCL: Create a savepoint called ab






22. Exceptions: Pragma that links an exception to an Oracle error code.






23. A kind of variable used as a placeholder.






24. Triggers and views always have _________ rights.

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


25. The _______ package lets you wrap dynamically generated PL/SQL.






26. The variable showing the user id that is automatically prepended to object names.






27. By default - an IN parameter is passed by ______.






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






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






30. I/O: dbms_output.put_line puts output into a _______.






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






32. Packaged constants can synchronize programs through use in _______ directives.






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






34. Assignment of PLSQL_CCFLAGS (cannot / can) be included in ALTER PROCEDURE ... COMPILE ...






35. I/O: This package does email.






36. Fundamental: What is the exponentiation operator?






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






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






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






40. Cursors: SYS_REFCURSOR is a predefined type based on _____ ______.






41. An editioning view can only select a subset of the columns from the base table and provide ________ for them






42. To enable result-caching for a function - use the _____________ clause.






43. You can have many autonomous transactions in ___________.






44. IDs: What a quoted user-defined identifier is enclosed in.






45. True encryption is done with package __________.






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






47. I/O: One of the 3 types of data stored in the DBMS_OUTPUT buffer.






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






49. Mode designation for an output parameter.






50. Cursors: Closing keywords of a cursor FETCH loop.