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
| Board | CBSE |
| Class | XII |
| Subject | Informatics Practices |
| Sample Paper Set | Paper 5 |
| 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 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) Ishaan is studying the concept of twisted pair cable. Suddenly, he got stuck at the point that, why the wires have been twisted in this type of cable? Help him to clarify his doubt.
(b) Expand the following terms with respect to networking :
(i) CDMA
(ii) FTP
(c) Which of the following unit measures the speed with which data can be transmitted from one node to another node of a network? Also, give the expansion of the suggested unit.
(i) Mbps
(ii) Kmph
(iii) Mgps
(d) Write one example each of domain name and IP address.
(e) Two friends in the same room have connected their palmtop using bluetooth for working on a group presentation.
(i) Out of the following, what kind of network have they formed? (LAN/MAN/PAN/WAN)
(ii) Name one communication channel that can be easily connected.
(f) Write down difference between Telnet and FTP
(g) Identify the topology shown below. Write 2 advantages of this topology.
Question 2.
(a) Tanvi added four radio buttons in an application. She is facing a problem that more than one radio button can be selected but she wants them to exhibit mutually exclusive behaviour, i.e. only one of them should be selected at a time. What could be the reason behind such behaviour of radio buttons?
(b) Write Java code to assign the value 5 to variable a and store its cube value in another variable b.
(c) Rewrite the following program segment using while instead of for statement.
int num=1, n ;
for (n=1 ; n<=5 ; n++)
{
num*=n ;
System.out.println(num) ;
}
(d) How many times will the loop execute and also write its output?
int x=3, y=T0 ;
do {
JOptionPane.showMessageDiaiog(null, x+y) ;
x=x+1 ;
y=y-2 ;
} while (x<=y) ;
System.out.println ("x="+x) ;
(e) (i) Differentiate between container and empty elements.
(ii) Do you think XML is the replacement of HTML?
Question 3.
(a) What are the major functions of database administrator?
(b) You have two tables, EMPLOYEE and COMPUTER that are in a one-to-one relationship. The foreign key is EmpNumber in COMPUTER which references EmpNumber as the primary key of EMPLOYEE. Explain, what must be done to convert the one-to-one EMPLOYEE-COMPUTER relationship to a one-to-many relationship where one employee can have more than one computer?
(c) Answer the following queries based on EMP and DEPT tables of MySQL database. Structure of these tables are given below :
EMP(EmpNo, EName, Job, Mgr, HireDate, Sal, Comm, DeptNo) Dept(DeptNo, DName, Ioc)
(i) Create a query to display the name and salary of Employees earning more than ₹ 2850.
(ii) Create a query to display the Employee name and Department number for Employee number 7566.
(d) Nitesh is using a table ‘CLOCK’. It has the following columns :
C_NO, Brand, Price, Color
He wants to display maximum Price according to brand name.
He wrote the following command :
SELECT C_N0, MAX(Price) FROM CLOCK ;
But he did not get desired result. Rewrite the above query with necessary change to help him get the desired output.
(e) (i) Given below is the ‘COMPANY’ table :
SET AUTOCOMMIT=0 ; INSERT INTO COMPAN.Y VALUES (5, ’ Chamma ’) ; COMMIT ; UPDATE COMPANY SET CName=’Chaya’ WHERE CN0=5 ; SAVEPOINT A ; INSERT INTO COMPANY VALUES (6, 'Vishal') ; SAVEPOINT B ; ROLLBACK TO A ;
What will be the output of the following SQL query now?
SELECT * FROM COMPANY ;
(ii) Consider the table :
What output will be displayed by the following SQL statement?
SELECT COUNT(DISTINCT Winby) AS Total FROM MATCH ;
Question 4.
(a) Estimate programming languages out of the following.
C, Python, MySQL, Oracle,Java
(b) (i) Identify and correct the errors in the following code :
int Principle = PrinTF.getText ( ) ;
int time = timeTF.getText ( ) ;
float int = Principled*08*time ;
JOptionPane.showMessageDialog ("Interest is" + int) ;
(ii) Write the tags to define the following :
I. Text area
II. Password field
(c) (i) What will be displayed in jTextFieldl and jTextField2 after the following code is executed?
int x=14, y=8 ;
float z ;
z=(float)(x/y) ;
jTextFieldl.setText(z) ;
jTextFiel d2.setText (" "+(++z) ) ;
(ii) What will be the value of numl and num2 after execution of the following code?
int numl=500,num2 ;
for (num2=20;num2<=22 ; num2++)
{
num1+=num2 ;
}
JOption Pane.showMessageDialog(null , "num1="+num1+”"+"num2=''+num2) ;
(d) Develop an application to prepare students result on the basis of marks entered. The interface of this application would be like :
The specification for above application are given below :
- For the set-up button’s action event, write code so that total marks, percentage and grade cannot be clicked/altered/changed by the user and alignment of all marks fields is right aligned.
- Ensure that Roll No field allows only number keys, backspace or delete key.
- Ensure that Name field allows only alphabet keys, space, backspace or delete key.
Question 5.
(a) Avika created the table ‘CLASS’ last Sunday, Ms. Avika forgot to include the column ‘Subject’. Now, write a command to insert the ‘Subject’ column with VARCHAR data type and 10 size into the ‘CLASS’ table.
(b) What is null value in MySQL database? Can you use nulls in arithmetic expression?
(c) (i) Mrs. Kanika is the HR of Arihant Publication. She wants to create a table ‘RECORD’ to store details all of its employees.
I. Which of the following can be the attributes of ‘RECORD’ table?
i. Emp_Name
ii. E_Id
iii. Ravi
iv. 24-10-10
II. Name the primary key of the table ‘RECORD’. State reason for choosing it.
(ii) What is deadlock? How can it be avoided? How can it be resolved once it occurs?
(d) Write the output of the following SQL queries :
-
SELECT INSTR (' Kal pna_Chawl a' , ' Ch') ; -
SELECT MID ('Hospital '. 2, 3) AS MID ; -
SELECT ROUND ('8.349'. 2) AS Round ; -
SELECT RIGHT ('Capital', 3) AS Data ;
Question 6.
(a) (i) Create the table EMPLOYEE as per following table instance chart :
I. Can the ‘No’ be set as the Primary Key in table ‘CUSTOMER’? Give reason.
II. The ‘No’ column in the ‘ITEM’ table is the …………… KEY. The ‘No’ column in the ‘CUSTOMER’ table is a …………….. KEY
(b) With the reference of above given tables (in Q6 a(ii)), write SQL commands for (i) and output for (ii) and (iii).
(i) To select the ItemName purchased after 1997-10-31.
(ii) SELECT No. ItemName, Customer_Name FROM ITEM I. CUSTOMER C WHERE I.No=C.Ho ; (iii) SELECT ItemName,No, Age, Customer_Name FROM ITEM I,CUSTOMER C WHERE I.No=C.No AND ItemName LIKE "%p%" AND Age BETWEEN 30 AND 40 ;
Question 7.
(a) What is it called when a J ava application is connected with a database using database connectivity drivers?
(b) Neerav works on GUI based software. What is the significance of a good GUI?
(c) Sangeeta is creating a form for the hotel where she works. Help her to choose most appropriate controls from ListBox, ComboBox, TextField, TextArea, RadioButton, CheckBox, Label and CommandButton for the following entries.
Answers
Answer 1.
(a) Wires in twisted pair cables are twisted in order to reduce cross talk. Cross talk is a form of signal interference.
(b) (i) CDMA (Code Division Multiple Access)
(ii) FTP (File Transfer Protocol)
(c) (i) Mbps (Mega bits per second)
(d) Domain name www.arihant.co.in
IP address 192.168.1.64
(e) (i) They formed a Personal Area Network (PAN)
(ii) Ethernet cable
(f) Differences between Telnet and FTP are as follows :
(g) It is a Mesh topology, in which each node is connected to more than one node, so that it provides alternative route.
Two advantages are as follows :
(i) Excellent for long distance networking.
(ii) Fault identification and fault isolation are easy.
Answer 2.
(a) The radio buttons must be added to same button group in order for them to exhibit a mutually exclusive behaviour.
(b) int a, b ;
a=5 ;
b=a*a*a ;
System.out.println(b) ;
(c) int num-1,n-1 ;
while(n<=5)
{
num*=n ;
System.out.println(num) ;
n++ ;
}
(d) The given loop will be executed 3 times.
Output
13
12
11
x=16
(e) (i) Differences between container elements and empty elements are as follows :
(ii) No, XML does not replacement of HTML. Instead of, it provides an alternative which allows you to define your own set of markup elements. HTML is expected to remain in common use for sometime to come and the current version of HTML is in XML syntax. XML is designed to make the writing of DTDs much simpler than with full SGML.
Answer 3.
(a) The main functions of Database Administrator (DBA) are managing database structure, controlling concurrent processing, managing processing rights and responsibilities, developing database security, providing for database recovery, managing DBMS and maintaining the data repository.
(b) In one-to-one relationship, there will be a constraint on EmpNumber as a foreign key in COMPUTER stating that EmpNumber must be unique. To convert the relationship to a one-to-many relationship, just drop primary key constraint.
(c) (i) SELECT EName, Sal FROM EMP WHERE Sal > 2850 ; (ii) SELECT EName, DeptNo FROM EMP WHERE EmpNo = 7566 ;
(d) The correct statement is :
SELECT C_N0, MAX(Price) FROM CLOCK GROUP BY Brand ;
Answer 4.
(a) Programming languages are as follows :
C, Python, Java
(b) (i) The correct code is :
(c) (i) jTextFieldl will contain 1.0
jTextField2 will contain 2.0
(ii) num1=563 num2=23
(d) (i) private void setupBtnActionPerformed(ActionEvent evt)
{
totTF.setEnabled(False) ;
perTF.setEnabled(False) ;
grTF.setEnabled(False) ;
m1TF.setHorizontalAlignment(HorizontalAlignment.RIGHT)
m2TF.setHorizontal Alignment(HorizontalAlignment.RIGHT)
m3TF.setHori zontal Alignment(HorizontalAlignment.RIGHT)
m4TF. setHorizontalAlignment(HorizontalAlignment.RIGHT)
m5TF.setHorizontalAlignment(HorizontalAlignment.RIGHT)
}
(ii) private void rnoTFKeyTyped (KeyEvent evt)
{
char ch=evt.getKeyChar ( ) ;
if (! ( (ch>='0'&&ch<='9') | |ch==KeyEvent. VK_BACK_SPACE
||ch==KeyEvent.VK_DELETE) )
evt.Consume( ) ;
}
(iii) private void nameTFKeyTyped(KeyEvent evt)
{
char ch=evt.getKeyChar( ) ;
if (! ( (ch>='a'&&ch<='z') | | (ch>='A'&&ch<='Z') | | ch==KeyEvent. VK_SPACE
||ch==KeyEvent.VK_BACK_SPACE || ch==KeyEvent.VK_DELETE) )
evt.Consume ( ) ;
}
Answer 5.
(a) ALTER TABLE CLASS ADD Subject VARCHAR(10) ;
(b) If a column in a row has no value, then column is said to be NULL, or to contain NULL. Yes, NULL can be used in arithmetic expression, but the result will always be equal to NULL.
(c) (i) i. Emp_Name
ii. E_ld
II. Primary key E_ld, as it will be unique for each employee of the publication.
(ii) Deadlock occurs when two transactions are waiting on a resource that the other transaction holds. Deadlock can be prevented by requiring transactions to acquire all locks at the same time, once it occurs, the only way to cure it is to abort one of the transactions and back out of partially completed work.
Answer 6.
(a) (i) CREATE TABLE EMPLOYEE ( EmpID INT(6) PRIMARY KEY, EmpName VARCHAR (20) NOT NULL, EmpAddress VARCHAR (30), EmpPhone VARCHAR (10), EmpSal DOUBLE (9,2), DeptID VARCHAR (2), FOREIGN KEY(DeptID) REFERENCES Department(DeptlD) ) ;
(ii) I. No, as it may be repeated in CUSTOMER table, because it is already a primary key of ITEM table.
II. Primary, Foreign
(b) (i) SELECT ItemName FROM ITEM WHERE DateofPurchase>31-10-1997 ;|
Answer 7.
(a) Java DataBase Connectivity, i.e. JDBC
(b) A good GUI design is an important feature for a software’s success and acceptance. If the end users find the software to difficult to understand, then the software may be rejected even if it is an excellent software product.
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.