Answer Posted / vijayabhaskarreddy

wen we are performing DML operations into table . amagic
table created in the memory.
inserted magic table
deleted magic table
update magic table

What are commonly used odbc functions in php?

721

---

What is a filestream?

735

---

How will you optimize a stored procedure optimization?

676

---

Explain left outer join and right outer join?

759

---

Explain what is lock escalation?

766

---

---

If you are given access to a SQL Server, how do you find if the SQL Instance is a named instance or a default instance?

841

---

What are ddl (data definition language) statements for tables in ms sql server?

749

---

What is system stored procedures?

760

---

What are the basic functions for master, msdb, model, tempdb databases?

784

---

Do you think BCNF is better than 2NF & 3NF? Why?

999

---

What are exact numeric data types in ms sql server?

687

---

What number aggregate functions are accessible there in sql?

772

---

How to find the source of a table in sql server?

709

---

what is database replicaion? : Sql server database administration

812

---

what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration

720

---