Explain the difference between inner and outer join ?
What are temp tables ?
What is database deadlock ?
What should be done for auto generating primary key id in a table ?
Can we have foreign key reference to a non primary key column ?
What's the benefit for specifying constraints like not null, primary key explicitly instead of specifying it against the column ?
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 ?
What is database deadlock ? How can we avoid them?
Describe the steps needed to execute a sql query using jdbc.
Which constraint cannot be specified as an explicit constraint and should be specified with the column only ?
What is jdbc? Describe the steps needed to execute a sql query using jdbc.
Does sql allow null values ?
Write an sql to find all records having all upper case alphanumeric characters in a field ?
What does the jdbc connection interface?
What is the advantage of namedparameterjdbctemplate?