CBSE Class 12 Informatics Practices Question Paper 2014 Set 02

CBSE Class 12 Informatics Practices Question Paper 2014 - Set 2 CBSE,CCE and NCERT students can refer to the attached file. All educational material on the website has been prepared by the best teachers having more than 20 years of teaching experience in various schools. The study material available on our website for all CBSE classes and subjects have been prepared by teachers from all over the country. All study material has been carefully designed keeping into mind the latest CBSE examination trends.  

INFORMATICS PRACTICES

Instructions :

(i) All questions are compulsory.

(ii) Answer the questions after carefully reading the text.

1. (a) Why is a switch called an intelligent hub ? 1

(b) What was the objective behind developing UNICODE ? 1

(c) Expand the following terms : 1

(i) OSS

(ii) ODF

(d) What is the use of Repeater in a Network ?

(e) Identify the following device : 2

(i) A device that is used to connect different types of networks. It performs the necessary translation so that the connected networks can communicate properly.

(ii) A device that converts data from digital bit stream into an analog signal and vice versa.

(f) Write one advantage and one disadvantage of using Optical fibre cable. 2

(g) Distinguish between Open Source Software and Proprietary Software. 2

2. (a) Is a string containing a single character same as a char ? 1

(b) Write a statement in Java to declare a String type variable with a name City. 1

(c) Distinguish between ‘/ ’ and ‘ %’ operators. 1

(d) Which tag/attributes of HTML are used to 1

(i) Insert a picture in the web page.

(ii) Insert an empty line in the web page.

3. (a) Distinguish between ALTER TABLE and UPDATE commands of MySQL. 1

(b) Mention two categories in which MySQL commands are broadly classified. 1

(c) Give two characteristics of Primary Key. 1

(d) A table FUNFOOD has 13 rows and 17 columns. What is the cardinality and degree of this table ? 1

(e) A numeric column MONEY contains 34567.7896. Write a command to truncate MONEY 2

(i) Up to 2 decimal places. (i.e. expected result 34567.78)

(ii) Up to -3 places. (i.e. expected result 34000)

(f) What happens when ‘‘ROLLBACK’’ command is issued in a transaction process ? 2

(g) Shanya Khanna is using a table Employee. It has the following columns. 2

Admno,Name,Agg,Stream [column Agg contains Aggregate marks] She wants to display highest Agg obtained in each Stream.

She wrote the following statement : SELECT Stream, MAX(Agg) FROM Employee; But she did not get the desired result. Rewrite the above query with necessary changes to help her get the desired output.

Please refer to the link below for CBSE Class 12 Informatics Practices Question Paper 2014 - Set 2