Associate/Senior Associate -(Technical)
Associate/Senior Associate -(Technical) Interview Questions and Answers for Freshers
Asked in NTT Data
Q. What are the different types of Database management systems. What are the Database languages ? What is the difference between drop, delete and truncate?
Different types of DBMS, DB languages & difference between drop, delete & truncate.
Types of DBMS: Relational, NoSQL, Object-oriented, Hierarchical, Network, etc.
Database languages: SQL, PL/SQL, T-SQL, etc.
DROP: Deletes a table and its data, cannot be rolled back.
DELETE: Deletes rows from a table, can be rolled back.
TRUNCATE: Deletes all rows from a table, cannot be rolled back.
Asked in NTT Data
Q. Give a real-time example of Inheritance, Polymorphism, Abstraction, and Encapsulation.
Real-time examples of OOP concepts
Inheritance: A car is a vehicle, inheriting properties of a vehicle
Polymorphism: A shape can be a square or a circle, both implementing the same area method
Abstraction: A TV remote has buttons to perform actions, but the user doesn't need to know how it works internally
Encapsulation: A bank account has private data like balance, which can only be accessed through public methods
Asked in NTT Data
Q. Write a SQL query to print all the rows in a table that have no match in a second table.
SQL query to print rows with no match in a second table
Use LEFT JOIN to join the two tables
Filter the rows where the second table's primary key is NULL
SELECT the columns from the first table
Asked in IBM
Q. What is the difference between final, finally, and finalize?
Final, finally and finalise are related to completion or conclusion, but have different meanings and usage.
Final is an adjective used to describe the last or ultimate stage of something.
Finally is an adverb used to indicate the end of a process or event after a long wait or delay.
Finalise is a verb used to complete or finish something, often with a formal or official process.
Examples: The final exam, finally finished the project, finalise the contract.
Asked in Infosys
Q. What is a HashMap?
HashMap is a data structure that stores key-value pairs and allows fast retrieval of values based on keys.
HashMap is part of the Java Collections Framework.
It uses hashing to store and retrieve elements.
It allows null values and null keys.
It is not synchronized by default, but can be made synchronized using Collections.synchronizedMap() method.
Example: HashMap
Asked in IBM
Q. What are the network topologies?
Network topologies refer to the arrangement of various elements in a network.
There are several types of network topologies, including bus, star, ring, mesh, and hybrid.
Bus topology involves connecting all devices to a single cable.
Star topology involves connecting all devices to a central hub or switch.
Ring topology involves connecting devices in a circular manner.
Mesh topology involves connecting devices to each other in a network.
Hybrid topology is a combination of two or m...read more
Interview Experiences of Popular Companies
Top Interview Questions for Associate/Senior Associate -(Technical) Related Skills
Reviews
Interviews
Salaries
Users
Made with ❤️ in India. Trademarks belong to their respective owners. All rights reserved © 2025 Info Edge (India) Ltd.
