CBSE Sample Papers for Class 12 Informatics Practices Paper 2

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

CBSE Sample Papers for Class 12 Informatics Practices Paper 2

Board	CBSE
Class	XII
Subject	Informatics Practices
Sample Paper Set	Paper 2
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 2 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) Which one useful to amplify the feeble signals?
(i) Repeater
(ii) Switch
(iii) Gateway
(iv) Bridge
(b) Arrange the following communication channels in ascending order of their data transmission rates.
Ethernet cable, Optical fibre, Telephone cable, Co-axial cable
(c) Define the term of DoS (Denial of Service) attacks.
(d) Define the role of OpenOffice.org.
(e) Nukul is working in a marketing company. That company have many branches in Delhi city. Select the
suitable option for the following :
(i) Name this type of network (LAN/MAN/WAN).
(ii) Name one communication device that can be used for send data in segment form.
(f) Write differences between a freeware and free software.
(g) What are the dangers associated with proprietary standards?

Question 2.
(a) Find the output of the following code fragment :

int S=14 ;
if (S < 2 0) 
System.out.print ("Under ") ;
else
System.out.print ("Over ") ;
System.out.print ("the limit") ;

(b) Name the class used to create the following :
(i) A list control
(ii) A combo box control

(c) (i) How would you determine whether 7th item of a list namely MyList is selected or not?
(ii) Specify the tag and attributes used to create a text box which can accept
maximum of 20 characters with a default value “Enter Name”. (l)

(d) How can you define the features of XML?

(e) (i) Rewrite the following code using while loop :

int x-1, y =2 ;
for (x=1; x<=14 ; x++, y+=1)
{
j TextAreal.append (" "+x++) ;
}
J Option Pane.showMessageDialog (null."Complete") ;

(ii) Write code fragment to obtain two values litres consumed and kilometres travelled and then display
kilometre per litre (use dialogs only).

Question 3.
(a) Consider an EMPLOYEE table as follows  :

To select tuples with name, a person has written the following erroneous SQL statement :

SELECT Emp_Id, Emp_Name FROM EMPLOYEE 
WHERE Emp_Name = nothing ;

Write the correct SQL statement.

(b) Consider the table ‘HOTEL’

Write the SQL command to obtain the following output :

(c) “Principal” is a column in a table SCHOOL. The SQL queries are as follows :

SELECT COUNT(*) FROM SCHOOL ;
SELECT COUNT(Principal) FROM SCHOOL ;

Given the result 28 and 27 respectively. What may be the possible reason for .this? How many records
are present in the table 27 or 28?

(d) Rishi create a table name ‘MAP’. In which a column name Address of a datatype VARCHAR(30) has
the value ‘Mumbai’. The column Dept of a datatype CHAR(IO) has the value ‘Manager’. How many c
haracters are occupied in both attributes?

(e) Consider the ‘CLASS’ table

(i) SET AUTOCOMMIT=0 ;
INSERT INTO CLASS VALUES (5, 'Reenu') ; 
SAVEPOINT A ;
INSERT INTO CLASS VALUES (6, 'Ravi') ; 
SAVEPOINT B ;
DELETE FROM CLASS WHERE CNo=3 ; 
SAVEPOINT C ;
INSERT INTO CLASS VALUES (7, 'ABC') ; 
ROLLBACK TO B ;

What will be the output of following query?

SELECT * FROM CLASS ;

(ii) SET AUTOCOMMIT-1 ;
INSERT INTO CLASS VALUES (8, 'Reenu') ; 
SAVEPOINT A ;
INSERT INTO CLASS VALUES (9, 'Ravi') ; 
SAVEPOINT B ;
DELETE FROM CLASS WHERE CNo=3 ;
SAVEPOINT C ;
ROLLBACK TO B ;

What will be the output of following query?

SELECT * FROM CLASS ;

Question 4.
(a) Identify markup language out of the following :
BASIC, HTML, COBOL, C, XML
(b) (i) Find out error(s) in the following code :

int x=2 ; y=10 ; 
do ;
{
++x ; 
y - =x-- ;
}
while (x ! <10) 
return (y)

(iii) How many times will the following loop execute? Which one of them is entry control and which one is exit control?

(c) (i) Shagun has to design two Web pages with the following specifications :
I. One Web page should have an image name ‘abc’ on center.
II. Another Web page should have image (name abc) on background.
(ii) What will be displayed in jTextFieldl and jTextField2 after the following code is executed?

