Answer Posted / anand k

the magic tables are deleted and inserted.
while we are inserting or deleting a rows into a object the
magic tables were created and after the commit transaction
the tables are removed.so it is called magic tables

What is the language structure to add a record to a table?

963

---

What is the optimal disk configuration for a database server and what raid configurations would you use if budget is not a constraint?

908

---

How to assign null values to variables or columns?

910

---

How to list all schemas in a database?

1003

---

Explain cdc and sql injection?

911

---

how many clustered indexes can be created on a table? : Sql server database administration

1066

---

Can we perform backup restore operation on tempdb?

953

---

Define the one-to-one relationship while designing tables.

855

---

Why normalization is used?

965

---

What is the difference between dropping a database and taking a database offline?

1115

---

How we can compare two database data?

873

---

How to use order by with union operators in ms sql server?

967

---

what is checksum in sql server.........???

1618

---

What is an indice?

982

---

What are logical/boolean operations in ms sql server?

978

---