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. I/O: The string table type in DBMS_OUTPUT for holding lines of text.






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






3. Declare an input NUMBER parameter - v2 - that defaults to 20.






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






5. The SET TRANSACTION statement affects only the ____________.






6. When a parameter is passed by reference - changes made to it inside the procedure cannot be undone. True/False.






7. How many times are a FOR loop's index bounds evaluated?






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






9. You can use the BULK COLLECT INTO clause in a SELECT or a ______.






10. IDs: You (can/cannot) use keywords as ordinary user-defined identifiers.






11. Exceptions: A GOTO statement CAN branch from an exception handler into an ________ block.






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






13. Wrap iname=xxxx _____=zzzzz






14. Cursors: The index variable in a cursor FOR loop (does/does not) need to be declared.






15. Pkgs: This procedure de-instantiates/resets all packages in this session.






16. The attribute used to get the type of a row without knowing what it is.






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






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






19. Delimiters: The association operator.






20. Cursors: The keyword that makes a ref cursor type STRONG.






21. Cursors: An implicit cursor is also called a/n ________ ________ -






22. Triggers: On a non-editioning view - you can only define __________ triggers.






23. The three sorts of date/time types are DATE - INTERVAL and _________.






24. Data dictionary view giving the AUTHID values on a user's objects.






25. Cursors: Give the statement to open cursor C.






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






27. What are two categories of SQL functions that cannot be used in procedural statements?






28. The method to add one or more elements to a nested table or VARRAY is ______.






29. A user-defined TYPE can have...






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






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






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






33. VARRAYs are (always / never) sparse.






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






35. Bulk: The two features that comprise Bulk SQL are:






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






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






38. Fundamental: Which one of these is a compound symbol: = - :=






39. Declare an output NUMBER parameter - v1 - that defaults to 10.






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






41. Name the two types of FOR loop.






42. The exception raised when a SELECT INTO statement returns more than one row.






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






44. In the IF syntax - is if ENDIF or END IF?






45. If a result-cached function's data source (based on the RELIES_ON clause) is updated - any cached results become _______.






46. An $ERROR directive ends with _____.






47. To use a TYPE declared in the database - a PL/SQL block has to have _______ privilege on the type.






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






49. Types: In addition to the SQL data types - PL/SQL has ___ more scalar data types.






50. I/O: This package lets two or more sessions in the same instance communicate.