i
CSM
Technologies
Filter interviews by
Some strategies to optimize a database query include indexing, using proper data types, limiting the result set, and optimizing joins.
Use indexes on columns frequently used in WHERE clauses
Avoid using SELECT * and only retrieve necessary columns
Use appropriate data types to minimize storage space and improve query performance
Limit the result set by using LIMIT or TOP clause
Optimize joins by using INNER JOIN instead of ...
Comparator is used to compare two objects for sorting, while Comparable is implemented by a class to define its natural ordering.
Comparator is used when the class being compared does not implement Comparable interface
Comparable is implemented by a class to define its natural ordering
Comparator can be used to sort objects in different ways, not just the natural ordering defined by Comparable
Design patterns are reusable solutions to common problems in software design.
Design patterns help in creating flexible, maintainable, and scalable software systems.
Some common design patterns include Singleton, Factory, Observer, and Strategy.
Singleton pattern ensures a class has only one instance and provides a global point of access to it.
Factory pattern creates objects without specifying the exact class of object th...
Python has dynamic typing, meaning you don't have to declare the data type of a variable before using it.
Python is dynamically typed, so variables can hold different types of data without explicit declaration.
Common data types in Python include integers, floats, strings, lists, tuples, dictionaries, and sets.
You can use the type() function to check the data type of a variable.
Example: x = 5 (integer), y = 3.14 (float),...
Top trending discussions
I applied via Recruitment Consultant and was interviewed in May 2019. There were 3 interview rounds.
posted on 16 Apr 2021
I applied via Referral and was interviewed in Oct 2020. There was 1 interview round.
posted on 20 Apr 2022
I applied via Recruitment Consulltant and was interviewed before Apr 2021. There was 1 interview round.
NoSQL databases are non-relational databases that store and retrieve data in a non-tabular format.
Document-oriented databases (MongoDB, Couchbase)
Key-value stores (Redis, Riak)
Column-family stores (Cassandra, HBase)
Graph databases (Neo4j, OrientDB)
Scaling refers to the process of increasing or decreasing the capacity of a system to handle more or less load.
Vertical Scaling: Adding more resources to a single node
Horizontal Scaling: Adding more nodes to a system
Load Balancing: Distributing the load across multiple nodes
Database Sharding: Splitting a database into smaller parts to distribute the load
Caching: Storing frequently accessed data in memory for faster acc...
I applied via Naukri.com and was interviewed in Sep 2020. There were 3 interview rounds.
Event loop is a mechanism that allows non-blocking I/O operations in a single-threaded environment.
Event loop is used in programming languages like JavaScript and Python.
It manages the execution of multiple tasks by prioritizing them based on their priority level.
It continuously checks for new events and executes them in a loop.
It allows for efficient handling of I/O operations without blocking the main thread.
It is co...
let, var and const are used to declare variables in JavaScript with different scoping rules and mutability.
let and var are used to declare variables that can be reassigned later, but var has function scope while let has block scope.
const is used to declare variables that cannot be reassigned and have block scope.
Using const does not mean the value is immutable, only the variable reference is.
let and const were introduc...
posted on 21 Nov 2020
I applied via Approached by Company and was interviewed before Apr 2021. There were 3 interview rounds.
I applied via Approached by Company and was interviewed before Apr 2021. There were 2 interview rounds.
I appeared for an interview in Aug 2020.
Remove duplicate entries from array of strings using JavaScript
Use Set to remove duplicates
Convert Set back to array
Use spread operator to convert Set to array
Determines if words in given array are anagram or not using JS
Create a function that takes an array of strings as input
Loop through the array and sort each string alphabetically
Compare the sorted strings to check if they are equal
Return true if all strings are anagrams, else false
Creating a reusable modal component in React JS with accessibility and styling considerations.
Use functional components and hooks for state management.
Implement props for dynamic content: <Modal title='My Modal' content='Hello World' />.
Add a backdrop for better user experience and to focus on the modal.
Include keyboard accessibility: close modal on 'Escape' key press.
Style the modal using CSS or a CSS-in-JS libr...
Implementing a custom version of Array.map to transform array elements.
Define a function that takes a callback and an array as arguments.
Use a for loop to iterate over the array elements.
Apply the callback to each element and push the result to a new array.
Return the new array after the loop completes.
Example: const myMap = (arr, callback) => { /* implementation */ };
based on 2 interview experiences
Difficulty level
based on 20 reviews
Rating in categories
Software Engineer
377
salaries
| ₹2 L/yr - ₹6 L/yr |
Programmer Analyst
93
salaries
| ₹4.3 L/yr - ₹13.2 L/yr |
Senior Software Engineer
85
salaries
| ₹3.6 L/yr - ₹7.2 L/yr |
Software Developer
81
salaries
| ₹1.8 L/yr - ₹6 L/yr |
Junior Software Engineer
54
salaries
| ₹1.8 L/yr - ₹3.6 L/yr |
ITC Infotech
CMS IT Services
KocharTech
Xoriant