Answer Posted / manoj pandey

Foreign Key is used to establish Referential Integrity/Constraint between 2 tables. Mainly it is a column in a table that uniquely identifies every record in another table. A table can have 1 or more than 1 FKs.

~Manoj (sqlwithmanoj.wordpress.com)

Is oracle faster than sql server?

884

---

What is temporal table?

820

---

What do you mean by authentication modes in sql server?

1025

---

Your company has 50 branches all over the country all the branches, including the head office have sql server as the database every night all 50 branches upload certain information to the head office which replication topology is best suited for the above scenario?

1066

---

Explain syntax for disabling triggers?

967

---

What is view in sql?

849

---

Can a table have 2 foreign keys?

855

---

What is a cache in ssrs?

127

---

What is bookmark link in ssrs?

232

---

Explain what is dbcc?

961

---

How do I edit a procedure in sql server?

897

---

What happens if you are trying to access a schema not owned by you?

911

---

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

884

---

What are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture

947

---

What is collation?

1098

---