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. Types: One of the scalar data types specific to PL/SQL: P________






2. The meaning of 'FGA'.






3. Assigning values to PL/SQL variables that appear in SQL statements is called _______.






4. Dbms_sql: A cursor opened with OPEN_CURSOR (can/cannot) be reused for multiple queries without first closing it.






5. Types: ________ data types have no internal components.






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






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






8. Cursors: A cursor variable's type must be a ____ ______ type.






9. IDs: You (can/cannot) use keywords as ordinary user-defined identifiers.






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






11. A FOR loop can be indexed by numbers or by a ______.






12. Triggers: On a non-editioning view - you can only define __________ triggers.






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






14. Cursors: The statement that closes a cursor.






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






16. Fundamental: What is the exponentiation operator?






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






18. You can put a label before any executable PL/SQL _________.






19. Triggers: INSTEAD OF triggers only run on ______ views.






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






21. Delimiters: Statement terminator.






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






23. SIMPLE_INTEGER is like PLS_INTEGER - but it does not allow ____ values - and it does not raise overflow exceptions.






24. Cursors: The four cursor attributes - in alphabetical order.






25. Mode designation for an input parameter.






26. I/O: This package has hypertext functions that generate HTML tags






27. Types: One of the scalar data types specific to PL/SQL: B_______






28. An autonomous program runs in its own __________.






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






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






31. Conditional ______ allows backward compability with older database versions.






32. I/O: dbms_output.put_line puts output into a _______.






33. Cursors: The values plugged into the DML in a FORALL must come from existing - populated _________.






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






35. Fundamental: One of the 4 types of lexical units: L_____






36. Declare an unconstrained subtype of NUMBER called NUMB.






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






38. The PL/SQL ________ evaluates compiler directives.






39. The EXCEPTION section is (optional/mandatory).






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






41. Nested tables can become sparse via ______.






42. The LIMIT method is only meaningful for _______.






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






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






45. An anonymous block always has _________ rights.

Warning: Invalid argument supplied for foreach() in /var/www/html/basicversity.com/show_quiz.php on line 183


46. Command to make a no-op (omit semicolon).






47. Fundamental: What are the 3 compound symbols for 'not equal to'?






48. Declare a constrained subtype of NUMBER called N that is not null.






49. Package for getting the postprocessed source of a program.






50. Static typing is also called _____ typing.