What are Magic Table?
Answer Posted / durga prasad.g
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 ? | 67 Yes | 7 No |
Post New Answer View All Answers
What functions can a view be used to performed?
What are the new features are introduced in sql server 2012 reporting services?
What are the advantages to use stored procedures?
What are three major types of constraints?
i have made a project i vb.net n created a .exe of it after installing it in to any pc, the database (sql express) is not geting accesed i.e the aplication cuts the link of the database, so plz help in this matter.
What sql server means?
Explain filtered indexes?
Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.
What is lock escalation? : sql server database administration
Define candidate key, alternate key, and composite key.
What are the five major components of a dbms?
What happens if null values are involved in boolean operations?
What are logical/boolean operations in ms sql server?
What is conditional split?
What is the default port for SQL Server over a firewall?