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: Give the first 3 words to open a cursor variable called cv.






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






3. Cursors: Give the statement for getting out of a FETCH loop for cursor CV.






4. A kind of variable used as a placeholder.






5. Internally - the NUMBER type is stored as ______. Therefore - decimal numbers (such as prices) are stored exactly - with no rounding.






6. Cursors: WHERE _______ ______ makes an UPDATE or DELETE apply to the current row of a cursor.






7. Mode designation for an input/output parameter.






8. A nested table has to be initialized using a ________ - named the same as the type.






9. Conversion: Just about everything will implicitly convert to _____ or _________.






10. Types: A data type family consists of a ______ type and its subtypes.






11. Bytecode is _______ _______ code.






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






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






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






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






16. What are the two sequence pseudo-columns?






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






18. Command to make a no-op (omit semicolon).






19. Cursors: Opening keyword of a cursor FETCH loop.






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






21. Advantage: Performance: Stored subprograms are ______ in memory.






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






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






24. Two types of stored subprograms.






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






26. Types: The only Oracle datetime type that doesn't begin with TIMESTAMP is ________.






27. The FIRST method gets the first (element / index) of a collection.






28. What word is in a function header but not in a procedure header?






29. DynSQL: The main command for Native Dynamic SQL.






30. Which two collection types are unbounded?






31. Give the statement to make a program autonomous.






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






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


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






35. Dbms_sql: The return type DBMS_SQL.open_cursor.






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






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






38. The _____ utility turns PL/SQL source code into unreadable text.






39. Cursors: Only a _____ _____ cursor can appear in the CURRENT OF clause of an UPDATE or DELETE statement.






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






41. Give the first line of the FOR loop with index i going from 1 to 10 in reverse.






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






43. Exceptions: You can pass an ______ ________ to SQLERRM.






44. A record is a group of related data items stored in fields - each with its own...






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






46. To create a collection type - use the TYPE command in PL/SQL and the ______ _____ command in SQL.






47. Triggers: You create a trigger with the _______ ________ statement.






48. Where an external subprogram is stored.






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






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