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. A (simple / searched) CASE statement begins with CASE <expression>.






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






3. An autonomous program runs in its own __________.






4. Advantage: PL/SQL runs anywhere Oracle runs - so it is very ________.






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






6. _____ arrays cannot be used as the type of an Oracle table column.






7. The DEFINITION of a cursor is the part after the keyword __.






8. Exceptions: Associate exception E with error code -1.






9. Advantage: Having procedures stored and executed on the server makes PL/SQL ________.






10. With Edition-based Redefinition enabled - the unique specification of an object requires OWNER - OBJECT_NAME and ___________.






11. I/O: One of the 3 types of data that can be passed to the DBMS_OUTPUT buffer.






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






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






14. The meaning of 'FGA'.






15. Cursors: The value of SQL%ROWCOUNT after a SELECT INTO statement returns more than one row.






16. PL/SQL is a ________ typed programming language.






17. Fundamental: identifiers (include/do not include) reserved words.






18. To run DDL statements - a trigger must be autonomous and must use ______ ______ SQL.






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






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






21. Types: The PL/SQL type that is identical to PLS_INTEGER.






22. Triggers: You (can/cannot) explicitly invoke a trigger.






23. DynSQL: The clause that supplies bind arguments to EXECUTE IMMEDIATE.






24. Triggers: The clause to make a trigger run before inserting or updating table EMPS.






25. The 2 characters that begin all inquiry directives.






26. Delimiters: the attribute indicator.






27. Triggers: The code in a trigger is actually an ________ block.






28. Exceptions: Write the call (2 args) to associate message 'Bad' with error code -20 -100.

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


29. Fundamental: Labels furnish targets for GOTO and _____ statements.






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






31. Triggers and views always have _________ rights.

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


32. A value that is neither represented by an identifier nor calculated from other values.






33. What do you FETCH from?






34. A kind of variable used as a placeholder.






35. True encryption is done with package __________.






36. A basic PL/SQL datatype that SQL does not have.






37. Command to assign to variables from a cursor.






38. Subprograms are stored in __________ form.






39. Triggers: An INSTEAD OF trigger is (always/never) a row-level trigger.






40. IDs: The two types of words that can - but should not - be used as user-defined identifiers.






41. Exceptions: The three words that can be used to guarantee all exceptions will be handled.






42. IDs: List the two types of user-defined identifiers.






43. Fundamental: Character used to escape a single quote inside a literal.

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


44. Declare an input/output NUMBER parameter - v3.






45. Wrapped code (is / is not) not backward compatible.






46. To run a PIPE ROW statement in your autonomous routine - you must close any _____________.






47. DBMS_DDL.WRAP returns a string containing wrapped _____ _____.






48. IDs: The type of words that cannot be user-defined identifiers.






49. Exceptions: Type ______ to re-raise the current exception.






50. Bulk: The keywords of a bulk collect FETCH statement.







Sorry!:) No result found.

Can you answer 50 questions in 15 minutes?


Let me suggest you:



Major Subjects



Tests & Exams


AP
CLEP
DSST
GRE
SAT
GMAT

Most popular tests