What are Magic Table?
- 34 Answers
- 80282 Views
- 3i Infotech, Digiweb, Evalueserve, NIIT, PL, I also Faced
- E-Mail Answers
Answer Posted / manish kumar
Magic tables are created when data is inserted or updated
in the normal tables. They get deleted when the commit is
done. They are used for the auditing purposes.
They are useful in keeping track of the insertion and
updation on the database.
| Is This Answer Correct ? | 7 Yes | 3 No |
Post New Answer View All Answers
What are different types of constraints?
What are the pros and cons of putting a scalar function in a queries select list or in the where clause?
Can you index views?
How to provide default values to function parameters?
How do I create a trace in sql server?
Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?
How to remove duplicate rows from table except one?
Is it possible to have clustered index on separate drive from original table location?
How to enter binary string literals in ms sql server?
Can one drop a column from a table?
What is subquery? Explain the properties of a subquery?
What are the different SQL Server Versions you have worked on?
Disadvantages of the indexes?
Can sql servers link to other servers like oracle?
What is a scheduled job or what is a scheduled task?
