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. Advantage: Caching of programs and sharing among users lowers _______ requirements.






2. Dbms_sql: The integer returned by OPEN_CURSOR is a _____ _____.






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






4. Cursors: Give the first 3 words to open a cursor variable called cv.






5. I/O: The output from DBMS_OUTPUT will display (during/after) program execution.






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






7. DynSQL: The colon-prefixed names used in EXECUTE IMMEDIATE are called ________.






8. A __________ can have an AUTHID property






9. The declaration section is (optional/mandatory).






10. To use a TYPE declared in the database - a PL/SQL block has to have _______ privilege on the type.






11. In Native Mode - PL/SQL code is compiled into ______ ______.






12. Cursors: A cursor FOR loop can use an explicit or an _______ cursor.






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






14. I/O: This package has hypertext functions that generate HTML tags






15. The compiler directive used to select which code to compile.






16. Types: Which type of arithmetic does NUMBER use - library or hardware?






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






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






19. The command used to populate PLSQL_CCFLAGS.






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






21. Cursors: A cursor that lives in session memory until the session ends.






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






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






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






25. Conditional ______ allows backward compability with older database versions.






26. Cursors: The statement that closes a cursor.






27. Cursors: You cannot use cursor attributes in _______ statements.






28. Types: ________ data types have internal components.






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






30. Advantage: Performance: PL/SQL automatically creates ______ variables for variables in WHERE and VALUES clauses.






31. An anonymous block is a(n) ____ statement.






32. Exceptions: The maximum length of an Oracle error message is ____ characters






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






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






35. The BETWEEN operator is (inclusive / exclusive).






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






37. Declaration of a varchar2 constant - called vname - with value 'x'.

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


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






39. True encryption is done with package __________.






40. After the RESULT_CACHE clause - you can put a _________ clause to enable dependency-checking.






41. The 2 characters that begin all inquiry directives.






42. In interpreted mode - PL/SQL code is run in a _______ _______.






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






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






45. What are two categories of SQL functions that cannot be used in procedural statements?






46. Delimiters: Statement terminator.






47. Cursors: What implicit cursor attribute gives row counts for a FORALL statement?






48. I/O: Max number of bytes DBMS_OUTPUT can handle in a session.






49. Command used to execute dynamic SQL.






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







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