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: The SQL%BULK_ROWCOUNT attribute is an _________ -






2. With dynamic typing - type checking is done at ______time.






3. Declare a variable r whose type is that of the records in table t.






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






5. In a FORALL loop - you (can / cannot) use the index variable for purposes other than indexing into the collection.






6. Set flag bb true: ALTER SESSION SET PLSQL_CCFLAGS= '____'






7. ______ SQL is a PL/SQL feature that allows SQL syntax directly in a PL/SQL statement.






8. The source for wrapping begins with the word ______.






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






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


11. When a session starts - CURRENT_SCHEMA has the value of the schema owned by ___________.






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






13. IDs: How an ordinary user-defined identifier must begin.






14. Dbms_sql: The return type DBMS_SQL.open_cursor.






15. Wrap iname=xxxx _____=zzzzz






16. Triggers: Unlike a stored procedure - you can enable and _____ a trigger.






17. Define a record variable r - of type tRec - initialized with values 9 and 'Jones' in its two fields.

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


18. Native compilation turns bytecode into ________ code.






19. Web: Abbreviation of PL/SQL Server Page.






20. Define a nested table type - tN - which is a table NUMBERs.






21. The command used to populate PLSQL_CCFLAGS.






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






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






24. 5 types of events that can have triggers: DML - DDL - INSTEAD OFs - database events - and ________ statements.






25. How to reference a variable V declared in a block labelled L: ____.






26. The allowed data types of user-defined conditional compilation directives are boolean and _______.






27. Delimiters: The remote access symbol.






28. Parameter that controls how much Oracle optimizes your PL/SQL code on compilation.






29. Advantage: PL/SQL supports ______-oriented programming.






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






31. Exceptions: An exception in the declarations section propagates to the enclosing _______.






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






33. Cursors: The keyword that makes a ref cursor type STRONG.






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






35. Exceptions: When an exception is raised inside a cursor FOR loop - the cursor is _______ implicitly.






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






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






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






39. I/O: The DBMS_OUTPUT function that writes output WITH a newline character.






40. Cursors: A pointer to a cursor is called a ______ _______.






41. Triggers: If two or more triggers are defined with the same timing point - then you can control the firing order using the ________ clause.






42. Abbreviation of definer's rights






43. Triggers: When using the NEW or OLD pseudo-records in the body of the trigger - they must be prefixed with a _______.






44. A null string and a BOOLEAN null are _______ (same/not the same).






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






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






47. Cursors: Which cursor attribute is not meaningful for an implicit cursor?






48. Characters that begin a multi-line comment.






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






50. Exceptions: An exception in the declarations section does not go to the __________ section.