Filter interviews by
I applied via Naukri.com and was interviewed in Dec 2023. There were 2 interview rounds.
Use SQL query to fetch maximum and minimum salary from emp table
Use SELECT MAX(salary) FROM emp to fetch maximum salary
Use SELECT MIN(salary) FROM emp to fetch minimum salary
Indexes and exceptions are used to optimize database performance and handle errors in code.
Indexes are used to quickly retrieve data from a database by creating a sorted list of values.
Exceptions are used to handle errors in code and prevent the program from crashing.
Examples: Creating indexes on frequently queried columns like 'id' or 'timestamp'. Using try-catch blocks to handle exceptions like divide by zero.
Top trending discussions
I applied via Company Website and was interviewed in Jun 2023. There were 2 interview rounds.
posted on 31 Jul 2024
I applied via Company Website and was interviewed in Jul 2024. There was 1 interview round.
Java program to check if two strings are anagrams
Create a function that takes two strings as input
Convert both strings to character arrays and sort them
Check if the sorted arrays are equal to determine if they are anagrams
Insert and select data in MySQL using SQL queries
Use INSERT INTO table_name (column1, column2, ...) VALUES (value1, value2, ...); to insert data
Use SELECT * FROM table_name; to select all data from a table
Use SELECT column1, column2 FROM table_name WHERE condition; to select specific data based on a condition
GET and POST are HTTP methods used in REST APIs for retrieving and sending data.
GET method is used to retrieve data from a server
POST method is used to send data to a server
GET requests are idempotent, while POST requests are not
GET requests should only be used for retrieving data, not for modifying data
Example: GET request to retrieve a list of users - GET /users
Example: POST request to create a new user - POST /users
posted on 16 May 2024
I applied via Indeed and was interviewed in Apr 2024. There were 2 interview rounds.
It was very easy basic qns
There were two question on DSA
I applied via Approached by Company and was interviewed in Aug 2023. There were 2 interview rounds.
Behaviour subject in Angular is a special type of subject that allows both subscribing and emitting values.
BehaviourSubject is a type of subject in RxJS library.
It has an initial value that will be emitted to new subscribers.
It stores the latest value and emits it immediately to new subscribers.
Example: const subject = new BehaviorSubject('initial value');
Example: subject.next('new value');
Design principles are guidelines for designing software solutions that are maintainable, scalable, and efficient.
Design principles help in creating software that is easy to understand, modify, and maintain.
They promote code reusability, modularity, and flexibility.
Examples of design principles include SOLID principles, DRY (Don't Repeat Yourself), KISS (Keep It Simple, Stupid), and YAGNI (You Aren't Gonna Need It).
I applied via Company Website and was interviewed in Jun 2023. There were 2 interview rounds.
I was interviewed before Feb 2023.
Interview experience
Consultant
1.1k
salaries
| ₹8.5 L/yr - ₹30 L/yr |
Associate Consultant
1.1k
salaries
| ₹4.8 L/yr - ₹18.5 L/yr |
Clinical Data Specialist
764
salaries
| ₹3.5 L/yr - ₹11.5 L/yr |
Drug Safety Associate
755
salaries
| ₹2.4 L/yr - ₹7.8 L/yr |
Software Developer
738
salaries
| ₹4.8 L/yr - ₹18.9 L/yr |
Cognizant
Accenture
TCS
Infosys