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


2. Define a collection type - tA - which is an associative array of NUMBERS - indexed with varchar2(20) values.






3. Fundamental: Maximum string length of a PL/SQL variable.






4. Define a collection type - tV - which is a varray of 100 NUMBERs.






5. Dbms_sql: The integer returned by OPEN_CURSOR is a _____ _____.






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






7. A unit with AUTHID = CURRENT_USER is an ________ rights unit.

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


8. The best candidates for result-caching are functions that are invoked frequently but depend on __________________ or never.






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






10. A (simple / searched) CASE statement begins with CASE <expression>.






11. What is the simplest statement for conditionally getting out of simple loop?






12. When a session starts - CURRENT_SCHEMA has the value of the schema owned by ___________.






13. You (can / cannot) wrap trigger source code.






14. You cannot bulk collect into an ARRAY OF RECORDS. You can into a ________________ (3 words).






15. Exceptions: Associate exception E with error code -1.






16. IDs: Predefined identifiers are declared in this package.






17. Default file extension of wrap's input file.






18. Cursors: Which cursor attribute is not meaningful for an implicit cursor?






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






20. Java - C or other program called directly in PL/SQL.






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






22. Define a record type REC with number num and varchar2(10) name.






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






24. Conversion: Implicit conversion is not always predictable; it is _______-sensitive. And its rules might change.






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






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






27. Exceptions: You cannot GOTO from an exception handler back into the __________ block.






28. Data dictionary view giving the AUTHID values on a user's objects.






29. Pkgs: The _______ package gives access to such SQL things as ALTER SESSION.






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






31. Exceptions: The ________ handler must always be the last handler.






32. Define a record variable r - of type tRec - initialized with values 9 and 'Jones' in its two fields.

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


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






34. Cursors: The SQL%FOUND attribute has how many possible values?






35. DBMS_DDL.WRAP returns a string containing wrapped _____ _____.






36. Delimiters: Item separator.






37. You can have many autonomous transactions in ___________.






38. The _____ utility turns PL/SQL source code into unreadable text.






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






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






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






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






43. A CASE expression ends with _____.






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






45. Delimiters: The left label delimiter.






46. Exceptions: The ________ function returns the error message associated with an error code.






47. A __________ can have an AUTHID property






48. Delimiters: Statement terminator.






49. Types: A data type family consists of a ______ type and its subtypes.






50. 5 types of events that can have triggers: DML - DDL - INSTEAD OFs - database events - and ________ statements.







Sorry!:) No result found.

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