tgindex

Coding Interview ⛥

описание

This channel contains the free resources and solution of coding problems which are usually asked in the interviews.

← к каналу@crackingthecodinginterviews
1 463
подписчиков
Охват к подписчикам
56,4%
ERR
Реакции к просмотрам
0,08%
13 на 19 постов
Пересылки к просмотрам
0,47%
77
Постов в день
0,0
всего 20

Где отзываются чаще

доля реакций к просмотрам
  • 20 окт. 2025 г.без подписи0,67%
  • 18 мая 2025 г.SQL Cheatsheet 📝 This SQL cheatsheet is designed to be your quick reference guide for SQL programming. Whether you’re a beginner learning how to query databases or an experienced developer looking for a handy resource, this cheatsheet covers essential SQL topics. 1. Database Basics - CREATE DATABASE db_name; - USE db_name; 2. Tables - Create Table: CREATE TABLE table_name (col1 datatype, col2 datatype); - Drop Table: DROP TABLE table_name; - Alter Table: ALTER TABLE table_name ADD column_name datatype; 3. Insert Data - INSERT INTO table_name (col1, col2) VALUES (val1, val2); 4. Select Queries - Basic Select: SELECT * FROM table_name; - Select Specific Columns: SELECT col1, col2 FROM table_name; - Select with Condition: SELECT * FROM table_name WHERE condition; 5. Update Data - UPDATE table_name SET col1 = value1 WHERE condition; 6. Delete Data - DELETE FROM table_name WHERE condition; 7. Joins - Inner Join: SELECT * FROM table1 INNER JOIN table2 ON table1.col = table2.col; - Left Join: SELECT * FROM table1 LEFT JOIN table2 ON table1.col = table2.col; - Right Join: SELECT * FROM table1 RIGHT JOIN table2 ON table1.col = table2.col; 8. Aggregations - Count: SELECT COUNT(*) FROM table_name; - Sum: SELECT SUM(col) FROM table_name; - Group By: SELECT col, COUNT(*) FROM table_name GROUP BY col; 9. Sorting & Limiting - Order By: SELECT * FROM table_name ORDER BY col ASC|DESC; - Limit Results: SELECT * FROM table_name LIMIT n; 10. Indexes - Create Index: CREATE INDEX idx_name ON table_name (col); - Drop Index: DROP INDEX idx_name; 11. Subqueries - SELECT * FROM table_name WHERE col IN (SELECT col FROM other_table); 12. Views - Create View: CREATE VIEW view_name AS SELECT * FROM table_name; - Drop View: DROP VIEW view_name; Hope it helps :)0,28%
  • 25 июл.𝟯𝟬 𝗦𝗰𝗲𝗻𝗮𝗿𝗶𝗼-𝗕𝗮𝘀𝗲𝗱 𝗝𝗮𝘃𝗮 𝗕𝗮𝗰𝗸𝗲𝗻𝗱 𝗜𝗻𝘁𝗲𝗿𝘃𝗶𝗲𝘄 𝗤𝘂𝗲𝘀𝘁𝗶𝗼𝗻𝘀 𝗝𝗮𝘃𝗮 & 𝗖𝗼𝗻𝗰𝘂𝗿𝗿𝗲𝗻𝗰𝘆: 1. Your HashMap is being accessed by multiple threads. What problems can occur, and how would you fix them? 2. Your application has a race condition causing duplicate payments. How would you identify and solve it? 3. Your application creates thousands of threads and CPU usage spikes. What would you do? 4. A REST API is taking 30 seconds because it calls three downstream services. How would you optimize it? 5. Multiple threads are updating the same record. How would you ensure consistency? 𝗦𝗽𝗿𝗶𝗻𝗴 𝗕𝗼𝗼𝘁: 6. Your Spring Boot application startup time increased from 15 seconds to 2 minutes. How would you investigate? 7. A circular dependency error appears after deployment. How would you resolve it? 8. One API works locally but fails in production with LazyInitializationException . What could be the reason? 9. A transaction partially updates data even though you expected a rollback. Why might this happen? 10. Your application suddenly starts throwing OutOfMemoryError . How would you debug it? 𝗠𝗶𝗰𝗿𝗼𝘀𝗲𝗿𝘃𝗶𝗰𝗲𝘀: 11. Service A calls Service B, which calls Service C. Service C is down. How would you prevent the failure from cascading? 12. A customer reports that the same payment was processed twice. How would you prevent duplicate processing? 13. One microservice becomes slow and starts affecting the entire system. What patterns would you implement? 14. How would you trace a request across 15 microservices? 15. One microservice must communicate with another. Would you choose REST, Kafka, or gRPC? Why? 𝗞𝗮𝗳𝗸𝗮: 16. A Kafka consumer processes the same message twice. How would you handle it? 17. One Kafka partition has much higher traffic than others. How would you fix it? 18. Consumer lag keeps increasing. How would you investigate? 19. A message fails repeatedly during processing. What should happen next? 20. How would you guarantee message ordering for a customer? 𝗗𝗮𝘁𝗮𝗯𝗮𝘀𝗲: 21. A query that used to take 50 ms now takes 10 seconds. How would you troubleshoot it? 22. Your database CPU reaches 100% during peak hours. What steps would you take? 23. Two transactions update the same row simultaneously. How would you handle concurrency? 24. A table has grown to hundreds of millions of records. How would you improve performance? 25. Would you choose optimistic locking or pessimistic locking for an inventory system? Why? 𝗦𝘆𝘀𝘁𝗲𝗺 𝗗𝗲𝘀𝗶𝗴𝗻 & 𝗔𝗪𝗦: 26. Your API receives 100,000 requests per minute. How would you scale it? 27. Users are abusing your API. How would you implement rate limiting? 28. Your Redis cache crashes unexpectedly. How should your application behave? 29. An EC2 instance needs to access S3 securely. How would you configure it without storing credentials? 30. A deployment causes increased latency. How would you identify the root cause and roll back safely?0,27%
  • 11 мая 2025 г.Data Lake vs Data Warehouse0,14%
  • 9 июн. 2025 г.CGI Interview Questions 1) Introduce Yourself 2) What is Full Stack Development? 3) Difference between GET and POST method 4) Explain OOPs Concepts with Examples 5) What is the difference between SQL and NoSQL? 6) Explain SDLC and Agile Model 7) Describe your Final Year Project 8) Write an SQL query to count employees in each department 9) SQL query to find duplicate records in a table 10) Difference between INNER JOIN and LEFT JOIN 11) SQL query to fetch top 3 highest salaries 12) Write a program to check if a number is a palindrome 13) Write a program to check if two strings are anagrams 14) Find the missing number in a sorted array 15) Implement Stack using Array 16) What is Time and Space Complexity? 17) What are your strengths and weaknesses? 18) Why do you want to join CGI? 19) Are you open to working night shifts or relocating? 20) How do you manage deadlines or pressure?0,06%
  • 30 дек.Accenture interview experiences Lächeln ✨: My Accenture interview question interview slot 2:40 pm. 1 Intro 2 Project discussion 3 your batch(2024) 4 about gap what have you done in this 5 did u do any project in this gap 😕 6 situation based question Last Do you have any question? She asked around 20-23 questions B G V: Accenture Technical Interview Experience Role: ASE (Off-campus) Interviewer: Mr. Kalyan (Team/Project Manager) Date and Time: December 29, 2025, at 4:00 PM slot - The interviewer introduced himself and shared his experience in IT Industry. - Was asked how I was doing and if I had lunch. - He checked if I was using just my laptop for the interview or had another device nearby. - Next was asked to introduce myself, covering my background, academics, projects, and hobbies. - Was asked explain each of my projects in detail. - Asked how many of the projects completed were as a group. - Asked how a team or group should be led. (Team Skills) - Also asked for one positive piece of feedback received on any project. - Asked to share one challenge faced in a project and how it was solved. - Discussed the most favorite and least favorite subjects and why I feel that way about it. - The interviewer gave me feedback on my projects. - Then asked if there any questions from my end. - Answered the questions and gave overall interview feedback0,06%
  • 20 маяHow to tailor your resume to a Job Description (JD) ?? Step 1 — Read the JD carefully Highlight keywords like: Skills mentioned (React, Node, AWS, etc.) Years of experience required Responsibilities listed Step 2 — Match your experience to it For every point in your resume, ask: "Does this relate to what they asked?" Example: JD says: "Build scalable REST APIs" Your resume should say: "Built REST APIs using Node.js handling 10k+ requests/day" Step 3 — Rewrite your bullet points using this formula Action verb + What you did + Result/Impact ❌ Bad: "Worked on backend" ✅ Good: "Developed microservices in Spring Boot, reducing response time by 40%" Step 4 — Put JD keywords naturally in your resume Most companies use ATS (auto-screening software). If your resume doesn't have their exact keywords, it gets rejected before a human even reads it. Step 5 — Sections to focus on Skills — mirror their tech stack exactly Projects — pick projects closest to their domain Experience — rewrite bullets to match their responsibilities Quick checklist before sending: [ ] JD keywords present in resume [ ] Numbers/metrics in every bullet point [ ] Irrelevant experience removed [ ] One page (for freshers) [ ] Same tech stack names as JD (e.g. don't write "JS" if they wrote "JavaScript")0,00%
  • 8 маябез подписи0,00%
  • 8 маябез подписи0,00%
  • 8 маябез подписи0,00%
  • 8 маябез подписи0,00%
  • 7 февр.✅ Top 50 Java Interview Questions ☕ 1. What are the main features of Java? 2. Difference between JDK, JRE, and JVM 3. What is the Java Virtual Machine (JVM)? 4. Explain the concept of Object-Oriented Programming in Java 5. What is the difference between == and .equals()? 6. What are access modifiers in Java? 7. Difference between abstract class and interface 8. What is a constructor? Types of constructors? 9. What is method overloading and overriding? 10. What is the difference between static and non-static methods? 11. What is the final keyword? 12. What is a package in Java? 13. What is the use of this and super keywords? 14. Difference between String, StringBuilder, and StringBuffer 15. What are exceptions? Checked vs unchecked exceptions 16. What is try-catch-finally in Java? 17. What is the difference between throw and throws? 18. Explain multithreading in Java 19. What is synchronization? 20. What is a thread lifecycle? 21. Explain collections in Java 22. Difference between List, Set, and Map 23. What is the difference between ArrayList and LinkedList? 24. What is HashMap? 25. Difference between HashMap and Hashtable 26. What is the hashCode() and equals() contract? 27. Explain generics in Java 28. What is an enum in Java? 29. What is a lambda expression? 30. What is functional interface? 31. What is the Stream API in Java 8? 32. What is Optional in Java 8? 33. What are default and static methods in interfaces? 34. What is garbage collection in Java? 35. What is the finalize() method? 36. What are annotations? 37. What is reflection in Java? 38. What is serialization and deserialization? 39. What is the transient keyword? 40. How does Java handle memory management? 41. What is JDBC in Java? 42. How do you connect to a database in Java? 43. What is the difference between Statement and PreparedStatement? 44. What is a singleton design pattern? 45. What is the factory pattern? 46. What is dependency injection? 47. What is the difference between stack and heap memory? 48. What are inner classes in Java? 49. What are best practices in exception handling? 50. How do you debug a Java application?0,00%