Goa Board Class 12 Question Paper 2025 Web Technology

2025 II 24 0930 Seat No.

Time : 2 Hours WEB TECHNOLOGY
Subject Code

V 4 3 1 7

Total No. of Questions : 24 (Printed Pages : 4) Maximum Marks : 50

INSTRUCTIONS : (a) All questions are compulsory.

(b) The question paper consists of 24 questions.

(c) Question Nos. 1, 2, 3, 4, 5, 6, 7 and 8 are short answers.

(d) Question Nos. 9, 10, 11, 12, 13, 14, 15, 16, 17, 18 and
19, answer in 2 to 3 sentences.

(e) Question Nos. 20, 21, 22, 23, 24 are long answers.

(f) There is internal choice in Question No. 24.

(g) In questions with choice, only one of the choices is to
be attempted.

1. Name the term used to refer to a collection of related files. 1

2. What is a Tuple ? 1

3. Name the command which is used to eliminate duplicate records in the result
set. 1

4. Construct MySQL query for the following : 1

Table : Student

Fields : Studentid, studentname, mobile, stream, studentaddress.

Display studentname whose stream is Science.

5. Name the function which returns the name of the day for a given date in

MYSQL. 1

6. How do you begin and end a block of PHP code ? 1

7. Name the mode which is used to Write only. Create a new file. returns FALSE

and an error if file already exists. 1

8. What is a parse error in PHP ? 1

9. Classify and explain any two types of Database Users. 2

10. Explain Internal and Conceptual level of DBMS architecture. 2

11. How do you use wildcards in a query ? 2

12. What is the difference between the DELETE and DROP commands ? 2

13. Explain MAX() and NOW() with example. 2

14. Briefly explain View in MYSQL. 2

15. State any two differenes between $_GET and $_POST ? 2

16. Explain require function in PHP. 2

17. With an example explain mysql_connect(). 2

18. Explain the following segment of PHP code 2

$query=mysql_query("select employeename, city from customer where salary

> 10000");

19. Explain the following segment of PHP code 2

$query=mysql_query("alter table std_tbl add column date_of_brith date after

address");

20. Explain briefly the Entity Relationship Model of Library System with a neat

E-R Diagram. 4

21. Construct MySQL queries for the following : 4

Table : Department

Fields : Department_id, Name, Address.

(1) To create above table.

(2) To arrange all records from the above table on name field in

alphabetical order.

(3) To display all the records.

(4) To find how many employees are working in a Department.

22. Explain while loop with example. 4

23. Write PHP code to allow a user to input a number and check if it’s an Armstrong

number. 4

24. Write PHP code to delete a record from the table. 4

Database : Customer

Table : customerinfo

Fields : customerid, name, mobileno, address.

Customerid :

DELETE

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

Customerid Name Mobileno Address

OR

Write a PHP code to calculate interest and total amount on deposits for bank

customers. 4

Database : Customer

Table : Bank

Fields : Custid, name, deposit

Calculations : Interest = Deposit * 12%

Total Amount = Deposit + Interest

Print a report in the following format :

Cust_id Name Deposit Interest Total Amount