CBSE Question Paper 2015 class 12 Informatics Practices

myCBSEguide App

myCBSEguide App

Complete Guide for CBSE Students

NCERT Solutions, NCERT Exemplars, Revison Notes, Free Videos, CBSE Papers, MCQ Tests & more.

Download Now

 

CBSE Question Paper 2015 class 12 Informatics Practices conducted by Central Board of Secondary Education, New Delhi in the month of March 2015. 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 2015 class 12 Informatics Practices

Download as PDF

CBSE Question Paper 2015 class 12 Informatics Practices

General Instructions:

  • All Questions are compulsory.
  • This Question Paper contains 7 Questions.

1 (a) A company has 3 departments namely Administrative, Sales, Product on. Out of telephone cable, Optical Fiber, Ethernet Cable, which communication medium is best for speed communication between departments? (1)

(b) Name one open Source Indian Operating System. (1)

OR

Bharat Operating Systems Solutions

(c) What is the purpose of a Server in a network? (1)

(d) What do the following top-level domains signify? (1)
(i) .com
(ii) .org

(e) List 2 measures to secure a network. (2)

(f) Distinguish between MAC address and IP address with the help of example of each. (2)
(g) Distinguish between Phonetic text entry and keymap based entry of typing Indian language text. (2)

2 (a) Write the value of t after the execution of the following code: (1)
int t; int s; s=6;
t = (8 * s++) % 7;  1
(b) Which tag is used to display a horizontal rule on a web page? (1)

(c) In a SWITCH statement, what is the purpose of BREAK statements? (1)
(d) Identify the error in the following HTML code. Rewrite the correct code. (1)
<UL TYPE = ”a“ START = 4>

(e) Write Java code to assign the value 70 to variable y. Then decrease the value of y by 5 and store it in variable z. (2)
(f) Write the output that will be generated by the code given below: (2)
int t;
int i;
for (i = 5; i <=10; i = i+5)
{
t = i+3;
System. out. Print ln(” ”+t);  2
}

(g) With XML you invent your own tags. “Explain this statement with the help of example. (2)

3 (a) Sharmila wants to make the database named ’COMPANY’ active and display the names of all the tables in it. Write MySQL commands for it. (1)

(b) Write SQL command to remove column named hobbies from a table named ‘Student’. (1)

(c) Rewrite the following SQL statement after correcting error(s). (1)
Underline the corrections made.
INSERT  ZN EMP (EMPNO, SALES )
VALUE  (100 ,  20078 . 50) ;

(d) A table STUDENT has 5 rows and 3 columns. Table ACTIVITY has 4 rows and 2 columns. What will be the cardinality and degree of the Cartesian product of them? (1)
(e) Name the SQL commands used to (2)
(i) Physically delete a table from the database.
(ii) Display the structure of at a table.
(f) Write one similarity and one difference between Unique and primary key constraints. (2)
(g) What effect does SET AUTOCOMMIT have in transactions? (2)
4. (a) The following code has some errors (s) Rewrite the correct code Underlining all the corrections made.  (2)
int written, interview;
written =
Integer.parselnt(jTextFieldl.getText());
interview =
Integer.parselnt(jTextField2.getText());
if (written <80) OR (interview <15)
{
System.out.println(Not selected);
}
Else;
{
System.out.println(“Selected”);
}
(b) How many times will the following loop execute: (2)
int z = 7, sum = 0;
do
{
sum = sum + z;
z = z+2;
System.out.println(” “+z);
}
while (z <=12);

