Interview Question and Answers | Search Coding Interview Questions

Interview Questions and Answers - Order By Newest

Q2021. Is Cassandra read optimized or Write optimized ?

Cassandra

Ans. Read optimized

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

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

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

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

Q2024. Can we query Cassandra Tables without specifying the partition id in the where clause ?

Cassandra

Ans. No.

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

_{Like Discuss Correct / Improve cassandra}

Q2025. What are the restrictions on querying Cassandra Tables ?

Cassandra

Ans. Cassandra Tables can only be queried using the partition key and then cluster keys, so all queries should have partition key for sure.

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

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

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

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

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

Q2029. What could be the driving force to have dependencies injected through class than through config file while using IOC or Dependency Injection ?

Design

Ans. Unit Testing

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

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

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

Q2031. Why was Cassandra written in Java and not C++ ?

Cassandra

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

Q2032. Why do we use Thread Class as well as Runnable Interface for creating threads 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 Threads Thread class runnable interface}

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

Q2034. Which components of AWS are you using in your project ?

Amazon Web Services (AWS)

Ans. We are using EC2 and Lambda for computing, RDS for Database , S3 for Storage , SQS and Kinesis for streaming and queue and CloudWatch for monitoring.

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

_{Like Discuss Correct / Improve aws aws components}

Q2035. If a team member send you the code for review which you don't agree to but is just slightly off , Would you approve it or reject it ?

General

^{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 code review Asked in 1 Companies}

Q2036. How do you keep yourself aupdated with the changes in technologies ?

General

^{This question was recently asked at 'Sofi,Overstock.com,General Electric (GE)'.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 3 Companies}

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

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

Q2039. How do you use Mock frmaework to test webservices in any of your previous project ?

Testing

Ans. We were having client methods to call web services and were mocking the client method call using Mockito.

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

_{Like Discuss Correct / Improve mocking testing mockito}

Q2040. How would you describe your current or previous Boss ?

General

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

Q2041. Write a Program to print fibonacci series using recursion.

Core Java

Ans. public class FibonacciUsingRecursion {
   public static void main(String[] args) throws IOException{
      getNextFibanocci(1,1);
   }

   static int getNextFibanocci(int a,int b){
      if(a+b >= 100){
         return 0;
      } else {
         System.out.println(a+b);
         getNextFibanocci(b,a+b);
      }

      return 0;
   }
}

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

_{Like Discuss Correct / Improve fibonacci recursion}

Q2042. What do you do when told to do something that you don't agree with?

General

^{This question was recently asked at 'Ancestry,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 Asked in 2 Companies}

Q2043. Can we use primitive types with Collection classes ?

Core Java

Ans. No, As collection classes involve use of Generics, they cannot accept primitive types.

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

_{Like Discuss Correct / Improve collection classes collections}

Q2044. Is immutability an advantage with Wrapper classes over primitive types ?

Core Java

Ans. There is no concept of de referencing with primitive types and hence they are implicitly immutable. Having wrapper classes as mutable offers disadvantages compared to primitive types. Wrapper classes being immutable offer similar advantage as primitive types.It actually overshadows the disadvantage wrapper class could have if they are immutable.

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

_{Like Discuss Correct / Improve immutable immutability classes wrapper classes}

Q2045. Do we have Integer constant pool of primitive int or Integer objects ?

Core Java

Ans. It's of Integer objects and not primitive int.

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

_{Like Discuss Correct / Improve integer constant pool}

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

Q2047. What are some of the SOAP frameworks ?

SOAP

Ans. Apache Axis, Apache CXF

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

_{Like Discuss Correct / Improve}

Q2048. Can we have contracts like WSDL with Rest Services ?

Web Service

Ans. Yes, we can have WADL to specify the contract but unlike SOAP , the usage is optional.

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

_{Like Discuss Correct / Improve}

Q2049. Write a SQL to find max salary by Dept

SQL

Ans. SELECT MAX(SALARY),DEPT FROM EMPLOYEE GROUP BY DEPT

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

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

Q2050. Write a SQL to display all duplicate names from Employee Table

SQL

Ans. SELECT * FROM EMPLOYEE A WHERE A.ROW_ID IN (SELECT MAX(ROW_ID) FROM EMPLOYEE b WHERE A.NAME = B.NAME )

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

_{Like Discuss Correct / Improve}

Search Interview Questions

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