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. To insert or update on a table that has a collection column - you have to have _______ privilege on the collection type.






2. Exceptions: PL/SQL exceptions are of two types: internal and _________.






3. An editioning view is like an ____ for a table.






4. In a cursor loop - the clause added to an INSERT or UPDATE to point at the current record.






5. IDs: List the two types of user-defined identifiers.






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






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






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






9. Abbreviation of definer's rights






10. Cursors: You cannot use cursor attributes in _______ statements.






11. One good use of bind variables is to guard against SQL _______.






12. Advantage: Performance: Storing and runnng procedures on the server minimizes ______ traffic.






13. Packaged constants can synchronize programs through use in _______ directives.






14. Types of blocks: A pl/sql block that is not stored in the database.






15. Cursors: Only a _____ _____ cursor can appear in the CURRENT OF clause of an UPDATE or DELETE statement.






16. Cursors: The value of SQL%ISOPEN is always ______.






17. For a collection - the NEXT method gets the next higher (element / index).






18. To use a TYPE declared in the database - a PL/SQL block has to have _______ privilege on the type.






19. A national character literal is composed of characters in the ________ character set.






20. The variable showing the user id that is automatically prepended to object names.






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






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






23. A subprogram defined within another subprogram is a _______ subprogram.






24. Cursors: A session cursor that is automatically created and managed by PL/SQL.






25. Cursors: The type definition of a WEAK ref cursor type has no _______ clause.






26. Exceptions: An exception in the declarations section does not go to the __________ section.






27. Conversion: If the specific value is suitable - ____ or _______ values can convert to almost any datatype






28. The three sorts of date/time types are DATE - INTERVAL and _________.






29. Fundamental: Labels furnish targets for GOTO and _____ statements.






30. Types: Which type of arithmetic does NUMBER use - library or hardware?






31. Dbms_sql: The return type DBMS_SQL.open_cursor.






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






33. An anonymous block is a(n) ____ statement.






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






35. Cursors: The three keywords in a full cursor declaration/definition (before the SELECT).






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


37. Command to create a procedure.






38. Cursors: You give an explicit cursor a name and associate it with a _______.






39. Web: PL/SQL _______ enables a Web browser to invoke a PL/SQL stored subprogram through an HTTP listener.






40. Cursors: Give the statement to fetch data from cursor C into variable V.






41. Declaration of a varchar2 constant - called vname - with value 'x'.

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


42. Delimiters: Item separator.






43. A SELECT statement with the FOR UPDATE clause puts a ______ on the selected rows.






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






45. A type of compiler directive - begins with 'e'.






46. Cursors: An implicit cursor is also called a/n ________ ________ -






47. Cursors: The statement where you pass the parameters to a cursor.






48. Exceptions: A GOTO statement cannot branch into an _______ ________.






49. Exceptions: The built-in procedure for raising an application-defined error.






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






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