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. Fundamental: One of the 4 types of lexical units: i_____






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






3. Characters that end a multi-line comment.






4. Cursors: WHERE _______ ______ makes an UPDATE or DELETE apply to the current row of a cursor.






5. This is a CASE (expression / statement): myvar := CASE num WHEN 1 THEN 'good' WHEN 2 THEN 'bad' END;






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






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






8. INSTEAD OF triggers are alternatives to ___ triggers






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






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






11. Dbms_sql: This DBMS_SQL function opens a new cursor.






12. For an associative array - the FIRST method gets the (lowest / first-created) index.






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






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






15. Data dictionary view that shows the compiler settings for each compiled object.






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






17. Exceptions: An exception raised inside an _______ _______ propagates immediately to the enclosing block






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






19. Advantage: PL/SQL programs are stored centrally - making them more ______.






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






21. Exceptions: When an exception is raised inside a cursor FOR loop - the cursor is _______ implicitly.






22. Set flag bb true: ALTER SESSION SET PLSQL_CCFLAGS= '____'






23. A CASE statement ends with ____ ____.






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






25. Web: Abbreviation of PL/SQL Server Page.






26. A kind of variable used as a placeholder.






27. Unlike the CASE statement - the CASE expression does not have the...






28. Searchable CASE statement: Each WHEN has its own _______ condition.






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






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






31. IDs: What a quoted user-defined identifier is enclosed in.






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






33. Default file extension of wrap's output file.






34. In a collection - the internal components are called _______.






35. A SELECT statement with the FOR UPDATE clause puts a ______ on the selected rows.






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






37. Mode designation for an input/output parameter.






38. In PL/SQL - what the variables in DML statements are turned into.






39. Conversion: Implicit conversion can be (faster / slower) than explicit conversion.






40. Types: The storage size of a NUMBER value is based on the number of ______ digits.






41. %ROWTYPE gets the type of a table or _______.






42. Cursors: Only a _____ _____ cursor can appear in the CURRENT OF clause of an UPDATE or DELETE statement.






43. Advantage: Performance: Storing and runnng procedures on the server minimizes ______ traffic.






44. Give the statement to make a program autonomous.






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






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






47. A result-cached function caches its results in the _____ _____ ____ (SGA)






48. To run TCL or DDL statements - a trigger (must / must not) be autonomous .






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






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







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