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. IDs: What a quoted user-defined identifier is enclosed in.






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






3. If none of a CASE expression's conditions are TRUE - it returns _____.






4. Declare an input NUMBER parameter - v2 - that defaults to 20.






5. Exceptions: The package that defines pre-defined exceptions.






6. Cursors: The FOR UPDATE phrase goes at the (beginning/end) of the cursor definition.






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






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






9. Delimiters: The component indicator/selector.






10. An editioning view can only select a subset of the columns from the base table and provide ________ for them






11. Abbreviation of invoker's rights






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






13. Triggers and views always have _________ rights.

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


14. Delimiters: The left label delimiter.






15. Exceptions: User-defined exceptions must have _______.






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






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






18. IDs: How an ordinary user-defined identifier must begin.






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






20. Cursors: Define a ref cursor type called T.






21. With dynamic typing - type checking is done at ______time.






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


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






24. The EXTEND method is not used with ______ _______.






25. A __________ can have an AUTHID property






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






27. The 2 characters that begin all inquiry directives.






28. Exceptions: Start of the range of error codes for RAISE_APPLICATION_ERROR.






29. Cursors: The first two keywords of a basic fetch statement.






30. The valid values of the AUTHID property.






31. Abbreviation for Abstract Data Type.






32. In Native Mode - PL/SQL code is compiled into ______ ______.






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






34. Exceptions: The keyword that begins an exception handler.






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






36. Wrap iname=xxxx _____=zzzzz






37. Dbms_sql: The DBMS_SQL procedure that closes a cursor.






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






39. Official acronym for PL/SQL's runtime engine.






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






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






42. Cursors: A Cursor FOR loop does not use a ______ statement.






43. VARRAYs are (always / never) sparse.






44. I/O: This package handles HTTP.






45. Triggers: INSTEAD OF triggers only run on ______ views.






46. I/O: SQLPlus command for turning on buffered output.






47. Triggers: In a per-row trigger - the ____ record shows you the original state of an affected row.






48. The command used to populate PLSQL_CCFLAGS.






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


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







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