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

971

---

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 ?

1002

---

What is database deadlock ? How can we avoid them?

1057

---

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

984

---

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

930

---

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

931

---

Does sql allow null values ?

973

---

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

948

---

What are the different class loaders used by jvm?

1099

---

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

1039

---

What is threadfactory?

1101

---

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

1046

---

Do you think that java should have had pointers?

1060

---

Why is string immutable in java?

1102

---

Can constructors be synchronized in java?

1128

---