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. A CASE expression ends with _____.






2. Fundamental: identifiers (include/do not include) reserved words.






3. Cursors: A cursor variable's type must be a ____ ______ type.






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






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






6. A kind of variable used as a placeholder.






7. Two types of stored subprograms.






8. The BETWEEN operator is (inclusive / exclusive).






9. Cursors: The second keyword of a FETCH statement.






10. Fundamental: Character used to escape a single quote inside a literal.

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


11. Keyword for doing assignment to a variable with SELECT.






12. Triggers: In a DML trigger - the phrase that makes the trigger run for every affected record.






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






14. Command to make a no-op (omit semicolon).






15. Conversion: Implicit conversion can be (faster / slower) than explicit conversion.






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






17. Exceptions: The maximum length of an Oracle error message is ____ characters






18. You (can/cannot) put a label before an END LOOP statement.






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






20. IDs: How an ordinary user-defined identifier must begin.






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






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






23. Cursors: The SQL%BULK_ROWCOUNT attribute is an _________ -






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






25. An autonomous program runs in its own __________.






26. Types: One of the scalar data types specific to PL/SQL: R_________.






27. Mode designation for an input/output parameter.






28. The NOCOPY option on an OUT or IN OUT parameter - causes it to be passed by ______.






29. Nested tables can become sparse via ______.






30. DynSQL: The colon-prefixed names used in EXECUTE IMMEDIATE are called ________.






31. Parameter that controls how much Oracle optimizes your PL/SQL code on compilation.






32. Triggers: In a trigger - you cannot issue a COMMIT or a ______.






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






34. Advantage: Performance: Storing and runnng procedures on the server minimizes ______ traffic.






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






36. The DEFINITION of a cursor is the _____ that returns the records.






37. Set flag bb true: ALTER SESSION SET PLSQL_CCFLAGS= '____'






38. Wrapping can be done with the ____ executable.






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






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






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






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






43. Exceptions: Declare an exception called E.






44. Default value of PLSQL_OPTIMIZE_LEVEL.






45. The FOR UPDATE OF clause references a (table / column).






46. Triggers: The clause to make a trigger run once for every affected row.






47. Cursors: Give the statement to open cursor C that takes parameter p.






48. Nested tables are multisets - meaning that there is no inherent _____ of their elements.






49. To get the current value of CURRENT_SCHEMA - CURRENT_USER - or SESSION_USER - use the ____ function.






50. Delimiters: Single-line comment marker.