String color ;
String Name ="B a j a j" ;
color=Name.concat (" " + "Yellow") ;
j TextFieldl.setText(Name.replace ('j','J') ) ; 
j TextFieldl.setTexttcolor.toUpperCase( ) ) ;

(d) Mr. Kapoor is designing the GUI for managing customer details, the GUI designed in Netbeans is as follows :

(i) Mr. Kapoor wants that when the form runs, it should display the details of first customer in the form from customer database, table (CUST (CID, CNAME, CADDR)). Write the code for performing this task. Write the complete code for connecting to database, executing query and fetching result.
(ii) Write Java code to go to next record and to go to previous record, when clicked on next button and previous button respectively. Display id and name in respective TextFieldl and TextField2 and address in TextAreal.
(iii) Write Java code to exit from the application, when extBTN is clicked.

Question 5.
(a) A table ‘BUILDING’ contains a column ‘SHOP’. It has many duplicate values. Write query to print different values only.
(b) What is meant by isolation property?
(c) (i) Mr. Arun is a project teacher of class XII. He wants to create a table ‘LAB’ to store details of his class.

I. Identify the attribute of LAB table.
i. Lab_no
ii. Project_name
iii. “Online study”
iv. 001

II. From the above options which one attribute is best for primary key.
(ii) Write the output of the following SQL queries :

