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. Types: PL/SQL has all the _____ data types.






2. IDs: List the two types of user-defined identifiers.






3. Wrap ______=xxxx oname=zzzzz






4. Declare an unconstrained subtype of NUMBER called NUMB.






5. The exception raised when a SELECT INTO statement returns more than one row.






6. The command used to populate PLSQL_CCFLAGS.






7. INSTEAD OF triggers are alternatives to ___ triggers






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






9. The three types of compiler warnings.






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






11. You have to use _______ SQL to run DDL statements n PL/SQL.






12. The variable showing the user id of the session owner.






13. Triggers: There are __ types of triggers.






14. Fundamental: Maximum string length of a PL/SQL variable.






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






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






17. Which two of these built-in SQL functions can be used in procedural (PL/SQL) statements: DECODE - CORR - UPPER - SUM - COALESCE - DEREF.






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






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






20. Command used to execute dynamic SQL.






21. The 2 characters that begin all inquiry directives.






22. Triggers: To simulate having triggers on SELECT statements - you can try ___ (3-letter acronym).






23. Mode designation for an input/output parameter.






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






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






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






27. Give the value list in the PLSQL_WARNINGS parameter to turn on SEVERE compiler warnings and make compiler warning 06002 be an error.

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


28. Where an external subprogram is stored.






29. Cursors: What are the 3 possible values of SQL%FOUND and SQL%NOTFOUND?






30. The default value of the AUTHID property.






31. Cursors: You give an explicit cursor a name and associate it with a _______.






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






33. Pkgs: The _______ package gives access to such SQL things as ALTER SESSION.






34. Wrap iname=xxxx _____=zzzzz






35. A PL/SQL extension to the WHERE clause of the SQL statements UPDATE and DELETE






36. Cursors: The SQL%FOUND attribute has how many possible values?






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






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






39. _______ arrays can be sparse or dense - depending on how you fill them.






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






41. The PL/SQL ________ evaluates compiler directives.






42. A CASE expression ends with _____.






43. IDs: You can use a reserved word as a _______ user-defined identifier.






44. Cursors: Give the statement to close cursor C.






45. Cursors: The value of SQL%ISOPEN is always ______.






46. DynSQL: EXECUTE IMMEDIATE does both dynamic SQL and dynamic _______.






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






48. Fundamental: What is the range operator?






49. Delimiters: the attribute indicator.






50. A unit with AUTHID = CURRENT_USER is an ________ rights unit.

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