SQL, PPT & Logic Interview Questions
(Part 2 - Q26 to Q100)
1. Q26. What is SQL?
Answer: SQL stands for Structured Query Language and is used to manage data in a
relational database.
2. Q27. What are DDL commands?
Answer: CREATE, ALTER, DROP used to define database schema.
3. Q28. What are DML commands?
Answer: INSERT, UPDATE, DELETE, SELECT used to manipulate data.
4. Q29. What is a primary key?
Answer: A column or combination of columns that uniquely identifies a record.
5. Q30. What is a foreign key?
Answer: A key used to link two tables together.
6. Q31. What is a JOIN?
Answer: JOIN combines rows from two or more tables based on a related column.
7. Q32. Difference between INNER JOIN and LEFT JOIN?
Answer: INNER JOIN returns matching rows only, LEFT JOIN returns all rows from left table
and matching rows from right.
8. Q33. What is GROUP BY used for?
Answer: Groups rows having the same values and is used with aggregate functions.
9. Q34. What is HAVING clause?
Answer: Used to filter groups created by GROUP BY.
10. Q35. What is a subquery?
Answer: A query nested inside another query.
11. Q36. What is normalization?
Answer: Process of organizing data to reduce redundancy and improve integrity.
12. Q37. What is a transaction?
Answer: A sequence of operations performed as a single logical unit of work.
13. Q38. What are ACID properties?
Answer: Atomicity, Consistency, Isolation, Durability - guarantees of database transactions.
14. Q39. What is an index?
Answer: An object that improves the speed of data retrieval operations.
15. Q40. Difference between DELETE and TRUNCATE?
Answer: DELETE removes selected rows, TRUNCATE removes all rows and resets identity.
16. Q41. What is a view?
Answer: A virtual table based on the result of a SELECT query.
17. Q42. What is DISTINCT keyword?
Answer: Removes duplicate rows from result set.
18. Q43. What is a stored procedure?
Answer: Precompiled SQL code that can be executed with parameters.
19. Q44. Difference between UNION and UNION ALL?
Answer: UNION removes duplicates, UNION ALL includes duplicates.
20. Q45. What is SQL injection?
Answer: A code injection technique to exploit SQL queries, prevented by using
parameterized queries.
21. Q46. What is the 6x6 rule in PPT?
Answer: Max 6 words per line and 6 lines per slide.
22. Q47. Best practices for PPT background?
Answer: Keep it simple, use high contrast text.
23. Q48. How to make a presentation engaging?
Answer: Use visuals, keep text minimal, maintain eye contact.
24. Q49. How to handle nervousness during presentation?
Answer: Practice well, breathe slowly, focus on audience not self.
25. Q50. Importance of slide consistency?
Answer: Maintains professional look and avoids distraction.
26. Q51. What is your biggest strength?
Answer: Quick learner, adaptable, or team player (give example).
27. Q52. What is your biggest weakness?
Answer: Mention something minor and how you are improving.
28. Q53. How do you handle deadlines?
Answer: Plan tasks, prioritize, communicate early if delay expected.
29. Q54. How do you work in a team?
Answer: Collaborate, share knowledge, respect others' opinions.
30. Q55. Tell me about a challenge you overcame.
Answer: Use STAR method: Situation, Task, Action, Result.
31. Q56. Why do you want to join Arrow Electronics?
Answer: Good learning opportunities, aligns with career goals.
32. Q57. Where do you see yourself in 5 years?
Answer: Growing in the organization, taking on more responsibility.
33. Q58. How do you handle criticism?
Answer: Listen calmly, improve based on feedback.
34. Q59. Are you willing to relocate or work in shifts?
Answer: Yes, open to opportunities that help my career growth.
35. Q60. Why should we hire you?
Answer: Skills match the role, motivated to learn, quick adaptability.
36. Q61. Difference between hard work and smart work?
Answer: Hard work = putting effort, Smart work = optimizing effort for better results.
37. Q62. Example of multitasking?
Answer: Handled academics and project work together successfully.
38. Q63. Describe yourself in 3 words.
Answer: Eg: Dedicated, Positive, Fast-learner.
39. Q64. Explain your final year project role.
Answer: Gathered requirements, helped with design, testing, and documentation.
40. Q65. What motivates you?
Answer: Learning new skills, achieving goals, contributing to success of team.
41. Q66. Describe a time you worked under pressure.
Answer: Give a STAR example with positive result.
42. Q67. What are your hobbies?
Answer: Reading, learning new tech, or sports (something genuine).
43. Q68. How do you keep learning?
Answer: Online courses, practice projects, reading tech blogs.
