Results 1 to 7 of 7

Thread: can i get answer for this

  1. #1
    Junior Member
    Join Date
    Feb 2007
    Answers
    12

    can i get answer for this

    the creation of which 4 database objects will cause a DDl trigger to fire
    1.index
    2.cluster
    3.package
    4.function
    5.synonym
    6.database link
    7.dimentions


  2. #2
    Expert Member
    Join Date
    Dec 2006
    Answers
    204

    Re: can i get answer for this

    It can be made to trigger before or after any of the CREATE statement.
    but i think it wont trigger in create database link command.

    Last edited by Barbie; 02-21-2007 at 05:54 AM.

  3. #3
    Junior Member
    Join Date
    Feb 2007
    Answers
    12

    Re: can i get answer for this

    can you explain in brief about this


  4. #4
    Expert Member
    Join Date
    Dec 2006
    Answers
    204

    Re: can i get answer for this

    DDL triggers can be made to trigger before or after any of the data definition statements.
    For example, any create or alter stmts which cause a change in the definition of the objects.

    that may be an table or index or anything.


  5. #5
    Expert Member
    Join Date
    Dec 2006
    Answers
    204

    Re: can i get answer for this

    This link is having a list of events that triggers the DDL triggers.

    http://www.extremeexperts.com/SQL/Yu...LTriggers.aspx


  6. #6
    Expert Member
    Join Date
    Sep 2006
    Answers
    130

    Re: can i get answer for this

    Quote Originally Posted by gujjar View Post
    the creation of which 4 database objects will cause a DDl trigger to fire
    1.index
    2.cluster
    3.package
    4.function
    5.synonym
    6.database link
    7.dimentions
    Hi Gujjar,

    The database objects which cause a DDl trigger to fire are Index, Package, Function, Synonym & Clusters in the above mentioned list.
    Since they have asked for only 4 options, im very sure about Index, Package, Function & Synonym. So the answer which can opted are 1, 3, 4, 5.

    *** Innila ***


  7. #7
    Junior Member
    Join Date
    Feb 2007
    Answers
    17

    Re: can i get answer for this

    ddl trig can fire on following objects only
    clustr,function,index,package,procedure,role,sequence,synonym,table,tablespace,trigger,type,view,user

    so the choices r first five are right so if u tried to choose any 4 of first five it will correct but u will definately loose ur one marks in exam...it happen....


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
About us
Applying for a job can be a stressful and frustrating experience, especially for someone who has never done it before. Considering that you are competing for the position with a at least a dozen other applicants, it is imperative that you thoroughly prepare for the job interview, in order to stand a good chance of getting hired. That's where GeekInterview can help.
Interact