What is differance unique key and primary key.

7 Answers   EDS,

---

What is sql used for?

0 Answers  

---

define data blocks ? : Sql dba

0 Answers  

---

What is Materialized View? In What Scenario we Use Materialized View?

2 Answers   Dinesh, Marlabs,

---

How many primary keys can a table have?

0 Answers  

---

---

Does indexing improve query performance?

1 Answers  

---

Given two tables Student(SID, Name, Course) and Level(SID, level) write the SQL statement to get the name and SID of the student who are taking course = 3 and at freshman level.

9 Answers   Oracle,

---

Can a key be both primary and foreign?

0 Answers  

---

How many sql statements are used? Define them.

0 Answers  

---

What is clustered and non-clustered indexes?

4 Answers   Microsoft,

---

Why we use join in sql?

0 Answers  

---

Which are the most commonly used sql joins?

1 Answers  

---