CBSE Class 12 Informatics Practices Sample Paper 2015 Set 04

Q- 1 a. Which of the following are open standards? 

    .OGG .DOC .TTF .JPEG

b. Which of the following technologies require line-of site between the transmitter and receiver? 

a) Satellite b) Fiber Optic c) Microwave d) Co-axial Cable

c. Which protocol is used for transfer files over the internet? 

d. Rene is confused as she is unable to find the name of a network of computers and other devices that is confined to

a relatively small space - an office. Help her do that.

e. What is an open standard? Give some examples. 

f. Jai Khanna is confused between the terms Domain Name and URL. Explain the difference with the help of appropriate examples of each. 

g. Write one advantage of star topology over bus topology and one advantage of bus over star topology. 

Q-2 a. What is XML-document system? 

b. What value for X below will print Exactly “Line 20” lines to standard output: 

int count=0;

while(++count<X)

jTextField1.setText(“Line “ + count);

c. What is Inheritance? 

d. Write the full form of XSLT. 

e. What is the difference between the <TD> and <TH> tag? 

f. Give two appropriate reasons of connecting GUI from with a Database. 

g. Write a method fact to take a number as parameter and return the factorial of the number. 

Q-3 a. Sanket wants to implement referential integrity in the tables being created. Which constraint should be used by Sanket while doing so? 

b. Meena uses an EMP table with following columns: 

   NAME, SAL, ID, DNAME

She needs to display names of employees who have not been assigned any department or have been assigned “Pathology”

department. Pathology dept’s names end with “Pathology”. She wrote the following query:

SELECT NAME, SAL

FROM EMP

WHERE DNAME = NULL AND DNAME = “%Pathology”;

c. What are three transaction control statements n MySQL? Give example. 

d. What do you mean by constraints? Explain ENUM and SET constraints. 

e. What do you mean by UNION? Also write the syntax of UNION. 

f. Which command is used in MySQL to make the changes in database permanent? 

Q-4 a. Rewrite the correct code underlining all the corrections made: 

int i; j=5;

i== j+5;

if(i=j)

{ jTextField1.setText(“i and j are unequal”);

jTextField2.setText(“they are not equal”); break;

Please click the below link to access CBSE Class 12 Informatics Practices Sample Paper 2015 Set D