CBSE Question Paper 2018 class 12 Informatics Practices

CBSE Question Paper 2018 class 12 Informatics Practices conducted by Central Board of Secondary Education, New Delhi in the month of March 2018. CBSE previous year question papers with solution are available in myCBSEguide mobile app and cbse guide website. The Best CBSE App for students and teachers is myCBSEguide which provides complete study material and practice papers to cbse schools in India and abroad.

CBSE Question Paper 2018 class 12 Informatics Practices

Download as PDF

Last Year Question Paper Class 12 Informatics Practices 2018

Time allowed : 3 hours
Maximum Marks: 70

Instructions :

1. All questions are compulsory.
2. Answer the questions after carefully reading the text.

---

1. 1. ABC Company wants to link its computers in Head office in New Delhi to its office in Sydney. Name the type of Network that will be formed. Which communication media should be used to form this Network? (2)
      Ans.Type of network that will be formed: Wide Area Network(WAN) Transmission media to be used: Satellite
   2. Which of the following is/are not communication media? (2)
      1. Microwaves
      2. Optical Fiber cable
      3. Node
      4. Radio waves
         Identify which of the above-mentioned communication media are Wired media and which ones are Wireless media.

      Ans. Not communication media: Node
      Wired media: Optical Fiber cable
      Wireless media: Microwaves, Radio waves

   3. Write two examples each of software in the following categories: (2)
      1. Open Source Operating System
      2. Open Source Web Browser

      Ans.

      1. Linux, Android, FreeBSD, OpenBSD, NetBSD, DragonFly BSD, OpenSolaris, illumos, AuroraUX, Darwin, OpenDarwin, MINIX, FreeRTOS, FreeDOS, Haiku, House KolibriOS, MenuetOS, GNU, ReactOS, L4, Fiasco, Pistachio, Plan 9, AROS, Syllable, Inferno, NuttX, eCos, RTEMS, HelenOS, E/OS, TempleOS, Linux, BOSS, Ubuntu, Kali Linux
      2. Mozilla Firefox, Google Chrome, Opera, QupZilla, Midori, rekonq, Tor Browser, NetSurf, Pale Moon, GNOME Web
   4. Expand the following terms : (2)
      1. GSM
      2. IP

      Ans.

      1. GSM – Global System for Mobile Communications/ Global System for Mobile/ Graphics Stimulator Media
      2. IP – Internet Protocol
   5. Name the devices: (2)
      1. This device constantly looks at all the data entering and exiting your connection. It can block or reject data in response to an established rule.
      2. This device connects multiple nodes to form a network. It redirects the received information only to the intended node(s).

      Ans.

      1. Firewall
      2. Switch
   1. Identify the invalid variable names. State the reason if invalid. (1)
      1. Marks Unit
      2. Product_1
      3. Sales123
      4. 2Marks

      Ans. Invalid variable names are :

      1. Marks Unit
         Reason: Variable Name should not contain space
      2. 2Marks
         Reason: Variable Name should not start with digit
   2. Write the data type of variables that should be used to store: (1)
      1. Marks of students
      2. Grades of students(Grade can be ‘A’ or ‘B’ or ‘C’)

      Ans.

      1. float/ double /int / byte / short / long
      2. char
   3. Write examples of any two properties and any two methods of jButton component (2)
      Ans. Properties of JButton component :
      Background, font, label, text, name, editable, enabled, horizontal alignment, border
      Methods of JButton component :
      setText(), getText(), setEnabled(), setVisible(), setEditable(), setVisible(), isSelected(), setSelected()
   4. Write the purpose of HTML. Distinguish between <P> and <BR> tag. (2)
      Ans. HTML is used to create web page(s).
      <P> tag is used to introduce a paragraph while <BR> tag is used to introduce a line break on a web page.
      Note: <P> as paragraph tag and <BR> as line break tag to be accepted as difference
   5. Distinguish between ComboBox and ListBox. When would you prefer using them over Radiobutton and Checkbox? (2)
      Ans. A ComboBox allows selection of one item from a set of items.
      while ListBox provides a scrollable set of items from which one or more item(s) may be selected.
      When the number of items are more Combobox or ListBox would be preferred over Radiobutton and Checkbox.
   6. Rewrite the following code using switch statement: (2)
      if ( code == ‘A’)
      allowance = 3500;
      else if ( code == ‘B’)
      allowance = 3200 ;
      else
      allowance = 2000 ;
      Ans. switch(code)
      {
      case ‘A’ : allowance = 3500;
      break ;
      case ‘B’ : allowance = 3200;
      break ;
      default : allowance = 2000;
      }
   1. What is MySQL used for? Abhay wants to start learning MySQL. From where can he obtain the MySQL software ? (1)
      Ans.
      1. MySQL is an open source RDBMS used for managing databases.
      2. For obtaining MySQL, Abhay has the following options :
         • download from the website mysql.org
         • downloads it from any website that offers MySQL.
         • get the software from any source
   2. In the table “Student”, Priya wanted to increase the Marks(Column Name: Marks) of those students by 5 who have got Marks below 33. She has entered the following statement: (1)
      SELECT Marks+5 FROM Student WHERE Marks<33;
      Identify errors (if any) in the above statement. Rewrite the correct SQL statement.
      Ans. Error: UPDATE should be used instead of SELECT
      Correct SQL statement:
      UPDATE Student SET Marks= Marks+5
      WHERE Marks<33;
      1. Name the Data type that should be used to store AccountCodes like “A1001” of Customers.
      2. Name two Data types that require data to be enclosed in quotes. (2)
   3. Ans.
      1. char/ varchar
      2. char/ varchar/ date
   4. Given the table ‘Player’ with the following columns : (2)
      Table: Player

      PCODE	POINTS
      1	50
      2	NULL
      3	40

      Write the output of the following statements:

      1. SELECT AVG(POINTS)
         FROM Player;
      2. Select COUNT(POINTS) FROM Player;

      Ans.

      1. 
      2. 
   5. ​‘Class’ table has columns RNO and NAME.
      The following statements are executed:
      SET AUTOCOMMIT = 0;
      INSERT INTO CLASS VALUES (5,‘Rajiv’);
      COMMIT;
      UPDATE CLASS SET NAME = ‘Rajeev’ WHERE ID = 5;
      SAVEPOINT A;
      INSERT INTO CLASS VALUES (6,‘Chris’);
      SAVEPOINT B;
      INSERT INTO CLASS VALUES (7,‘Feroze’);
      SELECT * FROM CLASS;
      ROLLBACK TO B;
      SELECT * FROM CLASS;
      What will be the output of both the above given SELECT statements? (2)
      Ans. (Case 1: If RNO is treated as ID, the following solution should be accepted:)
      Output of SELECT statement 1 :

      RNO	NAME
      5	Rajeev
      6	Chris
      7	Feroze

      Output of SELECT statement 2 :

      RNO	NAME
      5	Rajeev
      6	Chris

      (Case 2: If RNO is NOT treated as ID, the following should be accepted:)
      Output of SELECT statement 1 :

      RNO	NAME
      5	Rajeev
      6	Chris
      7	Feroze

      Output of SELECT statement 2 :

      RNO	NAME
      5	Rajeev
      6	Chris

      Case 1 and 2 : ( 2 marks for output of any one of the SELECT statement)

   6. Name SQL Single Row functions (for each of the following) that (2)
      1. returns a number.
      2. returns lowercase letters.
      3. returns names of days. For example: “Monday “, “Tuesday”.
      4. returns weekday number. For example 1 for Sunday, 2 for Monday, 3 for Tuesday.

      Ans.

      1. length()/ instr()/ round()/ truncate() or any other correct Single Row Function that returns a number
      2. lower() / lcase()
      3. dayname()
      4. dayofweek()

