i
Crest
Infosystems
Filter interviews by
Normalization in DBMS is the process of organizing data in a database to reduce redundancy and improve data integrity.
Normalization involves breaking down a database into smaller, more manageable tables.
It helps in reducing data redundancy by storing data in a structured way.
Normalization ensures data integrity by minimizing data anomalies.
There are different normal forms like 1NF, 2NF, 3NF, BCNF, etc.
Example: In ...
Some common hooks used in React.js are useState, useEffect, useContext, and useRef.
useState - for managing state in functional components
useEffect - for handling side effects in functional components
useContext - for accessing context in functional components
useRef - for accessing DOM elements or values in functional components
Kotlin is better than Java due to its concise syntax, null safety, interoperability, and improved performance.
Kotlin has concise syntax which reduces boilerplate code and makes code more readable.
Kotlin provides null safety features to prevent NullPointerExceptions at runtime.
Kotlin is fully interoperable with Java, allowing developers to use both languages in the same project.
Kotlin offers improved performance co...
I have integrated payment gateways like PayPal, Stripe, and Square into e-commerce websites.
Integrated PayPal payment gateway for seamless checkout process
Implemented Stripe API for secure credit card transactions
Configured Square payment gateway for in-person and online payments
MySQL injections are a type of cyber attack where malicious SQL statements are inserted into an entry field for execution.
MySQL injections occur when an attacker inserts malicious SQL code into a query to manipulate the database.
Attackers can use MySQL injections to access, modify, or delete data in the database.
Preventing MySQL injections involves using parameterized queries and input validation.
Example: SELECT *...
Polymorphism in OOPs allows objects of different classes to be treated as objects of a common superclass.
Polymorphism allows methods to be called on objects of different classes that implement the same interface or superclass.
There are two types of polymorphism: compile-time (method overloading) and runtime (method overriding).
Example: Animal superclass with methods like eat() and sleep(). Dog and Cat subclasses c...
Migration in Laravel is the process of managing database schema changes using PHP code.
Migration allows developers to define database tables and their structure using PHP code instead of SQL.
It helps in version control of database schema changes and makes it easier to collaborate with other developers.
Migrations can be rolled back to previous states if needed, making database changes reversible.
Example: 'php artis...
I am driven by the desire to create intuitive and user-friendly designs that solve real-world problems.
I am passionate about understanding user needs and behaviors
I enjoy collaborating with cross-functional teams to develop innovative solutions
I am constantly learning and staying up-to-date with industry trends and best practices
I find satisfaction in seeing my designs come to life and positively impacting users
I ...
I applied via Campus Placement and was interviewed in Jul 2024. There were 2 interview rounds.
Aptitude was based on reasoning and basic tech questions.It was easy.
I am a passionate Android developer with experience in building mobile applications using Java and Kotlin.
Experienced in developing Android apps using Java and Kotlin
Familiar with Android Studio and Android SDK
Knowledge of RESTful APIs and third-party libraries like Retrofit and Glide
Kotlin is better than Java due to its concise syntax, null safety, interoperability, and improved performance.
Kotlin has concise syntax which reduces boilerplate code and makes code more readable.
Kotlin provides null safety features to prevent NullPointerExceptions at runtime.
Kotlin is fully interoperable with Java, allowing developers to use both languages in the same project.
Kotlin offers improved performance compare...
I applied via Campus Placement and was interviewed in Jun 2024. There were 2 interview rounds.
Basic javascript questions and verbal reasoning
I applied via Campus Placement and was interviewed before Dec 2023. There were 2 interview rounds.
Basic aptitude questions about profit loss, percentage, a few were tricky but solvable.
Some common hooks used in React.js are useState, useEffect, useContext, and useRef.
useState - for managing state in functional components
useEffect - for handling side effects in functional components
useContext - for accessing context in functional components
useRef - for accessing DOM elements or values in functional components
Normalization in DBMS is the process of organizing data in a database to reduce redundancy and improve data integrity.
Normalization involves breaking down a database into smaller, more manageable tables.
It helps in reducing data redundancy by storing data in a structured way.
Normalization ensures data integrity by minimizing data anomalies.
There are different normal forms like 1NF, 2NF, 3NF, BCNF, etc.
Example: In a dat...
I applied via Naukri.com and was interviewed before Sep 2022. There were 2 interview rounds.
Polymorphism in OOPs allows objects of different classes to be treated as objects of a common superclass.
Polymorphism allows methods to be called on objects of different classes that implement the same interface or superclass.
There are two types of polymorphism: compile-time (method overloading) and runtime (method overriding).
Example: Animal superclass with methods like eat() and sleep(). Dog and Cat subclasses can ov...
MySQL injections are a type of cyber attack where malicious SQL statements are inserted into an entry field for execution.
MySQL injections occur when an attacker inserts malicious SQL code into a query to manipulate the database.
Attackers can use MySQL injections to access, modify, or delete data in the database.
Preventing MySQL injections involves using parameterized queries and input validation.
Example: SELECT * FROM...
Migration in Laravel is the process of managing database schema changes using PHP code.
Migration allows developers to define database tables and their structure using PHP code instead of SQL.
It helps in version control of database schema changes and makes it easier to collaborate with other developers.
Migrations can be rolled back to previous states if needed, making database changes reversible.
Example: 'php artisan ma...
I have integrated payment gateways like PayPal, Stripe, and Square into e-commerce websites.
Integrated PayPal payment gateway for seamless checkout process
Implemented Stripe API for secure credit card transactions
Configured Square payment gateway for in-person and online payments
I applied via LinkedIn and was interviewed in Nov 2021. There were 3 interview rounds.
Kotlin MVVM Retrofit Constraint Layout
I applied via Referral and was interviewed before Sep 2020. There were 4 interview rounds.
I am driven by the desire to create intuitive and user-friendly designs that solve real-world problems.
I am passionate about understanding user needs and behaviors
I enjoy collaborating with cross-functional teams to develop innovative solutions
I am constantly learning and staying up-to-date with industry trends and best practices
I find satisfaction in seeing my designs come to life and positively impacting users
I am mo...
My goal is to create intuitive and visually appealing user interfaces that enhance user experience.
Design user-friendly interfaces
Improve user engagement
Enhance visual aesthetics
Optimize user flows
Stay updated with industry trends and best practices
Top trending discussions
1st round included basic apt questions and essay writing
I applied via Campus Placement and was interviewed before Feb 2022. There were 2 interview rounds.
2 papers- Online tricky questions-medium to high-level difficulty. Computer based
Pasteurization is a process of heating food or liquid to a specific temperature to kill harmful bacteria and increase shelf life.
The process involves heating the substance to a temperature between 60-100°C for a specific time period.
This kills most of the harmful bacteria and pathogens present in the substance.
The process was developed by Louis Pasteur in the 19th century to prevent spoilage of wine and beer.
Pasteuriza...
Mean is the average of a set of numbers, median is the middle value, and mode is the most frequently occurring value.
Mean is calculated by adding up all the numbers in a set and dividing by the total number of values.
Median is the middle value in a set of numbers when they are arranged in order.
Mode is the value that appears most frequently in a set of numbers.
In a symmetrical distribution, the mean, median, and mode a...
posted on 31 May 2022
I appeared for an interview in Sep 2021.
Round duration - 150 Minutes
Round difficulty - Medium
3 coding question + 50 dsa
Given an array/list 'ARR' consisting of 'N' integers, your task is to find the majority element in the array. If there is no majority element present, return -1.
Find the majority element in an array, return -1 if no majority element exists.
Iterate through the array and keep track of the count of each element using a hashmap.
Check if any element's count is greater than floor(N/2) to determine the majority element.
Return the majority element or -1 if no majority element exists.
You are provided with an arbitrary binary tree consisting of 'N' nodes where each node is associated with a certain value. The task is to determine the height of the tree.
Calculate the height of a binary tree given its level order traversal.
Traverse the binary tree level by level and keep track of the height as you go down the tree.
Use a queue data structure to perform level order traversal efficiently.
The height of a binary tree is the maximum number of edges from the root to any leaf node.
Handle NULL nodes represented by -1 in the input.
Return the height of the binary tree as a single...
You are provided with a 2-dimensional matrix having N
rows and M
columns, containing only 1s (land) and 0s (water). Your goal is to determine the number of islands in t...
Count the number of islands in a 2D matrix of 1s and 0s.
Use Depth First Search (DFS) or Breadth First Search (BFS) to traverse the matrix and count the number of connected components.
Maintain a visited array to keep track of visited cells to avoid counting the same island multiple times.
Iterate through each cell in the matrix and if it is a land (1) and not visited, perform DFS/BFS to explore the connected land cells.
I...
Round duration - 60 Minutes
Round difficulty - Hard
2 coding questions
You are given 'N' pairs of integers where the first number is always smaller than the second number, i.e., in pair (a, b) -> a < b always. A pair chain is...
Find the length of the longest pair chain that can be formed using the given pairs.
Sort the pairs based on the second element in ascending order.
Iterate through the sorted pairs and keep track of the maximum chain length.
Update the chain length if the current pair can be added to the chain.
Return the maximum chain length at the end.
You are given an array prices
, representing stock prices over N consecutive days. Your goal is to compute the maximum profit achievable by performing multiple transactions (i...
Find maximum profit by buying and selling stocks multiple times.
Iterate through the array and find all increasing sequences of stock prices.
Calculate profit by buying at the start and selling at the end of each increasing sequence.
Sum up all profits to get the maximum profit achievable.
Round duration - 45 minutes
Round difficulty - Medium
Data structures,java script,web dev related questions,dbms questions
Designing a web crawler involves defining the scope, selecting a crawling strategy, implementing the crawler, handling data storage, and ensuring politeness.
Define the scope of the web crawler by determining the websites to crawl and the depth of the crawl.
Select a crawling strategy such as breadth-first or depth-first search based on the requirements.
Implement the web crawler using a programming language like Python o...
Tip 1 : Practice Atleast 250 Questions
Tip 2 : Do atleast 2 projects
Tip 3 : practice basics of dsa
Tip 1 : show your projects
Tip 2 : highlight your skills
posted on 5 Oct 2022
I applied via Campus Placement and was interviewed in Apr 2022. There were 5 interview rounds.
Basic aptitude questions. Just keep a track of time
2nd round is coding round. You can expect Leetcode medium questions. The topics asked are Linked list, Trees and arrays.
3rd round is again the Coding Test. Level of questions is Leetcode Medium to Leetcode Hard. Topics covered are Trees, Doubly Linked List, Dp etc.
based on 8 interview experiences
Difficulty level
Duration
based on 40 reviews
Rating in categories
5-8 Yrs
Not Disclosed
4-8 Yrs
Not Disclosed
3-5 Yrs
Not Disclosed
Senior Software Engineer
38
salaries
| ₹5.6 L/yr - ₹13.2 L/yr |
Software Engineer
27
salaries
| ₹4 L/yr - ₹8 L/yr |
Software Developer
15
salaries
| ₹4 L/yr - ₹8.4 L/yr |
Team Lead
5
salaries
| ₹6.8 L/yr - ₹19 L/yr |
Senior Software Developer
5
salaries
| ₹5.5 L/yr - ₹8.6 L/yr |
Maxgen Technologies
JoulestoWatts Business Solutions
Value Point Systems
F1 Info Solutions and Services