Goa Board Class 12 Question Paper Mar 2018 Web Technology _New Pattern_

2018 III 17 1000 Seat No. :

Time : 2 Hours WEB TECHNOLOGY
(New Pattern)

Subject Code

%

! 
8

Total No. of Questions : 5 (Printed Pages : 3) Maximum Marks : 50
INSTRUCTIONS : I) All questions are compulsory.
II) Figures to 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 for the row wise information in a relational database. [1]
B) What is an entity in a relational database ? [1]
C) Answer the following : [4]
1) Explain the NULL value concept.
2) Explain briefly data independence in a database.
D) Answer the following : [4]
1) Explain the three levels architectural proposal of DBMS, with a
neat diagram.
2) With the help of an E-R diagram, explain the payroll system.
2. A) Name the command/clause that is used to specify the number of records to
display. [1]
B) Write a Mysql query to remove all the rows from the table “product”. [1]
C) Answer the following : [4]
1) Briefly explain the char and varchar data types in Mysql.
2) Explain the update command with an example.
D) Write Mysql queries for the following (any one). [4]
1) Table ‘staff’ consist of the following fields :
Staff_id, Firstname, Lastname, email_id, phoneno
a) List all the records having email account of gmail.
b) Insert another field Date_of_join between Lastname and email_id.
V-317 -1- P.T.O.

c) List Firstname, Lastname and Phoneno of all the Staff who joined
before 31st December 1990.
d) Change the email_id of the staff to “xyz @ rediffmail.com”
whose staff_id = 102.
2) Table ‘Employee’ consist of the following fields Empno, Empname, Salary,
Department and date_of_birth.
a) Change the date_of_birth to “25th December 1980” of employee whose
Empname is ‘Rajesh’.
b) Decrease the salary of the employee by Rs. 1,500 whose Empno is
1001.
c) Display the total salary paid for the employees of each department.
d) Add a new field ‘Designation’ of varchar data type of length 15 before
salary.

3. A) Name the function in Mysql which returns the sign of the argument. [1]
B) Answer the following : [4]
1) What are database triggers ?
2) Explain the following functions with an example.
a) ROUND ()
b) DAYNAME ()
C) Name the operator which concatenate two strings. [1]
D) Answer the following : [4]
1) Explain the switch statement in PHP, with an example.
2) Explain user defined functions in PWP.

4. A) Name the mode to create a new file to write only. If file already exists it
returns false and an error. [1]
B) How is echo statement different from print () ? [1]
C) Answer the following : [4]
1) Explain the file upload command in Php with example.
2) What is the use of ‘Include’ statement in Php and how is it different from
‘Require’ statement ?
D) Answer the following (any one) : [4]
1) Write a Php code to find the sum of the digits and also reverse the given
number.
2) Write a Php code to count the number of words in a given sentence.

V-317 -2-

5. A) With an example, explain Mysql-error () function. [2]
B) Explain the following segments of Php code. [4]
1
1) $q = Mysql _query (Select Designation, Count (*) from Employee group
by Designation);
2) $q2 = Mysql _query ((update mark_tbl set remark = ‘Distinction’ where
total > 385 or percent > = 75);
C) Write the Php code for the following (any one). [4]
1) Write Php code to delete a record from
Database : Customer
Table : Order_tbl
Fields : Order no, Productname, Qty, Price
Accept the orderno from the user.
On pressing DELETE button, delete the record if exist and display the
message ‘Record has been deleted successfully’.
Also display all the remaining records as follows :
Order No. Product Name Qty Price
2) Write a PHP code to retrieve the data from
Database : Commission
Table : Sale_tbl
Fields : Salesman, Date of sale, Salesamount
Calculations :
To calculate commission, the conditions are
If sales amount is greater than equal to 50,000 commission is 6% of
sales amount.
If sales amount is less than 50,000 commission is 4% of sales amount.
Sort the records on salesman and print as report as follows.
Statement of salesman commission.
Salesman Date_of_sale Sales amount Commission

________________

V-317 -3-