PHP & MySQL(Mid sem exam questions)

ASSIGNMENT-1(MID SEM QUESTIONS)


                                                PHP


1. What is open source? Write down the advantages of it.
2.  Write down the rules of php syntax.
3.  Explain constant and variables in php.
4.  Explain integration of html code inside php script with example.
5.  Write down the method used for passing variables between pages and explain all with example.
6.  Explain use of following functions
     a)  rand
     b)  ceil
     c)  floor
     d)  number_format
     e)  max
     f)   min
     g)  print
     h)  print_r
     i)   sort
     j)   asort
     k)  rsort
     l)   arsort
7.  Explain the concept of include file for efficient code.
8.  Explain foreach construct with example.
9.  Compare session and cookie.
10. Write down disadvantages of passing variables using URL.
11. Explain use of heredoc as an alternative to  echo statement.

                                             MySQL

12. Explain different features provided by InnoDB storage engine.
13. Explain advantages of transactional table over non-transactional table and vice-versa.
14. List out different table format provided by MySQL.
15. Explain different datatype in MySQL.