Filter interviews by
I applied via Campus Placement and was interviewed in Jun 2023. There were 3 interview rounds.
Basic Question in C and C++ , and Technical Based Question in C and C++
Swapping Method, Prime Number , Star Patterns, Number Patterns
Top trending discussions
I was interviewed before Apr 2022.
A cursor is a pointer to a private SQL area that stores information about the processing of a SELECT or DML statement.
A cursor is used to retrieve data row by row from a result set.
There are two types of cursors: Implicit and Explicit.
Implicit cursors are used for single-row queries, while explicit cursors are used for multi-row queries.
Cursor variables can be used to pass cursors as parameters to procedures and functi
Truncate removes all data from a table while delete removes specific rows.
Truncate is faster than delete as it doesn't log individual row deletions
Truncate cannot be rolled back while delete can be
Truncate resets the identity of the table while delete doesn't
Truncate doesn't fire triggers while delete does
A trigger is a special type of stored procedure that automatically executes in response to certain events.
Triggers are used to enforce business rules or to perform complex calculations.
They can be defined to execute before or after a data modification operation.
Triggers can be used to audit changes to data or to replicate data changes to other tables.
Examples of events that can trigger a trigger include INSERT, UPDATE,...
I applied via Recruitment Consultant and was interviewed before Mar 2019. There were 4 interview rounds.
I applied via Campus Placement and was interviewed before Mar 2020. There was 1 interview round.
posted on 15 Dec 2019
I applied via Naukri.com and was interviewed in Jul 2019. There were 5 interview rounds.
I applied via LinkedIn and was interviewed in Mar 2024. There was 1 interview round.
posted on 27 Jan 2023
I applied via Job Portal and was interviewed in Dec 2022. There were 2 interview rounds.
To find code performance issues in production, use monitoring tools and profiling techniques.
Use monitoring tools like New Relic, AppDynamics, or Datadog to track performance metrics and identify bottlenecks.
Use profiling techniques like CPU profiling, memory profiling, and network profiling to pinpoint specific areas of the code that are causing performance issues.
Analyze logs and error messages to identify patterns a...
Asynchronous programming is a programming paradigm that allows multiple tasks to run concurrently without blocking each other.
Asynchronous programming is used to improve the performance of applications that require a lot of I/O operations.
It involves the use of callbacks, promises, and async/await keywords in JavaScript.
Asynchronous programming can be used in both front-end and back-end development.
Examples of asynchro...
Program to change background color on button click in Angular
Create a button in Angular template
Add click event listener to the button
Use setInterval() function to change background color after every 0.5 sec
Use ngStyle directive to change background color dynamically
Use Angular's 'resolve' property to load component after services are loaded.
Create a resolver service that waits for all three services to complete before resolving.
Add the resolver service to the 'resolve' property of the component's route.
Access the resolved data in the component using the ActivatedRoute service.
Example: { path: 'my-component', component: MyComponent, resolve: { data: MyResolverService } }
IQueryable is for querying data from a source that implements IQueryable interface while IEnumerable is for iterating over a collection of data.
IQueryable is used for deferred execution while IEnumerable is used for immediate execution.
IQueryable is used for querying data from a remote data source while IEnumerable is used for querying data from an in-memory collection.
IQueryable is more efficient for large datasets as...
Entity Framework is an ORM while ADO.NET is a data access technology.
Entity Framework is easier to use and provides more abstraction than ADO.NET.
ADO.NET is faster and more flexible than Entity Framework.
Use Entity Framework for simple CRUD operations and ADO.NET for complex queries and performance-critical applications.
I applied via Campus Placement and was interviewed in Jul 2023. There was 1 interview round.
Find the second largest number in an array.
Sort the array in descending order
Return the element at index 1
Program to add two numbers without using the '+' operator.
Use bitwise operators like XOR and AND to perform addition without '+' operator.
XOR the two numbers to get the sum without carry.
AND the two numbers and left shift the result to get the carry.
Repeat the process until carry becomes zero.
Mutable data types can be modified after creation, while immutable data types cannot be modified.
Examples of mutable data types: lists, sets, dictionaries
Examples of immutable data types: strings, tuples, frozensets
A dictionary is an unordered collection of key-value pairs, while a list is an ordered collection of elements.
Dictionaries are accessed by keys, while lists are accessed by indices.
Dictionaries are mutable, while tuples are immutable.
Dictionaries can have duplicate values, but not duplicate keys.
Lists can contain elements of different data types, while tuples can contain elements of the same or different data types.
Yes, a dictionary is mutable in Python.
A dictionary in Python can be modified by adding, updating, or deleting key-value pairs.
The values associated with keys in a dictionary can be changed.
Dictionaries are mutable objects, meaning they can be modified in-place.
The 'update()' method can be used to add or update multiple key-value pairs at once.
A program to determine if a number is prime or not.
A prime number is a number greater than 1 that has no positive divisors other than 1 and itself.
To check if a number is prime, iterate from 2 to the square root of the number and check if any of them divides the number evenly.
If any divisor is found, the number is not prime. Otherwise, it is prime.
I applied via LinkedIn and was interviewed in Sep 2023. There was 1 interview round.
based on 1 interview
Interview experience
based on 4 reviews
Rating in categories
Service Engineer
49
salaries
| ₹0 L/yr - ₹0 L/yr |
Software Developer
38
salaries
| ₹0 L/yr - ₹0 L/yr |
Production Engineer
28
salaries
| ₹0 L/yr - ₹0 L/yr |
Embedded Engineer
17
salaries
| ₹0 L/yr - ₹0 L/yr |
Product Specialist
15
salaries
| ₹0 L/yr - ₹0 L/yr |
Carl Zeiss
Topcon
Essilor
Alcon