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. Default file extension of wrap's output file.






2. A user-defined TYPE can have...






3. Simple CASE statement checks for different values of a single _________






4. Cursors: An explicit cursor (can/cannot) accept parameters.






5. Static typing is also called _____ typing.






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






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






8. This is a CASE (expression / statement): CASE num WHEN 1 THEN goto LABEL1 WHEN 2 THEN var := 2 END CASE;






9. DynSQL: Maximum string length to pass to EXECUTE IMMEDIATE.






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






11. I/O: This package has hypertext procedures that generate HTML tags






12. The Wrap utility ________ the source code.






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






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






15. DBMS_DDL.CREATE_WRAPPED: wraps and _______ the source code passed to it.






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






17. Declare a package procedure P with no arguments - and give it invoker's rights.






18. _______ arrays can be sparse or dense - depending on how you fill them.






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






20. The 2 characters that begin all inquiry directives.






21. A subprogram defined within another subprogram is a _______ subprogram.






22. The _____ utility turns PL/SQL source code into unreadable text.






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






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






25. _________ exceptions can not be trapped with an error handler






26. A CASE expression ends with _____.






27. The PL/SQL ________ evaluates compiler directives.






28. ______ SQL is a PL/SQL feature that allows SQL syntax directly in a PL/SQL statement.






29. Fundamental: Which one of these is a compound symbol: = - :=






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






31. Cursors: Give the statement to open cursor C.






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






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






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






35. Delimiters: Single-line comment marker.






36. The FIRST method gets the first (element / index) of a collection.






37. Types: One of the 4 PL/SQL things that have a data type (begins with 'v').






38. 5 types of events that can have triggers: DML - DDL - INSTEAD OFs - database events - and ________ statements.






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






40. An editioning view is like an ____ for a table.






41. Subprograms are stored in __________ form.






42. Cursors: If you use an EXIT statement to exit a cursor FOR loop prematurely - the cursor (is / is not) closed automatically.






43. Exceptions: The keyword that begins an exception handler.






44. Which two of these built-in SQL functions can be used in procedural (PL/SQL) statements: DECODE - CORR - UPPER - SUM - COALESCE - DEREF.






45. You can use the BULK COLLECT INTO clause in a SELECT or a ______.






46. Bulk: The implicit cursor attribute that gives the number of rows affected by each DML statement in a FORALL statement.






47. Types: Which type of arithmetic does PLS_INTEGER use - library or hardware?






48. Kind of datatypes that support object-oriented programming in PL/SQL.






49. Native compilation turns bytecode into ________ code.






50. Wrap iname=xxxx _____=zzzzz






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