Filter interviews by
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...
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
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
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
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.
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 Walk-in and was interviewed before Jun 2021. There were 2 interview rounds.
HR told about the company on the first day, how it works, told the rules, showed the management and a lot
I applied via Campus Placement and was interviewed before Feb 2020. There were 4 interview rounds.
Yes, algorithms and pseudocodes are still important in IT Services.
Algorithms are used in various fields of IT such as machine learning, data analysis, and cryptography.
Pseudocodes are used to plan and design algorithms before coding them.
Understanding algorithms and pseudocodes is essential for software engineers to write efficient and optimized code.
Examples of algorithms include sorting algorithms, search algorithms...
I applied via Referral and was interviewed in Dec 2020. There were 4 interview rounds.
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.2 L/yr - ₹12.9 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