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. CREATE TYPE cannot be used for _______ array types.






2. I/O: This DBMS_OUTPUT proc retrieves one line from the buffer.






3. For a collection - the NEXT method gets the next higher (element / index).






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






5. The $ERROR directive is used to make compilation ____.






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






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






8. Types: One of the 4 PL/SQL things that have a data type (begins with 'c').






9. Exceptions: Associate exception E with error code -1.






10. What do you FETCH from?






11. Cursors: A cursor FOR loop can use an explicit or an _______ cursor.






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






13. An editioning view can only select a subset of the columns from the base table and provide ________ for them






14. The LIMIT method is only meaningful for _______.






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






16. The compiler directive governing conditional compilation.






17. Labels for blocks and statements are enclosed in '__' brackets.






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






19. The lowest index of a nested table is ___.






20. Triggers: To simulate having triggers on SELECT statements - you can try ___ (3-letter acronym).






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






22. Types: Which type of arithmetic does NUMBER use - library or hardware?






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






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






25. You (can / cannot) wrap trigger source code.






26. If an initialized collection has no elements - FIRST and LAST return _____.






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






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






29. The AUTHID property applies to PL/SQL objects that contain _____.






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


31. Advantage: PL/SQL is tightly _______ with Oracle SQL.






32. Declare a cursor c with no parameters - and return type rC.






33. The three possible values of a BOOLEAN literal.






34. Cursors: What are the 3 possible values of SQL%FOUND and SQL%NOTFOUND?






35. Advantage: Performance: Storing and runnng procedures on the server minimizes ______ traffic.






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






37. A __________ can have an AUTHID property






38. A FOR-loop counter is defined only within the _____.






39. Dbms_sql: The return type DBMS_SQL.open_cursor.






40. SIMPLE_INTEGER is like PLS_INTEGER - but it does not allow ____ values - and it does not raise overflow exceptions.






41. I/O: The output from DBMS_OUTPUT will display (during/after) program execution.






42. In the special IF syntax - is it ELSIF - or ELSEIF?






43. I/O: To make sure the DBMS_OUTPUT buffer will be flushed - put a WHEN ______ clause in the EXCEPTION section of your outer block.






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






45. What is the exception that is implicitly raised in a CASE statement with no ELSE clause?






46. The $IF must evaluate a ______ _______ expression.






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






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






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






50. How many times are a FOR loop's index bounds evaluated?