What Is Oracle?

20 Questions

Settings
Please wait...
Oracle Quizzes & Trivia

Oracle


Questions and Answers
  • 1. 
    Which of the following is not a schema object ?
    • A. 

      Indexes

    • B. 

      Public synonyms

    • C. 

      Tables,

    • D. 

      Triggers

  • 2. 
    Functions can  be overloaded true/false
    • A. 

      A. TRUE

    • B. 

      B. FALSE

  • 3. 
    What are the various types of parameter modes in a procedure ? CHOOSE 3
    • A. 

      In

    • B. 

      Outin

    • C. 

      Out

    • D. 

      Inout

  • 4. 
    You can have two functions with the same name in a PL/SQL block
    • A. 

      True

    • B. 

      False

  • 5. 
    You can call a stored function in the constraint of a table
    • A. 

      True

    • B. 

      False

  • 6. 
    What are the various types of Exceptions ? choose 2
    • A. 

      User defined exception

    • B. 

      Pre defined exception

    • C. 

      Try

    • D. 

      Catch

  • 7. 
    What are the parts of a database trigger ? choose 3
    • A. 

      A. A triggering event or statement b. Open trigger c. A trigger restriction d. A trigger action e. Close trigger a. A triggering event or statement b. Open trigger c. A trigger restriction d. A trigger action e. Close trigger A triggering event or statement

    • B. 

      Open trigger

    • C. 

      A trigger restriction

    • D. 

      A trigger action

    • E. 

      Close trigger

  • 8. 
    How many types of database triggers are possible ?
    • A. 

      12

    • B. 

      11

    • C. 

      13

  • 9. 
    What is the maximum no.of statements that can be specified in a trigger statement ?
    • A. 

      One

    • B. 

      Two

    • C. 

      Three

    • D. 

      Four

  • 10. 
    Views can be specified in a trigger statement
    • A. 

      True

    • B. 

      False

  • 11. 
    Can you increase the size of a tablespace ? How ?
    • A. 

      Yes, by adding datafiles to it.

    • B. 

      No, It is impossible

    • C. 

      Yes, by using alter command

    • D. 

      Yes, by using update command

  • 12. 
    Benefits of Subprograms: choose 4
    • A. 

      Easy maintenance

    • B. 

      Improved data security and integrity

    • C. 

      Improved performance

    • D. 

      Improved code clarity

    • E. 

      Improved speed

    • F. 

      Improves efficiency

  • 13. 
    Types of Triggers : choose all that apply
    • A. 

      A. Row level

    • B. 

      B. Statement level

    • C. 

      C. Column level

  • 14. 
    A                        Trigger  will fire the trigger before the INSERT operation is executed
    • A. 

      Before insert

    • B. 

      Insert before

    • C. 

      After Insert

    • D. 

      Before update

  • 15. 
                     are stored procedures that gets implicitly executed when some database-related event      occurs .
    • A. 

      A. Procedures

    • B. 

      B. Triggers

    • C. 

      C. Functions

    • D. 

      D. Cursor

  • 16. 
    The four PL/SQL steps necessary for explicit cursor processing are as follows: choose 4
    • A. 

      Declare the cursor

    • B. 

      Open the cursor

    • C. 

      Fetch the results into PL/SQL variables

    • D. 

      Close the cursor

    • E. 

      Execute the cursor

    • F. 

      Delete the cursor

  • 17. 
    The                                   statement prepares (parses) and immediately executes a dynamic SQL statement or an anonymous PL/SQL block.
    • A. 

      Immediate execute

    • B. 

      Execute immediate

    • C. 

      Execute

    • D. 

      Execute later

  • 18. 
    .                                enables to write programs that reference SQL statement whose full text is not known until runtime.
    • A. 

      Static SQL

    • B. 

      Dynamic SQL

    • C. 

      PL/SQL

    • D. 

      Oracle 10g

  • 19. 
    Some utilities in Oracle are: choose 3
    • A. 

      Export

    • B. 

      Execute

    • C. 

      Import

    • D. 

      Sql loader

    • E. 

      DDL commands

  • 20. 
    Which of the following cursor attributes allows you to check whether the cursor is open or not
    • A. 

      %isopen

    • B. 

      %open

    • C. 

      %isclose

    • D. 

      Isopen