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. After the RESULT_CACHE clause - you can put a _________ clause to enable dependency-checking.






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






3. Native compilation turns bytecode into ________ code.






4. Loops: What is the index range operator in a FOR loop?






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






6. Delimiters: The assignment operator.






7. A type of compiler directive - begins with 'i'.






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






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


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






11. The Wrap utility ________ the source code.






12. The _______ package lets you wrap dynamically generated PL/SQL.






13. For an associative array - the FIRST method gets the (lowest / first-created) index.






14. Internally - the NUMBER type is stored as ______. Therefore - decimal numbers (such as prices) are stored exactly - with no rounding.






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






16. Command used to execute dynamic SQL.






17. PLSQL_CCFLAGS hold a comma-separated list of ______ pairs (hyphenated).






18. An $ERROR directive ends with _____.






19. Delimiters: Host variable indicator.






20. Fundamental: identifiers (include/do not include) reserved words.






21. Cursors: The statement that closes a cursor.






22. I/O: This package has hypertext functions that generate HTML tags






23. Command to delete a procedure.






24. Dbms_sql: This DBMS_SQL function opens a new cursor.






25. An INSTEAD OF trigger specifies what to do instead of a ___ statement.






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






27. Language that PL/SQL is derived from.






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






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






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






31. Types: ________ data types have internal components.






32. Labels for blocks and statements are enclosed in '__' brackets.






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






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






35. Triggers: The clause to make a trigger run once for every affected row.






36. The lowest index of a nested table is ___.






37. Exceptions: An unhandled exception ________ to the enclosing block.






38. The SET TRANSACTION statement affects only the ____________.






39. Cursors: What are the 3 possible values of SQL%FOUND and SQL%NOTFOUND?






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






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






42. When a parameter is passed by reference - changes made to it inside the procedure cannot be undone. True/False.






43. I/O: The DBMS_OUTPUT procedure that sets the size of the output buffer.






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






45. Triggers: By default - a trigger is created in the ______ state.






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






47. Types: One of the scalar data types specific to PL/SQL: b_____.






48. I/O: The DBMS_OUTPUT function that writes output WITH a newline character.






49. Fundamental: Delimiters are _____ and _____ symbols.






50. Delimiters: The association operator.







Sorry!:) No result found.

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