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

Interview Questions and Answers - Order By Newest

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

^{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}

Q842. 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}

Q843. 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}

Q844. 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}

Q845. 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}

Q846. 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}

Q847. 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}

Q848. 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}

Q849. 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}

Q850. 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}

Q851. 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}

Q852. Why can we have a static inner class but not a static Top level class 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 static class inner classes nested classes Expert rare}

Q853. Design a Database Schema to store Employee Information with each employee having multiple addresses.

Database

Ans. We can have 2 entities i.e EMPLOYEE and ADDRESS and can have a relationship Table , EMPLOYEE_ADDRESS having one to may relationship between the two.

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

_{Like Discuss Correct / Improve database schema design Asked in 2 Companies}

Q854. Write a SQL to find 2nd Max value in a Table.

Database

Ans. SELECT MIN(FIELD) FROM (SELECT TOP 2 FIELD FROM TABLE ORDER BY FIELD DESC)

or

SELECT MAX(FIELD) FROM TABLE WHERE FIELD NOT IN (SELECT MAX(FIELD) FROM TABLE)

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

_{Like Discuss Correct / Improve sql}

Q855. In a Tree, find common ancestor of two nodes.

Data Structures

^{This question was recently asked at 'Amazon'.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 Tree Data structures Asked in 1 Companies}

Q856. Which Data structure can be used for creating Queue ?

Data Structure

^{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 queue collections data structure}

Q857. Which immutable classes have you worked with ? Can you name some immutable Collections ? How to make an immutable collection ?

Core Java

Ans. string and wrapper class objects

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

_{Like Discuss Correct / Improve immutability immutable immutability classes immutable immutability collections Asked in 3 Companies}

Q858. Which of the two - Arrays or LinkedList - is a better data structure for implementing Queue ? and Why ?

Data Structure

^{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 Arraylist linkedlist queue collections}

Q859. How is LinkedList collection class internally implemented ? Is it a Linked List or Doubly Linked List ?

Core Java

^{This question was recently asked at 'Ancestry'.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 linkedlist internal implementation of linkedlist Asked in 1 Companies}

Q860. What are annotations and what are it's advantages ?

Core Java

^{This question was recently asked at 'Tata Consultancy (TCS)'.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 Asked in 1 Companies}

Q861. Suppose we have a string "Java is object oriented language" and we have to reverse every alternate word in string. How would we do that using Java program.

Core Java

^{This question was recently asked at 'datalake solutions'.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 string manipulation code coding Asked in 1 Companies}

Q862. Write a program for binary tree ?

Data Structure

Ans. public class BinarySearchTree {
//Represent the node of binary tree
public static class Node {
int data;
Node left;
Node right;
public Node(int data) {
//Assign data to the new node, set left and right children to null

this.data = data;
this.left = null;
this.right = null;
}
}
//Represent the root of binary tree

public Node root;
public BinarySearchTree() {
root = null;
}

//factorial() will calculate the factorial of given number

public int factorial(int num) {
int fact = 1;
if (num == 0) return 1;
else {
while (num > 1) {
fact = fact * num;
num--;
}
return fact;
}
}

//numOfBST() will calculate the total number of possible BST by calculating Catalan Number for given key

public int numOfBST(int key) {
int catalanNumber = factorial(2 * key) / (factorial(key 1) * factorial(key));
return catalanNumber;
}
public static void main(String[] args) {
BinarySearchTree bt = new BinarySearchTree();

//Display total number of possible binary search tree with key 5

System.out.println("Total number of possible Binary Search Trees with given key: "
bt.numOfBST(5));
}
}

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

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

Q863. What is the default data type of state variables in Clonable interface and Serializable interface ?

Core Java

Ans. Cloneable and Serializable are Marker Interfaces, So these are empty interfaces with no variables.

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

_{Like Discuss Correct / Improve cloneable serializable static variables Asked in 1 Companies}

Q864. What is meant by dirty object checking in hibernate ?

Hibernate

Ans. Dirty Checking is one of the features of hibernate. In dirty checking, hibernate automatically detects whether an object is modified (or) not and need to be updated. As long as the object is in persistent state i.e., bound to a particular Session, Hibernate monitors any changes to the objects and executes sql.

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

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

Q865. Can you write the code for implementing the one to many (student -> courses) relationship in hibernate?

Hibernate

Ans. @OneToMany(cascade = CascadeType.ALL)
@JoinColumn(name = "student_id")
private Set countries;

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

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

Q866. Can you explain software design principles cohesion and coupling with an example?

Design

^{This question was recently asked at 'Fidelity Information Services (FIS)'.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 cohesion coupling Asked in 1 Companies frequent}

Q867. What is read and write optimization in relation to databases ? Which database facilitates read optimization and which facilitates write optimization ?

Database

^{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 read optimization write optimization}

Q868. Does relational database facilitate read or write optimization while storing information ?

database

Ans. Usually Relational Databases are optimized for writing. Some exception being usage of indices where indices needs to be updated after insertion and eventually helps with Log(n) reading time.

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

_{Like Discuss Correct / Improve read optimization rdbms relational database}

Q869. How does relational database facilitates read optimization ?

Database

^{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 database rdbms read optimization}

Q870. Write an efficient program for printing k largest elements in an array. Elements in array can be in any order.

Data Structure

^{This question was recently asked at 'Amazon'.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 arrays coding code Asked in 1 Companies}

Search Interview Questions

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