Oracle

10 Questions

Settings
Please wait...
Oracle Quizzes & Trivia

.


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. 
    You can have two functions with the same name in a PL/SQL block
    • A. 

      True

    • B. 

      False

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

      True

    • B. 

      False

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

      12

    • B. 

      11

    • C. 

      13

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

      One

    • B. 

      Two

    • C. 

      Three

    • D. 

      Four

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

      True

    • B. 

      False

  • 8. 
    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

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

      Before insert

    • B. 

      Insert before

    • C. 

      After Insert

    • D. 

      Before update

  • 10. 
                     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