CBSE Sample Papers for Class 12 Informatics Practices Paper 1

CBSE Sample Papers for Class 12 Informatics Practices Paper 1 are part of CBSE Sample Papers for Class 12 Informatics Practices. Here we have given CBSE Sample Papers for Class 12 Informatics Practices Paper 1.

CBSE Sample Papers for Class 12 Informatics Practices Paper 1

Board	CBSE
Class	XII
Subject	Informatics Practices
Sample Paper Set	Paper 1
Category	CBSE Sample Papers

Students who are going to appear for CBSE Class 12 Examinations are advised to practice the CBSE sample papers given here which is designed as per the latest Syllabus and marking scheme, as prescribed by the CBSE, is given here. Paper 1 of Solved CBSE Sample Paper for Class 12 Informatics Practices is given below with free PDF download solutions.

Time : 3 hrs
Maximum Marks : 70

General Instructions

• All questions are compulsory.
• Answer the’questions after carefully reading the text.

QUESTIONS

Question 1.
(a) Most common communication protocol on Internet that ensures end-to-end communication is called what?
(b) What type of address is the following? Also, define it.
20 : B9 : FI : 63 : 2F : FB
(c) Joy wants to upload and download files from/to a remote Internet server. Write the name of relevant communication protocol. Which will let him to do the same?
(d) Which of the following standards are open standards and which are proprietary standards?
(i) AIFF
(ii) ASX
(iii) PNG
(iv) XML
(e) Two doctors in the same room have connected their pah tops using bluetooth for working on a group presentation.
(i) Out of the following, what kind of network they have formed LAN, MAN, PAN, WAN?
(ii) Name one communication channel that is used for exchanging data over a short distance from fixed and mobile devices.
(f) Write two advantages and disadvantages of satellite.
(g) Identify the topology shown below. Write 2 advantages of this topology.

Question 2.
(a) Identify the odd one out of the following jumping statements. State reason for your choice.

1. continue
2. break
3. for
4. return

(b) Give output of the following code segment:

String mess="Year of Joining" ;
String year= "2013" ;
System.out.print!n(mess.trim ( ) +" "+year) ;

(c) Manju is studying in computer class. She got a code to rewrite the following code into SWITCH case.
You also do the same.

if (choice==l)
j TextFieidl.setText ("First seat") ; 
else if (choice==2)
j TextFieidl.setText ("Second seat") ; 
else if (choice==3)
j TextFieldl.setText ("Third seat") ;
else
j TextFieldl.setText ("No seat") ;

(d) Write code fragment to obtain a temperature value in degree fahrenheit and display it in Celsius.
(Use dialog boxes to take input and display output)

(e) (i) Manisha works as a Website developer in Marina Designers Company. Currently she has
created following tags :

<SUBJECT>...</SUBJECT>
<Subject>...</Subject>

Are these tags part of HTML code or XML code? Are these similar or different?

(iii) Write the HTML tags used for following:

1. To set the font style for whole page.
2. To draw a horizontal line.
3. To create a hyperlink.
4. To insert an image.

Question 3.
(a) Ritu wants to update the amount =10000 where the ‘Name’ is ‘Jaya’ in the ‘DEPOSIT’ table.
She has entered the following SQL statement. An error is being displayed.

UPDATE amount=1000 SET Name='Jaya' FROM DEPOSIT ;

Rewrite the correct statement.

(b) Given STUDENT table as follows :

What value will SELECT COUNT(Teacherld) FROM STUDENT ; return?

(c) Consider the table CUSTOMER

(i) Write a query to display the name of all customers from Meerut.
(ii) Name the data type used for C_City field.

(d) Write statement for the following:
(i) Wife a command to display the first three characters of a string ‘Computer’.
(ii) Write a command display the name ‘RITU’ into lowercase.

(e) (i) Consider the table:

What will be the output of the following queries on the basis of the above table?

I. SELECT COUNT(DISTINCT Course) AS Total FROM PARAMOUNT;
II. SELECT COUNT!*) FROM PARAMOUNT;

(ii) Given below the ‘MINISTER’ table :

