Interview Questions and Answers for 'Ab' | Search Interview Question

Interview Questions and Answers - Order By Rating

Very Frequently asked. Favorite question in walkins and telephonic interviews. Usually among first few questions. Asked in different variants. Must know for intermediate and expert professionals.Among Top 10 frequently asked questions.

Q301. What is rule regarding overriding equals and hashCode method ?

Core Java

Ans. A Class must override the hashCode method if its overriding the equals method.

Help us improve. Please let us know the company, where you were asked this question :

_{Like Discuss Correct / Improve java collections hashcode hash code equals collections Asked in 44 Companies intermediate frequent}

Try 1 Question(s) Test

Q302. What do you mean by "Java is a statically typed language" ?

Core Java

Ans. It means that the type of variables are checked at compile time in Java.The main advantage here is that all kinds of checking can be done by the compiler and hence will reduce bugs.

Help us improve. Please let us know the company, where you were asked this question :

_{Like Discuss Correct / Improve java statically typed language variable declaration Asked in 7 Companies basic frequent}

Q303. How TreeMap orders the elements if the Key is a String ?

Ans. As String implements Comparable, It refers to the String compareTo method to identify the order relationship among those elements.

Help us improve. Please let us know the company, where you were asked this question :

_{Like Discuss Correct / Improve java collections comparable interface treemap compareto}

Q304. Can we add heterogeneous elements into TreeMap ?

Ans. No, Sorted collections don't allow addition of heterogeneous elements as they are not comparable.

Help us improve. Please let us know the company, where you were asked this question :

_{Like Discuss Correct / Improve java collections comparable interface treemap}

Q305. Will it create any problem if We add elements with key as user defined object into the TreeMap ?

Ans. It won't create any problem if the objects are comparable i.e we have that class implementing Comparable interface.

Help us improve. Please let us know the company, where you were asked this question :

_{Like Discuss Correct / Improve java collections treemap comparable interface}

Q306. Can we have null keys in TreeMap ?

Core Java

Ans. No, results in exception.

Help us improve. Please let us know the company, where you were asked this question :

_{Like Discuss Correct / Improve java collections treemap Asked in 6 Companies Basic frequent}

Very frequently asked Hibernate interview question. Frequently asked in TCS ( based on 2 feedback )

Q307. What are different types of associations in Hibernate ?

Hibernate

Ans. There are 4 types of associations in Hibernate

One to One
One to Many
Many to One
Many to Many

Help us improve. Please let us know the company, where you were asked this question :

_{Like Discuss Correct / Improve hibernate associations Asked in 11 Companies frequent}

Very frequently asked. Favorite question in Walk in Drive of many Indian service companies.

Q308. What is the difference between ArrayList and LinkedList ?

Core Java

Ans. Underlying data structure for ArrayList is Array whereas LinkedList is the linked list and hence have following differences -

1. ArrayList needs continuous memory locations and hence need to be moved to a bigger space if new elements are to be added to a filled array which is not required for LinkedList.

2. Removal and Insertion at specific place in ArrayList requires moving all elements and hence leads to O(n) insertions and removal whereas its constant O(1) for LinkedList.

3. Random access using index in ArrayList is faster than LinkedList which requires traversing the complete list through references.

4. Though Linear Search takes Similar Time for both, Binary Search using LinkedList requires creating new Model called Binary Search Tree which is slower but offers constant time insertion and deletion.

5. For a set of integers you want to sort using quicksort, it's probably faster to use an array; for a set of large structures you want to sort using selection sort, a linked list will be faster.

Sample Code for ArrayList

Sample Code for LinkedList

Help us improve. Please let us know the company, where you were asked this question :

_{Like Discuss Correct / Improve collections java data structures arraylist linkedlist arraylist vs linkedlist Asked in 61 Companies Basic frequent}

Try 1 Question(s) Test

Q309. What is the difference between these 2 annotations ?

@Entity ( name ="EMPLOYEES")
@Entity @Table ( name=""EMPLOYEES"" )

@Entity ( name="EMP")
@Table ( name="EMPLPYEES" )

Hibernate

Ans. First Annotation will set the Entity name as EMPLOYEES and hence will try to map with the same Table name.

The second annotation will make the Entity mapped to table EMPLOYEES irrespective of the Entity Name ( which is class name in this case ).

Third Annotations will set the different names for Enitity and Table and will explicitly map them.

