Filter interviews by
posted on 4 Sep 2023
I applied via campus placement at CMR College of Engineering & Technology, Hyderabad and was interviewed in Aug 2023. There were 4 interview rounds.
Basic aptitude concepts
2 Questions on sorting and profit related question
Use SQL query with ORDER BY and LIMIT to find the 2nd highest salary.
Use ORDER BY clause to sort salaries in descending order
Use LIMIT 1,1 to skip the first highest salary and get the second highest salary
Tuple is a data structure that stores a fixed number of elements, while delete command is used to remove data from a database table.
Tuple is used to store multiple values in a single variable, while delete command is used to remove specific rows from a database table.
Tuples are immutable, meaning their values cannot be changed once they are set, while delete command permanently removes data from a table.
Example: Tuple ...
Top trending discussions
I am a software developer with 5 years of experience in developing web applications using Java, JavaScript, and SQL.
5 years of experience in software development
Proficient in Java, JavaScript, and SQL
Developed web applications for various clients
Strong problem-solving skills
Excellent team player
As a Software Developer, my roles and responsibilities include designing, developing, testing, and maintaining software applications.
Designing and developing software applications based on client requirements
Testing and debugging code to ensure functionality and performance
Collaborating with team members to brainstorm and implement new features
Maintaining and updating existing software applications
Staying up-to-date wi
Bug lifecycle involves identification, reporting, fixing, retesting, and closing of software bugs.
Identification: Bug is identified by testers or users through testing or real-world usage.
Reporting: Bug is reported to developers with detailed information like steps to reproduce.
Fixing: Developers analyze and fix the bug in the code.
Retesting: Testers verify the fix to ensure the bug is resolved.
Closing: Bug is closed o
FIFO stands for First In, First Out. LIFO stands for Last In, First Out.
FIFO is a method for organizing and manipulating a data buffer, where the first element added is the first to be removed.
LIFO is a method where the last element added is the first to be removed.
FIFO is like a queue, while LIFO is like a stack.
Example: In a FIFO queue, if elements A, B, and C are added in that order, they will be removed in the same...
First round was on Hacker Earth
I applied via Walk-in and was interviewed in Jul 2024. There were 2 interview rounds.
Model classes in UIKit are used to represent data in an application's user interface.
Model classes in UIKit typically subclass NSObject and are used to store and manage data for views.
They can include properties to represent different data fields, methods to manipulate the data, and sometimes protocols for delegation.
For example, a model class for a user profile in a social media app might have properties like username...
Project related questions
I applied via Approached by Company and was interviewed in Jun 2024. There was 1 interview round.
I applied via Approached by Company and was interviewed in May 2024. There was 1 interview round.
A bloom filter in HBase is a data structure used to test whether a given element is a member of a set.
Bloom filters are used to reduce the number of disk reads in HBase by quickly determining if a row may exist in a table.
They are implemented as a compact array of bits, with multiple hash functions used to map elements to bits.
Bloom filters can produce false positives but not false negatives, making them useful for pre...
Use dropDuplicates() function in pyspark to remove duplicate rows based on primary key.
Use dropDuplicates() function on the DataFrame with the primary key column specified.
Specify the subset parameter in dropDuplicates() to specify the primary key column.
Example: df.dropDuplicates(['primary_key_column'])
I applied via Approached by Company and was interviewed in May 2024. There was 1 interview round.
GIL stands for Global Interpreter Lock in Python, which limits execution of multiple threads at once.
GIL is a mutex that protects access to Python objects, preventing multiple threads from executing Python bytecodes at once.
Due to GIL, Python threads are not suitable for CPU-bound tasks but are still useful for I/O-bound tasks.
To handle multi-threading in Python, one can use multiprocessing module or asynchronous progr...
React uses a virtual DOM to efficiently update the actual DOM based on changes in state or props.
React creates a virtual DOM representation of the actual DOM.
When state or props change, React compares the virtual DOM with the actual DOM to determine the minimal set of changes needed.
React then updates the actual DOM efficiently to reflect the changes.
I was interviewed in Apr 2024.
based on 1 interview
Interview experience
Member Technical Staff
304
salaries
| ₹9 L/yr - ₹24 L/yr |
Issue Resolution Analyst
208
salaries
| ₹3 L/yr - ₹7 L/yr |
Senior Member of Technical Staff
181
salaries
| ₹11.6 L/yr - ₹36 L/yr |
Operations Analyst
152
salaries
| ₹2.4 L/yr - ₹7 L/yr |
Senior Operations Analyst
88
salaries
| ₹3.7 L/yr - ₹7.4 L/yr |
Oracle Cerner
Veradigm
McKesson
Epic Systems Corporation (Wisconsin)