View Count: 0
Duration: 47 mins
Accessed date:
Not Yet Viewed
View Count: 0
Duration: 20 mins
Accessed date:
Not Yet Viewed
View Count: 0
Duration: 10 mins
Accessed date:
Not Yet Viewed
View Count: 0
Duration: 31 mins
Accessed date:
Not Yet Viewed
Post your comment / feedback here
 
 

Be the first one to comment about this video

Sorry!For this module there is no Sample Code.
Sorry!For this module there is no Assignments.
Question No: 1 of 20
The view which returns the list of triggers in a database 
Options:
  1. sys.trigger
  2. sys.triggers
  3. sys.viewtriggers
  4. None
View Answer/Explanation:
b
Explanation:

Question No: 2 of 20
The trigger that can be used on views is 
Options:
  1. After
  2. For
  3. Instead of
  4. Before
View Answer/Explanation:
c
Explanation:

Question No: 3 of 20
How many INSTEAD OF triggers are allowed on a table or view? 
Options:
  1. Any number
  2. 56
  3. Only one
  4. 10
View Answer/Explanation:
c
Explanation:

Question No: 4 of 20
To control the order of execution when multiple AFTER triggers are attached to sql table_____________ procedure is used. 
Options:
  1. sp_triggersetorder
  2. sp_settriggerorder
  3. sp_triggerorder
  4. sp_triggerorderset
View Answer/Explanation:
b
Explanation:

Question No: 5 of 20
Trigger:
        create trigger tri_emp
     on employee
     After insert
     as
     select * from inserted

     Insert action:
     insert into employee values(1,'aryan','manager',20000,1)

 Which statement is true for the above example 
Options:
  1. The code in the trigger is executed first and after that the insert statement is executed and the record is inserted into the table.
  2. The record is inserted into the database first and after that the trigger is fired and the code in the trigger is executed.
  3. The record is not inserted into the database at all, instead the code in the trigger is executed
  4. The insert statement is performed and the record is inserted in to the database, but the code in the trigger is not executed at allocated
View Answer/Explanation:
b
Explanation:

Question No: 6 of 20
Which of the following are similar triggers? 
Options:
  1. Instead of trigger
  2. After triggers
  3. For triggers
  4. None of the above are similar
View Answer/Explanation:
b c
Explanation:

Question No: 7 of 20
The code in the trigger can be executed by explicitly calling the trigger by its name 
Options:
  1. TRUE
  2. FALSE
View Answer/Explanation:
b
Explanation:

Question No: 8 of 20
Which of the following are magic tables? 
Options:
  1. Delete table
  2. Deleted table
  3. Insert table
  4. Inserted table
View Answer/Explanation:
b d
Explanation:

Question No: 9 of 20
Inside a trigger if the following IF condition is true then what is the action that fired the trigger?
  if((select COUNT(*) from inserted)=0) 
Options:
  1. Inserted
  2. Delete
  3. Update
  4. Create
View Answer/Explanation:
b
Explanation:

Question No: 10 of 20
Which trigger should be used to make possible un-updatable views work like updatable views 
Options:
  1. After
  2. For
  3. Instead of
  4. None
View Answer/Explanation:
c
Explanation:

  1