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. Cursors: You can just declare a cursor at first - then _______ it later.






2. If you are in a procedure inside a package - the compilation unit is the _______.






3. In a collection - the internal components always have the _____ data type.






4. I/O: This package sends text output to SQLPlus






5. In a record - the internal components are called ______.






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






7. You (can/cannot) put a label before an END LOOP statement.






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






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






10. Fundamental: One of the 4 types of lexical units: c_____.






11. Fundamental: What is the range operator?






12. Abbreviation for Abstract Data Type.






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






14. With conditional compilation you can avoid compiling debug code in the _______ environment.






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






16. A kind of variable used as a placeholder.






17. I/O: The string table type in DBMS_OUTPUT for holding lines of text.






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






19. Delimiters: Host variable indicator.






20. The meaning of 'FGA'.






21. PL/SQL is a ________ typed programming language.






22. I/O: To make sure the DBMS_OUTPUT buffer will be flushed - put a WHEN ______ clause in the EXCEPTION section of your outer block.






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






24. Web: mod_plsql is an implementation of the PL/SQL _________.






25. Advantage: PL/SQL gives SCALABILITY because stored procedures are executed on the _______.






26. The attribute used to get the type of a row without knowing what it is.






27. Triggers: In a trigger - you cannot issue a COMMIT or a ______.






28. Name the two types of FOR loop.






29. A basic PL/SQL datatype that SQL does not have.






30. Conversion: Just about everything will implicitly convert to _____ or _________.






31. Value of a character literal with zero characters.






32. Collections are one of the two kinds of PL/SQL _______ data types.






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






34. Type: A __________ subtype has only a subset of the values of its base type.






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






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






37. Cursors: The Oracle predefined REF CURSOR type.






38. You can define PL/SQL collections using TYPEs defined in the _______.






39. Define a collection type - tV - which is a varray of 100 NUMBERs.






40. Pkgs: This procedure de-instantiates/resets all packages in this session.






41. A CASE expression ends with _____.






42. If none of a CASE expression's conditions are TRUE - it returns _____.






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






44. IDs: Predefined identifiers are declared in this package.






45. Delimiters: Statement terminator.






46. The first SQL statement in an autonomous routine begins a _______.






47. An editioning view can only select a subset of the columns from the base table and provide ________ for them






48. Internally - the NUMBER type is stored as ______. Therefore - decimal numbers (such as prices) are stored exactly - with no rounding.






49. Triggers: In a per-row trigger - the ____ record shows you the original state of an affected row.






50. Types: One of the scalar data types specific to PL/SQL: R_________.