CBSE Sample Papers for Class 12 Informatics Practices Paper 3 are part of CBSE Sample Papers for Class 12 Informatics Practices. Here we have given CBSE Sample Papers for Class 12 Informatics Practices Paper 3.
CBSE Sample Papers for Class 12 Informatics Practices Paper 3
Board | CBSE |
Class | XII |
Subject | Informatics Practices |
Sample Paper Set | Paper 3 |
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 3 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) What do you mean by circuit switching?
(b) Define the term of OGG Vorbis.
(c) Write one disadvantage of UNICODE.
(d) A company with 20 stand-alone computers is considering networking them together and adding a server.
State one advantage of doing this.
(e) Write the name of the following :
(i) It can be used for broadband transmission, where several channels are handled in parallel.
(ii) Communication between two offices in two different countries.
(f) Why twisted pair cables are not always preferred over other transmission media?
(g) Mohan Associate Manager of unity branch corporate recently discovered that the communication between
his company’s account office and Head office is extremely slow and signals drop quite frequently.
These offices are
100 m away from each other and connected by an Ethernet cable.
(i) Suggest him a device which can be installed in between the offices for smooth communication.
(ii) What type of network is formed by having this kind of connectivity out of LAN, MAN and WAN?
Question 2.
(a) If the variable numl is equal to 5 and the variable num2 is equal to 10, how would you evaluate the logical expression ( (num1 ! =5) || (num2 == 10)) && ! (num1 = = 5)? Show each step of the evaluation.
(b) What will be the value of J = – -K+2*K+I++
If K is 20 and I is 10 initially?
(c) Which tags of HTML are used for the following?
(i) It is used to insert comments in the source code of the Web page.
(ii) It is used to create horizontal line on your page.
(d) Write code fragment to obtain a number from user and display whether it is odd or even, (use JOptionPane)
(e) (i) The following code has some error(s). Rewrite the correct code underlining all the corrections made :
int a=Integer.parse Int (jTextFieldl.setText ( ) ) ; if a>=18 J OptionPane.showMessageDialog (null."You can vote") ; else if J OptionPane.showMessageDialog (null,"You cannot vote") ;
(ii) You have assigned a foreground color and a background color through foreground and background properties
of a label. But the label is not showing any background color. What could be the reason?
Question 3.
(a) Monika is inserted “Batra” in the “LastName” column of the “STUDENT” table but an error is being displayed. Write the correct SQL statement.
INSERT INTO STUDENT('Batra') VALUES (LastName) ;
(b) Ritu created the following table with the name ‘DRIVER’ ;
Now, Ritu wants to add a column ‘Salary’. Write the MySQL statement.
(c) (i) Write syntax of aggregate function AVG ( ).
(ii) When a column value is skipped in an INSERT command which value is inserted in database?
(d) The LastName column of a table DIRECTORY is given below:
Based on this information, find the output of the following queries :
(i) SELECT LastName FROM DIRECTORY WHERE LastName LIKE *_a%* ;
(ii) SELECT LastName FROM DIRECTORY WHERE LastName NOT LIKE *%a%’ ;
(e) (i) What are single row and multiple row functions? Give examples.
(ii) Give the output of following statements :
I. SELECT SQRT(144) ; II. SELECT CEI L( 2845.90) ;
Question 4. (a) Write the output of the following code in Java : int x=0 ; while (x<=3) { System.out.println ("x") ; x=x+1 ; }
(b) (i) What is a combo box? When would you prefer a combo box over a list?
(ii) Rewrite the following code using WHILE loop :
int a=100 ; for (int b=2 ; b<=30 ; b=b+5) { j TextAreal.append ( "\n"+(b+a) ) ; a=a-2 ; }
(c) What will be the output of following code snippet? Also, write its explanation.
int n,a=500 ; if(a+n*10>5000) System.out.println ("100") ; else System.out.printl n ("200") ;
(i) if n is 500
(ii) if n is 300
(d) Shekher is a junior programmer at Ducom Enterprises. He creates the following GUI in NetBeans :
Help him to write code for the following :
(i) To calculate Income Tax to be paid and display in jTextField4 on the click of CommandButton “Calculate Income Tax” as per the following condition: If the Basic is less than 50000 then, Income tax=Basic*0.2
And if is greater or equal to 50000 then, Income Tax = Basic*0.3
(ii) To calculate Salary and display in jTextField5 on the click of CommandButton “CalculateSalary “as per the following condition: Salary = (Basic + Dearness Allowance+House Rent Allowance) -Income Tax.
(iii) To clear all text fields on the click of CommandButton “Clear”.
Question 5.
(a) Mr. Karan has created the following table with the name ‘ARMY’.
What is the data type of columns Soldier_Code and JoinDate in table ARMY?
(b) Consider the above table ARMY (in Q5 (a)). In which Mr. Dheeru trying to insert the given row :
Will he able to successfully insert it? If yes then write query for this row.
(c) (i) What is the role of following command?
ALTER TABLE EMPLOYEE DROP PRIMARY KEY :
(ii) The table YSALES has following information :
Based on this, find the output for the following :
I. SELECT AVG(Sales) FROM YSALES : II. SELECT CONCAT ('Yearly' , Yearly), Sales FROM YSALES :
(d) In a database OFFICE, there are various tables out of them one is ‘SALARY with details of employee salary details. Write commands of MySQL for (i), (ii) and output for (iii) and (iv).
(i) To display the Emp_Id, Balance of Employee whose Name not start with A.
(ii) To display whole detail of SALARY table that dated before 05-July-2014.
(iii) SELECT Name, LENGTH(Name), LEFT(AccountNo,3) FROM SALARY ; (iv) SELECT COUNT(Name), SUM(Balance) AS Total_Pay FROM SALARY ;
Question 6.
(a) (i) Write SQL query to create a table ‘PRODUCTS’ with the following structure:
(ii) Consider the following table :
I. Which column is used to relate the two above tables?
II. Is it possible to have a primary key and a foreign key both in one table? Justify your answer with
the help of tables given above.
(b) With the reference of above given tables (in Q6 (a)(ii)), write the SQL commands for (i) and (ii) and
output for (iii).
(i) To display Courseld, Studentld, TeacherName, Course Fee of .NET course.
(ii) To display Courseld, Name of Teacher, CourseName of all teachers whose name starting with ‘M’.
(iii) SELECT S.Stu_Name, C.CourseName FROM STUDENT S, COLLEGE
C WHERE S.CourseId=C.Courseld ;
Question 7.
(a) Which of the following statements is NOT true in E-Business? Rewrite the statement after correcting it.
(i) It provides best customer service.
(ii) Reduce the cost and transaction.
(iii) It can access only national market.
(iv) Provides more detailed information on customer transaction.
(b) What is meant by relationship? Name the type of relationship possible among entities.
(c) Mr. Harish works for a Resort. He wants to create controls on a form for the following functions.
Suggest controls to him. Choose appropriate controls from TextBox, Label, RadioButton, CheckBox,
ListBox, ComboBox and CommadButton.
Answers
Answer 1.
(a) Circuit switching is a methodology of implementing a telecommunication network in which two network nodes establish connection via a dedicated communication channel (circuit), first through the network and then the message is transmitted through the channels.
(b) OGG Vorbis is new audio compression format developed by Xiph.org.
It is an open, patent free, professional audio encoding and streaming technology with all the benefits of open sources.
(c) UNICODE files are very large as compare to the encoding scheme because it takes 2 bytes to store each character.
(d) Employees of company can logon to a computer anywhere on the network and can access their work files from the file server.
(e) (i) Optical Fibre (ii) Satellite Communication
(f) The twisted pair cable are not always preferred because of the following reasons :
(i) Due to high attenuation signals cannot be transported over a long distance without using repeaters.
(ii) Due to low bandwidth, it is unsuitable for broadband application.
(g) (i) The device that can be installed between the offices for smooth communication is repeater.
(ii) The type of network is Local Area Network (LAN).
Answer 2.
(a) ((num1 ! =5) || (num 2 == 10)) && !(num1 = = 5)
= (False || True) && ! True = (False || True) && False = True && False = False
(b) 67, because J = 19+2*19+10 = 19+38+10=67
(c) (i) Comment tag, i.e.
(ii) Horizontal rule tag, i.e. <HR>
(d) int number = Integer.parseInt(JOptionPane.showInputDialog("Enter the number :") ) ; if (number%2 == 0) JOptionPane.showMessageDialoglnull,"Entered number is even") ; else JOptionPane.showMessageDialog(nullEntered number is odd”) ; (e) (i) int a= Integer. parse Int (jTextFi eldl.getText( )) ; if (a>=18) JOptionPane.showMessageDialoglnull,"You can vote") ; else JOptionPane.ShowMessageDialog(null,"You cannot Vote") ;
(ii) The label is filled with background color only if the property opaque is set to true. The default setting
for opaque property is false. If the label is not showing any background color, the reason might be that its
opaque property is set to false.
Answer 3.
(a) The correct statement is,
INSERT INTO STUDENT(LastName)VALUES ('Batra') ;
(b) MySQL statement to add a column ‘Salary’ in ‘DRIVER’ table is,
ALTER TABLE DRIVER ADD Salary INT(1O) ;
(c) (i) Syntax
SELECT AVG(Column_name) FROM table_name ;
The columns that are not listed in the INSERT command will have their default value, if it is defined for them, otherwise NULL value.
(e) (i) Single row functions work with a single row at a time. A single row function returns a result for
every row of a queried table.
Example of single row functions are SQRT ( ), CONCAT ( ), LCASE ( ), UPPER ( ) etc.
Multiple row functions work with multiple data rows at a time and of return aggregated value.
Example of multiple row functions are SUM ( ), COUNT ( ), MAX ( ) etc.
Answer 4.
(a) Output
×
×
×
×
(b) (i) A combo box is a graphical control that displays a list of values in a dropdown list.
It also offers a text field where new value can be entered or existing values may be altered.
A combo box is preferred over a list because of these reasons :
I. It takes less space on screen.
II. It offers editing features through a text field.
III. Only a single item needs to be selected.
(ii) int a=100 ; int b=2 ; while (b<=30) { j TextAreal.append ("\n"+(b+a) ) ; a=a-2 ; b=b+5 ; }
(c) The expression a+n*100>5000 will evaluate on the basis of the operator’s precedence. The multiplication operator (*) has higher precedence then + and >, and + has higher precedence than >
(i) When n=500
then, a+n* 10=500+500* 10=5500
Which is greater than 5000. So, the output will be 100.
(ii) When n=300
then, a+n*10=500+300*10=3500
Which is less than 5000. So, the output will be 200.
(d) (i) We need to double click at the “Calculate Income Tax” button (jButtonl) and type the following code :
float basic = Float .parseFloat ( j TextFieldl.getText( ) ) ; float incometax ; if (basic<50000) inconietax=basic*0.2 ; else incometax=basic*0.3 ; j TextField4.setText (" " +incometax) ;
(ii) We need to double click at the “Calculate Salary” button (jButton2) and type the following code :
float basic=Float.parseFloat(j TextFieldl.getText ( ) ) ; int hra=Integer.parseInt (j TextField2.getText ( ) ) ; int da=Integer.parseInt (jTextField3.getText ( ) ) ; float incometax=Float.parseFloat (j TextField4.getText ( ) ) ; float Salary=(basic+hra+da)-incometax ; j TextField5.setText (" "+Salary) ;
(iii) We need to double click at the “Clear” button (jButton3) and type the following code :
j TextFieldl.setText (" ") ; j TextField2.setText(" ") ; j TextField3.setText (" ") ; j TextField4.setText (" '') ; j TextField5.setText (" ") ;
Answer 5.
(b) Yes, he will be able to successfully insert because all column name and data type are matched to table.
The query is as follows :
INSERT INTO ARMY(FirstName, LastName, Soldier_Code, JoinDate) VALUES ('Tarun’, ’Shekhawat’, ’M310’, ’22-June-85’) ;
(c) (i) The given statement drops the PRIMARY KEY constraint in table EMPLOYEE.
(d) (i) SELECT Emp_Id, Balance FROM SALARY WHERE Name NOT LIKE ‘A%’ ;
(ii) SELECT * FROM SALARY WHERE Date<’2014-07-05’ ;
Answer 6.
(a) (i) CREATE TABLE PRODUCTS ( Product_ID VARCHAR(IO) PRIMARY KEY, Product_Name VARCHARC20) NOT NULL, ListPrice INTEGER, Weight INTEGER ) ;
(ii) I. Courseld column is used to relate both tables.
II. Yes, it is possible to have a primary key and a foreign key columns in one table. As in the given table ‘STUDENT1, Studentld column is a primary key while Courseld may act as a foreign key.
(b) (i) SELECT Courseld, Studentld, Teacher, Fee FROM COLLEGE C, STUDENT S. WHERE C.CourseId=S.Courseld AND CourseName='.NET' ; (ii) SELECT Courseld, Teacher, CourseName FROM COLLEGE WHERE Teacher LIKE 'M%' ;
Answer 7.
(a) Statement (iii) is not true and the correct statement is :
E-Business can access national as well as international market.
(b) A relationship is an association among several entities, e.g. a relationship between teachers and students.
There are three types of relationships which are as follows :
- One-to-One relationship
- One-to-Many or Many-to-One relationship
- Many to – Many relationship
We hope the CBSE Sample Papers for Class 12 Informatics Practices Paper 3 help you. If you have any query regarding CBSE Sample Papers for Class 12 Informatics Practices Paper 3, drop a comment below and
we will get back to you at the earliest.