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

Interview Questions and Answers - Order By Rating

Q181. What is the advantage of using static final or constant variables in Java ?

Ans. Better Control - If the value is being used at multiple locations , that can be controlled better from single place. Any change would only require making single change.

Meaning , Aliasing and Better Readability - Sometimes its easy to read the value by its meaning or alias ( 0 as ZERO or 0 as NEUTRAL_VALUE ).

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

_{Like Discuss Correct / Improve static final final variable variable constants}

Q182. What could be the problems due to the usage of static methods and elements ?

Core Java

Ans. static methods and static elements are shared by all objects of a class and hence could create problem.

Static methods are not synchronized by default and hence could create problem when accessed through multiple threads. Static elements are shareable by class and hence state of one object could be altered by another object.

Some limitations with Unit testing as not all mocking framework facilitate mocking them. Power mock allows but Mockito doesn't

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

_{Like Discuss Correct / Improve static static method static variables}

Q183. What will be the crontab to run a job every last day of month ?

Unix

Ans. 59 23 28-31 * * [ "$(date +%d -d tomorrow)" = "01" ] && job_name

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

_{Like Discuss Correct / Improve unix crontab Asked in 1 Companies}

Frequently asked in Accenture.

Q184. What is your biggest achievement at work ?

General

Ans. [Open Ended Answer]

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

_{Like Discuss Correct / Improve general question non technical question Asked in 20 Companies frequent}

Q185. How to delete duplicate elements in a table ?

Database

Ans. DELETE FROM TABLE WHERE ROW_NUM NOT IN ( SELECT MAX(ROW_ID) FROM TABLE GROUP BY DUPLICATE_FIELD )

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

_{Like Discuss Correct / Improve Asked in 3 Companies}

Q186. How would you process a 20 gb file with an application only having access to 4gb memory ?

BigData

Ans. Load the file in chunks and then process. If we need to do analytic, we can process analytic information for those chunks and then reprocess the processed information from each chunk.

For example - we need to average all marks in the file. We can divide the file and load into 5 chunks and calculate average for each chunk. Then we can collect averages for all 5 chunks and then calculate the final average.

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

_{Like Discuss Correct / Improve bigdata processing big data Asked in 1 Companies}

Q187. Difference between relational databases and NoSQL databases ?

Database

Ans. https://www.mongodb.com/scale/nosql-vs-relational-databases

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

_{Like Discuss Correct / Improve database management nosql database relational database Asked in 1 Companies frequent}

Q188. Design an online shopping site system ?

Design

Ans. AWS Services - CloudFront for distribution / caching, EC2 for computing, EBS for block storage , S3 for object storage , RDS for database , Kinesis for streaming , CloudWatch for monitoring.

Technologies - Java for back end with Spring Boot , Angular , RxJs for front end .

Architecture - Service Oriented. Multi layer.

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

_{Like Discuss Correct / Improve Asked in 1 Companies}

Frequently asked in Alibaba (Based on 2 feedback)

Q189. What is the best Memory setting for JVM ?

Core Java

Ans. In Java JVM memory settings is done by use the arguments -Xms -Xmx. Use M or G after the numbers for indicating Megs and Gigs of bytes respectively. -Xms indicates the minimum and -Xmx the maximum.

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

_{Like Discuss Correct / Improve jvm memory management jvm best memory setting Asked in 1 Companies intermediate}

Q190. Difference between JDBC and Hibernate ?

Database

Ans. JDBC is a standard Java Api for Database communication whereas Hibernate is an ORM framework that uses JDBC to connect with Database.

Hibernate is another layer of object table mapping over JDBC that provide a database independent, object oriented and an efficient way of database communication.

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

_{Like Discuss Correct / Improve JDBC Hibernate JDBC vs Hibernate Asked in 3 Companies}

Q191. Implement the following method ?

int findMax(int[] items)

Core Java

Ans. int findMax(int[] items){
   int maxNumber = 0;
   for(int x:items){
      if(x > maxNumber){
         maxNumber = x;
      }
   }

   return maxNumber;
}

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

