Feb 13th, 2014 at 03:01 AM

IDB-BISEW Descriptive Questions on PHP & MYSQL

1. What are the functions used for file upload? 2. What is DNS? 3. Mention five Internet services? 4. Explain the parameters of PHP’s mail function. 5. Why HTTP is called stateless protocol? 6. How many ways session handling can be done? 7. What are web services? 8. What are the benefits of using web services? 9. What is RSS feed? 10. What is data encryption? 11. What is query caching? 12. What is storage engines? 13. What are the advantages of Innodb table? 14. What are the difference between primary key and unique? 15. What are the purposes of GRANT and REVOKE commands? 16. What is the benefit of using prepare statement? 17. What are the advantages of stored routine? 18. What are the benefits of using triggers? 19. What are the advantages of using view? 20. What is cursor? Why is it used? 21. What are the advantages of using indexes? 22. What is transaction? 23. How can you export data in mysql? 24. Difference between before trigger and after trigger? 25. What are the five items of the $_FILES Array? 26. What is the difference between fetch_row () and fetch_array()? 27. What is binding variables? 28. What is the difference between MYISAM and InnoDB engine? 29. What are the functions of --execute and --force option of mysql? 30. What are the purposes of INFORMATION_SCHEMA database? Topics 1. File upload 2. DNS 3. Internet services 4. PHP’s mail function 5. HTTP 6. Session handling 7. Web services 8. RSS feed 9. Data encryption 10. Query caching 11. Storage engines 12. Innodb table 13. Primary key and unique 14. GRANT and REVOKE commands 15. Prepare statement 16. Stored routine 17. Trigger 18. View 19. Cursor 20. Export data in mysql 21. Trigger and after trigger 22. $_FILES Array 23. fetch_row () and fetch_array() 24. Binding variables 25. MYISAM and InnoDB engine 26. --execute and --force option of mysql 27. INFORMATION_SCHEMA database