CBSE Class 12 Informatics Practices Question Paper 2014 - Set 2

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.  


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



Click to View or Download pdf file
Click for more Informatics Practices Study Material

Latest NCERT & CBSE News

Read the latest news and announcements from NCERT and CBSE below. Important updates relating to your studies which will help you to keep yourself updated with latest happenings in school level education. Keep yourself updated with all latest news and also read articles from teachers which will help you to improve your studies, increase motivation level and promote faster learning

Keep your kids engaged during Lockdown

Kids are the Future of our Country! Outlines have changed and so should the formats of existence! It is the best time to teach our kids the pleasure of Self-Discipline, Self-Realization and Self-Control. To keep the future generation safe in such unpredictable...

Revised SOP preventive measures followed while conducting examinations

Revised SOP on preventive measures to be followed while conducting examinations to contain spread of COVID-19 issued by Ministry of Health & Family Welfare Examination centres are frequented by large number of students (as well as their parents) and staff till the...

Conduct of the practical work during the lockdown

CBSE has advised schools to follow the Alternative Calendar developed by NCERT to continue education during the lockdown through alternative modes to achieve learning outcomes. Schools have reportedly started using these calendars and other prescribed pedagogical...

Studies Today