Filter interviews by
Optimizing SQL and database involves improving query performance and database design.
Use indexes to speed up query execution
Normalize database tables to reduce redundancy
Avoid using SELECT * and instead specify required columns
Use stored procedures to reduce network traffic
Regularly analyze and optimize database performance
Control statements in database are used to control the flow of execution of SQL statements.
Control statements in database include IF, CASE, WHILE, LOOP, and GOTO.
They are used to control the flow of execution of SQL statements.
They help in making decisions, looping through data, and jumping to specific parts of code.
For example, the IF statement can be used to check a condition and execute a block of code if the c...
Identifying risks involves analyzing potential threats and vulnerabilities in the project or product.
Conducting a thorough risk assessment
Identifying potential risks and their impact on the project
Prioritizing risks based on their likelihood and impact
Developing a risk management plan to mitigate or avoid risks
Regularly reviewing and updating the risk management plan
Prioritization depends on project requirements and team dynamics, but Agile/Scrum is preferred.
Understand project goals and requirements
Collaborate with team to identify priorities
Use Agile/Scrum methodology for iterative development
Consider impact on stakeholders and deadlines
Regularly reassess priorities and adjust as needed
MyISAM is faster but lacks transaction support, while InnoDB is slower but has transaction support.
MyISAM is the default engine for MySQL.
MyISAM is faster for read-heavy applications.
InnoDB is slower but provides transaction support.
InnoDB is better for write-heavy applications.
InnoDB supports foreign keys and row-level locking.
MyISAM does not support foreign keys or row-level locking.
Transactional statements cannot be implemented using MyISAM engine.
MyISAM engine does not support transactions.
It does not provide ACID compliance.
In case of a crash, data can be lost.
InnoDB engine should be used for transactional statements.
Test Driven Development is a software development approach where tests are written before the code.
Tests are written before the code
Code is written to pass the tests
Tests are run frequently to ensure code quality
Helps in catching bugs early in the development cycle
I applied via LinkedIn and was interviewed in Apr 2023. There were 8 interview rounds.
Fitment check and physc evaluation
I appeared for an interview before Apr 2023.
Aptitude test with logical reasoning questions
I applied via LinkedIn and was interviewed in Jan 2021. There were 4 interview rounds.
MyISAM is faster but lacks transaction support, while InnoDB is slower but has transaction support.
MyISAM is the default engine for MySQL.
MyISAM is faster for read-heavy applications.
InnoDB is slower but provides transaction support.
InnoDB is better for write-heavy applications.
InnoDB supports foreign keys and row-level locking.
MyISAM does not support foreign keys or row-level locking.
Test Driven Development is a software development approach where tests are written before the code.
Tests are written before the code
Code is written to pass the tests
Tests are run frequently to ensure code quality
Helps in catching bugs early in the development cycle
Transactional statements cannot be implemented using MyISAM engine.
MyISAM engine does not support transactions.
It does not provide ACID compliance.
In case of a crash, data can be lost.
InnoDB engine should be used for transactional statements.
Prioritization depends on project requirements and team dynamics, but Agile/Scrum is preferred.
Understand project goals and requirements
Collaborate with team to identify priorities
Use Agile/Scrum methodology for iterative development
Consider impact on stakeholders and deadlines
Regularly reassess priorities and adjust as needed
Identifying risks involves analyzing potential threats and vulnerabilities in the project or product.
Conducting a thorough risk assessment
Identifying potential risks and their impact on the project
Prioritizing risks based on their likelihood and impact
Developing a risk management plan to mitigate or avoid risks
Regularly reviewing and updating the risk management plan
I applied via Recruitment Consultant and was interviewed before Jun 2020. There were 4 interview rounds.
Optimizing SQL and database involves improving query performance and database design.
Use indexes to speed up query execution
Normalize database tables to reduce redundancy
Avoid using SELECT * and instead specify required columns
Use stored procedures to reduce network traffic
Regularly analyze and optimize database performance
Control statements in database are used to control the flow of execution of SQL statements.
Control statements in database include IF, CASE, WHILE, LOOP, and GOTO.
They are used to control the flow of execution of SQL statements.
They help in making decisions, looping through data, and jumping to specific parts of code.
For example, the IF statement can be used to check a condition and execute a block of code if the condit...
Top trending discussions
I applied via Naukri.com and was interviewed in Mar 2021. There were 4 interview rounds.
As an Assistant Manager, I have led teams, managed projects, and improved operational efficiency through strategic planning.
Led a team of 10 in a project that increased sales by 20% over six months.
Implemented a new inventory management system that reduced waste by 15%.
Conducted weekly team meetings to enhance communication and address challenges.
Developed training programs for new employees, improving onboarding effic...
I appeared for an interview in Dec 2020.
Round duration - 40 minutes
Round difficulty - Easy
Given an integer array ARR
of size N
, your task is to find the total number of subsequences in which all elements are equal.
A subsequence of an array i...
Count the total number of subsequences in which all elements are equal in an integer array.
Iterate through the array and count the frequency of each element.
Calculate the total number of subsequences for each element using the formula (frequency * (frequency + 1) / 2).
Sum up the total number of subsequences for all elements and return the result modulo 10^9 + 7.
Tip 1 : Do practice as much as you can
Tip 2 : Coding is key to crack
Tip 1 : It should look nice
Tip 2 : Skills should be mentioned properly
I applied via Referral and was interviewed in Apr 2021. There were 3 interview rounds.
I applied via Company Website and was interviewed in Jan 2021. There were 3 interview rounds.
I applied via Naukri.com and was interviewed in Aug 2021. There was 1 interview round.
Some of the top questions asked at the 411 Locals interview for experienced candidates -
based on 1 interview experience
Difficulty level
Duration
based on 17 reviews
Rating in categories
Executive Recruiter
5
salaries
| ₹5.7 L/yr - ₹11 L/yr |
Software Engineer
3
salaries
| ₹13.7 L/yr - ₹17 L/yr |
Accounts Manager
3
salaries
| ₹6.3 L/yr - ₹6.3 L/yr |
Digital Marketing Manager
3
salaries
| ₹17 L/yr - ₹20 L/yr |
Team Leader SEO
3
salaries
| ₹13.5 L/yr - ₹17.2 L/yr |
TCS
Accenture
Wipro
Cognizant