Goa Board Class 12 Question Paper June 2019 Web Technology

2019 VI 13 1430 Seat No.

Time : 2 Hours WEB TECHNOLOGY

Subject Code

V 3 1 7

Total No. Of Questions : 5 (Printed Pages : 6) Maximum Marks : 50

INSTRUCTION : (i) All questions are compulsory.

(ii) Figures to the right indicate full marks.

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

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

(v) Q. No. 3C, 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 refer to the collection of all related record. 1

(B) What is a tuple ? 1

(C) Answer the following : 4

(i) Explain normalization in designing of a database.

(ii) Explain any two policies framed to protect data in a database.

[V-317] 1 P.T.O.

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

(i) State and explain any four advantages of DBMS.

(ii) Explain the entity relationship model of Library System with a

neat E-R diagram.

2. (A) Name the command which is used to remove an existing table. 1

(B) Construct MYSQL query for the following : 1

To display the names of different cities by eliminating the duplicate records,

from employee table.

(C) Answer the following : 4

(i) Explain Group by clause with an example.

(ii) With an example explain join command.

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

(a) Construct Mysql queries for the following :

Table : Employee

Fields : Empid, name, designation, date of birth, city, salary

(i) Display name and date of birth of all the employees who are

born in “January”.

[V-317] 2

(ii) To increase the salary of employees by 2000 only if salary less

than 20000.

(iii) Display name and city of employees, if the designation of the

employee is either a Programmer or Operator.

(iv) To add another field as Gender of the data type character and

size 6.

(b) Table : Inventory

Fields : Itemid, Item_name, price, qty

(i) To arrange the records as per price in descending order.

(ii) Display Itemid, Item_name of all items where quantity is

between 5 to 10.

(iii) To remove the records where item_name is “Transistor”.

(iv) Display name of all items whose price is greater than 10000.

3. (A) Name the function which finds total number of characters in a given

string. 1

(B) Answer the following : 4

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

(ii) Explain any four aggregate functions.

[V-317] 3 P.T.O.

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

(D) Answer the following : 4

(i) Explain User Defined Function with an example.

(ii) With an example explain Array_push( ).

4. (A) Name the mode which is used to write only. Opens and clears the content

of file or creates new file if it doesn’t exist. 1

(B) What is the use of file upload ? 1

(C) Answer the following : 4

(i) State any two difference between $_Get( ) and $_Post( ).

(ii) Explain in brief PHP session.

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

(i) Write a PHP code to print 10 numbers in Fibonacci series.

(ii) Write PHP code to print occurrence of each vowel in a given

sentence.

5. (A) Explain Mysql_connect( ) with an example. 2

[V-317] 4

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

(i) $sql = mysql_query (‘‘select name, city from employee where state

like “ __ __ __”);

(ii) $result = mysql_query (‘‘select rollid, name from student

limit 2, 2”);

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

(i) Write a PHP code to delete a record using student_id

Database : Student

Table : Std_table

Fields : Student_id, name, address, gender

Student Id :

DELETE

After deleting record print a report in the format given below :

Student Id Name Address Gender

[V-317] 5 P.T.O.

(ii) Write the PHP code to calculate gross salary paid to the employees.

Database : Employee

Table : Emp_table

Fields : Empid, name, Basic salary

Calculations :

DA = 30% of Basic salary

HRA = 15% of Basic slary

TA = 10% of Basic salary

Gross = Basic salary + DA + HRA + TA

Print a report as follows :

Salary Report

Empid Name Basic salary DA HRA TA Gross salary

[V-317] 6