Symfony, PHP & SQL Interview Questions
Symfony Interview Questions
1. What is Symfony? How is it different from other PHP frameworks like Laravel?
2. Explain the concept of Bundles in Symfony.
3. What is Dependency Injection? How does Symfony implement it?
4. How do you define and use services in Symfony?
5. What is the purpose of the service container?
6. Explain the Request-Response lifecycle in Symfony.
7. What are Event Listeners and Subscribers in Symfony?
8. How does Symfony handle routing?
9. How do you validate forms and data in Symfony?
10. How do you use Doctrine ORM with Symfony?
11. How do you create and run migrations in Symfony?
12. What is the difference between annotations, YAML, and XML configuration in
Symfony?
13. How do you handle user authentication and authorization in Symfony?
14. What are Symfony environments and how do you manage them?
15. How do you write unit and functional tests in Symfony?
PHP Interview Questions
1. What are the main differences between == and === in PHP?
2. Explain variable scope in PHP.
3. What are Traits and how are they used in PHP?
4. What are namespaces and why are they important?
5. How does error handling work in PHP (try-catch-finally)?
6. What are the differences between include, require, include_once, and require_once?
7. What is the difference between GET and POST methods in PHP?
8. What are magic methods in PHP? List a few with examples.
9. How do sessions and cookies differ?
10. How is object-oriented programming implemented in PHP?
11. Explain the concept of late static binding.
12. What are generators and how do they work in PHP?
13. How do you use Composer in PHP projects?
14. What are PSR standards?
15. How do you perform dependency injection in plain PHP?
SQL Interview Questions & Queries
1. Write a query to find the second highest salary from a 'employees' table.
2. How do you retrieve duplicate records from a table?
3. Write a SQL query to find employees who joined in the last 30 days.
4. Explain different types of JOINs with examples.
5. Write a query to count the number of employees in each department.
6. What is a subquery? Give an example.
7. How do you update data in one table based on another table?
8. How do you find the highest salary in each department?
9. What is normalization? Explain 1NF, 2NF, 3NF.
10. What is indexing and how does it affect performance?
11. How do transactions work in SQL? What are ACID properties?
12. What is a window function? Give an example using RANK() or ROW_NUMBER().
13. How do you delete duplicate rows while keeping one?
14. What is the difference between WHERE and HAVING clauses?
15. What is a stored procedure? How do you create one?