_{Like Discuss Correct / Improve coding code find max number in an array Asked in 1 Companies}

Q192. Write a Program to check if 2 strings are Anagrams ?

Core Java

Ans. public void checkIfAnagram(String str1,String str2){
boolean anagram = true;
for(char c:str1.toCharArray()){
if(!str2.contains(String.valueOf(c))){
System.out.println("Strings are Anagrams");
anagram = false;
}

if(anagram == true){
System.out.println("Strings are not Anagrams");
}
}
}

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

_{Like Discuss Correct / Improve check if 2 strings are Anagrams Asked in 30 Companies basic frequent}

Q193. What are the advantages of using distributed database management system ?

Database

Ans. Reliability and Continuity if some of the sites goes down.Easy Scaling up and Down as sites can be added or removed without impacting business continuity.

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

_{Like Discuss Correct / Improve dbms database management system distributed database management system Asked in 1 Companies}

Q194. How is String class unique ?

Core Java

Ans. String class is immutable as well as final. Because of these properties , String objects offer many benefits

1. String Pool - When a string is created and if it exists in the pool, the reference of the existing string will be returned instead of creating a new object. If string is not immutable, changing the string with one reference will lead to the wrong value for the other references.

Example -

String str1 = "String1";
String str2 = "String1"; // It doesnt create a new String and rather reuses the string literal from pool

// Now both str1 and str2 pointing to same string object in pool, changing str1 will change it for str2 too

2. To Cache its Hashcode - If string is not immutable, One can change its hashcode and hence its not fit to be cached.

3. Security - String is widely used as parameter for many java classes, e.g. network connection, opening files, etc. Making it mutable might possess threats due to interception by the other code segment.

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

_{Like Discuss Correct / Improve immutable immutability immutability String string class Asked in 1 Companies}

Q195. What is Dirty read in Database Transactions ?

Database

Ans. A dirty read occurs when a transaction is allowed to read data from a row that has been modified by another running transaction but not yet committed.

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

_{Like Discuss Correct / Improve database transaction Asked in 8 Companies}

Q196. Write an SQL Statement to add a foreign key constraint in oracle ?

Database

Ans. ALTER TABLE <Table_Name> ADD CONSTRAINT <Constraint_Name> FOREIGN KEY (<Column_Name>) REFERENCES <Foreign_Table>(<Foreign_Column>);

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

_{Like Discuss Correct / Improve database add foreign key constraint}

Basic and Very Frequently asked.

Q197. What is Polymorphism in Java ?

Core Java

Ans. Polymorphism means the condition of occurring in several different forms.

Polymorphism in Java is achieved in two manners

1. Static polymorphism is the polymorphic resolution identified at compile time and is achieved through function overloading whereas

2. Dynamic polymorphism is the polymorphic resolution identified at runtime and is achieved through method overriding.

Sample Code for overloading

Sample Code for overriding

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

_{Like Discuss Correct / Improve polymorphism object oriented programming (oops) oops concepts oops concepts Asked in 108 Companies Basic frequent}

Try 2 Question(s) Test

Frequently asked to fresh graduates.

Q198. What is ACID ?

Database

Ans. ACID stands for Atomicity, Consistency, Isolation, Durability is a set of properties of database transactions.

Atomicity means all or nothing. i.e parts of a transaction shouldn't commit if any one of them fails. Either the whole transaction should succeed or it should be complete rollback.

Consistency means that any transaction should lead database from one stabe state to another.

Isolation means that the execution of transaction results in a system state that would be obtained if transactions were executed serially.

Durability means that when a transaction is committed it forms the permanent state of database.

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

_{Like Discuss Correct / Improve database acid Asked in 7 Companies Intermediate}

Try 1 Question(s) Test

Q199. What is the difference between Collections.emptyList() and creating new instance of List using new ?

Core Java

Ans. But Collections.emptyList() returns an Immutable list whereas new arraylist() creates a mutable list.

