1
LOYOLA COLLEGE (AUTONOMOUS), CHENNAI 600 034
B.SC. B.C.A.DEGREE EXAMINATION -COMPUTER SCIENCE &APPLICATIONS
SIXTH SEMESTER APRIL 2018
CS CA 6609- WEB PROGRAMMING WITH PHP MYSQL THEORY
Date: 19-04-2018 Dept. No. Max. 100 Marks
Time: 01:00-04:00
PART A
Answer the questions (10 x 2 20 Marks)
1. State the features of PHP.
2. What is the use of switch statement?
3. Define Cookies.
4. Give the syntax to insert rows in tables.
5. Define arrays in PHP.
6. What are the three level of database architecture?
7. What is subquery?
8. What are set operators?
9. Give the use of MYSQL commands in PHP.
10. Write any two aggregate function?
PART B
Answer ALL the questions x 8 40 Marks)
11. a. Write a PHP script arithmetic and logical operators.

b. State the difference between break and continue.
12. a. Explain the array functions in PHP.

b. Write a note on sessions.
13. a. Write a note on functional dependency.

b. Explain in detail about components and benefits of database.
14. a. Discuss about insert, update and delete of rows in tables.

b. Discuss about data types in My SQL.
15. a. Explain formatting query output using date and time functions.

b. Explain file handling in PHP.
2
PART C
Answer any TWO questions x 20 40 Marks)
16. a. Discuss in detail about control structures with suitable example.
b. Explain user defined functions in PHP.
17. a. Explain in detail about normal forms
b. Discuss about creating and manipulating tables.
18. a. Explain about handling errors in PHP
b.Explain about joining tables in PHP.