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 $ERROR directive is used to make compilation ____.






2. With static typing - type checking is done at ______ time.






3. Exceptions: A GOTO statement cannot branch into an _______ ________.






4. A GOTO cannot branch into a...






5. GOTO branches to a ________.






6. A (simple / searched) CASE statement begins with CASE WHEN <boolean expression>.






7. Abbreviation for Abstract Data Type.






8. Fundamental: What is the exponentiation operator?






9. Exceptions: Declare an exception called E.






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






11. The three possible values of a BOOLEAN literal.






12. Wrap iname=xxxx _____=zzzzz






13. How many PL/SQL collection types are there?






14. DynSQL: In EXECUTE IMMEDIATE - the statement string can use either placeholders - or string ________.






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






16. Cursors: The value of SQL%ISOPEN is always ______.






17. Triggers: On a non-editioning view - you can only define __________ triggers.






18. After the RESULT_CACHE clause - you can put a _________ clause to enable dependency-checking.






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






20. The _____ and ____ _____ collection types can be used in database table columns.






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






22. Clause added to a cursor to use it with WHERE CURRENT OF.






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






24. Types: One of the scalar data types specific to PL/SQL: R_________.






25. You can have many autonomous transactions in ___________.






26. Give the ANSI Date literal for December 25 - 2005.

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


27. Cursors: An explicit cursor (can/cannot) accept parameters.






28. Cursors: Give the statement to fetch data from cursor variable CV into MyVar.






29. You can define PL/SQL collections using TYPEs defined in the _______.






30. NAN stands for _________.






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






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


33. Delimiters: The assignment operator.






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






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






36. Advantage: PL/SQL is PORTABLE to any OS where ________ runs.






37. Mode designation for an input parameter.






38. Nested tables can become sparse via ______.






39. Fundamental: Delimiters are _____ and _____ symbols.






40. Give the value list in the PLSQL_WARNINGS parameter to turn on SEVERE compiler warnings and make compiler warning 06002 be an error.

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


41. Cursors: Define a ref cursor type called T.






42. Assigning values to PL/SQL variables that appear in SQL statements is called _______.






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






44. I/O: This package lets PL/SQL programs read and write OS files.






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






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






47. Cursors: A cursor with a name is an _________ cursor.






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






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






50. Which collection type is bounded?







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