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. In the special IF syntax - is it ELSIF - or ELSEIF?






2. Give the statement to make a program autonomous.






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






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






5. The command used to populate PLSQL_CCFLAGS.






6. You (can / cannot) wrap trigger source code.






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






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






9. I/O: The DBMS_OUTPUT function that writes output without a newline character.






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






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






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






13. Cursors: Give the statement to close cursor C.






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






15. List the transaction control statements.






16. The two kinds of CASE statements are simple and ________.






17. Abbreviation for Abstract Data Type.






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


19. User-defined compiler directives are defined in this system compile parameter.






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






21. SIMPLE_INTEGER is like PLS_INTEGER - but it does not allow ____ values - and it does not raise overflow exceptions.






22. $$PLSQL_LINE and $$PLSQL_UNIT are ______-ly defined inquiry directives.






23. If a result-cached function's data source (based on the RELIES_ON clause) is updated - any cached results become _______.






24. Associative array types (can / cannot) be defined in the database.






25. Give the value list in the PLSQL_WARNINGS parameter to turn on SEVERE compiler warnings and make compiler warning 06002 be an error.

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


26. Cursors: How many DML statements can a FORALL statement contain?






27. I/O: This package sends text output to SQLPlus






28. Types: ________ data types have internal components.






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






30. A GOTO cannot branch into a...






31. Cursors: Define a ref cursor type called T.






32. A FOR-loop counter is defined only within the _____.






33. Data dictionary view giving the AUTHID values on a user's objects.






34. Cursors: The first two keywords in a Cursor FOR loop.






35. Triggers: Programmers (as opposed to DBAs) mostly make use of _____ triggers.






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






37. What do you FETCH from?






38. Fundamental: Delimiters are _____ and _____ symbols.






39. The RESULT_CACHE clause comes (before / after) the RETURN clause.






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






41. PLS_INTEGER has its arithmetic implemented in ________ - so it is very fast.






42. Dbms_sql: The return type DBMS_SQL.open_cursor.






43. Are good for logging table DML operations.






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






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






46. An incomplete type is a type created by a ______ type definition.






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






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






49. Cursors: What is the 'name' of the implicit cursor?






50. DynSQL: In EXECUTE IMMEDIATE - the statement string can use either placeholders - or string ________.







Sorry!:) No result found.

Can you answer 50 questions in 15 minutes?


Let me suggest you:

Browse all subjects

Browse all tests

Most popular tests



Major Subjects

Tests & Exams


AP
CLEP
DSST
GRE
SAT
GMAT

Browse all subjects

Browse all tests

Most popular tests