BigBasket Interview Questions and Answers

Concurrency is the ability of a system to run multiple tasks simultaneously. Performance of applications can be checked using profiling tools. Concurrency can be handled using synchronization techniques like mutexes and channels.

• Concurrency allows multiple tasks to run concurrently, improving performance and responsiveness.

• Performance of applications can be checked using profiling tools like Go's built-in 'pprof' package.

• Concurrency can be handled using synchronization techni...read more

To ensure no vulnerabilities, follow secure coding practices, conduct regular security audits, use encryption, and stay updated on security threats.

• Follow secure coding practices such as input validation, output encoding, and parameterized queries.

• Conduct regular security audits to identify and address vulnerabilities in the code.

• Use encryption to protect sensitive data in transit and at rest.

• Stay updated on security threats and patches to ensure the software is secure.

• Implem...read more

Load balancing network devices distribute network traffic across multiple servers to prevent overload and improve performance.

• Load balancers can be hardware or software-based

• They help optimize resource utilization and ensure high availability

• Common examples include F5 BIG-IP, Citrix NetScaler, and NGINX

• They can use various algorithms like round-robin, least connections, and IP hash

A subquery is a query nested within another query in SQL.

• A subquery is enclosed within parentheses and is used to return data that will be used by the main query.

• It can be used in SELECT, INSERT, UPDATE, and DELETE statements.

• Example: SELECT * FROM table1 WHERE column1 = (SELECT column2 FROM table2 WHERE condition);

DDL stands for Data Definition Language and is used to define the structure of database objects. DML stands for Data Manipulation Language and is used to manipulate data within the database.

• DDL is used to create, modify, and delete database objects like tables, indexes, etc.

• DML is used to insert, update, delete, and retrieve data from tables.

• Examples of DDL statements include CREATE TABLE, ALTER TABLE, DROP TABLE.

• Examples of DML statements include INSERT, UPDATE, DELETE, SELE...read more