Interview Q&A

Short answer: A good unit test is: Isolated: Tests one unit without external dependencies. Repeatable: Produces the same results every run. Fast: Executes quickly to allow frequent runs. Automated: Runs without manual intervention. Clear: Easy to understand and maintain. Independent: Does not depend on other tests.

Real-world example (ShopNest)

Arrange a cart with 2 items → Act Checkout() → Assert total and that payment was called once.

Say this in the interview

1. Define — one clear sentence (the short answer above).
2. Example — relate it to a project like ShopNest or your real work.
3. Trade-off — when you would not use it.

Short answer: Common database security risks include: SQL Injection: Malicious queries that can compromise the database if the input is not properly validated.

Explain a bit more

Unauthorized Access: Users gaining access to sensitive data without permission. Data Breaches: Exposing sensitive data due to insufficient encryption or weak access controls. Privilege Escalation: Attackers gaining elevated permissions or access levels. Malicious Insiders: Employees or authorized users intentionally or unintentionally leaking or modifying data. Denial of Service (DoS): Attackers overwhelming the database with requests, making it unavailable to legitimate users. Backup Exposure: Unencrypted or improperly secured backup files that are accessible to unauthorized users.

Real-world example (ShopNest)

ShopNest’s SQL Server database stores customers, products, and orders. Good indexes and clear foreign keys keep checkout queries fast and safe.

Say this in the interview

1. Define — one clear sentence (the short answer above).
2. Example — relate it to a project like ShopNest or your real work.
3. Trade-off — when you would not use it.

Short answer: uthorized users based on roles. Each role defines a set of permissions (what actions can be performed on which database objects). Steps to implement RBAC:

Real-world example (ShopNest)

ShopNest’s SQL Server database stores customers, products, and orders. Good indexes and clear foreign keys keep checkout queries fast and safe.

Say this in the interview

1. Define — one clear sentence (the short answer above).
2. Example — relate it to a project like ShopNest or your real work.
3. Trade-off — when you would not use it.

Short answer: Role-Based Access Control (RBAC) is a method for restricting system access to authorized users based on roles. Each role defines a set of permissions (what actions can be performed on which database objects). Steps to implement RBAC:

Real-world example (ShopNest)

ShopNest’s SQL Server database stores customers, products, and orders. Good indexes and clear foreign keys keep checkout queries fast and safe.

Say this in the interview

1. Define — one clear sentence (the short answer above).
2. Example — relate it to a project like ShopNest or your real work.
3. Trade-off — when you would not use it.

Short answer: And SQL statements in precompiled code, making it harder for attackers to inject malicious code.

Explain a bit more

Roles in database security: Input Validation: Stored procedures allow you to validate user inputs at the database level, preventing malicious input from being executed. UPDATE employees SET salary = new_salary WHERE id = emp_id; END IF; END; And SQL statements in precompiled code, making it harder for attackers to inject malicious code. Roles in database security: Input Validation: Stored procedures allow you to validate user inputs at the database level, preventing malicious input from being executed. UPDATE employees SET salary = new_salary WHERE id = emp_id; END IF; END;

Real-world example (ShopNest)

ShopNest’s SQL Server database stores customers, products, and orders. Good indexes and clear foreign keys keep checkout queries fast and safe.

Say this in the interview

1. Define — one clear sentence (the short answer above).
2. Example — relate it to a project like ShopNest or your real work.
3. Trade-off — when you would not use it.

Short answer: Stored Procedures can help improve database security by encapsulating business logic and SQL statements in precompiled code, making it harder for attackers to inject malicious code.

Explain a bit more

Roles in database security: Input Validation: Stored procedures allow you to validate user inputs at the database level, preventing malicious input from being executed. Preventing Direct Access: By using stored procedures, users can be given permissions to execute specific procedures rather than direct access to the underlying tables. Encapsulation of Business Logic: The logic within stored procedures is not visible to the end-user, reducing the attack surface. Audit Logging: Stored procedures can include logic to log user activity for auditing and compliance purposes. Example: Instead of allowing users to execute arbitrary INSERT or UPDATE statements, you can give them permission to execute a specific stored procedure that does the necessary validation and modification of data. CREATE PROCEDURE update_salary(IN emp_id INT, IN new_salary DECIMAL) BEGIN IF new_salary > 0 THEN

