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. IDs: You (can/cannot) use keywords as ordinary user-defined identifiers.






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






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






4. Give the first line of the FOR loop with index i going from 1 to 10 in reverse.






5. Are good for logging table DML operations.






6. Abbreviation of invoker's rights






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






8. Triggers: By default - a trigger is created in the ______ state.






9. The $ERROR directive is used to make compilation ____.






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






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






12. Cursors: What are the 3 possible values of SQL%FOUND and SQL%NOTFOUND?






13. Conditional compilation is useful for compiling a program under different ______ of Oracle.






14. When an autonomous routine begins execution - the main transaction is ________.






15. If a result-cached function's data source (based on the RELIES_ON clause) is updated - any cached results become _______.






16. Labels for blocks and statements are enclosed in '__' brackets.






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






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






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






20. Give the statement to make a program autonomous.






21. Make a FOR loop that executes NULL 10 times counting in reverse - using index i.






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






23. Exceptions: The three words that can be used to guarantee all exceptions will be handled.






24. GOTO branches to a ________.






25. Triggers: There are __ types of triggers.






26. IDs: You cannot use reserved words as ______ user-defined identifiers.






27. The 4 keywords in the $IF compiler directive.






28. A (simple / searched) CASE statement begins with CASE WHEN <boolean expression>.






29. Name the two types of FOR loop.






30. Cursors: The two keywords in a mere cursor declaration (one is optional).






31. Associative array types (can / cannot) be defined in the database.






32. In a sparse collection - the indexes of defined elements (do / do not) run in consecutive order.






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






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






35. Delimiters: the attribute indicator.






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






37. To run DDL statements - a trigger must be autonomous and must use ______ ______ SQL.






38. Declare a number variable - A - initialized to 10.






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






40. The RESULT_CACHE clause comes (before / after) the RETURN clause.






41. What clause makes a compilation default to the PLSQL_CCFLAGS settings from the last compilation?






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






43. Static typing is also called _____ typing.






44. The variable showing the user id of the session owner.






45. In interpreted mode - the PL/SQL VM interprets the _________.






46. Data dictionary view giving the AUTHID values on a user's objects.






47. User-defined compiler directives are defined in this system compile parameter.






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






49. I/O: This DBMS_OUTPUT proc retrieves multiple lines from the buffer.






50. True encryption is done with package __________.






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