2012 Latest SQL Interview Questions

1.       How to create a table (including data) with selected columns of another table?

2.       DDL ,DML and DCL?

3.       Order of order by , group by. Where, having ?

4.       Materialized view ?

5.       Write a query to display n maximum salaries

6.       What are the pseudo columns in oracle? (rowid, rownum)

7.       Difference between procedure and function?

8.      Difference between varchar and varchar2?

9.       Can a table have more than one primary key?

10.   Difference between IN and EXISTS

11.    truncate , drop and delete?

12.    How can we handle exceptions in PL/SQL

13.    Join, Inner joins, Outer Joins

14.    How do you create Index. Advantages of Index

15.    View is physical Database Object or Logical Database object. Can we modify the View ?

16.    What are triggers and types of triggers ?

17.    What is cursor and types?

**********************************************************************************************
**********************************************************************************************
Can we override a constructor if yes, what will happend?

Difference b/w instanceOf and isInstance ?

How can you restrict finally block to not to execute ?

How to make a class immutable ?

Where you will use inner classes ?

In thread creation which mechanism is good and why ?

equals() vs hashCode() ?

Collection vs Collecions ?

Can we serialize static data ?

Can i add duplicate keys/values into hashmap, what will happen ?

I have to do many insert/delete operation on a collection, which one you will use?

 

.can we have multiple struts-config.xml, how ?

 

How to configure log4j in your application?

How to configure ResourceBundle in your application?

Levels of loggers?

What all you mention in logger properties?

How to set class level logger ?

ANT means ? Alternatives to ANT ?

Web container and app server ?

Jboss vs Weblogic ?

 

Authentication vs authorization ?

Tell me Authentication mechanisms by the container ?

What all you will mention in Deployment Descriptor ?

If i have 100 requests hitting a servlet, this scenario how many instances will be created and how ?

How you will count the no.of users accessing an application ?

JAR vs WAR vs RAR ?

Purpose of filters and listeners ?

How to restrict browser cashing ?

How a make a particular JSP to refresh continuously?

Types of comments in JSP(output and hidden) ?

Jspwriter vs Printwriter ?

How to send a mail ?

JNDI ?

What is Ripple Effect?