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: If an exception is raised inside a cursor loop - the cursor (is / is not) also closed automatically.






2. Dbms_sql: This DBMS_SQL function opens a new cursor.






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






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






5. Delimiters: The assignment operator.






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






7. A subprogram defined within another subprogram is a _______ subprogram.






8. Triggers and views always have _________ rights.

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


9. Conversion: Implicit conversion is not always predictable; it is _______-sensitive. And its rules might change.






10. Which collection type is bounded?






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






12. Cursors: Give the statement to fetch data from cursor C into variable V.






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






14. Type: An ________ subtype has all the values of its base type.






15. Cursors: The SQL%FOUND attribute has how many possible values?






16. Cursors: The Oracle predefined REF CURSOR type.






17. Give the statement to make a program autonomous.






18. You cannot bulk collect into an ARRAY OF ________.






19. With a result-cached function - it uses a cached value when the function is called again with the...






20. Cursors: SYS_REFCURSOR is a predefined type based on _____ ______.






21. Conversion: Implicit conversion can be (faster / slower) than explicit conversion.






22. The _______ package lets you wrap dynamically generated PL/SQL.






23. Cursors: The type definition of a WEAK ref cursor type has no _______ clause.






24. Triggers: You (can/cannot) explicitly invoke a trigger.






25. How many types of compiler directives are there?






26. If you are in a procedure inside a package - the compilation unit is the _______.






27. PL/SQL is a ________ typed programming language.






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






29. What is the simplest statement for conditionally getting out of simple loop?






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






31. Advantage: Caching of programs and sharing among users lowers _______ requirements.






32. Advantage: PL/SQL gives SCALABILITY because stored procedures are executed on the _______.






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






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






35. Declare an unconstrained subtype of NUMBER called NUMB.






36. A SELECT statement with the FOR UPDATE clause puts a ______ on the selected rows.






37. Searchable CASE statement: Each WHEN has its own _______ condition.






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






39. The RESULT_CACHE clause has to be in both the declaration and in the ______ of the function.






40. The two kinds of CASE statements are simple and ________.






41. Make a FOR loop that executes NULL 10 times counting in reverse - using index i.






42. Conditional compilation is useful for compiling a program under different ______ of Oracle.






43. Exceptions: The ________ function returns the error message associated with an error code.






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






45. Associative array types (can / cannot) be defined in the database.






46. I/O: The PL/SQL I/O packages (can/cannot) accept input directly from the keyboard.






47. PLS_INTEGER has its arithmetic implemented in ________ - so it is very fast.






48. In Native Mode - PL/SQL code is compiled into ______ ______.






49. Cursors: A Cursor FOR loop does not use a ______ statement.






50. To run TCL or DDL statements - a trigger (must / must not) be autonomous .