Goa Board Class 12 Question Paper Mar 2019 Web Technology _CWSN_

2019 III 14 1000 Seat No.

Time : 2 Hours Web Technology (CWSN)

Subject Code

V 3 2 0

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

INSTRUCTIONS : (i) All the questions are compulsory.

(ii) Answer each question on a fresh page.

(iii) Write question and sub-questions number clearly.

(iv) Figures to the right indicate full marks.

1. (A) Fill in the blanks by choosing the appropriate words from the
choices : 5

(i) The term used for row-wise information in relational database
is ........................ .

(file, attributes, tuple, data)

(ii) The command used to prevent duplicate records is .................. .

(Insert, distinct, list, alter,)

(iii) The clause used to soft the result of a query is ...................... .

(where, order by, sort, group by)

(iv) The function used to display name of weekday is ................... .

(nameday( ), dayname( ), weekday( ), date( ))

(v) The characters used to give a Single line comment in PHP
are ............................ .

(<!, /*, //, >>)

V-320 1 P.T.O.

(B) Match the following : 5

(i) Select (a) or operator

(ii) Super key (b) extracts data records

(iii) || (c) displays records

(iv) Update (d) identifies combined values uniquely

(v) Mysql_fetch_array( ) (e) modifies a record

(C) State whether the following are true or false : 5

(i) Record is a collection of related files.

(ii) Varchar are fixed length data types.

(iii) Count( ) displays the total number of records from a table.

(iv) ! = is an equality operator.

(v) < ? is the closing PHP tag.

(D) Answer the following in a word or phrase : 5

(i) Name the term used to represent a collection of all possible

values.

(ii) Name the mysql command to remove a record in Mysql.

(iii) Name the term used to represent a missing value.

(iv) Name the special character which is used to declare variables

in PHP.

(v) Name the mode used to open and write at the end of the file.

V-320 2

2. Answer the following questions in one sentence each : 10

(i) What is a database ?

(ii) Define foreign key.

(iii) State entity integrity rule.

(iv) What is a view in database ?

(v) What is the use of join command ?

(vi) What are global variables ?

(vii) What are triggers ?

(viii) Give the full form of PHP.

(ix) Mention the use of switch statement.

(x) What does R mode do in PHP ?

3. Answer the following in brief (any 10) : 20

(i) State and explain any two types of DBMS users.

(ii) Explain in brief the data independence in database.

(iii) Explain any two disadvantages of DBMS.

(iv) Explain any two data types in mysql.

(v) Explain the two wildcards in mysql.

(vi) With an example explain between clause.

(vii) Explain now( ) and sign( ) in mysql.

(viii) Explain while loop in PHP.

(ix) State any two differences between $_GET and $_POST.

V-320 3 P.T.O.

(x) Write php code to add two numbers and print their sum.

(xi) Explain fopen( ) in PHP with an example.

(xii) Explain the following segment of PHP code :

$y = mysql_query(“insert into emp values (“10l”, “Raj Malhotra”,

“01-10-1999”);

(xiii) Explain with an example mysql_select_db( ).

(xiv) Write PHP code to design the following form :

Employee Id :

Name :

Date of Birth :

City :

SUBMIT

V-320 4