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. I/O: This package has hypertext functions that generate HTML tags






2. Value of a character literal with zero characters.






3. A numeric FOR loop cannot _________ by other than 1?






4. DynSQL: Native Dynamic SQL






5. To insert or update on a table that has a collection column - you have to have _______ privilege on the collection type.






6. Cursors: The Oracle predefined REF CURSOR type.






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






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






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






10. Kind of comment not to put in a PL/SQL block to be processed dynamically by an Oracle Precompiler program.






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






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






13. Types: One of the 4 PL/SQL things that have a data type (begins with 'p').






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






15. Types: Which type of arithmetic does PLS_INTEGER use - library or hardware?






16. Cursors: The keyword that makes a ref cursor type STRONG.






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






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






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






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






21. Types: PL/SQL has all the _____ data types.






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






23. The Wrap utility (does / does not) encrypt source code.






24. Types: One of the scalar data types specific to PL/SQL: P________






25. Triggers: The clause to make a trigger run before inserting or updating table EMPS.






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






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






28. A PL/SQL block that is not stored.






29. Clause added to a cursor to use it with WHERE CURRENT OF.






30. You cannot bulk collect into an ARRAY OF ________.






31. The lowest index of a VARRAY is ___.






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






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






34. Into nested table ex - put elements of tbl1 that are not in tbl2.






35. Set flag bb true: ALTER SESSION SET PLSQL_CCFLAGS= '____'






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






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






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






39. Cursors: What is the 'name' of the implicit cursor?






40. Triggers: Unlike a stored procedure - you can enable and _____ a trigger.






41. Declare a cursor c with no parameters or return type.






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






43. IDs: The type of words that cannot be user-defined identifiers.






44. The BETWEEN operator is (inclusive / exclusive).






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






46. Triggers and views always have _________ rights.

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


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






48. Declare an unconstrained subtype of NUMBER called NUMB.






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






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