Example code

UPDATE employees SET salary = new_salary WHERE id = emp_id; END IF; END;

Real-world example (ShopNest)

ShopNest’s SQL Server database stores customers, products, and orders. Good indexes and clear foreign keys keep checkout queries fast and safe.

Say this in the interview

1. Define — one clear sentence (the short answer above).
2. Example — relate it to a project like ShopNest or your real work.
3. Trade-off — when you would not use it.

Short answer: LTER DATABASE MyDatabase SET ENCRYPTION ON; Column-Level Encryption: For encrypting specific columns. CREATE CERTIFICATE MyCertificate WITH SUBJECT = 'My Certificate'; CREATE SYMMETRIC KEY MySymmetricKey WITH ALGORITHM = AES_256 ENCRYPTION BY CERTIFICATE MyCertificate; OPEN SYMMETRIC KEY MySymmetricKey DECRYPTION BY CERTIFICATE MyCertificate; PostgreSQL: pgcrypto extension provides functions for encrypting data.

Real-world example (ShopNest)

ShopNest’s SQL Server database stores customers, products, and orders. Good indexes and clear foreign keys keep checkout queries fast and safe.

Say this in the interview

1. Define — one clear sentence (the short answer above).
2. Example — relate it to a project like ShopNest or your real work.
3. Trade-off — when you would not use it.

Short answer: Encryption is essential for protecting sensitive data both at rest (on disk) and in transit (during communication).

Explain a bit more

SQL Server: Transparent Data Encryption (TDE): Encrypts data at rest without requiring application changes. CREATE DATABASE ENCRYPTION KEY; ALTER DATABASE MyDatabase SET ENCRYPTION ON; Column-Level Encryption: For encrypting specific columns. CREATE CERTIFICATE MyCertificate WITH SUBJECT = 'My Certificate'; CREATE SYMMETRIC KEY MySymmetricKey WITH ALGORITHM = AES_256 ENCRYPTION BY CERTIFICATE MyCertificate; OPEN SYMMETRIC KEY MySymmetricKey DECRYPTION BY CERTIFICATE MyCertificate; PostgreSQL: pgcrypto extension provides functions for encrypting data. SELECT pgp_sym_encrypt('Sensitive Data', 'encryption_key'); MySQL: Encryption Functions: MySQL provides functions like AES_ENCRYPT and AES_DECRYPT. SELECT AES_ENCRYPT('Sensitive Data', 'encryption_key'); SELECT AES_DECRYPT(encrypted_data, 'encryption_key'); For all databases, consider using SSL/TLS for encrypting data in transit.

Real-world example (ShopNest)

ShopNest’s SQL Server database stores customers, products, and orders. Good indexes and clear foreign keys keep checkout queries fast and safe.

Say this in the interview

1. Define — one clear sentence (the short answer above).
2. Example — relate it to a project like ShopNest or your real work.
3. Trade-off — when you would not use it.

Short answer: Backup and restore security involves ensuring that backup files are stored securely and that access to backup data is tightly controlled. Steps for Secure Backup:

Real-world example (ShopNest)

ShopNest’s SQL Server database stores customers, products, and orders. Good indexes and clear foreign keys keep checkout queries fast and safe.

Say this in the interview

1. Define — one clear sentence (the short answer above).
2. Example — relate it to a project like ShopNest or your real work.
3. Trade-off — when you would not use it.

Short answer: There are three primary types of database backups:

Real-world example (ShopNest)

Checkout wraps stock decrement + order insert in a transaction so you never sell stock you do not have.

Say this in the interview

1. Define — one clear sentence (the short answer above).
2. Example — relate it to a project like ShopNest or your real work.
3. Trade-off — when you would not use it.

Short answer: SQL Server: To back up a database in SQL Server, you can use the BACKUP DATABASE command.

Explain a bit more

