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 attribute used to get the type of a row without knowing what it is.






2. With a result-cached function - it uses a cached value when the function is called again with the...






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






4. A CASE statement (can / cannot) execute more than one group of statements.






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






6. Advantage: Performance: PL/SQL automatically creates ______ variables for variables in WHERE and VALUES clauses.






7. Types: A data type family consists of a ______ type and its subtypes.






8. A SELECT statement with the FOR UPDATE clause puts a ______ on the selected rows.






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






10. Declare a variable r whose type is that of the records in table t.






11. Cursors: SYS_REFCURSOR is a predefined type based on _____ ______.






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






13. In a FORALL loop - you (can / cannot) use the index variable for purposes other than indexing into the collection.






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






15. The PL/SQL preprocessor passes ______ code to the compiler.






16. $$PLSQL_LINE and $$PLSQL_UNIT are ______-ly defined inquiry directives.






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






18. An incomplete type is a type created by a ______ type definition.






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






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






21. Triggers: A compound trigger can fire at more than one ______ point.






22. TCL: Undo changes back to savepoint ab.






23. I/O: dbms_output.put_line puts output into a _______.






24. I/O: One of the 3 types of data that can be passed to the DBMS_OUTPUT buffer.






25. Two types of stored subprograms.






26. Exceptions: User-defined exceptions must have _______.






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






28. Wrapping can be done with the ____ executable.






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






30. A CASE expression ends with _____.






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






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






33. Types: PL/SQL has all the _____ data types.






34. The valid values of the AUTHID property.






35. 5 types of events that can have triggers: DML - DDL - INSTEAD OFs - database events - and ________ statements.






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






37. Cursors: A pointer to a cursor is called a ______ _______.






38. A (simple / searched) CASE statement begins with CASE WHEN <boolean expression>.






39. Declare a number variable - A - initialized to 10.






40. After the RESULT_CACHE clause - you can put a _________ clause to enable dependency-checking.






41. Wrap ______=xxxx oname=zzzzz






42. INSTEAD OF triggers are alternatives to ___ triggers






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






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






45. Wrap iname=xxxx _____=zzzzz






46. To run DDL statements - a trigger must be autonomous and must use ______ ______ SQL.






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






48. DynSQL: The clause that supplies bind arguments to EXECUTE IMMEDIATE.






49. An INSTEAD OF trigger specifies what to do instead of a ___ statement.






50. Cursors: An explicit cursor (can/cannot) accept parameters.