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. How to reference a variable V declared in a block labelled L: ____.






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






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






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






5. A (simple / searched) CASE statement begins with CASE <expression>.






6. TCL: Create a savepoint called ab






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






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






9. Triggers: The code in a trigger is actually an ________ block.






10. An INSTEAD OF trigger is used - e.g - when you want to insert into a complex _____.






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






12. NAN stands for _________.






13. Command to assign to variables from a cursor.






14. Triggers: A compound trigger can fire at more than one ______ point.






15. The EXTEND method is not used with ______ _______.






16. Advantage: Having procedures stored and executed on the server makes PL/SQL ________.






17. Wrapped code (is / is not) not backward compatible.






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






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






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






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






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






23. Exceptions: You cannot GOTO from an exception handler back into the __________ block.






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






25. Types: The PL/SQL type that is identical to PLS_INTEGER.






26. Abbreviation of invoker's rights






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






28. Web: Abbreviation of PL/SQL Server Page.






29. The lowest index of a VARRAY is ___.






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






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






32. Cursors: Give the statement for getting out of a FETCH loop for cursor CV.






33. In interpreted mode - PL/SQL code is run in a _______ _______.






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






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






36. The names of Java objects in Oracle can be up to __ characters in length.






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






38. A FOR loop can be indexed by numbers or by a ______.






39. Declare an output NUMBER parameter - v1 - that defaults to 10.






40. Define a record variable r - of type tRec - initialized with values 9 and 'Jones' in its two fields.

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


41. The declaration section is (optional/mandatory).






42. Triggers: There are __ types of triggers.






43. VARRAYs are (always / never) sparse.






44. INSTEAD OF triggers are alternatives to ___ triggers






45. Types: The predefined subtype of PLS_INTEGER that has the NOT NULL constraint.






46. Cursors: A session cursor that a PL/SQL user creates and manages.






47. A type of compiler directive - begins with 's'.






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






49. Define a nested table type - tN - which is a table NUMBERs.






50. Into nested table ex - put elements of tbl1 that are not in tbl2.







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