Help us improve. Please let us know the company, where you were asked this question :

_{Like Discuss Correct / Improve hibernate hibernate annotations entity annotation table annotation}

Frequently asked question in companies using Hibernate.

Q310. What is Lazy Initialization in Hibernate ?

Hibernate

Ans. It's a feature to lazily initialize dependencies , relationship and associations from the Database. Any related references marked as @OneToMany or @ManyToMany are loaded lazily i.e when they are accessed and not when the parent is loaded.

Sample Code for Lazy Initialization

Help us improve. Please let us know the company, where you were asked this question :

_{Like Discuss Correct / Improve hibernate lazy loading hibernate lazy initialization hibernate architecture Asked in 77 Companies Basic frequent}

Try 2 Question(s) Test

Q311. What is the difference between int[] x; and int x[]; ?

Core Java

Ans. No Difference. Both are the acceptable ways to declare an array.

Help us improve. Please let us know the company, where you were asked this question :

_{Like Discuss Correct / Improve java array arrays array declaration difference between Asked in 3 Companies basic}

Frequently asked at Manhattan Associates ( Based on 2 feedback )

Q312. What is a Lambda Expression ? What's its use ?

Core Java

Ans. Its an anonymous method without any declaration.

Lambda Expression are useful to write shorthand Code and hence saves the effort of writing lengthy Code.

It promotes Developer productivity, Better Readable and Reliable code.

Sample Code for lambda

Help us improve. Please let us know the company, where you were asked this question :

_{Like Discuss Correct / Improve java java8 lambda expression architecture Asked in 58 Companies expert frequent}

Try 1 Question(s) Test

Q313. What things you would care about to improve the performance of Application if its identified that its DB communication that needs to be improved ?

Solution

Ans. 1. Query Optimization ( Query Rewriting , Prepared Statements )

2. Restructuring Indexes.

3. DB Caching Tuning ( if using ORM )

4. Identifying the problems ( if any ) with the ORM Strategy ( If using ORM )

Help us improve. Please let us know the company, where you were asked this question :

_{Like Discuss Correct / Improve java db database hibernate orm at&t overstock.com performance improvement architecture technical lead architect intermediate}

Very frequently asked. Usually followed by questions related to private constructor and synchronized access. Frequently asked in JPMorgan and TCS (Based on 2 feedback)

Q314. Explain Singleton Design Pattern ?

Design

Ans. http://www.buggybread.com/2014/03/java-design-pattern-singleton-interview.html

Help us improve. Please let us know the company, where you were asked this question :

_{Like Discuss Correct / Improve java design pattern singleton at&t ebay fidelity india united healthcare india Asked in 46 Companies intermediate frequent}

Q315. Write an SQL to find all records having all upper case alphanumeric characters in a field ?

Ans. Select * from Table where field = upper(field)

Help us improve. Please let us know the company, where you were asked this question :

_{Like Discuss Correct / Improve sql database}

Q316. Write an SQL to find all records having all numeric characters in a field ?

Ans. Select * from Table where isnumeric(field) = 1;

Help us improve. Please let us know the company, where you were asked this question :

_{Like Discuss Correct / Improve sql database}

Q317. What are the conventions regarding constant variables or static final variables ?

Core Java

Ans. They should be named all in upper case with underscore separating words.

Moreover the name should be such that it identifies the value. For example, if we are using constant for employee Id 123, it should be named something like EMPLOYEE_ID_123 and not EMPLOYEE_ID

Help us improve. Please let us know the company, where you were asked this question :

_{Like Discuss Correct / Improve constants variable names java conventions}

Q318. 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 ?

1. Insert into the DB Table. If exception occurs, update the existing record.
2. Check if the record exists and update it if it exists, If not insert a new record.

Solution

Ans. In first case, there would be 2 DB calls in worst case and 1 in best case. In 2nd approach there will be always 2 DB calls.

Decision on the approach should depend on the following considerations -

1. How costly is the call to DB ? Are we using indices , hibernate etc

If calls to DB are costly , 1st approach should be the choice.

2. Exception Book keeping load upon exception.

The benefit of saving 1st call in approach 1 should be bigger than the Book keeping for the exception.

3. Probability of the exception in first apparoach.

If the DB Table is almost empty, it makes sense to follow Approach 1 as majority of the 1st calls will pass through without exception.

Help us improve. Please let us know the company, where you were asked this question :

