SECOND PRE BOARD EXAMINATION, JANUARY 2018
Class : XII TIME : 3 HR
SUB : INFORMATICS PRACTICES MAX MARK : 70
Instructions:-
This question paper is divided into four sections.
Answer the questions after carefully reading it.
This question paper consists of 6 pages
I Section – A
1. Write the name of most suitable communication wireless channels for each of the following
situations
(i) Communication between two offices in hilly areas.
(ii) Transfer data from one mobile phone to another, which are kept near by 1
2. Name two encodings used for Indian language computing. 1
3. Name the type of network formed when you connect your computer to internet 1
4. Brightlands Girls School installed Windows 10 and Open Office for its computer lab .
Which type of software is Windows 10 and Open Office? 1
5. Heena says that the following numbers indicate an address 20 : AC : C2 : 56 : 3D : AB
What is the above address called? Define it and What does the last three values of it stand for? 2
6. What is an open standard? Give any two examples. 2
7. What do you understand by Network Security? Name two common threats to it. 2
II
1. Identify the odd one out of the following clauses in Java. State reason for your choice. 1
switch, do-while, while, for
2. What is the difference between setVisible() and setEnabled() methods? 1
3. What is the difference between the following statements (i) and (ii)? 1
i ) a = 5;
ii) if(a = = 5)
x=3;
4. Name the String method to compare two strings without prioritizing case. 1
5. Jennifer wants to create an ordered list in HTML starting with “C”. Help her to write the
code for it.
6. Ms Sanga wants to add few descriptive lines in HTML code which should not be displayed
on the web page rather should remain inactive during execution. Suggest her the solution
and how to implement it?
1
7. Create a Java method that receives a number as parameter and returns the sum of the even
digits in it. 3
2
III
1. Write the SQL command to create a database named BLS, if it is does not exist in MySQL
1
2. Name any two SQL commands which are committed by default.
1
3. Write a SQL command to view the constraints of EMP table. 1
4. A table Student has 5 columns and 3 rows. What will be the degree and cardinality of the
table after execution of the given SQL command
Update Student Set Session=2016;
1
5. Mr Kumar created two tables Admission and Library to store detail of students. When
1
he is trying to delete a record of student from Admission table he is unable to perform the same.
What may be possible reason? Both the tables contains a common column Reg_No.
6. A table EMP has column COMM with NULL value for some tuples in it.
2
a) Write the SQL command that will display COMM column with value 100, wherever it is
NULL b) Write the SQL
command that will replace COMM column with value 100 wherever it is NULL
7. Distinguish between
a) Primary key and Candidate key 3
b) Now ( ) and Sysdate( ) functions
Section – B
IV
1. What will be displayed textfields, after the following code is executed
a) jTF1.setText(“A”+ ‘a’);
jTF2.setText(“ ”+ (‘A’+ ‘a’)) 1
b) int t, s; s = 8;
t = 4*s++/2;
jTextField1.setText(“ ”+t);
jTextField2.setText(“ ”+s); 2
c) String x, str = “study ”;
x = str.concat (“Java”);
double a = 7.8765;
jTextField1.setText (x.length()+“ ”);
jTextField2.setText (x.toUpperCase () );
3
jTextField3.setText (x.substring (2,5));
jTextField4.setText (Math.round(7.8765)+“ ”); 2
2. Rewrite the following code snippet using another entry controlled loop 2
int i, j;
for (i=1, j=2; i<=6; i++, j+=2)
System.out.println(i++);
System.out.println("Finished!!!");
3. Mrs. Annu works in a Manufacturing company. To calculate total wages she has developed the
following GUI in NetBeans. Male and female workers from city are paid Rs. 350/- per day and
Rs. 400/- per day respectively. Male and female workers from rural areas are paid 20% less of
city worksers, per day. Skilled workers are paid extra at the rate of Rs. 200/- day.
The list of controls for above interface is as follows :
Control Type Object Name Description
nameTF To enter name
Text Field daysTF To enter number of days worked
totwageTF To display total wage
maleRB To select a male worker
femaleRB To select a female worker
Radio Button ruralRB
To select a rural area
cityRB To select a city
Check Box skillCHK To be checked if the worker is a skilled one
clearBTN To clear the frame
quitBTN To exit the frame
Button
calcBTN To calculate total wage & display it in
totwageTF
Write Java code in the corresponding event handler to do the following:
4
a) When Calculate Wage button is clicked, the total wages is calculated as per the criteria given
above and displayed in total wage textbox. ( total wage =wage * number of days worked ) 4
b) When Clear button is clicked, all the textboxes should be cleared and maleRB and ruralRB
should be selected , skillCHK should be selected.
2
c) Close the application when Quit button is pressed, after getting confirmation from the user by
displaying the message- “ <Name>, do you want to exit the application?” 2
V Section – C
1. Write the output of the following SQL queries:
(i). SELECT MOD(7.75, 5) + ROUND(258.453, – 1)+TRUNCATE(304.89,-1);
(ii). SELECT UCASE(MID(‘PreBoard2 Exam’, 3, 7));
(iii) SELECT POWER( DAYOFMONTH(‘2016-09-25’),2);
2. Write an SQL command for creating a table Employee with the following structure :
Field Data Type Size Constraint
EmpNo Int 5 Primary Key
EName Varchar 15 Should be distinct values
Dept Varchar 5 Should not be blank
Gender Char 1 Can be “M” or “F” only
Salary Decimal 5,2 >=6000
3. Write the SQL command for the following from ( a) to (g) and output from ( h) to ( j )
on the basis
of given table. 10
Relation : PATIENT
PCODE PNAME GENDER CITY REG_DATE INCOME
3111 DURGA F DELHI 1998-01-09 10000
1123 UNNI M MADRAS 2010-03-12 5500
2141 MRIDULA F MUMBAI 2001-05-07 8000
4155 SOBHANA F DELHI 2014-01-01 4000
3160 ANITHA F CALCUTTA 2007-03-05 9500
2165 SIDHARTH M MADRAS 2011-04-22 8000
5185 MOHAN M DELHI 2010-02-10 6000
a) To display code, name, income and annual income of all patients , in alphabetical
order. (Patient’s monthly income is given in the table).
b) To change the city to DELHI and income to 7500 of the patient ‘MRIDULA’.
c) To display the name of the city & the total number of patients from each city.
5
d) To display the details of all the patients whose registration date is before 15th
March 2010 and having 4 lettered names starting with “R”
e) To rename the attribute CITY to RES
f) To delete the records of patients who have registered before 2000
g) To display the name of the patients who have registered on MONDAY.
h) SELECT AVG(Income) As Average from Patient WHERE Gender = ‘M’;
i) SELECT MID(PNAME,2,2) from Patient Where Reg_date >= ‘2010-03-03’;
j) SELECT SUM(Income) From Patient Group by City having City= ‘DELHI’;
VI
1. Given a table T3(Code, Grade, Value)
Code Grad Value
e
1 G 300
2 K 600
3 B 200
2
Considering the following series of statements, determine which all statements will bring
changes permanent and show the content of the table T3 after statement 12
1. START TRANACTION
2. INSERT INTO T3 VALUES( 4,’A’,100);
3. DELETE FROM T3 WHERE CODE=2;
4. ROLLBACK WORK;
5. BEGIN;
6. UPDATE T3 SET GRADE=’C’ WHERE CODE =1;
7. ROLLBACK
8. INSERT INTO T3 VALUES(5.’D’,200);
9. DELETE FROM T3 WHERE CODE =1;
10. ROLLBACK WORK’
11. UPDATE T3 SET VALUE =400 WHERE CODE =1 ;
12. COMMIT;
2. Consider the tables EMPLOYEE and PROJECT given below:
EMPLOYEE
NAME SEX DESIGNATION P_CODE
RAHUL M PROGRAMMER 2
SANJANA F ANALYST 1
RADHIKA F PROGRAMMER 1
ANURADHA F ANALYST 3
6
HARISH M ANALYST 2
ANJALI F PRAGRAMMER 1
PARVESH M PROGRAMMER 3
PROJECT
PNo P_Name Size
1 Financial Accounting System Large
2 Library System Medium
3 Inventory Control System Small
a) Is referential integrity implemented in above tables? Justify. 1
b) Give SQL command for the following. 2
i) Display Name and Designation of the employee who are working in the project named,
Library System
ii) Display the Number of Employees involved in Financial Accounting System
Section – D
VII
1. How has society benefited from e-governance?
1
2. What benefit does e-business offers to the customers?
2
3. Johan is creating a Frame for his practical file. He wishes to create controls on a form for
the following functions. Choose appropriate controls from text field, text area label, radio
button, check box, list box, combo box, button and write in the third column.
2
S. No. Control used to Control
1 Typed text should remain hidden
2 An input to choose one subject from a set of choices
3 To select the hobbies from the different options
4 To enter Feedback in the form of paragraph
****************
7
ABUDHABI INDIAN SCHOOL, ABUDHABI
SECOND PRE BOARD EXAMINATION, JANUARY 2018
SUB : INFORMATICS PRACTICES (XII) MAX MARK : 70
Marking Scheme
Q.No Answer Marks
1 1. Microwave/radio wave, 1
Blue Tooth 1
2.Unicode ISCII 1 each
3. WAN 1
4. Proprietory , Open Source Software
5.MAC address, last 3 values are card number
6. Open standard are internationally accepted technical 1 each
standards that guarantee that data can be exchanged and
accessed across platforms and applications . Examples :
OGG, FLAC, HTML, SVG
7. Network security is needed to protect data during their
transmission and to guarantee that data transmissions
are authentic. Two common threats are
(i) Trojan Horse (ii) Worms
II 1. switch
2. enabled—visible but not active
3. assigning and comparing
4. equalsIgnorecase( )
5. <OL start =3>
6. <!- ->
III 1. Create database if not exists BLS
2. Create, alter drop,
3. Desc emp, show columns from emp
4. Degree 5 cardinality 3
5. Foreign key assigned
6. Select ifnull(comm.,0)
Update emp set comm.= 100 where comm. Is null
IV 1. Aa
162 1
8
b. 16,9 1
c) 9 ½ each
STUDYJAVA
UDY
8
V 1. a 2.75 +260+300 =362.75 1
iv)625 1
3. a) select..income *12 “annual income”…order by pname 1
b) update..where mridula 1
c)select city, count(*) …group by city 1
d) where reg_date<’2010-03-15’ and pname like ‘R___’; 1
e) alter table change city res char(20); 1
f) delete from… where year(reg_date)<2000; 1
g) where dayname(reg_date)=’monday’ 1
h) Average 1
6500 1
i) MID(pname,2,2)
NN
OB
ID
j) sum(income) ½
16000 ½
VI 1 )stmts 8 ,9 and 11 ½
Tcode Grad Value 1
e 1
2 K 600 1
3 B 200 1
5 A 200 1
2) a) yes
b) i) equijoin and where P_name =”library system’;
ii) join with group by
VII 1. Reduction in the number of trips to office, waiting 1
time,bribe
2.Improved speed of response,efficiency and availability, cost 1
savings
9
3. password
Radio or combo ½ each
List or check
Text area
10
