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

Interview Questions and Answers - Order By Newest

Q931. What is the use of @Import and @ImportResource anotations ?

Ans. The @Import annotation is used to import one or more @Configuration classes. This annotation provides the functionality equivalent to element in xml based configuration.

The @ImportResource annotation is used to import one or more XML configuration files.

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

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

Q932. What is optimistic and pessimistic locking ?

Operating System

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

Q933. How will you implement your own custom hashmap and linkedlist ?

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}

Q934. Why does an array index starts at 0 and not 1 ?

Data Structure

Ans. The array index starts with 0 because program locates an element using the expression ( BaseAddress + ( Index * size of array Element ), where index is used as an offset. As the starting address is actually the address of first element, the index of first element is used as 0 and so on.

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

_{Like Discuss Correct / Improve}

Q935. Why does an array need continuous memory locations and not Linked List ?

Data Structure

Ans. Array needs continuous memory location because it need to provide random access of it's elements which is not required for Linked List.

Array index acts as an offset from the base address and hence can retrieve the respective element using the expression Base Address + ( Index * Element Size ). This expression could only hold true if the elements are in continuous memory location.

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

_{Like Discuss Correct / Improve}

Q936. Design a Program to clone an object and all it's children.

Design

^{This question was recently asked at 'Bloomberg'.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 coding cloning design pattern cloning design pattern Asked in 1 Companies}

Q937. Difference between sleep() and Wait()

Operating System

^{This question was recently asked at 'PegaSystems'.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}

Q938. how is the internal code for the "volatile" implemented ?

Core Java

^{This question was recently asked at 'Symantec'.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 volatile Asked in 1 Companies}

Q939. Design database schema for Facebook like application.

Database

^{This question was recently asked at 'Symantec'.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 design Asked in 1 Companies expert}

Q940. How Bitly shortens the URL ?

Web

^{This question was recently asked at 'Symantec'.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 web application url Asked in 1 Companies rare}

Q941. Write Java code that would cause deadlock ?

Core Java

Ans. https://howtodoinjava.com/java/multi-threading/writing-a-deadlock-and-resolving-in-java/

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

_{Like Discuss Correct / Improve multithreading threads deadlock Asked in 1 Companies intermediate}

Q942. What is hashing ?

data structure

Ans. Hashing is a technique to calculate the hash code for any object

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

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

Q943. Draw uml for singleton pattern.

Design

^{This question was recently asked at 'deutche bank'.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 design pattern singleton Asked in 1 Companies}

Q944. Difference between static and dynamic binding ?

Design

Ans. Static binding happens at the compile time whereas dynamic binding happens at runtime.

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

_{Like Discuss Correct / Improve static vs dynamic binding overriding Asked in 1 Companies basic frequent}

Library Management System has always been the favorite question. This questions is asked irrespective of level.

Q945. Write data models and service end points for Library Management System ?

Architecture

Ans. Following could be the business sub domains or database schemas in such a system

1. Users / Members
2. Sourcing
3. Inventory Management
4. Operations

Following services end points could be there

1. Users - addNewUser ( put ), removeUser ( post )
2. Sourcing - addSupplier ( put ), removeSupplier ( post )
3. Inventory Management - getInventory ( get )
4. Operations - checkIn ( post ), checkout ( post )

There could be following Tables in Database

1. Users / Members - MEMBER, MEMBERSHIP_TYPE
2. Sourcing - SUPPLIER, SUPPLIER_PRODUCT, PRODUCT_REORDER_LEVELS
3. Inventory Management - INVENTORY,PRODUCTS
4. Operations - TRANSACTION

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

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

Q946. Write SQL to get all members and the count of books they have checked out , even the ones that haven't checked out anything.

SQL

^{This question was recently asked at 'Canopy Tax'.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 sql Asked in 1 Companies}

Q947. What is MVC in GUI components ?

Design

Ans. The Model/View/Controller pattern, a strategy for dividing responsibility in a GUI component.

The model is the data for the component.

The view is the visual presentation of the component on the screen.

The controller is responsible for reacting to events by changing the model.

According to the MVC pattern, these responsibilities should be handled by different objects.

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

_{Like Discuss Correct / Improve mvc design pattern Asked in 1 Companies rare}

Q948. Can we use Prototype Bean scope with Autowiring ?

Spring

Ans. Default Bean scope in auto wiring is Singleton but Yes, that can be changed by specifying the Bean scope explicitly.

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

_{Like Discuss Correct / Improve spring boot spring mvc autowiring bean scope prototype bean scope intermediate}

Q949. Write code to sort an array.

Algorithm

Ans. https://www.geeksforgeeks.org/arrays-sort-in-java-with-examples/

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

_{Like Discuss Correct / Improve array sorting Asked in 16 Companies basic frequent}

Q950. If your application has multiple databases, how many changes you have to made in Hibernate?

Hibernate

Ans. If you have mulitple Databases you just need to add multiple configuration files and create the corresponding SessionFactory object.

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

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

Q951. How to sort objects based on one of the field ?

Core Java

Ans. Using comparable and comparator and sorted collections like TreeSet or TreeMap.

or

use stream api from java 8 onwards which internally refers to comparable and comparator through lambda expressions

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

_{Like Discuss Correct / Improve sort sorting comprator comparable treeset treemap sorting collections Asked in 1 Companies Basic frequent}

Q952. Given an Employee Table with Salary Column, Find 2nd and 5th highest salary in a particular department.

SQL

Ans. Select salary from (select salary from employee where department = order by salary desc limit 5) emp order by salary limit 1 AND Select salary from (select salary from employee where department = order by salary desc limit 2) emp2 order by salary limit 1

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

_{Like Discuss Correct / Improve sql database find 2nd highest salary sql database Asked in 1 Companies}

Q953. What are custom annotations and How can we create one ?

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 annotations custom annotations basic}

Q954. While working on a web application, you are informed that there is no new data in Database for last few hours ? How would you go about debugging this problem ?

Solution

Ans. Will look into access logs to see if web application is getting any traffic. If not , then will inform the server support team.

Will look into intermediary infrastructure , queues , streams etc to see if there is any choke or throttle there.

If there is any throttle at any point, would make request for either debugging the cause or increasing the infrastructure. For ex - increasing shards in Kinesis.

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

_{Like Discuss Correct / Improve Solution Designing Solutioning Asked in 2 Companies}

Q955. What is OSGI ?

OSGI

Ans. OSGI is open service gateway initiative, its used as java framework for developing and deploying the modular softwares.

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

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

Q956. What is the use of load-on-startup ?

Design

Ans. The load-on-startup element of web-app loads the servlet at the time of deployment or server start if value is positive. It is also known as pre initialization of servlet.You can pass positive and negative value for the servlet.

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

_{Like Discuss Correct / Improve load on startup web application Asked in 1 Companies}

Q957. How many VTables are there for each class ?

Core Java

Ans. There is one VTable for each class.

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

_{Like Discuss Correct / Improve virtual table method vtable runtime polymorphism object oriented programming (oops) oops concepts method overriding intermediate rare}

Q958. Can an In Memory Data Management play a significant role for Big Data Analytics?

BigData

^{This question was recently asked at 'Jean Martin'.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}

Q959. Explain the use of Client certificates for authentication ?

Authentication

^{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 authentication client certificates}

Q960. How cookies helps by storing encrypted passwords ?

Authentication

Ans. It helps user autofill password on the form where its presented for authentication

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

_{Like Discuss Correct / Improve cookie authentication}

Search Interview Questions

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