- Full Backup BACKUP DATABASE MyDatabase TO DISK = 'C:\Backups\MyDatabase.bak'; - Transaction Log Backup BACKUP LOG MyDatabase TO DISK = 'C:\Backups\MyDatabase_log.trn'; PostgreSQL: In PostgreSQL, you can use the pg_dump command for backing up the database. - Full Backup pg_dump mydatabase > /path/to/backup/mydatabase.sql For backing up with compression or other options: pg_dump -Fc mydatabase > /path/to/backup/mydatabase.dump For transactional backups, you can use WAL (Write-Ahead Logging) archiving, typically managed through archive_mode and archive_command settings in the postgresql.conf. MySQL: In MySQL, you can use the mysqldump command for backing up the database. - Full Backup mysqldump -u username -p mydatabase > /path/to/backup/mydatabase.sql For binary logging (transaction logs), MySQL uses binlog: - Enabling binary log [mysqld] log-bin=mysql-bin

Real-world example (ShopNest)

ShopNest’s SQL Server database stores customers, products, and orders. Good indexes and clear foreign keys keep checkout queries fast and safe.

Say this in the interview

1. Define — one clear sentence (the short answer above).
2. Example — relate it to a project like ShopNest or your real work.
3. Trade-off — when you would not use it.

Short answer: SQL Server: To restore a full backup in SQL Server: - Full Restore RESTORE DATABASE MyDatabase FROM DISK = 'C:\Backups\MyDatabase.bak'; - Transaction Log Restore RESTORE LOG MyDatabase FROM DISK = 'C:\Backups\MyDatabase_log.trn'; To restore a database to a specific point in time (using point-in-time recovery), you would restore the full backup and apply transaction logs.

Explain a bit more

RESTORE DATABASE MyDatabase FROM DISK = 'C:\Backups\MyDatabase.bak'; RESTORE LOG MyDatabase FROM DISK = 'C:\Backups\MyDatabase_log.trn' WITH STOPAT = '2023-09-14T15:30:00'; -- Restore to a specific time PostgreSQL: To restore a backup from a pg_dump: - Full Restore from SQL dump psql -U username -d mydatabase < /path/to/backup/mydatabase.sql For binary dump (pg_dump -Fc): pg_restore -U username -d mydatabase /path/to/backup/mydatabase.dump MySQL: To restore a MySQL database: - Full Restore from SQL dump mysql -u username -p mydatabase < /path/to/backup/mydatabase.sql For restoring binary logs: mysqlbinlog /path/to/binlog/mysql-bin.000001 | mysql -u username -p

Real-world example (ShopNest)

ShopNest’s SQL Server database stores customers, products, and orders. Good indexes and clear foreign keys keep checkout queries fast and safe.

Say this in the interview

1. Define — one clear sentence (the short answer above).
2. Example — relate it to a project like ShopNest or your real work.
3. Trade-off — when you would not use it.

Short answer: Automating backups ensures that backups are performed regularly and without manual intervention. You can use the following methods:

Real-world example (ShopNest)

ShopNest’s SQL Server database stores customers, products, and orders. Good indexes and clear foreign keys keep checkout queries fast and safe.

Say this in the interview

1. Define — one clear sentence (the short answer above).
2. Example — relate it to a project like ShopNest or your real work.
3. Trade-off — when you would not use it.

Short answer: Database replication is the process of copying and maintaining database objects in multiple databases to ensure high availability and fault tolerance. Types of Replication:

Real-world example (ShopNest)

ShopNest’s SQL Server database stores customers, products, and orders. Good indexes and clear foreign keys keep checkout queries fast and safe.

Say this in the interview

1. Define — one clear sentence (the short answer above).
2. Example — relate it to a project like ShopNest or your real work.
3. Trade-off — when you would not use it.

Short answer: Sharding and partitioning are techniques used to distribute data across multiple servers or tables to improve performance and scalability.

Real-world example (ShopNest)

ShopNest’s SQL Server database stores customers, products, and orders. Good indexes and clear foreign keys keep checkout queries fast and safe.

Say this in the interview

1. Define — one clear sentence (the short answer above).
2. Example — relate it to a project like ShopNest or your real work.
3. Trade-off — when you would not use it.

Short answer: Monitoring database performance is crucial for identifying bottlenecks and ensuring optimal functioning. The following methods are commonly used:

