ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
tip   To Refer this Site to Your Friends   Click Here
Google
 
Categories  >>  Software  >>  Databases  >>  SQL Server
 
 


 

 
 Oracle interview questions  Oracle Interview Questions
 SQL Server interview questions  SQL Server Interview Questions
 MS Access interview questions  MS Access Interview Questions
 MySQL interview questions  MySQL Interview Questions
 Postgre interview questions  Postgre Interview Questions
 Sybase interview questions  Sybase Interview Questions
 DB Architecture interview questions  DB Architecture Interview Questions
 DB Administration interview questions  DB Administration Interview Questions
 DB Development interview questions  DB Development Interview Questions
 SQL PLSQL interview questions  SQL PLSQL Interview Questions
 Databases AllOther interview questions  Databases AllOther Interview Questions
Question 
Which virtual table does a trigger use?
 Question Submitted By :: Guest
I also faced this Question!!     Rank Answer Posted By  
 
  Re: Which virtual table does a trigger use?
Answer
# 1		 
Triggers use magic tables(update and delete tables)
 
Is This Answer Correct ?    4 Yes 11 No
Chandra Rekha
 
  Re: Which virtual table does a trigger use?
Answer
# 2		 
Triggers use magic tables - Inserted and Deleted 

updated or update table not available.
 
Is This Answer Correct ?    15 Yes 1 No
Kmbkrishnan
 
 
 
  Re: Which virtual table does a trigger use?
Answer
# 3		 
Yes,Only inserted and deleted are available in SQL
 
Is This Answer Correct ?    5 Yes 1 No
Lenin
 
  Re: Which virtual table does a trigger use?
Answer
# 4		 
Inserted and Deleted.. right answer

what is updated....nonsence.
 
Is This Answer Correct ?    4 Yes 1 No
Gourav
 
  Re: Which virtual table does a trigger use?
Answer
# 5		 
triggers use 2 virtual tables called OLD and NEW.
 
Is This Answer Correct ?    1 Yes 7 No
Learner
 
  Re: Which virtual table does a trigger use?
Answer
# 6		 
DML triggers use the deleted and inserted logical 
(conceptual) tables. They are structurally similar to the 
table on which the trigger is defined, that is, the table 
on which the user action is tried. The deleted and inserted 
tables hold the old values or new values of the rows that 
may be changed by the user action. For example, to retrieve 
all values in the deleted table, use
 
Is This Answer Correct ?    0 Yes 0 No
Yoshita
 

 
 
 
Other SQL Server Interview Questions
 
  Question Asked @ Answers
 
what is bit data type? and what are the information that can be stored inside a bit column?  2
Differnce between sel server 2000 and 2005  3
Which is better in performance - CONSTRAINT or TRIGGER over a column which restricts say an input of particular value in a column of a table? Accenture3
Create Index myIndex On myTable(myColumn) What type of Index will get created after executing the above statement  2
WHAT OPERATOR PERFORMS PATTERN MATCHING? CTS2
What is difference beteen Migration and Upgrdation? Satyam4
can any one answer this query,thank you in advance Table 1 has 2 columns: EmployeeId, T shirtsize(values can be 1,2,3) Table 2 has 2 columns: EmployeeId, Region Write SQL to Find the region which has the largest number of people with Tshirt size=3 Google10
What is SQL server agent? SAP-Labs2
wht's the differece between sqlserver05 and sqlserver2000  3
How to Create Login and User through query in Sql server 2005.and also how to delete Login and User through query?  2
Is it possible to allow NULL values in foreign key? I s it possible to use different constraints for the same column in the table (i.e) (id int NOT NULL,UNIQUEUE)  1
What's the maximum size of a row?  4
What is a view?  4
What is a deadlock and what is a live lock? How will you go about resolving deadlocks? Microsoft1
Explain the new features of SQL server 2000?  1
What is normalization?  6
There is table like Events...in that name ,startdate ,enddate,location are the column names write a stored Procedure for this table to get events by Months "GetEventsByMonths"  1
What is INTVAL( )and where we use Plz any body help me  1
Which institute is best for SQL Server 2005 Training?  5
how to get the maximum among two tables,for example table 1 (dep1) have (emp_id,emp_name,salary) columns and table 2 (dept2) have (emp_id,emp_name,salary) columns,i want which employee have the maximum salary among two tables? Lason2
 
For more SQL Server Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us |   interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com