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 inquiry directive that gives the current line number in the procedure.






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






3. Cursors: Which cursor attribute is not meaningful for an implicit cursor?






4. Declare a variable r whose type is that of the records in table t.






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






6. Types: One of the scalar data types specific to PL/SQL: P________






7. Triggers: An INSTEAD OF trigger (can/cannot) be conditional.






8. I/O: To make sure the DBMS_OUTPUT buffer will be flushed - put a WHEN ______ clause in the EXCEPTION section of your outer block.






9. Cursors: If no SELECT or DML statement has run - the value of SQL%ROWCOUNT is what?






10. By default - OUT and IN OUT parameters are passed by _____.






11. Cursors: Give the statement to fetch data from cursor variable CV into MyVar.






12. Characters that begin a multi-line comment.






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






14. Term for a character literal with zero characters.






15. I/O: Max number of bytes to pass in a call to DBMS_OUTPUT.PUT_LINE.






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






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






18. Exceptions: The ________ function returns the current error code.






19. A large OUT or IN OUT parameter will waste a lot of space and CPU if it is passed by _____.






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






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






22. Loops: What is the index range operator in a FOR loop?






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






24. Where an external subprogram is stored.






25. Bulk: The two features that comprise Bulk SQL are:






26. With static typing - type checking is done at ______ time.






27. Declare an unconstrained subtype of NUMBER called NUMB.






28. Declare an associative array type - t - whose elements are of type rPerson - and whose index is PLS_INTEGER.






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






30. Abbreviation for Abstract Data Type.






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






32. The values defined in PLSQL_CCFLAGS can be referenced as _____ directives.






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






34. Types: In addition to the SQL data types - PL/SQL has ___ more scalar data types.






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






36. The Wrap utility (does / does not) encrypt source code.






37. A CASE expression ends with _____.






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


39. A PL/SQL extension to the WHERE clause of the SQL statements UPDATE and DELETE






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






41. Fundamental: What are the 3 compound symbols for 'not equal to'?






42. The _______ package lets you wrap dynamically generated PL/SQL.






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






44. Cursors: The index variable in a cursor FOR loop (does/does not) need to be declared.






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






46. In a collection - the internal components always have the _____ data type.






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






48. DynSQL: The main command for Native Dynamic SQL.






49. The method to add one or more elements to a nested table or VARRAY is ______.






50. Default file extension of wrap's input file.






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