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. Fundamental: What are the 3 compound symbols for 'not equal to'?






2. Give the ANSI Date literal for December 25 - 2005.

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


3. Command to assign to variables from a cursor.






4. Delimiters: The remote access symbol.






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






6. Cursors: The FOR UPDATE phrase goes at the (beginning/end) of the cursor definition.






7. Are good for logging table DML operations.






8. Value of PLSQL_OPTIMIZE_LEVEL that prevents optimization.






9. Triggers: By default - a trigger is created in the ______ state.






10. Web: mod_plsql is an implementation of the PL/SQL _________.






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






12. To run TCL or DDL statements - a trigger (must / must not) be autonomous .






13. Exceptions: The ________ function returns the current error code.






14. A __________ can have an AUTHID property






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






16. The lowest index of a VARRAY is ___.






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






18. Triggers: If two or more triggers are defined with the same timing point - then you can control the firing order using the ________ clause.






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






20. The _______ package lets you wrap dynamically generated PL/SQL.






21. Dbms_sql: The return type DBMS_SQL.open_cursor.






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






23. A national character literal is composed of characters in the ________ character set.






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






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






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






27. GOTO branches to a ________.






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






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






30. Dbms_sql: The integer returned by OPEN_CURSOR is a _____ _____.






31. Default file extension of wrap's input file.






32. The values defined in PLSQL_CCFLAGS can be referenced as _____ directives.






33. Mode designation for an input/output parameter.






34. Cursors: The value of SQL%ROWCOUNT after a SELECT INTO statement returns more than one row.






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






36. Fundamental: One of the 4 types of lexical units: L_____






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






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






39. Cursors: The four cursor attributes - in alphabetical order.






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






41. Fundamental: One of the 4 types of lexical units: d_____






42. Types: Which type of arithmetic does NUMBER use - library or hardware?






43. Delimiters: The left label delimiter.






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






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






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






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






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






49. Give the first line of the FOR loop with index i going from 1 to 10 in reverse.






50. The default value of the AUTHID property.