CBSE Class 12 Informatics Practices Question Paper 2014 - Set 2

Scroll down for PDF

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 on the text For more study material for Informatics Practices please click here - Informatics Practices

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

CBSE to launch 'Tamanna' aptitude test

Introduction: The poor decisive condition of students to pursue their subject of interest has been an area of concern. To the ease of which CBSE is to launch ‘Tamanna’. An aptitude test in order to provide a line of guidance to students of class 9th and 10th. What is '...

CBSE examination board hike the fee for class 10th and 12th

The CBSE (Central Board Secondary Education) increased the examination fees for classes 10 and 12 of the 2020 boards, with no profit no loss principle, from Rs. 750 to Rs 1500, for all categories of students, including SC/ST candidates for all schools throughout India...

Registration of NEET 2020 starts

The NEET 2020 registration process would start on Monday, December 2nd, 2019. National Testing Agency, NTA would carry out the county’s undergraduate entrance exam for medical and dental admissions.  The examination is scheduled to take place in English, Hindi, and...

JEE in Punjabi too after English, Hindi and Gujarati

Punjab Minister Tript Rajinder Singh Bajwa requested the joint technology entrance exam (main) to be conducted in Punjabi and other regional languages too. In his letter to Union HRD Minister Ramesh Pokhriyal Nishank, the Punjab Minister for Higher Education and...

CBSE Board Secretary says Class 10 and 12 CBSE Exam Pattern to be modified

The Central Board of Secondary Education is expected to introduce a few changes to the exam pattern for class 10 and board exams by 2023. Anurag Tripathi, secretary of CBSE speaking at an Assoham School Education Summit said that although this year class 10 students...

Studies Today