What's the benefit for specifying constraints like not null, primary key explicitly instead of specifying it against the column ?

938

---

If you are given a choice to implement the code to either insert a record or update if already exist, which approach will you follow ?

968

---

What is database deadlock ? How can we avoid them?

1019

---

Describe the steps needed to execute a sql query using jdbc.

945

---

Which constraint cannot be specified as an explicit constraint and should be specified with the column only ?

902

---

What is jdbc? Describe the steps needed to execute a sql query using jdbc.

880

---

Does sql allow null values ?

930

---

Write an sql to find all records having all upper case alphanumeric characters in a field ?

917

---

What are the different class loaders used by jvm?

1069

---

Describe, in general, how java's garbage collector works?

1001

---

What is threadfactory?

1055

---

How substring() method of string class create memory leaks?

1007

---

Do you think that java should have had pointers?

1027

---

Why is string immutable in java?

1072

---

Can constructors be synchronized in java?

1082

---