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. IDs: The two types of words that can - but should not - be used as user-defined identifiers.






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






3. The $ERROR directive is used to make compilation ____.






4. What word is in a function header but not in a procedure header?






5. SIMPLE_INTEGER is like PLS_INTEGER - but it does not allow ____ values - and it does not raise overflow exceptions.






6. Exceptions: Write the call (2 args) to associate message 'Bad' with error code -20 -100.

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


7. A subprogram created inside a block is a _________ subprogram.






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






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






10. A GOTO statement cannot branch from an exception handler back into the...






11. The inquiry directive that gives the current line number in the procedure.






12. Where an external subprogram is stored.






13. The $IF must evaluate a ______ _______ expression.






14. The meaning of 'FGA'.






15. Advantage: PL/SQL supports ______-oriented programming.






16. To run a PIPE ROW statement in your autonomous routine - you must close any _____________.






17. IDs: You cannot use reserved words as ______ user-defined identifiers.






18. Which collection type is bounded?






19. Fundamental: Which one of these is a simple symbol: a - = - !=






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






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






22. Cursors: The four cursor attributes - in alphabetical order.






23. A ___________ behaves like a table column - but it is not stored in the table.






24. Fundamental: One of the 4 types of lexical units: L_____






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






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






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






28. What clause makes a compilation default to the PLSQL_CCFLAGS settings from the last compilation?






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






30. _____ arrays cannot be used as the type of an Oracle table column.






31. I/O: This package handles HTTP.






32. Subprograms are stored in __________ form.






33. The declaration section is (optional/mandatory).






34. Types of blocks: A pl/sql block that is not stored in the database.






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






36. Give the clause you add to a CREATE TABLE statement - when there is a collection column myColl - that you want to be stored in a table called myCollTab.






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






38. The EXTEND method is not used with ______ _______.






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






40. A unit with AUTHID = DEFINER is a ________ rights unit.

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


41. With Edition-based Redefinition enabled - the unique specification of an object requires OWNER - OBJECT_NAME and ___________.






42. Characters that end a multi-line comment.






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






44. Internally - the NUMBER type is stored as ______. Therefore - decimal numbers (such as prices) are stored exactly - with no rounding.






45. Cursors: Give the statement to close cursor C.






46. Which two of these built-in SQL functions can be used in procedural (PL/SQL) statements: DECODE - CORR - UPPER - SUM - COALESCE - DEREF.






47. Types: One of the scalar data types specific to PL/SQL: P________






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






49. For a collection - the NEXT method gets the next higher (element / index).






50. I/O: Max number of bytes to pass in a call to DBMS_OUTPUT.PUT_LINE.