Real-world example (ShopNest)

ShopNest adds an index on Orders(CustomerId, CreatedAt) because “my recent orders” is queried constantly.

Say this in the interview

1. Define — one clear sentence (the short answer above).
2. Example — relate it to a project like ShopNest or your real work.
3. Trade-off — when you would not use it.

Short answer: A connection pool is a cache of database connections that are maintained so that connections can be reused when future requests to the database are made.

Explain a bit more

Instead of opening and closing a new connection each time a query is executed, the application can reuse existing connections from the pool. How it helps with scaling: Improves efficiency: Reusing connections reduces the overhead of establishing new connections, leading to faster query execution. Reduces resource consumption: By limiting the number of connections to the database, the pool avoids overloading the database with too many open connections. Improves scalability: Connection pools help handle a large number of requests without overwhelming the database. The pool can be scaled by adjusting the maximum number of connections based on the workload. Example: A connection pool size can be set to 100, meaning up to 100 connections to the database can be active at once, with others waiting in line for an available connection.

Real-world example (ShopNest)

ShopNest’s SQL Server database stores customers, products, and orders. Good indexes and clear foreign keys keep checkout queries fast and safe.

Say this in the interview

1. Define — one clear sentence (the short answer above).
2. Example — relate it to a project like ShopNest or your real work.
3. Trade-off — when you would not use it.

Short answer: Multi-tenancy refers to a single instance of a database serving multiple tenants (clients or organizations) while keeping their data isolated. Approaches:

Real-world example (ShopNest)

ShopNest’s SQL Server database stores customers, products, and orders. Good indexes and clear foreign keys keep checkout queries fast and safe.

Say this in the interview

1. Define — one clear sentence (the short answer above).
2. Example — relate it to a project like ShopNest or your real work.
3. Trade-off — when you would not use it.

Short answer: And ensuring consistency across different environments (development, staging, production). pproaches:

Real-world example (ShopNest)

ShopNest’s SQL Server database stores customers, products, and orders. Good indexes and clear foreign keys keep checkout queries fast and safe.

Say this in the interview

1. Define — one clear sentence (the short answer above).
2. Example — relate it to a project like ShopNest or your real work.
3. Trade-off — when you would not use it.

Short answer: Managing and versioning database schema changes is essential in keeping track of updates and ensuring consistency across different environments (development, staging, production). Approaches:

Real-world example (ShopNest)

ShopNest’s SQL Server database stores customers, products, and orders. Good indexes and clear foreign keys keep checkout queries fast and safe.

Say this in the interview

1. Define — one clear sentence (the short answer above).
2. Example — relate it to a project like ShopNest or your real work.
3. Trade-off — when you would not use it.

Short answer: Data migration involves transferring data between systems or platforms, often when changing database engines or moving to the cloud. Steps:

Real-world example (ShopNest)

ShopNest’s SQL Server database stores customers, products, and orders. Good indexes and clear foreign keys keep checkout queries fast and safe.

Say this in the interview

1. Define — one clear sentence (the short answer above).
2. Example — relate it to a project like ShopNest or your real work.
3. Trade-off — when you would not use it.

Short answer: The ACID properties ensure reliable processing of database transactions:

Real-world example (ShopNest)

Checkout wraps stock decrement + order insert in a transaction so you never sell stock you do not have.

Say this in the interview

1. Define — one clear sentence (the short answer above).
2. Example — relate it to a project like ShopNest or your real work.
3. Trade-off — when you would not use it.

Short answer: Your hike target should be based on market demand, not only your current CTC. If your skill set is niche or revenue-linked, you can justify a stronger jump than a standard lateral move. Always decide a target, an acceptable minimum, and a walk-away number before interviews close.

Step-by-step approach

1. Map your role to market bands for your city and years of experience.
2. Classify your skills into common, in-demand, and scarce to estimate pricing power.
3. Set three numbers: aspirational, fair, and minimum acceptable compensation.
4. Adjust expected hike if the new role has bigger scope, team ownership, or on-call complexity.
5. Calculate real take-home after variable pay, tax impact, and benefits breakdown.
6. Use this line in discussion: "Based on scope and market benchmarks, I am targeting this range."

