Dattu

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

CBSE Sample Papers for Class 12 Informatics Practices Paper 5

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 5 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) Define a network. What are the different types of networks?
(b) Two neighbourhood schools at a distance of 120 m from each other have decided to join their LkNs using UTP cable, so that they can share their E-Learning resources. But after joining their LANs, they are not able to share the resources due to loss of signal in between. Which device should they use so that signal is amplified in between?
(c) Write the difficulty to sell the software developed using open source software.
(d) What is the mechanism that obtains IP address using a URL of a website?
(e) Define the following terms: (i) Data channel (ii) Baud
(f) Discuss about MODEM. What is its function?
(g) Write down the various facilities provided by the server.

Question 2.
(a) Write HTML code to produce a TextArea with 20 rows and 10 columns.
(b) Identify invalid vanable naines out of the following. State reason if invalid.
(i) switch
(ii) sum 12
(ii) address
(iv) Name
(c) Briefly explain the different GUI output methods used in Java.
(d) Write code for the event handler of a radio button so that when it is selected/unselected, its text changes to “Selected” or “Unselected”.
(e) (i) Rewrite the following program code using if else statement:

int a=jComboBox1.getSelectedlndex ( ) ;
switch(a)
{
case 0 :
GrandTotal=0. 10 * BillAmt ;
break ;
case 1 :
GrandTotal=0 .9 * BillAmt ;
break ;
case 2 :
GrandTotal=O. 8 * Bill Amt ;
break ;
default :
GrandTotal=BillAmt ;

(ii) Neelam has to design two Web pages with following specffications write HTML tags for these :
I. One Web page should have ordered list.
II. Another Web page should have horizontal rule with color ‘Blue’.

Question 3.
(a) How would you display system date as the result of a query?
(b) Following are some statements :

CREATE TABLE EMPLOYEE
(
Emp_Id INT NOT NULL ,
OrderNo INT NOT NULL ,
Emp_rank INT ,
PRIMARY KEY(Emp_Id) ,
FOREIGN KEY(Emp_rank) REFERENCES Persons(Emp_rank)
) ;

Identify the number and types of constraints in the above table EMPLOYEE.

(c) Ahuja entered the following SQL statement to display all workers of the country “US” and “India” from the table “PROFIT”.

SELECT*FROM PROFIT WHERE Country='US' AND Country-'India' ;

Rewrite the correct statement, if it is wrong.

(d) Consider the table :

(i) Write query to display Emp_Name, Emp_Salary whose name starts from ‘S’.
(ii) Delete the record of employee Neeru from the table COMPANY.

(e) (i) Consider the CUSTOMER table.

The following SQL queries are executed on the above table :

INSERT INTO CUSTOMER VALUES ('C106', ‘Aakash’) ;
COMMIT ;
UPDATE CUSTOMER SET Cust_Name='Abhishek' WHERE Cust_ID='C104'; SAVEPOINT P ;
INSERT INTO CUSTOMER VALUES ('C107','Chris') ;
SAVEPOINT Q ;
INSERT INTO CUSTOMER VALUES ('C108Gagan’) ; 
SAVEPOINT R ;
ROLLBACK TO Q ;

What will be the output of the following SQL query now?

SELECT*FROM CUSTOMER ;

(ii) An attribute P of datatype VARCHAR (30) has the value “Rastogi”. The attribute Q of datatype CHAR(30) has value “Garg”. How many characters are occupied in attributes P and Q?

Question 4.
(a) What will be the value of variables’m’ and ‘n’ after the execution of the following code?

int m,n = 0 ;
for(m = 1; m <= 4; m++)
{
n+=m; 
n- -;
}

(b) (i) Write the corresponding Java expressions for the following mathematical expressions :

(c) (i) What is XML editor? Also, write Free XML editors.
(ii) The following code has some error(s). Rewrite the correct code underlining all the correction made.

float m=6, float n=1,p=1 ;
do ;
{
p==p*n ;
n++ ;
while (n<=m)
j TextFieldl.setText (" " +p) ;
}

(d) Read the following case study and answer the questions that follow :

Mr. Das is working as a Chief Information Officer in AMD constructions company. In the month of January, he received a letter from the management to store all his employees information in electronic form. He decided to develop a small software application form to store employee’s personal data. He instructed one of his juniors to make a form in Java swing to enter employees information. The junior presented the following form to Mr. Das.

The form details are given in the following table :

(i) Write a code snippet on Action Event of ClearFormBTN button to clear Text Field objects, set default choice in the Radio Buttons to Female and clearing all CheckBox controls.
(ii) Write a method ProCheckQualification to be called in the Submit Button’s Action Event. The procedure code will perform the following action:

If the Check Box PostGraduateCB is checked, then the procedure will automatically check the CheckBoxes GraduatcCB and lntermediateCB irrespective of their initial state. Similarly, if the CheckBox GraduateCB is checked then automatically check IntermethateCB, otherwise only IntermediateCB should be automatically checked.

(iii) Write a method ProConvertCase to convert all the employee details in NameTF, FatherNameTF, MotherNameTF and AddressTF to upper case characters.

Question 5.
(a) How do you select all rows from a table named “PRODUCT’ where the value of the column “Product_name” starts with “B”?
(b) What is null value in MySQL database?
(c) (i) Riya Pandey is the Manager of company named Royal, she wants to create a table ‘EMPLOYEE’ to store details of her company.

I. Which of the following can be the attribute(s) of ‘EMPLOYEE’ table?
i. EmpNo
ii. ”Rahul”
iii. Name
iv. 115

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

(ii) Write the output of the following SQL queries :

I. SELECT TRUNCATED.864,2) ;
II. SELECT RIGHT(CONCAT(’PUBLICATION', 'ARIHANT'), 4) ;

(d) Consider the following table named “BANK” with details of account holders.
Write commands in SQL for (i) and (ii) and outputs for (iii) and (iv).

(i) To display all information of account holders whose transaction value is not mentioned.
(ii) To add another column Address with datatype VARCHAR and size (30).

(iii) SELECT Name, Balance FROM BANK WHERE Name LIKE '%i%' ;
(iv) SELECT ROUNDCBalance, -3) FROM BANK WHERE AccountNo = ’B2436’ ;

Question 6.
(a) (i) Write a MySQL command for creating a table ‘SUPPLIERS’

(ii) In a database Bank, there are two tables CUSTOMER and TRANSACTION with the following contents :

I. The Cust_ID column in the CUSTOMER table is the key.
The Cust_ID column in the TRANSACTION table is a key.

II. Identify the attributes, which can be chosen as candidate keys in the table CUSTOMER. Also, define candidate key.
(b) With reference to the above given tables (in Q.6 (a) (ii)), write SQL commands for (i) and (ii) and output for (iii).

(i) To add a column Tranjfype with datatype VARCHAR and size 15 in the table TRANSACTION.
(ii) To display Cust_ID, Cust_Name, Account_No, Tran lD, Amount where Amount is greater than 5000.00

(iii) SELECT Cust_ID, Cust_Name, Tran_ID, Amount 
FROM CUSTOMER, TRANSACTION
WHERE CUSTOMER.Cust_ID = TRANSACTION.Cust_ID 
AND Account_Type = "Saving" ;

Question 7.
(a) Define front-end of an information system.
(b) E-Business is useful for both businessmen and customer. What benefits does an E-Business offer to the customer?
(c) Muskan works for a store. She wants to create controls on a form for the following functions. Which controls should she use? Choose appropriate controls from TextBox, Label, OptionButton, CheckBox, IistBox, ComboBox, CommandButton.

ANSWERS

Answer 1.
(a) A network is an interconnected collection of autonomous computers and devices via same kind of transmission machine. Networks can be classified into three categories which are as follows:

1. Local Area Network (LAN)
2. Metropolitan Area Network (MAN)
3. Wide Area Network (WAN)

(b) Repeater is a device used to amplify signals.

(c) Sometimes there is no commercial market for software. You cannot sell software using previous trademarks, which is developed by another person.

(d) Domain Name Resolution.

(e) (i) A data channel is the medium used to carry information or data from one point to another.
(ii) Baud is the unit of measurement for the information carrying capacity of a communicatton channel of analog type. It is synonymous with bps (bits per second) of digital type circuit.

(f) A modem is a computer peripheral device that connects a workstation to other workstations via telephone lines and facilitates communications. It is short form for MOdulation/DEModulation. Modem converts digital signals into analog signals and vice-versa.

(g) Facilities provided by the server in a network environment are as follows:

1. Resource sharing
2. Centralised database storage
3. Internet sharing with authentication
4. Account monitoring

Answer 2.

(a) <TEXTAREA rows= "20" cols= “10” name= "tar” > Enter detail</TEXTAREA>

(b) (i) switch is invalid because variable names must not be a keyword.
(c) For displaying an output in a Java program, we can use either of the two methods. which are as foIlows:

System.ouiprint ( ) This method displays the text and keeps the cursor in the same line.
System.out.printin ( ) This method displays the text and then moves the cursor to the next line.

(d) private void RdBtnStateChanged ( javax.swing.event.ChangeEvent evt )
{
//RdBtn is the name of Radio Button 
if ( RdBtn.isSelected ( ) )
RdBtn.setText ("Selected") ;
else
RdBtn.setText ("Unselected") ;
}

(e) (i) The rewritten code with the use of if else Statement is as follows :
int a=j ComboBox1.getSelectedlndex( ) ; 
if (a==0)
GrandTotal=0.10*Bill Amt : 
else if(a==1) .
GrandTotal=0.9*BllAmt ; 
else if(a==2)
GrandTotal=0.8*BillAmt;
else
GrandTotal=BillAmt ;
(ii) I. <0L> <LI>
II. <HR color='blue'>

Answer 3.
(a) To obtain current system date :

SELECT CURDATE ( ) ;

(b) There are three constraints defined in EMPLOYEE table, are as follows :
(i) Two NOT NULL constraints for column Empjd and OrderNo.
(ii) One PRIMARY KEY constraint for column Empjd.
(iii) One FOREIGN KEY constraint for column Emp_rank.

(c) The correct code is,

SELECT*FROM PROFIT WHERE Country='US' OR Country-'India' ;

(d)

(i) SELECT Emp_Name, Emp_Salary FROM COMPANY WHERE Emp_Name LIKE'S%' ;
(ii) DELETE FROM COMPANY WHERE Emp_Name='Neeru' ;

(ii) The number of characters occupied in attribute P has value Rastogi are 7 and in attribute Q has value Garg are 4.

Answer 4.
(a) Value of m 5 and n = 5

(b) (i) I. float A = (((b + f) / c ) - d) ; 
II. float z = x * x * x + y * y - (sqrt(x*y))/2 ;

(ii) Java code is ;
float price=Float.parseFloat ( j TextField1.getText ( ) ) ;
int quantity=Integer.parselnt ( j TextFleld2.getjext ( ) ) ;
float tot=price*quantity ;
float tax=tot*10/100 ;
j TextFleld3.setText(” “+tot) ;
j TextField4.setText(” “+tax) ;

(c)
(i) XML editor allow you to create and manipulate XML documents. The basic features which you need are syntax highlighting, color code to make XML easier to read and understand.

Free XML editors

1. XML look top
2. XML mind standard Edition
3. Peter’s XML editors

(d) (i) private void ClearFormBTNActionPerformed(javax.swing.event.ActionEvent evt)
{
NameTF.setText (" ") ;
FatherNameTF.setText (" ") ;
MotherNameTF.setText (" ") ;
AddressTF.setText (" ") ;
FemaleRB.setSelected(true) ;
IntermediateCB.setSelected(false) ;
GraduateCB.setSelected(false); 
PostGraduateCB;setSelected(false) ;
}
(ii) void ProCheckQual ification ( )
{
if (PostGraduateCB.isSelected ( ) )
{ 
GraduateCB.setSelected(true) ;
IntermediateCB.setSelected(true) ;
}
else if (GraduateCB.isSelected ( ) )
{
IntermediateCB.setSelected(true) ;
} 
else
IntermediateCB.setSelected(true) ;
}
(iii) void ProConvertCase ( )
{
String Name = NameTF.getText ( ) ;

NameTF.setText(Name.tollpperCase( ) ) ;
String Fname = FatherNameTF.getText( ) ; 
FatherNameTF.setText(Fname.toUpperCase( ) ) ;
String Mname = MotherNameTF.getText( ) ;
MotherNampTF.setText(Mname.tollpperCase( ) ) ;
String add = AddressTF.getText( ) ; 
AddressTF.setText(add.toUpperCase( ) ) ;

}

Answer 5.

(a) SELECT* FROM PRODUCT WHERE Product_name LIKE ’B%’ ;

(b) If a column in a row has no value, then column is said to be null, or to contain a null.
(c) (i) I. i. EmpNo ii. Name

II. Primary key is EmpNo as it will be unique for each employee of the company.
(ii) Output of the above queries :

(d) (i) SELECT * FROM BANK WHERE Transaction IS NULL ;
(ii) ALTER TABLE BANK ADD Address VARCHAR(30) ;

Answer 6.

(a) (i) CREATE TABLE SUPPLIERS
( 
Product_id INT(4),
Product_Name CHAR(10),
Quantity I NT (10),
Price DECIMAL (7,2),
Phone CHAR (10)
) ;

(ii) I. Primary, Foreign
II. Candidate keys: Cust_ID, Account_No

A candidate key can be defined as a column or set of columns, in a table that can uniquely identify any database record without referring to any other data.

(b) (i) ALTER TABLE TRANSACTION ADD Tran_Type VARCHAR (15) ;
(ii) SELECT Cust_ID, Cust_Name, Account_No, Tran_ID, Amount 
FROM CUSTOMER. TRANSACTION
WHERE CUSTOMER.Cust_ID=TRANSACTION.Cust_ID AND Amount>5000.00 ;

Answer 7.
(a) Front-end of an information system This is the user interface that the users see and which is responsible for interacting with the user. The front-end is responsible for receiving user’s queries, requests etc., and passing it over to the back-end.

(b) E-Business offers following benefits to the customers :

1. Improved speed of response
2. Cost savings
3. Improved efficiency and productivity
4. Improved customer service.

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