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. Declare an unconstrained subtype of NUMBER called NUMB.






2. The LIMIT method is only meaningful for _______.






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






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






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


6. Nested tables are multisets - meaning that there is no inherent _____ of their elements.






7. What do you FETCH from?






8. In the IF syntax - is if ENDIF or END IF?






9. Cursors: The three keywords in a full cursor declaration/definition (before the SELECT).






10. With a result-cached function - it uses a cached value when the function is called again with the...






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






12. To exit an active autonomous transaction without causing an exception - you must issue _____ or ______.






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






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






15. I/O: The buffered output of dbms_output.put_line is retrieved by _______.






16. Dbms_sql: A cursor opened with OPEN_CURSOR (can/cannot) be reused for multiple queries without first closing it.






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






18. Language that PL/SQL is derived from.






19. Triggers and views always have _________ rights.

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


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






21. The FOR UPDATE OF clause references a (table / column).






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






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






24. Abbreviation of invoker's rights






25. Bytecode is _______ _______ code.






26. Type: A __________ subtype has only a subset of the values of its base type.






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






28. Exceptions: Declare an exception called E.






29. I/O: The most basic PL/SQL way to give output to the user.






30. Fundamental: One of the 4 types of lexical units: c_____.






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






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






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






34. IDs: You can use a reserved word as a _______ user-defined identifier.






35. Characters that begin a single-line comment.






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






37. The PL/SQL virtual machine turns bytecode into system ______.






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






39. Cursors: The type definition of a WEAK ref cursor type has no _______ clause.






40. Exceptions: The ________ handler must always be the last handler.






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






42. Fundamental: A label can be used to name an ______ block.






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






44. Command to create a procedure.






45. Exceptions: Some internal exceptions have ________ names.






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






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






48. (from inside a package) Declare a function f - that takes a number n - returns a number - and caches results - depending on table EMPS.






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






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