Answer / sapan saxena

Super Key: All possible keys which can identify entities in
the table uniquely.
Primary Key: uniquely identify each entity in the table and
does not contain null and duplicate vales.
Composite key: The combination of two or more than two keys
which identifies entities uniquely.
Candidate Key: Nominee for the primary key.
Alternate Key: Rest of the candidate keys which is not the
primary key.
Unique Key: Same as primary key but can accept one null key
only.
Foreign Key: A foreign key is one or more columns whose
value must exist in the primary key of another table.

what is the difference between sql query and google query?

10 Answers   TCS,

---

Explain indexed views and partitioned view with their syntax.

0 Answers  

---

What do we need queues in sql service broker?

0 Answers  

---

Explain what are the restrictions that views have to follow? : SQL Server Architecture

0 Answers  

---

What is tabulation?

0 Answers  

---

Ek lifafa 10 noto se bhara hai usme 2 or 5 ke note nahi hai aur usme total 50Rs hai, to batao lifafe me kon se not kitne hia it’s a challenge thank’s

6 Answers   Broadridge,

---

What is the new security features added in sql server 2014? : sql server security

0 Answers  

---

Diff between Composite key, Alternate Key, Candidate Key, Primary Key, Unique Key, Super Key, Foreign Key

1 Answers  

---

Explain the difference between delete,drop and truncate in SQL Server?

0 Answers   HCL,

---

Do you know how to make remote connection in database?

0 Answers  

---

How do we get current date in SQL Server 2000, Oracle, MS Access?

13 Answers  

---

How to get number of days in a given year?

4 Answers   ADP,

---