Real-world example

Ananya, a backend engineer at Infosys, got interview calls from Zoho and Freshworks. She realized one role included architecture ownership and weekend release responsibility, so she increased her expected hike ask. Vikram reviewed her compensation sheet and helped her compare fixed pay versus variable components. She negotiated a stronger final number at Zoho with better in-hand salary and accepted.

What to say / email template

Hi [Recruiter Name], thank you for the offer details. Based on current market compensation for this scope and my recent outcomes in [domain], I am targeting a total CTC in the range of [X]-[Y], with stronger fixed pay preference. I am very interested in joining and would appreciate if we can review the offer once.

Numbers & benchmarks

• Many India job switches close in the 25% to 55% hike range depending on skill demand.
• For high-demand domains, candidates sometimes negotiate 60%+ with strong proof of impact.
• Keep at least 10% buffer between target and minimum acceptable number.

Mistakes to avoid

• Copying a friend's hike expectation without considering your own role maturity.
• Ignoring hidden deductions and overestimating actual monthly in-hand.
• Asking too low early in process and getting anchored below market.
• Not revising expectations when scope significantly increases.

Decide your walk-away number before negotiation starts.

Short answer: To negotiate a higher CTC, you must demonstrate higher expected impact. Recruiters can stretch budgets when they can justify your value to hiring managers and finance. Build your case around outcomes, not effort or tenure.

Step-by-step approach

1. Translate your last two years of work into business metrics and decision-level talking points.
2. Highlight risk areas in the new role where your experience reduces failure probability.
3. Offer two compensation structures, for example higher fixed or lower fixed plus joining bonus.
4. Ask politely whether there is room in band based on interview feedback quality.
5. Use competing opportunities carefully as context, not as threats.
6. Request a written revised breakdown before final confirmation.

Real-world example

Meera interviewed at CRED for a senior Android role while working at Freshworks. She prepared a scorecard showing app crash-rate reduction, payment success uplift, and release turnaround improvements from her past projects. The recruiter said the band was tight, so Meera offered two structure options. CRED approved a higher CTC with a better fixed portion and a joining bonus to close quickly.

What to say / email template

I am very positive about this role. Based on interview scope and the outcomes I have delivered in similar responsibilities, is there flexibility to move the offer closer to [target range]? I am open to discussing structure options to make this workable.

Mistakes to avoid

• Talking only about years of experience without impact numbers.
• Demanding max band despite average interview performance.
• Overusing external offers as pressure in every conversation.
• Forgetting to verify if ESOP value is real or only projected.

Give alternatives; flexibility increases approval probability.

Short answer: Experienced candidates are evaluated on ownership depth, not just technical skills. Your negotiation should show that you can de-risk delivery, mentor teams, and improve business outcomes quickly. The stronger your leadership evidence, the more room you have to negotiate compensation structure.

Step-by-step approach

1. Summarize your last 3 years in terms of scope, team influence, and measurable impact.
2. Show examples where you handled ambiguity, incidents, or cross-team delivery risk.
3. Ask how success is measured in the first 90 days and align compensation discussion to that scope.
4. Negotiate fixed pay and variable payout conditions separately.
5. Discuss long-term wealth components like ESOP vesting schedule and liquidity history.
6. Lock in notice buyout support or joining flexibility if that affects your decision.

Real-world example

Vikram, a senior engineer at HCL, interviewed for a staff role at PhonePe. He highlighted how he mentored 11 engineers and reduced release rollback incidents by 41% across two quarters. Neha from Flipkart helped him frame this as leadership leverage rather than only coding output. PhonePe revised his package with better fixed pay, a buyout component, and clearer bonus terms.

Mistakes to avoid

• Discussing compensation before understanding role expectations fully.
• Ignoring payout conditions attached to variable components.
• Undervaluing managerial and mentoring impact in negotiation conversations.
• Not calculating opportunity cost of notice period overlap.

Follow-up questions you may get

• After final round, ask for compensation review only after receiving positive interview feedback signals.

For experienced roles, negotiate based on scope leverage.