Filter interviews by
Query to find the second highest salary in a SQL database table.
Use the ORDER BY clause to sort the salaries in descending order.
Use the LIMIT clause to limit the result to the second row.
Consider handling cases where there might be ties for the highest salary.
Reverse a given string
Use string slicing with a step of -1 to reverse the string
Alternatively, use the built-in 'reversed' function to reverse the string
Top trending discussions
posted on 10 Oct 2024
I applied via Naukri.com and was interviewed in Sep 2024. There were 2 interview rounds.
I applied via Naukri.com and was interviewed in Sep 2024. There was 1 interview round.
Shift all zeros in an array to the right while maintaining the order of non-zero elements.
Iterate through the array and move all non-zero elements to the front of the array.
Fill the remaining elements with zeros.
Maintain the relative order of non-zero elements.
A decorator is a design pattern in Python that allows adding new functionality to an existing object without modifying its structure.
Decorators are denoted by the @ symbol followed by the decorator function name.
They are commonly used to modify or extend the behavior of functions or methods.
Decorators can be used for logging, timing, authentication, caching, etc.
Example: @staticmethod, @classmethod, @property
posted on 27 May 2024
List is a built-in Python data structure that can hold elements of different data types, while Array is a data structure from the NumPy library that can hold elements of the same data type.
List is a dynamic array that can grow or shrink in size, while Array has a fixed size.
List can hold elements of different data types, while Array can only hold elements of the same data type.
List is a part of Python's standard librar...
DRF provides JSON, BrowsableAPI, TemplateHTML, and AdminRenderer classes for rendering responses.
JSONRenderer: Renders data in JSON format.
BrowsableAPIRenderer: Renders data in a browsable HTML format with forms for interacting with the API.
TemplateHTMLRenderer: Renders data using a specified template in HTML format.
AdminRenderer: Renders data in a format suitable for Django admin interface.
Method Resolution Order (MRO) is the order in which classes are searched for a method or attribute in Python.
MRO is determined by the C3 linearization algorithm in Python.
It follows a depth-first left-to-right traversal of the class hierarchy.
MRO is important in multiple inheritance scenarios to resolve method conflicts.
Example: class A: pass class B(A): pass class C(A): pass class D(B, C)
Class method is bound to the class itself, while static method is not bound to any specific instance or class.
Class method takes 'cls' as the first parameter, allowing access to class variables and methods.
Static method does not take any special parameters and does not have access to class or instance variables.
Class method can be called on both the class and instances of the class.
Static method is mainly used for util...
Transactions in SQL are a way to ensure data integrity by grouping multiple SQL statements into a single unit of work.
Transactions help maintain the ACID properties (Atomicity, Consistency, Isolation, Durability) of a database.
They allow multiple SQL statements to be executed as a single unit, either all succeeding or all failing.
Transactions can be started with BEGIN TRANSACTION, COMMIT to save changes, or ROLLBACK to...
Waiting for l2 round
posted on 2 Jul 2024
Simple python programming concepts
Inter service communication in transactional systems involves designing a reliable and efficient way for services to communicate and exchange data.
Use asynchronous messaging systems like RabbitMQ or Kafka to decouple services and ensure reliable message delivery.
Implement RESTful APIs for synchronous communication between services, using HTTP methods like GET, POST, PUT, DELETE.
Consider using gRPC for high-performance,...
Use pandas library for efficient loading and processing of large files in Python.
Use pandas read_csv() function with chunksize parameter to load large files in chunks.
Optimize memory usage by specifying data types for columns in read_csv() function.
Use pandas DataFrame methods like groupby(), merge(), and apply() for efficient data processing.
Consider using Dask library for parallel processing of large datasets.
Use gen...
posted on 21 Dec 2024
I applied via Naukri.com and was interviewed in Nov 2024. There was 1 interview round.
They will test your coding ability on first round, for me they kept test on hacker earth.
posted on 18 Jun 2023
posted on 17 Apr 2024
Prepare coding with some therotical question
I applied via Naukri.com and was interviewed in Oct 2021. There were 4 interview rounds.
Senior Software Engineer
31
salaries
| ₹11.9 L/yr - ₹35.6 L/yr |
Software Engineer
28
salaries
| ₹8.1 L/yr - ₹24 L/yr |
Java Developer
14
salaries
| ₹4 L/yr - ₹4.9 L/yr |
Medical Scribe Specialist
14
salaries
| ₹4.3 L/yr - ₹8.3 L/yr |
Software Developer
13
salaries
| ₹4.2 L/yr - ₹4.7 L/yr |
Lagardère Travel Retail
DFS Group
Shoppers Stop
Future Retail