I. SELECT R0UND (6.5675,2) ;
II. SELECT TRUNCATE (5.3456,1) ;
III. SELECT DAY0FM0NTH ('2009-08-251) ;
IV SELECT MID ('Class 12' , 2, 3) ;

(d) Table “SOFTDRINK” is shown below. Write commands in SQL for (i) and (ii) and output for (iii) and (iv).

(i) To display names and drink codes of those drinks that have more than 120 calories.
(ii) To display names and price of drink that have PRICE in the range 12 to 18 (both 12 and 18 included).

(iii) SELECT COUNT (DISTINCT PRICE) FROM SOFTDRINK ;
(iv) SELECT DNAME FROM SOFTDRINK WHERE DNAME LIKE '%Mango%' :

Question 6.
(a) (i) Write MySQL command to create the table ‘LIBRARY’ with given constraints.

(ii) Consider the tables MOV and CINEMA

I. Identify the primary key in table CINEMA.
II. SN is the …………… key in the MOV table and ……………. key in the CINEMA table.

(b) With reference of above given tables (in Q6 a(ii)), write SQL query ior (i) and output for (ii) and (iii).

(i) Display a report listing a movie number, current value and replacement value for each movie in the above
table. Calculate the replacement value for all movies as QTY * Price * 1.15.

(ii) SELECT Type, Rating, Stars, CName, City FROM MOV, CINEMA 
WHERE MOV.SN=CINEMA.SN AND Type LIKE '%ra%' ;

(iii) SELECT Title, CName FROM MOV, CINEMA 
WHERE MOV.SN=CINEMA.SN AND Rating ='G' ;

Question 7.
(a) Which of the following is/are the advantage of E-Leaming?
(i) It provides computer literacy and basic Internet usage is not required.
(ii) Provides different learning styles are addressed and facilitation of learning.
(b) List two features of good interface.
(c) Rajat works for a school. He wishes to create controls on a form for the following functions. Choose appropriate controls and write in the second column.

Answers

Answer 1.
(a) (i) Repeater
(b) Telephone cable, Ethernet cable, Co-axial cable, Optical fibre.
(c) Denial of Service (DoS) attacks are those attacks that prevent the legitimate users of the system from accessing or using the resources, information or capabilities of the system.
(d) It is an Open Source office application suit compatible with Microsoft Office. It contains various application softwares such as Writer, Calc, Impress, Draw, Base and Maths that are used in a official work.
(e) (i) This type of network is Local Area Network (LAN).
(ii) Switch
(f) Differences between freeware and free software are as follows :

(g) The dangers of using proprietary standards are as follows:
(i) The recipients may not be able to read the file, if they do not have matching proprietary software/technology.
(ii) Confidential information may get lost, if the specification of its proprietary standard is not known.
(iii) Proprietary softwares are not usually adaptable to the constantly changing needs of the business owner.
(iv) Extra charge is required for the maintenance apart from selling cost.

Answer 2.
(a) Output Under the limit
(b) (i) JList (ii) JComboBox
(c) (i) If (MyList.isIndexSelected (6)) returns true, then the 7th item is selected, otherwise not.
(ii) The tag and attributes to create a text box to accept maximum 20 characters with default value ‘
Enter Name’ is as follows :

<INPUT type="Text" name="Name" size="20" value="Enter Name">

(d) The features of XML are as follows :
(i) XML provides a gateway for communication between applications.
(ii) XML does not allow references to external data entities, named as, character references which are
not allowed in XML.

(e) (i) int x-1, y=2 ;
while (x<=14)
{
j TextAreal.append (" "+x++) ;
x++;
y+=1 ;
J OptionPane.showMessageDialog (null."Complete") ;

(ii) float km=0.0, Lit=0.0, res=0.0 ;
km=Float.parseFloat (JOptionPane.showInputDialog("Enter Kilometres travelled :") ) ; 
Lit = FI oat. parseFl oat (JOptionPane. showInputDialog (" Enter litres Consumed:") ) ;
res=km/Lit ;
J OptionPane.showMessageDialog (NULL,"kilometre per litre=" + res) ;

Answer 3.
(a) Correct SQL statement is :

SELECT Emp_Id. Emp_Name FROM EMPLOYEE 
WHERE Emp_Name IS NOT NULL ; 

(b) SELECT Clientld AS Cld. RoomNo AS RNo, Member AS M FROM HOTEL 
WHERE Member <=12 ;

(c) The possible reason for this is that one record in the table has NULL in the Principal column.
Number of records present in the table are 28.
(d) (i) Address column value Mumbai contains 6 characters.
(ii) Dept column value Manager contains 7 characters.

Answer 4.
(a) HTML, XML

(ii) The loops would execute 3. times.
Loopl is the Entry Control Loop.
Loop2 is the Exit Control Loop.

(c) (i) I. <IMG src="abc. jpg" al ign="center">
II. <B0DY background=”abc.jpg">

(ii) j TextFieldl will contain BaJaJ
j TextField2 will contain BAJAJYELLOW

(d) (i) try
{
Class.forNamel ("com.mysql.jdbc.Driver") ;
Connection con = DriverManager.getconnection 
("jdbc:mysql://localhost : 3306 / customer", "root", "root") ; 
String sql = "SELECT CID, CNAME, CADDR FROM CUST" ; 
Statement smt = con . createStatement ( ) ;
ResultSet rs = smt.executeQuery(sql ) ; 
rs.next ( ) ;
String CID = Integer.toString (rs.getInt ( 1 ) ) ;
String CNAME = rs.getString (2) ;
String CADDR = rs.getString (3) ;
j TextFieldl.setText (CID) ; 
j TextFieid2.setText (CNAME) ; 
j TextAreal.setText(CADDR) ; 
}
catch (Exception e)
{
System.out.println ("Error occurred") ;
}

(ii) Code for Next button

try
{
rs . next ( ) ;
String CID = Integer.toString (rs.getlnt ( 1 ) ) ;
String CNAME = rs . getString ( 2 ) ;
String CADDR = rs .getString ( 3 ) ; 
j TextFieldl.setText (ClD) ; 
j TextField2.setText (CNAME) ;
j TextAreal.setText (CADDR) ;
}
catch(Exception e)
{
System.out.print ( "Error" ) ;
}

Code for Previous Button

try
{
rs.previous ( ) ;
String CID = Integer.toString(rs.getInt(1));
String CNAME = rs.getString(2);
String CADDR = rs.getString(3); jTextFieldl.setText(CID); jTextField2.setText(CNAME);

jTextAreal.setText(CADDR);
}
catch(Exception e)
{
System.out println("Error occurred") ;
}

(iii) Code for Exit button

System.exit(0) ;

Answer 5.

(a) SELECT DISTINCT SHOP FROM BUILDING ;

(b) Isolation property implies that each transaction is unaware of other transactions executing concurrently in the system.

Answer 6.

(a) (i) CREATE TABLE LIBRARY
(
BookId INT (10) PRIMARY KEY, 
BookName VARCHAR (40) NOT NULL, 
Type CHAR (4),
Author VARCHAR (40),
No_Copies INT (6),
Price DECIMAL (8,2)
) ;

(ii) I. CN is the primary key in table CINEMA. It is uniquely identify the items.
II. Primary, Foreign

(b) (i) SELECT SN, QTY *Price AS 'Current Value',
QTY *Price*1.15 AS 'Replacement Value' FROM MOV ;

Answer 7.
(a) (ii) Is the advantage of E-Learning.
(b) Two features of good interface are as follows:
(i) It should have pleasant color combination, so that user likes to use it.
(ii) It should have all relevant options for all the required fields, so that user is at ease while entering the data.

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