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. Cursors: SYS_REFCURSOR is a predefined type based on _____ ______.






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






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






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






5. Exceptions: The ________ handler must always be the last handler.






6. I/O: The buffered output of dbms_output.put_line is retrieved by _______.






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






8. In Native Mode - PL/SQL code is compiled into ______ ______.






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






10. What is the exception that is implicitly raised in a CASE statement with no ELSE clause?






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






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






13. 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


14. A null string and a BOOLEAN null are _______ (same/not the same).






15. A GOTO cannot branch into a...






16. Setting CURRENT_SCHEMA only changes what is prepended to __________ references.






17. Define a record type REC with number num and varchar2(10) name.






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






19. IDs: How an ordinary user-defined identifier must begin.






20. A large OUT or IN OUT parameter will waste a lot of space and CPU if it is passed by _____.






21. Dbms_sql: The return type DBMS_SQL.open_cursor.






22. Advantage: PL/SQL programs are stored centrally - making them more ______.






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






24. Are good for logging table DML operations.






25. Cursors: Define a ref cursor type called T.






26. I/O: Max number of bytes DBMS_OUTPUT can handle in a session.






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






28. Dbms_sql: DBMS_SQL package is compiled with _______ rights.

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


29. I/O: The PL/SQL I/O packages (can/cannot) accept input directly from the keyboard.






30. Cursors: WHERE _______ ______ makes an UPDATE or DELETE apply to the current row of a cursor.






31. Searchable CASE statement: Each WHEN has its own _______ condition.






32. 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


33. Which collection type is bounded?






34. Types: The PL/SQL type that is identical to PLS_INTEGER.






35. The EXCEPTION section is (optional/mandatory).






36. VARRAYs are (always / never) sparse.






37. Cursors: The first two keywords of a basic fetch statement.






38. Set flag bb true: ALTER SESSION SET PLSQL_CCFLAGS= '____'






39. What is the simplest statement for conditionally getting out of simple loop?






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






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






42. The LIMIT method is only meaningful for _______.






43. The 4 keywords in the $IF compiler directive.






44. Triggers: Unlike a stored procedure - you can enable and _____ a trigger.






45. I/O: This package handles HTTP.






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






47. The three possible values of a BOOLEAN literal.






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






49. Types: Which type of arithmetic does PLS_INTEGER use - library or hardware?






50. Exceptions: When an exception is raised inside a cursor FOR loop - the cursor is _______ implicitly.