_{Like Discuss Correct / Improve database insert-update db exceution plan db strategy design architecture technical lead}

Q319. Do you know of any DB statement that can be used if we would like to insert multiple rows into a table ?

Database

Ans. We can use INSERT ALL.

Help us improve. Please let us know the company, where you were asked this question :

_{Like Discuss Correct / Improve database insert dml statement sql}

Q320. What is Closeable ?

Core Java

Ans. A Closeable is an interface which is a source or destination of data that can be closed.

Help us improve. Please let us know the company, where you were asked this question :

_{Like Discuss Correct / Improve closeable interfaces intermediate rare}

Q321. What is the advantage of JPA ?

Database

Ans. Its a specification that guides the implementation of ORM frameworks. Implementations abiding by the specification would mean that one can be replaced with other in an application without much hassle. Only the Features that are added over the specification needs to be taken care of if any such change is made.

Help us improve. Please let us know the company, where you were asked this question :

_{Like Discuss Correct / Improve jpa hibernate orm technologies}

Q322. Why is a constant defined as a static final in Java?

Core Java

Ans. Final makes sure that the value doesn't change after initialization and static makes sure that there is only one copy that can be shared across objects.

Making it non static will unnecessarily create a different copy per object wherein the same value will kept for all copies ( as its final and cannot be changed ).

Help us improve. Please let us know the company, where you were asked this question :

_{Like Discuss Correct / Improve java static final variables variable constants basic frequent}

Frequently asked to fresh graduates and less experienced.

Q323. Why do we write public static void main ? Can we use some other syntax too for main ?

Core Java

Ans. 1. public is the access modifier that makes the method accessible from anywhere, static is the keyword that makes it accessible even without creating any object, void means it doesn't return anything , String args[] is the array of argument that the method receives.

2. If we use main without the string args , it will compile correctly as Java will treat it as just another method. It wont be the method "main" which Java looks for when it looks to execute the class and hence will throw

Error: Main method not found in class , please define the main method as:
public static void main(String[] args)

3. Main is not a keyword but a special string that Java looks for while initiating the main thread.

Help us improve. Please let us know the company, where you were asked this question :

_{Like Discuss Correct / Improve java main method Asked in 4 Companies basic frequent}

Try 1 Question(s) Test

Q324. What things you will look for if you get following exception while making DB call ?

table or view does not exist

Database

Ans. First will check if the table or view actually exist in the DB

If it does , Will make sure to see that the application has rights on the schema that holds the respective Table.

Will then make sure that we have prefixed the schema with the table name while accessing it.

Will then make sure that its not DB Cache that's causing it as the table DDL might have been created recently.

Help us improve. Please let us know the company, where you were asked this question :

_{Like Discuss Correct / Improve sql database oracle technical lead}

Q325. What's the benefit for specifying constraints like Not Null , Primary Key explicitly instead of specifying it against the column ?

Database

Ans. In case we specify them explicitly we can have control over constraint name as otherwise they will be system generated. It provides an ease in case we plan to drop the constraint in future.

Help us improve. Please let us know the company, where you were asked this question :

_{Like Discuss Correct / Improve sql database oracle}

Q326. How can we disable a constraint ?

Database

Ans. alter table
table_name
DISABLE constraint
constraint_name;

Help us improve. Please let us know the company, where you were asked this question :

_{Like Discuss Correct / Improve sql database oracle}

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

Database

Ans. Yes, but the respective key in the foreign table should be declared Unique.

Help us improve. Please let us know the company, where you were asked this question :

_{Like Discuss Correct / Improve sql database oracle Asked in 2 Companies}

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

Database

Ans. We need to create a sequence.

Help us improve. Please let us know the company, where you were asked this question :

_{Like Discuss Correct / Improve sql database oracle}

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

Database

Ans. NOT NULL

Help us improve. Please let us know the company, where you were asked this question :

_{Like Discuss Correct / Improve sql oracle database ddl constraint table creation}

Q330. Will this code compile ?

public class BuggyBread1{
abstract public void test();
}

Core Java

Ans. No. It will give the compilation error saying "The abstract method test in type BuggyBread1 can only be defined by an abstract class".

We need to declare the class abstract for it to have any abstract method.

Help us improve. Please let us know the company, where you were asked this question :

_{Like Discuss Correct / Improve java oops abstract class abstract methods java compilation error}

Search Interview Questions

Help us and Others Improve. Please let us know the questions asked in any of your previous interview.