CBSE Class 12 Informatics Practices Sample Paper 2013 Set 01

1. a) Mrs. Geetha is surfing over internet and he wants to know the IP Address of particular website.Do you know which process he has to do to obtain IP Address from website’s name? 

b) Mr. Loknath wants to send/receive e-mail over TCP/IP networks(internet).Which protocol he can use for this purpose? 

c) An Internet Service Provider has a network within a city area.Which type of network is it? 

d) Which transmission technology can we use for connecting two countries over an ocean? 

e) Differentiate between HUB and SWITCH devices. 

f) Explain following terms. 

(1) Apache Server (2) Linux

g) What is Font ?Which are two parameters for to categorized them? 

2. (a) While working with Netbeans, Ashita included a TextArea control which contains a list of students. What code she should write to add one more student name at the end of the TextArea? 

(b) In what sequence the initialization, testing and execution of body is done in a for loop.

(c) Write HTML code to produce a Textarea with 10 rows and 30 columns. 

(d) What do you mean by web browser? 

(e) How many times does the following loop execute? What is its type (Entry controlled or Exit controlled ) ? 

int x=2,y=20;

while( x < = y)

{

JOptionPane.showMessageDialog(null, “ “ + x);

}

(f) Write a function in java that takes an integer number as parameter and returns its sum of digits. 

(g) Which tag is used to specify :

a. Table data

b. Table header

c. Table row

d. Table border

3. a) Raju wants to change the schema of the table “ STUDENT ” which already exists in the database. Which command he will use. 

b) Neha is not able to enter the details of students born after ‘ 30-Mar-2007’. Which

constraint might be specified when the table was created. 

c) What is the purpose of the following query. 

SELECT COUNT(*) FROM ELECTION GROUP BY city.

d) What is the role of UNIQUE constraint? How is PRIMARY KEY constraint

differ from UNIQUE key constraint. 

e) What is the significant of ORDER BY command in SQL query.

Please refer to attached file for CBSE Class 12 Informatics Practices Sample Paper 2013 Set A