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. Exceptions: A GOTO statement CAN branch from an exception handler into an ________ block.






2. Delimiters: The assignment operator.






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






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






5. Cursors: A cursor with a name is an _________ cursor.






6. Web: mod_plsql is an _______ module.






7. The NOCOPY option on an OUT or IN OUT parameter - causes it to be passed by ______.






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






9. TCL: Undo changes back to savepoint ab.






10. Cursors: The value of SQL%ROWCOUNT after a SELECT INTO statement returns more than one row.






11. From a block nested inside a procedure P - reference variable V of the outer procedure.






12. Abbreviation for Abstract Data Type.






13. How many PL/SQL collection types are there?






14. The best candidates for result-caching are functions that are invoked frequently but depend on __________________ or never.






15. Cursors: What is the 'name' of the implicit cursor?






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






17. Command used to execute dynamic SQL.






18. Conversion: If the specific value is suitable - ____ or _______ values can convert to almost any datatype






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






20. Package for getting the postprocessed source of a program.






21. Declare an associative array type - t - whose elements are of type rPerson - and whose index is PLS_INTEGER.






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






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






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






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






26. Delimiters: The left label delimiter.






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






28. Advantage: Performance: Stored subprograms are ______ in memory.






29. A numeric FOR loop cannot _________ by other than 1?






30. Advantage: Having procedures stored and executed on the server makes PL/SQL ________.






31. I/O: This package sends text output to SQLPlus






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






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






34. I/O: This DBMS_OUTPUT proc retrieves multiple lines from the buffer.






35. When an autonomous routine begins execution - the main transaction is ________.






36. Give the ANSI Date literal for December 25 - 2005.

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


37. The LIMIT method is only meaningful for _______.






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






39. Exceptions: Each internal exception has an Oracle ______ _______.






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






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






42. Web: PL/SQL ______ ______ (PSPs) let you develop web pages with dynamic content.






43. Bulk: The keywords of a bulk collect FETCH statement.






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






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






46. Declare a constrained subtype of NUMBER called N that is not null.






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






48. Web: Abbreviation of PL/SQL Server Page.






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






50. Exceptions: If there is no handler for an exception - PL/SQL returns an ________ exception error to the invoker or host environment.