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. The BEGIN section is (optional/mandatory)






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






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






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






5. If you are in a procedure inside a package - the compilation unit is the _______.






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






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






8. Exceptions: Some internal exceptions have ________ names.






9. You cannot bulk collect into an ARRAY OF ________.






10. What are the starting and ending keywords of a simple loop?






11. In a sparse collection - the indexes of defined elements (do / do not) run in consecutive order.






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






13. Wrap ______=xxxx oname=zzzzz






14. Cursors: Give the statement to fetch data from cursor C into variable V.






15. Advantage: PL/SQL gives SCALABILITY because stored procedures are executed on the _______.






16. A PL/SQL block that is not stored.






17. Triggers: When using the NEW or OLD pseudo-records in the body of the trigger - they must be prefixed with a _______.






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






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






20. Cursors: A cursor that lives in session memory until the session ends.






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






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






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






24. DynSQL: The standard package that does dynamic SQL.






25. Cursors: Opening keyword of a cursor FETCH loop.






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






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






28. I/O: The DBMS_OUTPUT buffer will not be flushed until it is full or until the current PL/SQL block _________.






29. Fundamental: Labels furnish targets for GOTO and _____ statements.






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






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






32. Cursors: A cursor FOR loop can use an explicit or an _______ cursor.






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






34. The RESULT_CACHE clause has to be in both the declaration and in the ______ of the function.






35. A basic PL/SQL datatype that SQL does not have.






36. An anonymous block is a(n) ____ statement.






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






38. I/O: The most basic PL/SQL way to give output to the user.






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






40. Nested tables can become sparse via ______.






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






42. True encryption is done with package __________.






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






44. Clause added to a cursor to use it with WHERE CURRENT OF.






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






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






47. Exceptions: Start of the range of error codes for RAISE_APPLICATION_ERROR.






48. Cursors: How many implicit cursors can you access?






49. A CASE statement ends with ____ ____.






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






Can you answer 50 questions in 15 minutes?



Let me suggest you:



Major Subjects



Tests & Exams


AP
CLEP
DSST
GRE
SAT
GMAT

Most popular tests