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. Fundamental: One of the 4 types of lexical units: c_____.






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






3. Delimiters: The assignment operator.






4. DynSQL: EXECUTE IMMEDIATE can be used for any SQL statement or PL/SQL block - except for ________ queries.






5. Dbms_sql: The integer returned by OPEN_CURSOR is a _____ _____.






6. Command to create a procedure.






7. Unlike the CASE statement - the CASE expression does not have the...






8. Fundamental: What are the 3 compound symbols for 'not equal to'?






9. Cursors: Give the statement to open cursor C.






10. The meaning of 'FGA'.






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






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






13. I/O: If the current (outermost) PL/SQL block ends with an unhandled exception - the output buffer will not be ___________.






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






15. Command used to execute dynamic SQL.






16. Cursors: If you use an EXIT statement to exit a cursor FOR loop prematurely - the cursor (is / is not) closed automatically.






17. An INSTEAD OF trigger is used - e.g - when you want to insert into a complex _____.






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






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






20. An autonomous program runs in its own __________.






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






22. Cursors: What is the 'name' of the implicit cursor?






23. PLSQL_CCFLAGS hold a comma-separated list of ______ pairs (hyphenated).






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






25. Which two collection types are unbounded?






26. Types: One of the scalar data types specific to PL/SQL: b_____.






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






28. Dbms_sql: The DBMS_SQL procedure that will execute a DDL or DML statement.






29. True encryption is done with package __________.






30. _________ exceptions can not be trapped with an error handler






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






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






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






34. A (simple / searched) CASE statement begins with CASE <expression>.






35. Triggers: By default - a trigger is created in the ______ state.






36. Exceptions: Some internal exceptions have ________ names.






37. In 11g you can directly reference _____________ in PL/SQL.






38. Advantage: Having procedures stored and executed on the server makes PL/SQL ________.






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






40. _____ arrays cannot be used as the type of an Oracle table column.






41. Give the clause you add to a CREATE TABLE statement - when there is a collection column myColl - that you want to be stored in a table called myCollTab.






42. The Wrap utility (does / does not) encrypt source code.






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






44. Delimiters: The association operator.






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


46. Declaration of a varchar2 constant - called vname - with value 'x'.

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


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






48. To run a PIPE ROW statement in your autonomous routine - you must close any _____________.






49. Pkgs: The _______ package gives access to such SQL things as ALTER SESSION.






50. Command to delete a procedure.