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. Delimiters: Host variable indicator.






2. Cursors: The second keyword of a FETCH statement.






3. Triggers: An INSTEAD OF trigger (can/cannot) be conditional.






4. The compiler directive governing conditional compilation.






5. TCL: Create a savepoint called ab






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






7. A CASE statement (can / cannot) execute more than one group of statements.






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






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






10. You can have many autonomous transactions in ___________.






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






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






13. IDs: Maximum number of bytes in a user-defined identifier.






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






15. Fundamental: Character used to escape a single quote inside a literal.

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


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






17. Types: In addition to the SQL data types - PL/SQL has ___ more scalar data types.






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






19. Declare an unconstrained subtype of NUMBER called NUMB.






20. Cursors: Opening keyword of a cursor FETCH loop.






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






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






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






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






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






26. With an sparse - integer-indexed associative array - you (can / cannot) use a regular FOR loop.






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






28. With a result-cached function - it uses a cached value when the function is called again with the...






29. I/O: This package handles HTTP.






30. Static typing is also called _____ typing.






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






32. The DEFINITION of a cursor is the part after the keyword __.






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






34. The inquiry directive that gives the current line number in the procedure.






35. An ordinary character literal is composed of characters in the ________ character set.






36. Bulk: The keywords of a bulk collect FETCH statement.






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






38. DynSQL: The main command for Native Dynamic SQL.






39. I/O: The DBMS_OUTPUT procedure that sets the size of the output buffer.






40. Cursors: You can just declare a cursor at first - then _______ it later.






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






42. When a parameter is passed by reference - changes made to it inside the procedure cannot be undone. True/False.






43. I/O: Max number of bytes DBMS_OUTPUT can handle in a session.






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






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






46. An INSTEAD OF trigger is used - e.g - when you want to insert into a complex _____.






47. Triggers: Programmers (as opposed to DBAs) mostly make use of _____ triggers.






48. How to reference a variable V declared in a block labelled L: ____.






49. Cursors: A cursor FOR loop can use an explicit or an _______ cursor.






50. The compiler directive used to select which code to compile.