what is acid property in database? : Sql dba

0 Answers  

---

What is difference between primary and secondary key?

0 Answers  

---

what are the type of locks ? : Sql dba

0 Answers  

---

Q1.all the depts which has more then 10 empls? Q2.all the dept which does not have any emply? Q3 all the emp which does not have any dept? Q4 get all the emply detais with the dept details it dept is exit otherwise any emp details? Q5 how to debugg the dynamic sql and packages?

2 Answers  

---

What is int identity in sql?

0 Answers  

---

---

What is clustered and non-clustered indexes?

4 Answers   Microsoft,

---

What is union and union all keyword in sql and what are their differences?

0 Answers  

---

How to get second highest salary from a table

3 Answers  

---

If we declare constraints Unique and Not null on a single column then it will act as a Primary key, so what is the use of primary key??

3 Answers  

---

How many scalar data types are supported in pl/sql?

0 Answers  

---

Regarding joins what are the differences you observed in oracle 9i and sql server?

3 Answers   Choice Solutions,

---

How to pronounce postgresql?

0 Answers  

---