After using delete statement in sql query to delete some records...to ret

Advertise your Business Here

Refer this Site

Login | Sign Up


	Did you received any Funny E-Mails from your Friends and like to share with rest of our friends? Yeah!! you can post that stuff HERE

Categories >> Software >> Databases >> SQL Server

Oracle Interview Questions

SQL Server Interview Questions

MS Access Interview Questions

MySQL Interview Questions

Postgre Interview Questions

Sybase Interview Questions

DB Architecture Interview Questions

DB Administration Interview Questions

DB Development Interview Questions

SQL PLSQL Interview Questions

Databases AllOther Interview Questions

Question

After using delete statement in sql query to delete some 
records...to retrieve the deleted records we can get using 
rollback command but till that where it stores means 
particular location name i need....(after deleting and 
rollback )

Question Submitted By :: Priyanka

I also faced this Question!!

Rank

Answer Posted By

Re: After using delete statement in sql query to delete some records...to retrieve the deleted records we can get using rollback command but till that where it stores means particular location name i need....(after deleting and rollback )

Answer
# 1

wen we are performing DML operations into table . 2 magic 
tables created in the memory i.e., in Master Database.
Names of the 2 tables
1) INSERTED
2) DELETED 

When we insert any record then that record will be added 
into this Inserted table initially, similarly while 
updating a record a new entry will be inserted into 
Inserted table & old value will be inserted into Deleted 
table.

In the case of deletion of a record then it will insert 
that record in the Deleted table

when we call rollback command the deleted record retrieved
from Deleted table. Once committed we can't call rollback.

Is This Answer Correct ?

12 Yes

3 No

Nagesh

Answer
# 2

When we delete the records using triggers only the deleted 
records will be stored in deleted table.

But if we do delete using begin transaction, the deleted 
records will be stored in transaction log file. We cannot 
see it visually.

Is This Answer Correct ?

1 Yes

0 No

Saravanan P

Question	Asked @	Answers
Other SQL Server Interview Questions


what is meant by sql injection with example and one more question how to catch the errors in sqlserver		1
Hello all, I have data like :- year amt 2004 10 2005 20 2006 30 Now i want output as:- 2004 2005 2006 10 30 60 but i have to use here group by on year.So, i need a single query within that i can find.		2
Why we need a group by clause?		3
What is a NOLOCK?		3
What is the use of DBCC commands?		1
what is curser.		8
What is an extended Stored Procedure?		1
what is differece between union and union all		4
Why Do you want to work in this company?	HCL	3
What is the difference between DTS and SSIS?	Allianz	3
What is Schema? and why we use schemas?		1
Create Index myIndex On myTable(myColumn) What type of Index will get created after executing the above statement		2
How to create logins using windows Authentication mode?		2
What is a sub-query? When would you use one?		3
What is the diff between Dynamic queries and static queries	ICS-Integrated-Computer-Solutions	1
Difference between Function and Procedure-in general?		3
How can I create a plain-text flat file from SQL Server as input to another application?		2
What is the difference between 2-Tier architecture and 3-Tier architecture	Oracle	10
What is the system function to get the current user's user id?	HCL	1
What is an index?	Yardi-Software	7

For more SQL Server Interview Questions Click Here


Copyright Policy \| Terms of Service \| Help \| Site Map 1 \| Articles \| Site Map \| Site Map \| Contact Us \|

Copyright © 2007 ALLInterview.com. All Rights Reserved.

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