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. Make a FOR loop that executes NULL 10 times counting in reverse - using index i.






2. Types: A ______ has the same valid operations as its base type.






3. Conversion: Just about everything will implicitly convert to _____ or _________.






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






5. Cursors: The Oracle predefined REF CURSOR type.






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






7. A pointer to a private SQL area that stores information about processing a specific SELECT or DML statement.






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






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






10. Cursors: Which cursor attribute is not meaningful for an implicit cursor?






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






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






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






14. In a sparse collection - the indexes of defined elements (do / do not) run in consecutive order.






15. Cursors: You can just declare a cursor at first - then _______ it later.






16. Exceptions: The package that defines pre-defined exceptions.






17. The _____ utility turns PL/SQL source code into unreadable text.






18. Mode designation for an input/output parameter.






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


20. Triggers: An INSTEAD OF trigger (can/cannot) be conditional.






21. Advantage: PL/SQL programs are stored centrally - making them more ______.






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






23. Types: PL/SQL has all the _____ data types.






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






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






26. DynSQL: Maximum string length to pass to EXECUTE IMMEDIATE.






27. Delimiters: Host variable indicator.






28. Declare a package procedure P with no arguments - and give it definer's rights.






29. 5 types of events that can have triggers: DML - DDL - INSTEAD OFs - database events - and ________ statements.






30. I/O: This package has hypertext procedures that generate HTML tags






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






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






33. The three types of compiler warnings.






34. Bulk: The keywords of a bulk collect FETCH statement.






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






36. The compiler directive governing conditional compilation.






37. Conversion: It is best to use (implicit / explicit) conversion.






38. (from inside a package) Declare a function f - that takes a number n - returns a number - and caches results - depending on table EMPS.






39. I/O: The buffered output of dbms_output.put_line is retrieved by _______.






40. Declare a cursor c with no parameters or return type.






41. Web: The gateway that allows a web browser to invoke a PL/SQL procedure through an HTTP listener.






42. You can put a label before any executable PL/SQL _________.






43. Wrapping can be done with the ____ executable.






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






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






46. Native compilation turns bytecode into ________ code.






47. Delimiters: The association operator.






48. IDs: What a quoted user-defined identifier is enclosed in.






49. Give the statement to make a program autonomous.






50. Types: The storage size of a NUMBER value is based on the number of ______ digits.







Sorry!:) No result found.

Can you answer 50 questions in 15 minutes?


Let me suggest you:

Browse all subjects

Browse all tests

Most popular tests



Major Subjects

Tests & Exams


AP
CLEP
DSST
GRE
SAT
GMAT

Browse all subjects

Browse all tests

Most popular tests