Filter interviews by
I was interviewed in Jul 2023.
Indexing in SQL is a way to optimize the performance of queries by creating a data structure that allows for faster retrieval of data.
Indexes are created on columns in a database table to speed up the retrieval of rows that match a certain condition in a WHERE clause.
Indexes can be created using CREATE INDEX statement in SQL.
Types of indexes include clustered indexes, non-clustered indexes, unique indexes, and composit...
Primary index is the main index used to uniquely identify records in a database, while secondary index is an additional index for faster access to specific data.
Primary index is typically based on the primary key of a table, ensuring uniqueness of each record.
Secondary index is created on non-primary key columns to improve query performance for specific data retrieval.
Example: In a student database, student ID can be a...
Table Lock in SQL is a mechanism that prevents other users from accessing a table while it is being used by a transaction.
Table Lock is used to control access to a table in a database.
It can be used to prevent other users from reading or writing to a table while a transaction is in progress.
There are different types of table locks such as shared lock, exclusive lock, and update lock.
Table locks can impact the performan
Maintain security in Web API by implementing authentication, authorization, encryption, and input validation.
Implement authentication mechanisms such as OAuth, JWT, or API keys to verify the identity of clients accessing the API.
Use authorization to control access to resources based on roles and permissions.
Encrypt sensitive data using SSL/TLS to ensure secure communication between clients and the API.
Validate and sani...
They give you basic code for their requirements
Top trending discussions
posted on 1 Nov 2024
I applied via Campus Placement and was interviewed in Oct 2024. There were 2 interview rounds.
Number series in aptitude involves identifying the pattern in a sequence of numbers and predicting the next number.
Look for patterns such as arithmetic progression, geometric progression, or a combination of both.
Check for alternate numbers, differences between consecutive numbers, or multiplication factors.
Consider prime numbers, squares, cubes, or other mathematical operations applied to the series.
Example: 2, 4, 6, ...
Relationships in verbal communication are crucial for effective collaboration and understanding.
Verbal communication involves both verbal and non-verbal cues
Active listening is key to building strong relationships in verbal communication
Clarity and conciseness in speech can enhance relationships
Empathy and understanding of others' perspectives are important in verbal relationships
The four branches of OOP are encapsulation, inheritance, polymorphism, and abstraction.
Encapsulation: Bundling data and methods that operate on the data into a single unit.
Inheritance: Allowing a class to inherit properties and behavior from another class.
Polymorphism: The ability for objects of different classes to respond to the same method call.
Abstraction: Hiding the complex implementation details and showing only
Structures in C are user-defined data types that allow grouping of variables of different data types under a single name.
Structures are used to represent a record which consists of different data types.
They are defined using the 'struct' keyword.
Each variable in a structure is called a member.
Structures can be nested within other structures.
Example: struct employee { int emp_id; char emp_name[50]; float emp_salary; };
E
I was interviewed in Nov 2024.
The aptitude test evaluates problem-solving, coding skills, and logical reasoning, offering a fair challenge to showcase technical expertise.
I address conflicts in team projects by promoting open communication, active listening, and seeking compromise.
Encourage open communication among team members to address conflicts early on
Practice active listening to understand all perspectives and concerns
Seek compromise and find common ground to resolve conflicts effectively
Interface is a contract that defines the methods a class must implement, while an abstract class can have both implemented and abstract methods.
Interface can only have abstract methods and cannot have any implementation, while abstract class can have both abstract and implemented methods.
A class can implement multiple interfaces but can only inherit from one abstract class.
Interfaces are used to achieve multiple inheri...
Abstract class can have both abstract and non-abstract methods, while interface can only have abstract methods.
Abstract class can have method implementations, while interface cannot.
A class can implement multiple interfaces, but can only inherit from one abstract class.
Interfaces are used to define contracts for classes to implement, while abstract classes are used to provide a common base for subclasses.
Example: Abstr...
posted on 24 Oct 2024
I applied via Campus Placement and was interviewed in Sep 2024. There were 3 interview rounds.
Aptitude questions with some basic coding questions
They have given 3 coding questions and some pseudo codings
posted on 27 Aug 2024
I applied via Job Portal
I applied via Recruitment Consulltant and was interviewed in May 2024. There were 3 interview rounds.
It is easy to solve the Aptitude question and some identifying outputs of program.
A class is a blueprint for creating objects in object-oriented programming.
A class defines the properties and behaviors of objects.
An object is an instance of a class.
Example: Class 'Car' can have properties like 'color' and 'model', and behaviors like 'drive' and 'stop'.
Swap two numbers without using temp variable and reverse a string without using built-in functions.
To swap two numbers without using temp variable, use bitwise XOR operation.
To reverse a string without using built-in functions, use two pointers approach.
Example for swapping numbers: a = a ^ b; b = a ^ b; a = a ^ b;
Example for reversing a string: use two pointers to swap characters from start and end of the string.
Now, I am preparing for the third round.
So, I don't know the Coding Question.
posted on 24 Sep 2024
I applied via Campus Placement
Easy aptitude, 30 min with 20 question
based on 1 interview
Interview experience
based on 1 review
Rating in categories
Assistant Software Engineer
59
salaries
| ₹1 L/yr - ₹4 L/yr |
Software Engineer
27
salaries
| ₹1.7 L/yr - ₹8 L/yr |
Senior Software Engineer
9
salaries
| ₹4 L/yr - ₹4.8 L/yr |
Software Developer
9
salaries
| ₹0.9 L/yr - ₹4.5 L/yr |
Associate Software Engineer
7
salaries
| ₹1 L/yr - ₹3 L/yr |
Infosys
TCS
Wipro
HCLTech