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. The inquiry directive that gives the current line number in the procedure.






2. Types: Which type of arithmetic does PLS_INTEGER use - library or hardware?






3. A user-defined TYPE can have...






4. When a session starts - CURRENT_SCHEMA has the value of the schema owned by ___________.






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






6. The attribute used to get the type of a column or variable without knowing what it is.






7. Set flag bb true: ALTER SESSION SET PLSQL_CCFLAGS= '____'






8. I/O: The DBMS_OUTPUT function that writes output without a newline character.






9. The FORALL statement to loop over a collection MyList using index i.






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






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






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






13. Triggers and views always have _________ rights.

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


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


15. The collection method that tells the number of elements in the collection.






16. Records are one of the two kinds of PL/SQL _______ data types.






17. INSTEAD OF triggers are alternatives to ___ triggers






18. DynSQL: The clause that receives single-row query output from EXECUTE IMMEDIATE.






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


20. If a result-cached function's data source (based on the RELIES_ON clause) is updated - any cached results become _______.






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






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






23. A null string and a BOOLEAN null are _______ (same/not the same).






24. Types: The only PL/SQL type for which you can specify a range constraint.






25. The SET TRANSACTION statement affects only the ____________.






26. Default value of PLSQL_OPTIMIZE_LEVEL.






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






28. %ROWTYPE gets the type of a table or _______.






29. Advantage: PL/SQL runs anywhere Oracle runs - so it is very ________.






30. Exceptions: The keyword that begins an exception handler.






31. Exceptions: A GOTO statement CAN branch from an exception handler into an ________ block.






32. With an sparse - integer-indexed associative array - you (can / cannot) use a regular FOR loop.






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






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






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






36. Type: A __________ subtype has only a subset of the values of its base type.






37. Abbreviation of invoker's rights






38. This is a CASE (expression / statement): myvar := CASE num WHEN 1 THEN 'good' WHEN 2 THEN 'bad' END;






39. Triggers: In a DML trigger - the phrase that makes the trigger run for every affected record.






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






41. A type of compiler directive - begins with 'i'.






42. Delimiters: The association operator.






43. IDs: You cannot use reserved words as ______ user-defined identifiers.






44. CREATE TYPE cannot be used for _______ array types.






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






46. ______ SQL is a PL/SQL feature that allows SQL syntax directly in a PL/SQL statement.






47. A GOTO cannot branch into an...






48. Nested tables can become sparse via ______.






49. Cursors: Give the first 3 words to open a cursor variable called cv.






50. DynSQL: The clause that supplies bind arguments to EXECUTE IMMEDIATE.