wirte the syntax of update query?

3 Answers   IBM,

---

waht is the difference between primary key and super key?

9 Answers  

---

what is difference between DBMS and RDBMS?

2 Answers   Metric Stream,

---

What are the Limitations of a CHECK Constraint ?

5 Answers  

---

How are extents allocated to a segment?

0 Answers  

---

what is the output of select * from emp where null=null & select * from emp where 1=1

8 Answers   IMS Health, NIIT,

---

WHAT IS THE DIFFERENCE BETWEEN PRIMARY KEY(PK) CONSTRAINT AND UNIQUE KEY(UK) + NOT NULL(NN) CONSTRAINT ASSIGN TO A COLUMN ? INSTEAD OF ASSIGNING PK ,WE CAN ASSIGN UK + NN TO A COLUMN. WHAT ARE THE MARRITS AND DEMARITS BETWEEN THE ABOVE TWO?THE ABOVE TWO ARE SAME,THEY DON'T ALLOW DUPLICATE AS WELL AS NULL VALUES.

3 Answers  

---

What are the major difference between truncate and delete?

0 Answers  

---

when do u go for hash partitioning?

1 Answers  

---

What is a cursor and what are the steps need to be taken?

0 Answers  

---

Oracle

0 Answers   ABC, Genpact, HUI, Oracle,

---

What is the exact use of Collections?

0 Answers  

---