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. Statement to set current schema to x: _____ _____ SET CURRENT_SCHEMA = 'x';






2. Advantage: PL/SQL is tightly _______ with Oracle SQL.






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






4. Command to create a procedure.






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






6. The source for wrapping begins with the word ______.






7. Cursors: Closing keywords of a cursor FETCH loop.






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






9. The declaration section is (optional/mandatory).






10. An autonomous program runs in its own __________.






11. For a collection - the NEXT method returns ____ when there is no next index value.






12. Give the statement to make a program autonomous.






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






14. Advantage: Having procedures stored and executed on the server makes PL/SQL ________.






15. Exceptions: Write the call (2 args) to associate message 'Bad' with error code -20 -100.

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


16. A GOTO statement cannot branch from an exception handler back into the...






17. To exit an active autonomous transaction without causing an exception - you must issue _____ or ______.






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






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






20. I/O: The DBMS_OUTPUT buffer will not be flushed until it is full or until the current PL/SQL block _________.






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






22. GOTO branches to a ________.






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






24. I/O: One of the 3 types of data stored in the DBMS_OUTPUT buffer.






25. Web: PL/SQL ______ ______ (PSPs) let you develop web pages with dynamic content.






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






27. The FIRST method gets the first (element / index) of a collection.






28. You can have many autonomous transactions in ___________.






29. The DEFINITION of a cursor is the _____ that returns the records.






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






31. I/O: One of the 3 types of data that can be passed to the DBMS_OUTPUT buffer.






32. Exceptions: The _________ package defines the PL/SQL environment.






33. FOR-Looping over a collection from FIRST to LAST only works if the collection is _______.






34. Bulk: The use of FORALL statements cuts down on ______ traffic.






35. The meaning of 'FGA'.






36. I/O: One of the 3 types of data stored in the DBMS_OUTPUT buffer.






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






38. I/O: This package has hypertext procedures that generate HTML tags






39. To run TCL or DDL statements - a trigger (must / must not) be autonomous .






40. How many times are a FOR loop's index bounds evaluated?






41. IDs: The 3 non-alphanumeric characters that can be in an ordinary user-defined identifier.






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






43. I/O: Max number of bytes to pass in a call to DBMS_OUTPUT.PUT_LINE.






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






45. The statement that is used to execute most (native) dynamic SQL.






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






47. Parameter that controls how much Oracle optimizes your PL/SQL code on compilation.






48. 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


49. Fundamental: One of the 4 types of lexical units: d_____






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






Can you answer 50 questions in 15 minutes?



Let me suggest you:

Browse all subjects

Browse all tests

Most popular tests



Major Subjects

Tests & Exams


AP
CLEP
DSST
GRE
SAT
GMAT

Browse all subjects

Browse all tests

Most popular tests