Goa Board Class 12 Question Paper Mar 2019 Web Technology

2019 III 14 1000 Seat No.

Time : 2 Hours WEB TECHNOLOGY
Subject Code

V 3 1 7
Total No. of Questions : 5 (Printed Pages : 5) Maximum Marks : 50

INSTRUCTIONS : (i) All questions are compulsory.

(ii) Figures to the right indicate full marks.

(iii) Q. No. 1 is based on Database concept.

(iv) Q. No. 2 and Q. No. 3 A, B are based on MYSQL.

(v) Q. No. 3 C, D and Q. No. 4 are based on PHP.

(vi) Q. No. 5 is based on MYSQL and PHP connectivity.

1. (A) Name the term used to define a collection of related files. 1

(B) What is normalization ? 1

(C) Answer the following : 4

(i) Mention any four characteristics of a DBMS.

(ii) Explain entity integrity rule.

(D) Answer the following (any one) : 4

(i) Classify and explains the different types of DBMS users.

(ii) Explain briefly entity relatonship model of school admission

system with a neat E-R diagram.

2. (A) Name the command that changes or modifies data values in a table. 1

(B) Construct Mysql query for the following : 1

Table : Employees;

Fields : Empid, Name, Designation

To display empid, Name and designation of the employees where the

designation is either ‘Programmer’ or ‘Operator’.

(C) Answer the following : 4

(i) With an example explain how records are sorted in descending

order.

(ii) Explain the use of group by clause with an example.

(D) Answer the following (any one) : 4

(i) Construct Mysql queries for the following :

Table : Student

Fields : Roll No, Name, Address, State

(a) To add a new field ‘date of birth’ after State field.

(b) To view total number of records present in the table.

(c) To change the name of the state from ‘Madras’ to ‘Chennai’.

(d) To display the names of different states present in the table.

(ii) Construct Mysql queries for the following :

Table : Commission_table

Fields : Sales_id, name, contact, amount of sale, commission

(a) To display maximum and minimum salary earned by
salesman.

(b) To remove contact field from the table.

(c) To change name of the table from commission to com_table.

(d) To display all records where commission earned is more
than 5000.

3. (A) Name the function which displays date and time. 1

(B) Answer the following : 4

(i) State any two differences between view and table.

(ii) Explain union operator with an example.

(C) What is the full form of PHP ? 1

(D) Answer the following : 4

(i) Explain while loop with an example.

(ii) With an example explain for each loop.

4. (A) Name the mode which append, open and write to the end of the file
or creates a new file if it does not exist. 1

(B) State any one difference between $_Get() and $_Post() command. 1

(C) Answer the following : 4

(i) Explain the use of file upload command with an example.

(ii) Explain briefly PHP session variable.

(D) Answer the following (any one) : 4

(i) Write a PHP code to print total number of vowels in a given
sentence.

(ii) Write a PHP code to print prime numbers between the range
of 2 to 50 numbers.

5. (A) Explain with an example the use of mysql-fetch-array(). 2

(B) Explain the following segment of PHP code. 4

(i) $sql = Mysql_query (‘‘Delete from stock_table where item_id =

101 and price > 500’’);

(ii) $result = Mysql_query (‘‘Select * from product_table where price

between 1000 and 2000’’);

(C) Answer the following (any one) : 4

(i) Write a PHP code to calculate interest and total amount on

deposits for bank customers.

Database : Customer

Table : Bank

Fields : Custid, name, deposit

Calculations :

Interest = Deposit * 6%

Total Amount = Deposit + Interest

Print a report in the following format :

Cust_id Name Deposit Interest Total Amount

(ii) Write a PHP code to add records to a table in the following
format :

Database : Employee

Table : Emp_table

Fields : Empid, Name, Address, City, State

Empid :

Name :

Address :

City :

State :

ADD RECORD

Also print a report in the format given below :

Empid Name Address City State