i
Digitas
Filter interviews by
Top trending discussions
posted on 29 Jul 2024
I applied via Approached by Company and was interviewed in Jun 2024. There was 1 interview round.
Pivoting columns in SQL involves transforming rows into columns to display data in a different format.
Use the PIVOT keyword in SQL to pivot columns
Specify the columns to pivot on and the values to display in the new columns
Aggregate functions like SUM, AVG, COUNT can be used with PIVOT
Example: SELECT * FROM table_name PIVOT (SUM(value_column) FOR pivot_column IN ('value1', 'value2', 'value3'))
posted on 9 Jul 2024
Binary search is a search algorithm that finds the position of a target value within a sorted array.
Binary search works by repeatedly dividing the search interval in half.
It compares the target value with the middle element of the array.
If the target value matches the middle element, the position is returned.
If the target value is less than the middle element, the search continues on the lower half of the array.
If the ...
An algorithm based on graph is a set of instructions designed to solve problems related to graphs.
Graph algorithms are used to solve problems related to graphs, such as finding the shortest path between two nodes, detecting cycles, and determining connectivity.
Some common graph algorithms include Dijkstra's algorithm for finding the shortest path, Kruskal's algorithm for finding the minimum spanning tree, and Depth Fir...
Scheduling is the process of planning and organizing tasks or resources over a period of time.
Scheduling involves determining the start and end times for tasks or activities.
It helps in optimizing resources and ensuring efficient use of time.
Examples include project scheduling, employee scheduling, and appointment scheduling.
Round robin is a scheduling algorithm that assigns equal time slices to each process in a circular queue.
Each process is given a small unit of time to execute before being moved to the end of the queue.
It ensures fairness by preventing a single process from monopolizing the CPU.
Example: In a round robin scheduling with time quantum of 10ms, processes A, B, and C will each get 10ms of CPU time before moving to the end o
I applied via Approached by Company and was interviewed in Jun 2024. There were 2 interview rounds.
Built an app using dot net and angular
Api related questions
posted on 19 Feb 2024
I applied via campus placement at The LNM Institute of information Technology, Jaipur and was interviewed in Aug 2023. There were 4 interview rounds.
It will be around 3 hours and 2 questions of leetcode hard difficulty will be asked in the interview and 1 question is of codeforces 2400+ difficulty question.
Indexing in MySQL is a technique to improve the performance of database queries by creating a data structure that allows for faster data retrieval.
Indexes are created on one or more columns of a table.
They help in speeding up the search, sorting, and joining of data.
Indexes can be created using different algorithms like B-tree, hash, or bitmap.
Using indexes appropriately can significantly enhance query performance.
Exam...
Object-oriented programming concepts in PHP
Encapsulation: bundling data and methods together in a class
Inheritance: creating new classes based on existing ones
Polymorphism: using a single interface to represent different types
Abstraction: hiding unnecessary details and exposing only essential features
Class: blueprint for creating objects
Object: instance of a class
Method: function defined inside a class
Property: variabl
posted on 26 Feb 2024
I applied via Naukri.com and was interviewed before Oct 2023. There were 2 interview rounds.
I applied via Recruitment Consulltant and was interviewed before Feb 2022. There were 5 interview rounds.
Technical Recruiter
24
salaries
| ₹2.4 L/yr - ₹5.5 L/yr |
Senior Associate Project Manager
22
salaries
| ₹7.7 L/yr - ₹15 L/yr |
Lead Application Developer
19
salaries
| ₹8 L/yr - ₹22 L/yr |
Senior Associate
18
salaries
| ₹7 L/yr - ₹21 L/yr |
Accounts Manager
14
salaries
| ₹4.9 L/yr - ₹7 L/yr |
Wunderman Thompson
Ogilvy
Publicis Sapient
VML Y&R