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. Cursors: The two keywords in a mere cursor declaration (one is optional).






2. I/O: The DBMS_OUTPUT function that writes output WITH a newline character.






3. To enable result-caching for a function - use the _____________ clause.






4. Declare an input/output NUMBER parameter - v3.






5. I/O: This package does email.






6. Declare an unconstrained subtype of NUMBER called NUMB.






7. Types: One of the scalar data types specific to PL/SQL: P________






8. A type of compiler directive - begins with 'e'.






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






10. I/O: The DBMS_OUTPUT buffer will not be flushed until it is full or until the current PL/SQL block _________.






11. A GOTO cannot branch into an...






12. If a procedure fails - an OUT parameter passed to it by value (will / will not) be passed back with changes.






13. Cursors: WHERE _______ ______ makes an UPDATE or DELETE apply to the current row of a cursor.






14. Delimiters: Single-line comment marker.






15. By default - OUT and IN OUT parameters are passed by _____.






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






17. Dbms_sql: DBMS_SQL package is compiled with _______ rights.

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


18. When a parameter is passed by reference - changes made to it inside the procedure cannot be undone. True/False.






19. By default - an IN parameter is passed by ______.






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






21. The inquiry directive that gives the current line number in the procedure.






22. With static typing - type checking is done at ______ time.






23. Fundamental: Delimiters are _____ and _____ symbols.






24. The 2 characters that begin all inquiry directives.






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






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






27. The method to add one or more elements to a nested table or VARRAY is ______.






28. Subprograms are stored in __________ form.






29. The four keywords that define a PL/SQL block.






30. I/O: The string table type in DBMS_OUTPUT for holding lines of text.






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






32. Exceptions: The _________ package defines the PL/SQL environment.






33. In interpreted mode - the PL/SQL VM interprets the _________.






34. Give the clause you add to a CREATE TABLE statement - when there is a collection column myColl - that you want to be stored in a table called myCollTab.






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


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






37. Types: One of the scalar data types specific to PL/SQL: b_____.






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






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






40. Cursors: Define a ref cursor type called T.






41. A GOTO statement can branch from an exception handler into...






42. A CASE expression ends with _____.






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






44. Triggers: There are __ types of triggers.






45. Exceptions: Start of the range of error codes for RAISE_APPLICATION_ERROR.






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






47. Declare an input NUMBER parameter - v2 - that defaults to 20.






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






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






50. The _____ and ____ _____ collection types can be used in database table columns.







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