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 appeared for an interview before Jul 2021.
I applied via Walk-in and was interviewed before May 2020. There were 3 interview rounds.
I applied via Naukri.com
Amazon's innovation, customer focus, and diverse opportunities align with my career goals and values.
Customer Obsession: Amazon prioritizes customer satisfaction, evident in initiatives like Prime and personalized recommendations.
Innovation: The company is a leader in technology and logistics, constantly pushing boundaries with services like AWS and drone delivery.
Diversity of Roles: Amazon offers a wide range of caree...
I expect Amazon to foster innovation, provide growth opportunities, and maintain a customer-centric culture.
Opportunities for professional development, such as training programs and mentorship.
A collaborative work environment that encourages teamwork and idea sharing.
Access to cutting-edge technology and resources to drive innovation.
A strong focus on customer satisfaction, ensuring that every decision prioritizes the ...
I applied via Naukri.com and was interviewed before Feb 2020. There were 3 interview rounds.
Workflow, trigger, reports, roles, profiles, permission set, and sharing rules are all important features in Salesforce.
Workflow is a series of automated steps that can be used to streamline business processes.
Triggers are used to execute code before or after a record is inserted, updated, or deleted.
Reports are used to display data in a visual format, such as a table or chart.
Roles are used to define the hierarchy of ...
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