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. List the transaction control statements.






2. I/O: The DBMS_OUTPUT procedure that sets the size of the output buffer.






3. Exceptions: If there is no handler for an exception - PL/SQL returns an ________ exception error to the invoker or host environment.






4. Triggers: A compound trigger can fire at more than one ______ point.






5. This is a CASE (expression / statement): CASE num WHEN 1 THEN goto LABEL1 WHEN 2 THEN var := 2 END CASE;






6. Mode designation for an output parameter.






7. Cursors: The first two keywords of a basic fetch statement.






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






9. Triggers: In a trigger - you cannot issue a COMMIT or a ______.






10. Statement to exit a cursor loop on cursor cGo when there are no more records.






11. IDs: The 3 non-alphanumeric characters that can be in an ordinary user-defined identifier.






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






13. Cursors: A cursor FOR loop cannot use a _______ variable.






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






15. The exception raised when a SELECT INTO statement returns more than one row.






16. The lowest index of a nested table is ___.






17. Which collection type is bounded?






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






19. Subprograms are stored in __________ form.






20. A FOR loop can be indexed by numbers or by a ______.






21. Cursors: A session cursor that a PL/SQL user creates and manages.






22. Types: The predefined subtype of PLS_INTEGER that has the NOT NULL constraint.






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






24. The four keywords that define a PL/SQL block.






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






26. A ___________ behaves like a table column - but it is not stored in the table.






27. From a block nested inside a procedure P - reference variable V of the outer procedure.






28. Dbms_sql: The DBMS_SQL procedure that closes a cursor.






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






30. Java - C or other program called directly in PL/SQL.






31. Cursors: The statement where you pass the parameters to a cursor.






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






33. Exceptions: Pragma that links an exception to an Oracle error code.






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






35. Cursors: Statement to end a loop when MyCur is used up: _____ ______ MyCur%NOTFOUND.






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






37. You have to use _______ SQL to run DDL statements n PL/SQL.






38. Exceptions: Each internal exception has an Oracle ______ _______.






39. Associative arrays (do / do not) have to be initialized with a constructor.






40. FOR-Looping over a collection from FIRST to LAST only works if the collection is _______.






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






42. Fundamental: What is the exponentiation operator?






43. Define a record type REC with number num and varchar2(10) name.






44. DBMS_DDL.CREATE_WRAPPED: wraps and _______ the source code passed to it.






45. The $IF must evaluate a ______ _______ expression.






46. Declare a cursor c with no parameters - and return type rC.






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






48. Cursors: The Oracle predefined REF CURSOR type.






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






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