CBSE Class 12 Informatics Practice Question Paper 2015 Delhi with Answers

CBSE Class 12 Informatics Practice Question Paper 2015 Delhi with Answers. Students can download the last year question papers using the link below. Free download of examination question papers with solutions. Last 10 year question papers should be practised to get better marks in examinations.

1. (a) A company has 3 departments namely Administrative, Sales, Production. Out of telephone cable, Optical Fiber, Ethernet Cable, which communication medium is best for high speed communication between departments ?

(b) Name one open source Indian operating system.

(c) What is the purpose of a Server in a network ?

(d) What do the following top level domains signify ?

(i) .com

(ii) .org

(e) List 2 measures to secure a network.

(f) Distinguish between MAC address and IP address with the help of example of each.

(g) Distinguish between Phonetic text entry and keymap based entry of typing Indian language text.

Candidates must write the Code on the title page of the answer-book.

2. (a) Write the value of t after the execution of the following code :

int t;

int s;

s=6;

t = (8 * s++) % 7;

(b) Which tag is used to display a horizontal rule on a web page ?

(c) In a SWITCH statement, what is the purpose of BREAK statements ?

(d) Identify the error in the following HTML code. Rewrite the correct code.

<UL TYPE = “a” START = 4>

(e) Write Java code to assign the value 70 to variable y. Then decrease the value of y by 5 and store it in variable z.

(f) Write the output that will be generated by the code given below :

int i;

int t;

for (i = 5; i <=10; i = i+5)

{

t = i+3;

system.out.println(“ ”+t);

}

(g) “With XML you invent your own tags.” Explain this statement with the help of example.

3. (a) Sharmila wants to make the database named ‘COMPANY’ active and display the names of all the tables in it. Write MySQL commands for it.

(b) Write SQL command to remove column named ‘Hobbies’ from a table named ‘Student’.

(c) Rewrite the following SQL statement after correcting error(s). Underline the corrections made.

INSERT IN EMP(EMPNO, SALES) VALUE (100, 20078.50);

(d) A table STUDENT has 5 rows and 3 columns. Table ACTIVITY has 4 rows and 2 columns. What will be the cardinality and degree of the Cartesian product of them ?

(e) Name the SQL commands used to :

(i) Physically delete a table from the database.

(ii) Display the structure of a table.

(f) Write one similarity and one difference between UNIQUE and PRIMARY KEY constraints. 

(g) What effect does SET AUTOCOMMIT have in transactions ? 

Please click the link below to download pdf file of CBSE Class 12 Informatics Practice Question Paper 2015 Delhi with Answers.