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. DynSQL: The main command for Native Dynamic SQL.






2. In a collection - the internal components always have the _____ data type.






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


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






5. The two kinds of CASE statements are simple and ________.






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


7. Delimiters: The left label delimiter.






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






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






10. DynSQL: EXECUTE IMMEDIATE can be used for any SQL statement or PL/SQL block - except for ________ queries.






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






12. List the transaction control statements.






13. An incomplete type only has a ____.






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






15. A GOTO statement cannot branch from an exception handler back into the...






16. Wrap ______=xxxx oname=zzzzz






17. Fundamental: Delimiters are _____ and _____ symbols.






18. The 2 characters that begin all inquiry directives.






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






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






21. I/O: The string table type in DBMS_OUTPUT for holding lines of text.






22. Command to delete a procedure.






23. What are two categories of SQL functions that cannot be used in procedural statements?






24. Delimiters: Host variable indicator.






25. PL/SQL is a ________ typed programming language.






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






27. Conditional compilation is useful for compiling a program under different ______ of Oracle.






28. _________ exceptions can not be trapped with an error handler






29. Advantage: Performance: PL/SQL automatically creates ______ variables for variables in WHERE and VALUES clauses.






30. Bulk: The use of FORALL statements cuts down on ______ traffic.






31. Advantage: PL/SQL gives SCALABILITY because stored procedures are executed on the _______.






32. Conversion: Implicit conversion can be (faster / slower) than explicit conversion.






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






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






35. Dbms_sql: The return type DBMS_SQL.open_cursor.






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






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






38. DynSQL: The clause that supplies bind arguments to EXECUTE IMMEDIATE.






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






40. To run DDL statements - a trigger must be autonomous and must use ______ ______ SQL.






41. In interpreted mode - the PL/SQL VM interprets the _________.






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






43. %ROWTYPE gets the type of a table or _______.






44. I/O: This package handles HTTP.






45. The exception raised when a SELECT INTO statement returns more than one row.






46. Bulk: The two features that comprise Bulk SQL are:






47. What word is in a function header but not in a procedure header?






48. Triggers and views always have _________ rights.

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


49. In the IF syntax - is if ENDIF or END IF?






50. You (can/cannot) put a label before an END LOOP 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