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. Advantage: Performance: Stored subprograms are ______ in memory.






2. Types: The only Oracle datetime type that doesn't begin with TIMESTAMP is ________.






3. Cursors: What is the 'name' of the implicit cursor?






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






5. Cursors: A session cursor that is automatically created and managed by PL/SQL.






6. Triggers: The clause to make a trigger run after inserting into table EMPS.






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






8. Fundamental: Delimiters are _____ and _____ symbols.






9. Conditional ______ allows backward compability with older database versions.






10. I/O: This package sends text output to SQLPlus






11. Types: The only PL/SQL type for which you can specify a range constraint.






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






13. For an associative array - the FIRST method gets the (lowest / first-created) index.






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






15. Default file extension of wrap's output file.






16. Exceptions: An unhandled exception ________ to the enclosing block.






17. I/O: This package lets PL/SQL programs read and write OS files.






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






19. One good use of bind variables is to guard against SQL _______.






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






21. Labels for blocks and statements are enclosed in '__' brackets.






22. Language that PL/SQL is derived from.






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






24. DynSQL: The main command for Native Dynamic SQL.






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






26. IDs: What a quoted user-defined identifier is enclosed in.






27. The command used to populate PLSQL_CCFLAGS.






28. Default value of PLSQL_OPTIMIZE_LEVEL.






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






30. Exceptions: The three words that can be used to guarantee all exceptions will be handled.






31. When an autonomous routine begins execution - the main transaction is ________.






32. Bulk: The use of FORALL statements cuts down on ______ traffic.






33. Delimiters: The assignment operator.






34. I/O: The DBMS_OUTPUT procedure that sets the size of the output buffer.






35. Types of blocks: Procedures and functions are _______ blocks.






36. A CASE expression ends with _____.






37. DBMS_DDL.CREATE_WRAPPED: wraps and _______ the source code passed to it.






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






39. Fundamental: What is the exponentiation operator?






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






41. Wrapped code (is / is not) not backward compatible.






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






43. Triggers: You create a trigger with the _______ ________ statement.






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






45. What are the 3 values of the BOOLEAN data type?






46. Triggers: The clause to make a trigger run before inserting or updating table EMPS.






47. The attribute used to get the type of a column or variable without knowing what it is.






48. Static typing is also called _____ typing.






49. To recompile a procedure - use the _____ ______ command.






50. Simple CASE statement checks for different values of a single _________







Sorry!:) No result found.

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