Advantage of getting an empty list using Collections.emptyList is that it returns a singleton list which can be shared among many references and hence made immutable. This is good fit for situations where we would like to initialize a list to basic minimum empty to avoid null pointer exception.

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

_{Like Discuss Correct / Improve collections Collections.emptyList immutable immutability immutability}

Q200. How to Bulk upload the data into Oracle database?

Database

Ans. We can use external table feature of Oracle.

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

_{Like Discuss Correct / Improve Asked in 1 Companies Intermediate}

Q201. There is a Table Student having Student Id, Name and Total Marks. Can you please write an SQL that will display the maximum marks obtained by a student ?

Database

Ans. SELECT MARKS FROM STUDENT ORDER BY MARKS DESC LIMIT 1;

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

_{Like Discuss Correct / Improve database query Asked in 1 Companies}

Q202. How to count total number of tables in database ?

Database

Ans. SELECT COUNT(*) FROM information_schema.tables

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

_{Like Discuss Correct / Improve database query Asked in 1 Companies}

Q203. Have you heard about the external table feature of Oracle ?

Database

Ans. The external tables feature is a complement to existing SQL Loader functionality. It enables to access data in external sources as if it were in a table in the database. We have used it few times for replicating tables across different database systems.

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

_{Like Discuss Correct / Improve external table oracle Asked in 1 Companies rare}

Q204. What is a Database Trigger ?

Database

Ans. A trigger is a special kind of stored procedure that automatically gets executed upon an event in the database server.

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

_{Like Discuss Correct / Improve database trigger Asked in 10 Companies basic frequent}

Q205. What is a Database sequence ?

Database

Ans. Its a feature wherein database creates unique values incremental values to be stored as primary key for the table.

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

_{Like Discuss Correct / Improve database sequence Asked in 1 Companies}

Q206. What is a Database Procedure ?

Database

Ans. Stored procedures are a batch of SQL statements along with programming constructs ( if else, loops etc ) and stored as a single program that can be called by different clients and hence reused.

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

_{Like Discuss Correct / Improve database stored procedure Asked in 2 Companies basic frequent}

Frequently asked to Fresh graduates.

Q207. Write a program to implement Binary search ?

Core Java

Ans. http://algs4.cs.princeton.edu/11model/BinarySearch.java.html

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

_{Like Discuss Correct / Improve binary search search Asked in 5 Companies basic frequent}

Try 1 Question(s) Test

Q208. Why Collection interface does not extend Cloneable interface ?

Core Java

Ans. Here is the list of classes that implements Collections Interface - http://www.buggybread.com/2015/02/java-collections-classes-that-implement.html

Having Collection interface to extend Cloneable interface would mean necessarily implement clone method by all implementing classes. As not all collection classes allow duplicate elements, it makes no sense to clone elements for them.

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

_{Like Discuss Correct / Improve cloneable collections collection interface cloning}

Q209. Where do we generally use comparable interface ?

Core Java

Ans. Implementing Comparable interface means that the elements of the class are comparable i.e the class provides the implementation of compareTo method that would help comparing the elements.

This is usually required if we are planning to sort elements of a collection, If compareTo method is not defined , the sorting class / method could never understand a way to compare its elements in order to sort them.

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

_{Like Discuss Correct / Improve comparable interface}

Try 1 Question(s) Test

Q210. Can we access private members of the parent class ? i.e Are private members of the class visible in the derived class ?

Core Java

Ans. No, If both Parent and Derived are outer classes.

public class Vehicle {
private static String manufacturingDate = "2016";
}

public class Car extends Vehicle{
public static void main(String args[]){
System.out.println(manufacturingDate); // error - The field Vehicle.manufacturingDate is not visible
}
}

Yes, If derived is the inner class of Parent.

public class Vehicle {
private static String manufacturingDate = "2016";
static public class Car extends Vehicle{
public static void main(String args[]){
System.out.println(manufacturingDate); // no problem
}
}
}

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

_{Like Discuss Correct / Improve private members private methods private variables inheritance object oriented programming (oops) oops concepts members visibility inner classes nexted classes basic frequent}

Search Interview Questions

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