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. A CASE statement ends with ____ ____.






2. Records are one of the two kinds of PL/SQL _______ data types.






3. PL/SQL does not automatically create bind variables in ________ SQL.






4. Delimiters: the attribute indicator.






5. Assignment of PLSQL_CCFLAGS (cannot / can) be included in ALTER PROCEDURE ... COMPILE ...






6. In short-circuit evaluation - IF-conditions are only evaluated up to where the outcome ___________.






7. The command used to populate PLSQL_CCFLAGS.






8. Triggers: The clause to make a trigger run after inserting into table EMPS.






9. A PL/SQL block that is not stored.






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






11. Web: mod_plsql is an _______ module.






12. Mode designation for an input parameter.






13. Exceptions: A GOTO statement cannot branch into an _______ ________.






14. Declare an unconstrained subtype of NUMBER called NUMB.






15. Fundamental: What is the range operator?






16. Triggers: The code in a trigger is actually an ________ block.






17. A numeric FOR loop cannot _________ by other than 1?






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






19. Advantage: PL/SQL is PORTABLE to any OS where ________ runs.






20. What do you FETCH from?






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






22. Cursors: The SQL%FOUND attribute has how many possible values?






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






24. TCL: Undo changes back to savepoint ab.






25. Characters that begin a single-line comment.






26. CREATE TYPE cannot be used for _______ array types.






27. The BEGIN section is (optional/mandatory)






28. The meaning of 'FGA'.






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






30. Are good for logging table DML operations.






31. Triggers: If two or more triggers are defined with the same timing point - then you can control the firing order using the ________ clause.






32. The FOR UPDATE OF clause references a (table / column).






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






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






35. The PL/SQL virtual machine turns bytecode into system ______.






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






37. Into nested table ex - put elements of tbl1 that are not in tbl2.






38. Cursors: An implicit cursor is also called a/n ________ ________ -






39. Fundamental: Labels furnish targets for GOTO and _____ statements.






40. The compiler directive governing conditional compilation.






41. An $ERROR directive ends with _____.






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






43. Value of a character literal with zero characters.






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






45. Triggers: There are __ types of triggers.






46. Abbreviation of definer's rights






47. Conversion: It is best to use (implicit / explicit) conversion.






48. In the special IF syntax - is it ELSIF - or ELSEIF?






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






50. Types: The only PL/SQL type for which you can specify a range constraint.







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