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

Interview Questions and Answers - Order By Rating

Q331. Which is the best NoSql Database for Performance ?

NoSql

Ans. Possible Answer - doument base - monogodb

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

_{Like Discuss Correct / Improve Nosql Database}

Q332. Which of the following databases - Cassandra / Oracle - provides more flexibility about querying the database ?

Database

Ans. Oracle as it is not modeled for a particular query or set of queries.

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

_{Like Discuss Correct / Improve Cassandra Nosql database nosql vs relational database}

Q333. Which of the two Normalization / Denormalization facilitate better performance ? Which of the two facilitate better space management ?

Database

Ans. DeNormalization facilitate better performance. Normalization remove data duplication and hence facilitate better database space management.

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

_{Like Discuss Correct / Improve normalization denormalization normalization vs denormalization}

Q334. Difference between Normalization and Denormalization ?

Database

Ans. Normalization is the process of splitting one Table into multiple so as to avoid Data duplication whereas Denormalization is the process of reducing Tables that creates data duplication but would remove joins in the queries.

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

_{Like Discuss Correct / Improve normalization denormalization normaization vs denormalization Asked in 1 Companies}

Q335. How different is the Search algorithm when we query Cassandra Tables and When we query Oracle Tables ?

Cassandra

Ans. Relational Database uses linear search if we don't query using indices. Performance for linear search is O(n). If indices have been used , relational database uses binary search. Performance for binary search is O(Log n).

Casandra uses hash search. Performance for Hash Search is O(1).

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

_{Like Discuss Correct / Improve cassandra vs oracle nosql vs relational search algorithm}

Q336. How Cassandra provides better Read performance than Oracle Indices ?

Database

Ans. Cassandra uses Hash Search which provides a look time of O(1) whereas Oracle Indices uses Binary Search that provide a lookup time of O(Log n).

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

_{Like Discuss Correct / Improve cassandra hash search hash search vs binary search}

Q337. Can we mock static methods ?

Testing

Ans. Yes we can use PowerMock. With Mockito , we cannot mock static methods.

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

_{Like Discuss Correct / Improve mocking fraeworks mocking static methods mockito}

Q338. Which validation frameworks have you worked on ?

Frameworks

^{This question was recently asked at 'Sofi'.This question is still unanswered. Can you please provide an answer.}

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

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

Q339. Explain Hibernate Validation ?

Hibernate

^{This question was recently asked at 'Sofi'.This question is still unanswered. Can you please provide an answer.}

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

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

Q340. Difference between stateless and stateful rest services ?

Rest

^{This question was recently asked at 'Sofi'.This question is still unanswered. Can you please provide an answer.}

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

_{Like Discuss Correct / Improve rest services stateful rest service stateless rest service Asked in 1 Companies}

Q341. Write a SQL to remove records with a duplicate field in a Table ?

Database

^{This question was recently asked at 'Sofi'.This question is still unanswered. Can you please provide an answer.}

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

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

Q342. Can we instantiate the object of derived class if parent constructor is private ?

Core Java

Ans. No

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

_{Like Discuss Correct / Improve constructor private constructor}

Q343. Which of the two - iteration or recursion - is slower ?

Core Java

Ans. Any function call is slower than the code in the same method as Java has to maintain stack of meta and function call information. So recursion is slower.

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

_{Like Discuss Correct / Improve iteration recursion iteration vs recursion}

Q344. In the following code, which text will get printed immediately after Hello

for(int countx=0;countx<10;count++){
System.out.println("World");
for(int countx=0;countx<10;count++){
System.out.println("Friend");
for(int countx=0;countx<10;count++){
System.out.println("Hello");
break;
}
System.out.println("Buddy");
}
}

Core Java

^{This question is still unanswered. Can you please provide an answer.}

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

_{Like Discuss Correct / Improve break statement}

Q345. What do we mean by a Data Type ?

Core Java

Ans. if you have similar type of data or objects or entities, then we can give them a type with unique name. And this name will be our Data type.

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

_{Like Discuss Correct / Improve data type}

Q346. Why shouldn't we use string concatenation extensively or in a loop ?

Core Java

Ans. Because String being an immutable object creates a new object upon each concatenation cycle. If there is any such need , we should use String Builder whose objects are mutable.

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

_{Like Discuss Correct / Improve string string immutable immutability for loop control statements loop statement Asked in 1 Companies}

Q347. How is string object immutable if we can concat a string to it ?

Core Java

Ans. Because it doesn't make the change in the existing string but would create a new string by concatenating the new string to previous string. So Original string won't get changed but a new string will be created. That is why when we say

str1.concat("Hello");

It means nothing because we haven't specified the reference to the new string and we have no way to access the new concatenated string. Accessing str1 with the above code will still give the original string.

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

_{Like Discuss Correct / Improve string string immutable immutability string concat}

Q348. Which of the OOP's features facilitate dependency injection ?

Design

Ans. Inheritance , Runtime Polymorphism and Composition.

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

_{Like Discuss Correct / Improve dependency injection inversion of control ioc oops oops features}

Q349. What is ORM or Object Relationship Mapping ?

Database

Ans. ORM is the mapping technique, which maps object with relational data model. As we know that in java we need objects we can not user data in relational(in table form). So ORM is set of guideline which allows us to map relational data model in object form.

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

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

Q350. Write method to delete Node from a LinkedList.

Data Structure

