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 attribute used to get the type of a column or variable without knowing what it is.






2. Conditional ______ allows backward compability with older database versions.






3. By default - an IN parameter is passed by ______.






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






5. Types: ________ data types have internal components.






6. Collections are one of the two kinds of PL/SQL _______ data types.






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






8. The Wrap utility ________ the source code.






9. Exceptions: The maximum length of an Oracle error message is ____ characters






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






11. Statement to set current schema to x: _____ _____ SET CURRENT_SCHEMA = 'x';






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






13. The variable showing the user id that is automatically prepended to object names.






14. Declare a constrained subtype of NUMBER called N that is not null.






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






16. Default file extension of wrap's output file.






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






18. NAN stands for _________.






19. Default value of PLSQL_OPTIMIZE_LEVEL.






20. The NOCOPY option on an OUT or IN OUT parameter - causes it to be passed by ______.






21. IDs: You (can/cannot) use keywords as ordinary user-defined identifiers.






22. Types of blocks: A pl/sql block that is not stored in the database.






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






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






25. Exceptions: An exception raised inside an _______ _______ propagates immediately to the enclosing block






26. The EXTEND method is not used with ______ _______.






27. Kind of code created by the PL/SQL compiler.






28. In a sparse collection - the indexes of defined elements (do / do not) run in consecutive order.






29. Name the two types of FOR loop.






30. Conversion: If the specific value is suitable - ____ or _______ values can convert to almost any datatype






31. Dbms_sql: DBMS_SQL package is compiled with _______ rights.

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


32. Fundamental: One of the 4 types of lexical units: d_____






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






34. You can put a label before any executable PL/SQL _________.






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






36. List the transaction control statements.






37. The BEGIN section is (optional/mandatory)






38. Cursors: The statement that closes a cursor.






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






40. DynSQL: The three modes of arguments in the USING clause of EXECUTE IMMEDIATE.






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






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






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






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






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






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






47. The DECLARE keyword is only required in an _______ _______.






48. The meaning of 'FGA'.






49. The RESULT_CACHE clause has to be in both the declaration and in the ______ of the function.






50. Types: ______ data types are those storing values with no internal components.