KENDRIYA VIDYALAYA SANGATHAN- KOLKATA REGION

MODEL PAPER CLASS XII

Informatics Practises (065)
Max Marks:70
1a Sanjay Gupta wants to upload and download files from / to a remote internet server. 1
Write the name of the relevant communication protocol, which will let him do that
1 Which transmission medium should be used to transfer data across two continents at 1
b very high speed
1c Two neighbouring schools at a distance of 120 m from each other , decide to join their 1
LAN using UTP to share their e-learning resources. But they are unable to share the
resources due to loss of signal.Which device should they use so that signal is amplified?
1 What is the difference between Star and Ring topology? 1
d
1e Identify the wired and wireless technologies from the following : 2
i) Blue Tooth ii) Optical Fibre iii)Co-axial iv)Infrared
1f i) Distinguish between Open Source and Propriety Software with reference to 4
customization of software.
ii) Anita says that the following numbers indicate an address:
192.168.0.1
What is the above address called? To which object /device is it assigned?
2a I)Help Asmita in identifying the incorrect variable name with justification: 4
i)unit_price ii) Userid iii) tot marks iv)for
II)What is the purpose of default clause in switch case?
2 Rewrite the following program code in Java using switch case statement: 2
b if(grade==’A’)
jTextField1.setText(“Distinction”);
else if(grade==’B’)
jTextField1.setText(“v Good”);
else if(grade==’C’);
jTextField1.setText(“Pass”);
else
jTextField1.setText(“Fail”);

2c i) Differentiate between ordered and unordered list. 4

ii) Mention the purpose of each of the following HTML tags:
<BR>, <L1>, <HR>, <TABLE>
3a Rita is working in the school database. He wants to see what are the tables in the school 1
database. Which MySql command will he use to see the list of available tables.
3 Write the full form of 1
b i)RDBMS iii)TCL
3c I ) Mr Satyam , a class XI student has just started learning MySql. Help him in 4
understanding the basic difference between DELETE and DROP command.
II ) Suggest suitable command for the following purpose:
i) To create a database named XIICom.
ii) To use the database just created by you.
iii) To see the structure of the table named Student.
iv) To remove the structure of the table named Student.
3 The students names and marks column of a table “Student” are given below:
d STUDENT 4
 Name Marks
Ritesh 86
Prakshi 65
Rishabh 92
Ranita NULL
Based on the above information, find the output of the following queries:
i) Select Avg(Marks) from student;
ii) Select Marks + 5 from student where marks >90;
iii) What is the degree of the above table?
iv) What is the cardinality of the above table?
4a Name any two type of Inheritance supported by JAVA. 1
4 A phone number, consisting of 10 digits is stored in a string variable strPhone. Now it is 1
b required to store this phone number in a log type variable LngPhone. Write a Java
statement to do this.
4c Write the purpose of the following statements. 1
jTextField1.setText(“Foundation”,substring(2));
4 I ) Rewrite the following program code using for loop: 4
d int i=1, sum=0;
while(i<10)
{
Sum=sum+I;
i=i+1;
}
II ) Find the output of the JavaCode snippet after executing of each Java Statement
labelled as L1 , L2, L3 and L4.
String str=”KOLKATA”, pwd=””;
i) Pwd=str.substring(0,2); //L1
ii) Int l=str.length(); //L2
iii) jTextField1.setText(math.round(4.2); // L3
iv) jTextField2.setText(Marh.pow(2,4)+””);//L4

4e The following code has some errors. Rewrite the correct code underlying all corrections. 2
int I,j=5;
I==j+5;
if(i=j)
{ jTextField1.setText(“I & j are equal”);
{
jTextField2.setTeaxt(“They are not equal”);
}
4f The students of “Shiksha Vidyalaya” work for different extracurricular 6
activities like‘community Outreach Program’, ‘Swachh Bharat Abhiyan’ and ‘Traffic
Safety Club’. The Programmer at the school has developed a GUI application as shown
below:
 • A student can participate in more than one activities.
• Each student gets 10 points for each activity- namely Community Outreach
Programme, Swachh Bharat ABhiyan and Traffic Safety Club.
Help the programmer to write code for the following:
(i) When ‘Calculate Total Score’ button is clicked, the points for each activity
(that is selected) should be displayed in the text field in from of that
activity’s checkbox and theTotal score should be displayed in the
appropriate Text field.
(ii) When Clear button is clicked, all the Textfields and Checkboxes should be
cleared.
(iii) When Stop button is clicked, the application should close.
5a While creating a table named “Student”, Mr Ashok got confused as which datatype he 2
should choose for the column studentname out of char and varchar. Help him in choosing
the right data type to store employee name. Give valid justification for the same.
5 Shuchi has just created a table Customer containing columns Customer, City, Product. 2
b After creating the table she realized that she has forgotten to add a column phoneno.
Help her in writing SQL command to add one more attribute.
5c Consider the following table :
EMP 4
Empid Ename Desig Salary
1001 Arun Manager 80000
1002 Vishal Salesman 20000
1008 Babita Manager 70000
1004 Sagnick Analyst 81000
1003 Arindam Salesman 30000
Write commands in SQL for (i) to (iv)
i) To display the details of those who are Managers by designation.
ii) To display the details of those whose name starts with ‘A’.
iii) To increase the salary of all salesman by 2000.
iv) To display the names of those whose salary is less than 50000.
5 Give the output based on the above table: 2
d i) Select Max(Salary), Min(Salary) from EMP;
ii) Select Ename from EMP where Desig IN(‘Analyst’, ‘Manager’);
6a Create a table ITEMS with the following attributes: 2
Field name Data Type Size Constraint
ItemId Integer 5 Primary Key
IName Varchar 25
IDescp Varchar 35
PurchaseDate Date
6 Consider the following Tables
b DOCTOR 2
D-ID D_NAME ADDRESS
D01 R P CHOWDHURY 2ND MILE
D02 A DASGUPTA MATIGARA
D03 VIKAS AGARWAL SHIV MANDIR
PATIENT
P_NO P_NAME DEPT D_ID
P01 ANITA SURGERY DO1
P02 VINITA ORTHO DO2
P03 NITIN SURGERY D01
P04 MUKESH ENT D03
P05 RAMESH ENT D03
I) Identify the foreign key in the table PATIENT.
II) How many rows and columns will be there in the Cartesian Product of the two
tables.
6c Write the SQL queries based on the above tables. 6
i) To display the P_NAME, DEPT and D_NAME.
ii) To display the name of Doctors who deal with surgery.
iii) To sort the PATIENT table in alphabetical order of P_NAME
7a Write down two benefits of cashless transactions. 2
7 Write the name of two major websites for e-learning 1
b
7c Mr Shubham works in Education Department. He wishes to create controls on Form to 2
collect student information.Write the name of appropriate controls which he can use for
it.
Sl No Control used to Control
1 Enter name ?
2 Select Gender (Male/Female) ?
3 Select Class & sec ?
4 Submit the Form ?