Ans. public class LinkedList {

   Node start = null;
   Node head = null;

   class Node {
      Integer body;
      Node nextNode;

      Node(Integer value) {
         body = value;
      }
   }

   private void addNodeToEnd(Integer value) {
      if (start == null) {
         start = new Node(value);
         head = start;
         head.nextNode = null;
         return;
      }

      while (head.nextNode != null) {
         head = head.nextNode;
      }

      head.nextNode = new Node(value);
   }

   private void deleteNode(Integer value) {
      head = start;
      while (head.nextNode != null) {
         if(head.nextNode.body == value){
            head.nextNode = head.nextNode.nextNode;
         }

         head = head.nextNode;
      }
   }



   private void traverse() {
      head = start;
      while (head != null) {
         System.out.println(head.body);
         head = head.nextNode;
      }
   }

   public static void main(String[] args) {
      LinkedList ll = new LinkedList();

      ll.addNodeToEnd(5);
      ll.addNodeToEnd(10);
      ll.addNodeToEnd(15);

      ll.traverse();

      ll.deleteNode(10);

      ll.traverse();

   }
}

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

_{Like Discuss Correct / Improve linkedlist delete node from linkedlist}

Q351. In a Linked list with sorted numbers, insert a new numbers while maintaining the sort order.

Algorithm

Ans.
public class LinkedList {

   Node start = null;
   Node head = null;

   class Node{
      Integer body;
      Node nextNode;

      Node(Integer value){
         body = value;
      }
   }

   private void insertInMiddle(Integer value){
      head = start;
      if(start == null) {
         start = new Node(value);
         head = start;
         head.nextNode = null;
         return;
      }

      while(head.body < value){
         if(head.nextNode == null || head.nextNode.body >= value){
            Node newNode = new Node(value);
            newNode.nextNode = head.nextNode;
            head.nextNode = newNode;

            break;
         }
         head = head.nextNode;
      }
   }

   private void traverse(){
      head = start;
      while(head != null){
         System.out.println(head.body);
         head = head.nextNode;
      }
   }

   public static void main(String[] args){
      LinkedList ll = new LinkedList();

      ll.insertInMiddle(5);
      ll.insertInMiddle(10);
      ll.insertInMiddle(15);
      ll.insertInMiddle(7);

      ll.traverse();

   }
}

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

_{Like Discuss Correct / Improve LinkedList Data structures Algorithm}

Q352. Write a program for LinkedList, with method to append node and traversing the list ?

Algorithm

Ans. public class LinkedList {

   Node start = null;
   Node head = null;

   class Node {
      Integer body;
      Node nextNode;

      Node(Integer value) {
         body = value;
      }
   }

   private void addNodeToEnd(Integer value) {
      if (start == null) {
         start = new Node(value);
         head = start;
         head.nextNode = null;
         return;
      }

      while (head.nextNode != null) {
         head = head.nextNode;
      }

      head.nextNode = new Node(value);
   }

   private void traverse() {
      head = start;
      while (head != null) {
         System.out.println(head.body);
         head = head.nextNode;
      }
   }

   public static void main(String[] args) {
      LinkedList ll = new LinkedList();

      ll.addNodeToEnd(5);
      ll.addNodeToEnd(10);
      ll.addNodeToEnd(15);

      ll.traverse();

   }
}

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

_{Like Discuss Correct / Improve LinkedList Data structures Algorithm}

Q353. If you need to consume messages from the queue faster, which approach will you recommend - batching or concurrency ?

Design

Ans. Each has it's own advantages

Batching requires less resources but may result in loosing whole batch in case of failure whereas concurrency even though is little more expensive in terms of resources but would result in minimal loss in case of failure.

In case messages are to be consumed in a particular order, batching them in that order and then consuming them makes better sense.

if incoming messages are not continuous , it makes more sense to do concurrency as we need not wait for all messages to form a batch and flush. Though time sensitivity can be added but that would add unnecessary complexity.

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

_{Like Discuss Correct / Improve concurrency vs batching concurrency multithreading batch}

Q354. What is nested if ?

Core Java

Ans. if statements nested within another if or else blocks are called nested if statements.

if(condition1) {
if(condition2){
}
}

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

_{Like Discuss Correct / Improve if statement control statements nested if}

Q355. What are the worst anti patterns in Java ?

Design

^{This question is still unanswered. Can you please provide an answer.}

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

_{Like Discuss Correct / Improve antipattern anti pattern}

Q356. Can we synchronize the run() method in Java?

Core Java

^{This question is still unanswered. Can you please provide an answer.}

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

_{Like Discuss Correct / Improve synchronization multithreading run method}

Q357. What will be the output of following code and Why ?

int x = 5;
int y = 7;
float f = 5f;
float z = y / x * f;
System.out.println(z);

Core Java

Ans. 5.0

operation between two ints generate int only. so 7/5 generates 1 and not 1.4. Multiplication between int and float generates float and hence

1 * 5.0 = 5.0

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

_{Like Discuss Correct / Improve arithmetic calculation data types}

Q358. What is the difference between return and break statement ?

Core Java

Ans. return is used within a method to return control out of the method. It may be followed by a value which is returned from the method to calling method immediately preceding the point of call.

break statement is used within a loop to move control out of the loop.

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

_{Like Discuss Correct / Improve return statement break statement return vs break}

Q359. What is the difference between return and continue statement ?

Core Java

Ans. return is used within a method to return control out of the method. It may be followed by a value which is returned from the method to calling method immediately preceding the point of call.

continue statement is used within a loop to start next iteration without executing the remaining statements in the loop.

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

_{Like Discuss Correct / Improve return statement continue statement return vs continue for loop control statements loop statement}

Q360. Difference between Tree and Graph ?

Data Structures

Ans. Graph contain cycles whereas Trees cannot.

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

_{Like Discuss Correct / Improve graph trees data structures tree vs graph}

Search Interview Questions

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