What are Magic Table?
- 34 Answers
- 80315 Views
- 3i Infotech, Digiweb, Evalueserve, NIIT, PL, I also Faced
- E-Mail Answers
Answer Posted / sharda prasad shukla
MAGIC TABLES NOTHING BUT INSERTED AND DELETED WHICH ARE
TEMPORARY OBJECTS CREATED BY SERVER INTERNALLY TO HOLD
RECENTLY INSERTED VALUES IN THE CASE OF INSERT,TO HOLD
RECENTLY DELETED VALUES IN THE CASE OF DELETE,TO HOLD
BEFORE UPDATING VALUES OR AFTER UPDATING VALUES IN THE CASE
OF UPDATE.
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
How efficient you are in oracle and SQL server?
explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
Is it possible to have clustered index on separate drive from original table location?
What is temporary table in sql server? Why we use temp table?
What is normalization and what are the advantages of it?
What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?
What are the different subsets of sql?
What kind of problems occurs if we do not implement proper locking strategy?
What is subquery? Explain the properties of a subquery?
What is the difference between for xml raw and for xml auto?
How do I start sql server 2017?
Why use identity in sql server?
What is a scheduled job or what is a scheduled task?
How do I create a trace in sql server?
Why and when do stored procedure recompile?
