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. CREATE TYPE cannot be used for _______ array types.






2. In short-circuit evaluation - IF-conditions are only evaluated up to where the outcome ___________.






3. Delimiters: the attribute indicator.






4. Characters that begin a single-line comment.






5. Delimiters: The assignment operator.






6. Types: In addition to the SQL data types - PL/SQL has ___ more scalar data types.






7. Cursors: If no SELECT or DML statement has run - the value of SQL%ROWCOUNT is what?






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






9. The BEGIN section is (optional/mandatory)






10. Cursors: SYS_REFCURSOR is a predefined type based on _____ ______.






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






12. Cursors: An explicit cursor (can/cannot) accept parameters.






13. Fundamental: What is the exponentiation operator?






14. I/O: The most basic PL/SQL way to give output to the user.






15. Delimiters: Item separator.






16. A subprogram created inside a block is a _________ subprogram.






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






18. Define a nested table type - tN - which is a table NUMBERs.






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






20. A pointer to a private SQL area that stores information about processing a specific SELECT or DML statement.






21. Cursors: A cursor that lives in session memory until the session ends.






22. Exceptions: An exception in the declarations section does not go to the __________ section.






23. Cursors: Give the statement to close cursor C.






24. Declare a constrained subtype of NUMBER called N that is not null.






25. Types: The storage size of a NUMBER value is based on the number of ______ digits.






26. The default value of the AUTHID property.






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






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






29. A type of compiler directive - begins with 'e'.






30. Declare a variable r whose type is that of the records in table t.






31. To recompile a procedure - use the _____ ______ command.






32. Cursors: Opening keyword of a cursor FETCH loop.






33. What is the exception that is implicitly raised in a CASE statement with no ELSE clause?






34. Delimiters: The left label delimiter.






35. When an autonomous routine begins execution - the main transaction is ________.






36. Value of a character literal with zero characters.






37. Dbms_sql: DBMS_SQL package is compiled with _______ rights.

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


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






39. User-defined compiler directives are defined in this system compile parameter.






40. Conversion: If the specific value is suitable - ____ or _______ values can convert to almost any datatype






41. Declare an input/output NUMBER parameter - v3.






42. Abbreviation for Abstract Data Type.






43. Give the value list in the PLSQL_WARNINGS parameter to turn on SEVERE compiler warnings and make compiler warning 06002 be an error.

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


44. The attribute used to get the type of a row without knowing what it is.






45. I/O: The DBMS_OUTPUT function that writes output without a newline character.






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






47. DynSQL: EXECUTE IMMEDIATE does both dynamic SQL and dynamic _______.






48. This is a CASE (expression / statement): CASE num WHEN 1 THEN goto LABEL1 WHEN 2 THEN var := 2 END CASE;






49. _____ arrays cannot be used as the type of an Oracle table column.






50. The _____ and ____ _____ collection types can be used in database table columns.







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