- PHP/MYSQL/LARAVEL Interview Questions

        

    

1. Why we use htaccess?

2. What is the difference between index, primary, and unique keys?

3. Difference between the index and index key?

4. What is the foreign key why used it?

5. Difference between array() and [] in php?

6. Why we use Abstract classes and interface in oops?

7. Can we search MySQL records by concat alias name when concat 2 values?

8. Is it necessary to make all methods abstract in abstract classes?

9. Difference between interface and abstract classes?

10. What are design patterns?

11. Difference between array_search and in_array in PHP? 

12. Difference between array_merge and array_combine in PHP? if we define a duplicate key in array _merge than what it will return?

13. When we use any class and declare construct and a magic method, which method is called the first construct method or magic method?

14. What is abstract class why we use this?

15. What is inheritance? Please give an example?

16. Define hooks and their types?

17. Why we use array_unique?

18. What do u understand by interface why we use it?

19. How to set database settings in laravel?

20. How to use multiple databases in a single laravel application?

21. How to use multiple languages in laravel?

22. Why we use collation in MySQL.

23. What are web services? how can we use it in laravel?

24. What is the Mysql engines? which is better MyISAM or InnoDB?

25. How we can define logs in laravel?

26. What is array_flip?

27. Difference between array_shift and array_unshift?

28. how to export XML DB in MySQL?

29. What is middleware in laravel? Please give 1 example.

30. How can we run migrations in laravel?

31. What are seeders in laravel and how can we use it?

32. How can we write test cases in laravel?

33. What are the triggers in MySQL?

34. What is the store procedure in MySQL?

35. how to know the site is in HTML or HTML 5?

36. What is the difference between include_once & Require_once? which one is better?

37. Difference between max_execution_time and max input time?

38. What are the commands and how can we use it in laravel?

39. Describe the Laravel Structure?

40. How to use Repositories in Laravel for Create APIs?

41. How to create helpers and use them in laravel?

42. Please describe endpoints used in Laravel APIs for delete and view records?

43. How to setup Supervisor in Laravel?

44. How to use queues in laravel?