Answer Posted / shyam

Union: It will combine the output of two or more queries &
it will eliminate duplicate values.

Union all:It will combine the output of two or more queries
& it will not eliminate duplicate values.

Mention the differences between local and global temporary tables.

1054

---

What do you need to connect php to sql server?

1118

---

What does it mean to invest in the index?

980

---

How many replicas are maintained for each SQL Azure database?

142

---

Does a sql server 2005 select statement require a from?

1025

---

What is create command?

979

---

What are the different acid properties?

1078

---

What are different types of replication in sql server?

1100

---

What are truncate options available in sql server? : sql server database administration

1039

---

what are questions asked in TCS for database tester (sqlserver)for 2-3 exp?

5937

---

Do you know data definition language, data control language and data manipulation language?

1051

---

What is data source view or dsv? : sql server analysis services, ssas

1019

---

Explain the properties of a relational table?

1035

---

How to convert numeric expression data types using the cast() function?

1078

---

Explain the various types of concurrency problem. I.e. Lost or buried updates, uncommitted dependency, inconsistent analysis, phantom read?

961

---