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 subprogram created inside a block is a _________ subprogram.






2. A numeric FOR loop cannot _________ by other than 1?






3. Delimiters: The component indicator/selector.






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






5. Exceptions: An exception in the declarations section does not go to the __________ section.






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






7. Bytecode is _______ _______ code.






8. DynSQL: In EXECUTE IMMEDIATE - the statement string can use either placeholders - or string ________.






9. The DEFINITION of a cursor is the part after the keyword __.






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






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






12. Triggers: In a per-row trigger - the ____ record shows you the changed state of an affected row.






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






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






15. Conversion: If the specific value is suitable - ____ or _______ values can convert to almost any datatype






16. _________ exceptions can not be trapped with an error handler






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






18. Unlike the CASE statement - the CASE expression does not have the...






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






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






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






22. Language that PL/SQL is derived from.






23. Data dictionary view that shows the compiler settings for each compiled object.






24. In short-circuit evaluation - IF-conditions are only evaluated up to where the outcome ___________.






25. I/O: This DBMS_OUTPUT proc retrieves one line from the buffer.






26. For a collection - the NEXT method gets the next higher (element / index).






27. Declaration of a varchar2 constant - called vname - with value 'x'.

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


28. 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


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






30. An editioning view is like an ____ for a table.






31. Dbms_sql: A cursor opened with OPEN_CURSOR (can/cannot) be reused for multiple queries without first closing it.






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






33. True encryption is done with package __________.






34. For a collection - the NEXT method returns ____ when there is no next index value.






35. The SET TRANSACTION statement affects only the ____________.






36. Triggers: INSTEAD OF triggers only run on ______ views.






37. Exceptions: An exception raised inside an _______ _______ propagates immediately to the enclosing block






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






39. In a collection - the internal components are called _______.






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






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






42. A unit with AUTHID = DEFINER is a ________ rights unit.

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


43. Fundamental: Which one of these is a simple symbol: a - = - !=






44. Java - C or other program called directly in PL/SQL.






45. 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


46. Delimiters: Item separator.






47. Cursors: Only a _____ _____ cursor can appear in the CURRENT OF clause of an UPDATE or DELETE statement.






48. An anonymous block always has _________ rights.

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


49. Cursors: The values plugged into the DML in a FORALL must come from existing - populated _________.






50. FOR-Looping over a collection from FIRST to LAST only works if the collection is _______.







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