SET AUTOCOMMIT=0 ; 
INSERT INTO MINISTER VALUES ('Udisa' , 'Naveen') ;
SAVEPOINT A;
INSERT INTO MINISTER VALUES ('Delhi ' , ’Kej rival') ;
SAVEPOINT B;
UPDATE MINISTER SET Name='Nitin' WHERE State='Udisa' ;
SAVEPOINT C ;
ROLLBACK TO B ;

What will be the output of following query?

SELECT * FROM MINISTER ;

Question 4.
(a) Following is a list of a programming languages :
XML, Java, HTML, C+ +
Identify object oriented language (s) from the above given list.

(b) (i) Distinguish between compile time and runtime polymorphism.
(ii) What will be displayed in jTextFieldl and jTextField2 after the following code is executed?

int m=5 ;
if (m<10)
{ 
j TextFieldl.setText ("m="+m) ; 
m++ ;
j TextField2.setText ( "++m="+(++m) ) ;
}
else
{ 
j TextFieldl.setText ("m") ; 
m++ ;
j TextField2.setText ("m") ;
}

(c) (i) The following code has error (s). Rewrite the correct code underlining all the corrections made:

int i=0
do( )
{
system.out.printn (i is:"+i)
i++;
while i<5

(ii) Find output of the following Java code snippet:

String city="Banglore" ; 
int t=city.length ( ) , CT ;
CT=200-t ;
System.out.println!Integer.toString( t ) ) ;
System.out.println(Integer.toString( CT ) ) ;

(d) The GUI developed by Glamour Garments is shown below :

The company accepts payments in 3 modes as cheque, cash and credit cards.
This discount is given as per mode of payment as follow :

If the bill amount is more than 15000 then the customer gets an additional discount of 10% on bill amount.

(i) Write the code to make the textfields for Discount and Net Amount
(named txtDisc and textNetAmt respectively) uneditable.

(ii) When “Calculate Discount” button is clicked, the discount should be calculated as per the given
criteria and it should be displayed in the Discount textfield. “Calculate Net Amount”
button (named btnCalcNetAmt) should also be enabled.

(iii) When “Calculate Net Amount” button is clicked the net amount should be calculated and it
should be displayed in the Net Amount textfield. (NetAmount = BillAmount – Discount)

Note
1. Name of Textfield Objects

• txtDisc – Textfield to show discount
• txtNetAmt – Textfield to show net amount
• txtBillAmt – Textfield to enter bill amount

2. cmbMoae – ComboBox to select the mode of payment.
3. btnCalNetAmt – Button to calculate net amount.

Question 5.
(a) While creating the table AGENT, Mr. Batra forgot to include the column ‘Bill’. Now, write a command
to insert the ‘Bill’ column with Integer data type and 10 size into the AGENT table.
(b) In ‘Day’ column of ‘MONTH’ table for Id 1, the person entered the Day as ‘Mon’. He wants to
change the Day as ‘Tue1. Which MySQL command should be used to change the Day in MONTH table?
(c) (i) Write the output of the following SQL queries:

I.SELECT DAYNAME ('2016-05 -19 ') AS Day :
II.SELECT P0WER (128, 2) AS Pow ;
III. SELECT TRUNCATE (2.8979, 3) AS Val ;
IV SELECT LEFT ('Bharatiya', 6) AS Name ;

(ii) Mrs. Nisha is the head of class ‘X’. She wants to create a table ‘STUDENTS’ to store detail of marks.
I. Which of the following can be the attribute(s) of STUDENTS table?

1. RollNo
2. Section
3. “PQR”
4. 5

II. Name the primary key of the table ‘STUDENTS’. State reason for choosing it.

(d) Consider the table TEACHER given below :

Write the output for following :
(i) To display name, department and salary of female teachers.
(ii) To display name, department of teacher whose salary between 20000 and 35000.

(iii) SELECT ID FROM TEACHER WHERE Hi redate >'1990-08-01';
(iv) SELECT Category, MIN(Saiary) FROM TEACHER GROUP BY Category :

Question 6.
(a) (i) MySQL command for creating a table PAYMENT, whose structure is given below :

(ii) Consider the tables given below :

I. Can the No be set as the primary key in table ‘EXAM’? Give reason.
II. EID is the and No is the in the EXAM table.

(b) With reference of above given tables (in Q6 a(ii)), write SQL command for (i) and (ii) and output for (iii).
(i) List the names of those students who are in class 12 sorted by Stipend.
(ii) To display the name of student corresponding to subject.

(iii) SELECT Name, Stream, Class, EID FROM STUDENT, EXAM 
WHERE STUDENT.No=EXAM.No AND Grade='C' AND Stipend<=300 ;

Question 7.
(a) How has E-Govemance benefitted the common man?
(b) What do you mean by ICT? Name the fields where we use ICT in our every day life.
(c) Prakul works for the Customer Department. He wishes to create controls on a form for the
following functions. Choose appropriate controls from Text field, Label, RadioButton, CheckBox,
IistBox, ComboBox, Button and write in the third column.

Answers

Answer 1.
(a) TCP/IP (Transmission Control Protocol/Internet Protocol)

(b) This is a MAC address. The MAC address refers to the physical address assigned by
NIC manufacturer.

(c) FTP and HTTP

(d) (i) AIFF Proprietary (Apple Macintosh’s) standard
(ii) ASX Proprietary (Microsoft’s) standard
(iii) PNG Open standard
(iv) XML Open standard

(e) (i) PAN, (ii) Bluetooth

(f) Advantages of satellite are as follows:

1. Large area coverage.
2. Useful for sparsely populated areas.

Disadvantages of satellite are as follows:

1. Cannot deploy large, high gain antennas
2. Requires high investment in case of failure.

(g) Tree topology
Advantages of tree topology are as follows :

1. Stimulates hierarchical flow of data.
2. Easy to extend.

Answer 2.
(a) (iii) for, because it iteration, while continue, break and return are comes in jumping.
(b) Output
Year of Joining 2013

(c) switch(choice)
{ 
case 1 : 
j TextFieldl.setText ("First seat") ; 
break ;
case 2 :
j TextFieldl.setText ("Second seat”) ; 
break ; 
case 3 :
j TextFieldl.setText ("Third seat") ; 
break ; 
default :
j TextField1.setText ("No seat") ;
}

(d) float tempFahr = 0.0 ;
tempFahr = FIoat.parseFloat (JOptionPane,showInputDialog 
("Enter temperature in Fahrenheit") ) ; 
float tempCel = (tempFahr - 32) * 5/9 ;
J OptionPane.showMessageDialog (NULL,"Temperature in Celsius is" + tempCel + "°C") ;

(e) (i) These tags are part of XML code. Because these are user defined tags.
These tags are different.
(ii)

I. <BASEFONT> 
II. <HR>
III. <A> 
IV. <IMG>

Answer 3.
(a) Correct statement is UPDATE DEPOSIT SET amount = 10000 WHERE Name = “Jaya” ;
(b) 2

(c) (i) SELECT C_Name FROM CUSTOMER WHERE C_City ="Meerut" ;
(ii) VARCHAR

(d) (i) SELECT SUBSTR('Computer', 1, 3) ;
(ii) SELECT LOWER('RITU') ;

Answer 4.
(a) Java, C++
(b) (i) Differences between compile time and runtime polymorphism are as follows :

(ii) j TextFieldl will contain m = 5 
j TextField2 will contain ++m = 7

(d) (i) txtDisc. setEditable (false) ;
txtNetAmt.setEditable (false) ;
(ii) .float Bill Amt, NetAmt, Disc ;
String ModeofPayment :
BillAmt = Float.parseFloat (txtBillAmt.getText( ) ) ; 
ModeofPayment = (String) cmbMode.getSelectedItem ( ) ; 
if (ModeofPayment.equals("Cash") )
Disc = BillAmt*8/100 ; 
else if (ModeofPayment.equals ("Cheque") )
Disc = BillAmt*7/100 ;
else
Disc = 0 ; 
if (BillAmt > 15000)
Disc = Disc + Bill Amt*10/100 ; 
btnCalcNetAmt.setEnabled(true) ;
txtDisc.setText (Disc+" ") ;

(iii) float BillAmt, NetAmt, Disc ;
BillAmt = Float.parseFloat (txtBillAmt.getText ( ) ) ; 
Disc = Float.parseFloat (txtDisc.getText( ) ) ;
NetAmt = Bill Amt-Disc ; 
txtNetAmt.setText (NetAmt+ " ") ;

Answer 5.

(a) ALTER TABLE AGENT ADD Bill INTEGERUO) ;

(b) UPDATE Command

(d) (i) SELECT NAME, Department, Salary FROM TEACHER WHERE Gender = 'F' ;
(ii) SELECT NAME, Department FROM TEACHER 
WHERE Salary BETWEEN 20000 AND 35000 ;

Answer 6.

(a) (i) CREATE TABLE PAYMENT 
(
Loan_number INTE6ER (4) PRIMARY KEY , 
Payment_number VARCHAR (3) , 
Payment_date DATE ,
Payment_amount INTEGER (8) NOT NULL
) ;

(ii) I. No as it may be repeated in STUDENT table.
II. Primary key, Foreign key

(b) (i) SELECT Name FROM STUDENT WHERE Class LIKE ’ 12_’ ORDER BY Stipend ; 
(ii) SELECT Name, Subject FROM STUDENT, EXAM WHERE STUDENT.No = Exam.No ;

Answer 7.
(a) The number of trips to government offices reduced by nearly 11% to 27%.
(b) ICT stands for Information and Communication Technology. ICT is the technology which will store, retrieve, manipulate, transmit or receive information electrically in a digital form. It is used to refer to the convergence of audio-visual and telephone network with computer networks through a single cabling or link system.
We use ICT in education, banking, industry and in commerce in our daily life.
(c)

We hope the CBSE Sample Papers for Class 12 Informatics Practices Paper 1 help you. If you have any query regarding CBSE Sample Papers for Class 12 Informatics Practices Paper 1, drop a comment below and
we will get back to you at the earliest.