Differentiate between delete and truncate table?

0 Answers  

---

What is the differnce between Order by and Group by

1 Answers  

---

How does non-cluster index functions?

0 Answers   Alcatel-Lucent,

---

Does facebook use graph database?

0 Answers  

---

Give the syntax of exception handling used in DBMS?

0 Answers   C DAC, CDAC,

---

---

Which is the best sorting method if i have to sort the students of Harvard University according to their first name?

1 Answers   CybAge,

---

How does database replication work?

0 Answers  

---

How concurrency problems effect the database?

0 Answers   BirlaSoft,

---

What is lagging in DBMS ?

0 Answers   Hexaware,

---

Two tables emp(empid,name,deptid,sal) and dept(deptid,deptname) are there.write a query which displays empname,corresponding deptname also display those employee names who donot belong to any dept.

0 Answers   Amazon,

---

how to implement dense rank in rank transformation in Informatica? so that output should be like 1,1,2,3 and not like 1,2,3,4

1 Answers  

---

What is the candidate key used for?

0 Answers   BirlaSoft,

---