What should be done for auto generating primary key id in a table ?

1025

---

Can we have foreign key reference to a non primary key column ?

1039

---

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

1030

---

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 ?

1062

---

What is database deadlock ? How can we avoid them?

1141

---

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

1036

---

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

992

---

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

998

---

Does sql allow null values ?

1036

---

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

1009

---

What are the different class loaders used by jvm?

1156

---

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

1086

---

What is threadfactory?

1157

---

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

1104

---

Do you think that java should have had pointers?

1130

---