These are first 3 questions only. To view and download complete question paper with solution install myCBSEguide App from google play store or log in to our student dashboard.

Download myCBSEguide App

CBSE Question Paper 2018 class 12 Informatics Practices

Download class 12 Informatics Practices question paper with solution from best CBSE App the myCBSEguide. CBSE class 12 Informatics Practices question paper 2018 in PDF format with solution will help you to understand the latest question paper pattern and marking scheme of the CBSE board examination. You will get to know the difficulty level of the question paper.

Previous Year Question Paper for class 12 in PDF

CBSE question papers 2018, 2017, 2016, 2015, 2014, 2013, 2012, 2011, 2010, 2009, 2008, 2007, 2006, 2005 and so on for all the subjects are available under this download link. Practicing real question paper certainly helps students to get confidence and improve performance in weak areas.

• Physics
• Chemistry
• Mathematics
• Biology
• Accountancy
• Business Studies
• Economics
• History
• Geography
• Political Science
• Physical Education
• Computer Science
• Informatics Practices
• English Core
• Hindi Core
• Hindi Elective
• Other Subjects

To download CBSE Question Paper class 12 Accountancy, Chemistry, Physics, History, Political Science, Economics, Geography, Computer Science, Home Science, Accountancy, Business Studies and Home Science; do check myCBSEguide app or website. myCBSEguide provides sample papers with solution, test papers for chapter-wise practice, NCERT solutions, NCERT Exemplar solutions, quick revision notes for ready reference, CBSE guess papers and CBSE important question papers. Sample Paper all are made available through the best app for CBSE students and myCBSEguide website.