Answer Posted / jebastin unnatha raja

Joins-> Joins allow You to view and retrive the data from multible related tables in a single result set.

Primary key-> A primary key is used to uniquely identify each row in a table.A primary key columns can not contain a nULL values.

foriegn key-> A foreign key is a field (or fields) that points to the primary key of another table. The purpose of the foreign key is to ensure referential integrity of the data

super Key-> A superkey is a combination of attributes that can be uniquely used to identify a database record. A table might have many superkeys.

Candidate key-> A candidate key is one that can identify each row of a table uniquely. Generally a candidate key becomes the primary key of the table.

how to define testing of network layers? : Sql server database administration

975

---

How do I manually uninstall an instance of sql server 2016?

1039

---

Can truncate be rolled back?

951

---

How to create database with physical files specified in ms sql server?

1003

---

What are points to remember while using the fillfactor argument?

972

---

What do you understand by replication in sql server? Mention the different types of replication in sql server.

949

---

what is difference between NULL and ISNULL in SQL Server 2008?

1020

---

What is best institute to Learn DotNET And SQL in chennai?

2163

---

Is ssrs support other database except ms sql server?

142

---

what is normalization? Explain different levels of normalization? : Sql server database administration

1333

---

The external application that is executed in one of the tasks does not have a log file, but only a screen log. How can I save the data from the screen? : sql server management studio

1017

---

What are security principals used in sql server 2005?

989

---

Is foreign key a primary key?

1098

---

Mention the command used to rename the database.

1009

---

Explain the different types of joins?

997

---