(c) Rewrite the following program code using IF ELSE IF instead of SWITCH statement. (2)
String rem;
int code =
Integer.parseInt(jTextFieldl.getText());
Switch(code)
{
case 1: rem = “Classes start on        8th April”; break;
case 2:  rem = “Classes start on        loth April”; break;
case 3: rem = “Classes start on        l2th April”; break;
default: rem   = “Contact Admin Office”;

(d) Write the values of sum and t after execution of the following code: (2)
int sum t ;
sum=27;
t=3
sum=sum+2*(++t);

(e) What will be the contents of jTextField1 and jTextField2 after executing the following code: (2)
String s = “Best”;
String r= “Luck”
String z;
z=r. concat (s);
jTextField1.setText(z);
jTextField2.setText(r.toUpperCase());

(f) Seema is a junior programmer at ‘Avon Shoe Factory’. She has created the following GUI in Net beans.
CBSE Question Paper 2015 class 12 Informatics Practices

  • 3 items namely Shoes S and as and S Uppers are manufactured by the factory.
  • A buyer can buy more than one item at a time.
  • Each pair of shoes costs Rs. 1,500.00, each pair of Sandals costs Rs. 1,000.00 and each pair of slippers cost Rs. 500.00.
  • The item bought will be selected by the user and the Quantity (number of pairs) bought wit be entered by the user.
  • Amount to be paid for that item wit be displayed in front of the item.

For example, if ‘Shoe’ is selected and Quantity entered is 20, then Amount should be displayed as 30000.

Help Seema write code for the following:

(a) When ‘Calculate’ button is clicked, the amount should be displayed in front of each item (in the appropriate text field) and Total amount (sum total of all the amounts) should be displayed in the appropriate’ text field. (3)

(b) When Clear button is clicked, all the text fields and Checkboxes should be cleared. (1)

(c) When stop button is clicked, the application should close. (1)

5 (a) Write one similarity and one difference between CHAR and VARCHAR data types. (2)

(b) Consider the following table named “GARMENT”. Write command of SQL for (i) to (iv) and output for (v) to (vii).

Table: GARMENT

GCODE

GNAME

SIZE

COLOUR

PRICE

111
112
113
114
115
116

T-shirt
Jeans
Skirt
Ladies Jacket
Trousers
Ladies top

XL
L
M
XL
L
L

Red
Blue
Black
Blue
Brown
Pink

1400.00
1600.00
1100.00
4000.00
1500.00
1200.00

(i)  To display names of those garments that are available in ‘XL’ size. (1)

(ii) To display codes and names of those garments that have their names starting with ’Ladies’. (1)

(iii) To display garment names, codes and prices of those garments that have price in the range 1000.00 to 1500.00 (both 1000.00 and 1500.00 included). (1)
(iv) To change the color of garments with code as 116 to “Orange”. (1)

(v) SELECT COUNT (DISTINCT (SIZE)) FROM GARMENT; (1)

(vi) SELECT AVG (PRICE) FROM GARMENT; (1)

(vii) SELECT NAME FROM GARMENT (1)
(c) What is the degree and cardinally of ‘Garment’ table? (1)
6. (a) Write MySql command to create the table DEPARTMENT with given constraints (2)
TABLE: DEPARTMENT

COLUM_NAMEDATATYPE(SIZE)CONSTRAINT
Department ID
DepName
Manager ID
Location
Int(4)
varchar(50)
char (40)
varchar (30)
Primary Key
Not Null

(b) In a Database, there are two tables given below:

Table: EMPLOYEE

EMPLOYEEIDNAMESALESOBID
E1SAMIT SINHA1100000102
E2       IJAY SINGH TOMAR1300000101
E3JAY RAJPAL1400000103
E4OHIT RAMNANI1250000102
E5SHAILJA SINGH1450000           103

Table: JOB

JOBIDJOB TITLESALARY
101
102
103
104
105
106
President
Vice President
Administration Assistant
Accounting Manager
Accountant
Sales Manager
200000
125000
80000
70000
65000
80000

Write SQL Queries for the following:
(i) To display employee ids, names of employees, job ids with corresponding job titles.
(2)
(ii) To display names of employees, sales and corresponding job titles who have achieved sales more than 1300000. (2)

(iii) To display names and corresponding job titles of those employees who have ’SINGH’ (anywhere) in their names.   (2)

(iv) Identify foreign key in the table EMPLOYEE. (1)

(v) Write SQL command to change the JOBID to 104 of the Employee with ID as E4 in the table ‘EMPLOYEE’ (1)

7. Write one advantage and one disadvantage of e-learning to students. (2)
(b) What precaution must be taken with regard to making payments while shopping online? (1)

(c) James works for a Garments company. He has created a form for the employees. Help him choose most appropriate controls from ListBox, ComboBox, TextFieId, TextArea, RadioButton, Checkbox, Label and Command Button for the following entries: (2)

S.No.Function
1To enter first name of employee
2To select gender (M/F)
3To choose gender of employee
(Permanent/Temporary)
4To allow entering remarks about the employee in the form of paragraph.

These are 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 2015 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 2015 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.

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.


Test Generator

Test Generator

Create Papers with your Name & Logo

Try it Now (Free)


Leave a Comment