Domanda di colloquio di Cognizant

Explain the SDLC process. Which phases have you worked on? How do you approach debugging a complex codebase? What is the difference between a JOIN and a UNION in SQL? How would you optimize a slow-running SQL query? Have you worked with APIs? Can you explain how REST APIs work?