INFORMATICS PRACTICES
WORKSHEET-I
CLASS-XII
1. (a)
Write the value of z after execution of following code :
int j;
int z;
j=4;
z = (4*++j)%3;
(b) Write one difference between IF statement and SWITCH
statement.
(c)
Write the difference between the following :
(i)
A = 10
(ii)
If (A==10)
(d) Write statement to increase the value assigned to variable z by 5
and then to display the value.
2. (a)
How is NULL value different from 0 (zero) value ?
(b) Write the UPDATE statement in MySQL to increase commission
by 100.00 in the Commission column in the Emp table.
(c) When using the LIKE clause, which wildcard symbol represents
any sequence of none, one or more characters ?
(d) Rewrite the following SQL statement after correcting error(s).
Underline the corrections made.
2
1
1
1
1
INSERT IN STUDENT(RNO,MARKS) VALUE (5, 78.5);
(e)
Distinguish between a Primary key and a Unique key in a table.
(f)
Given Employee table as follows :
Employee_ID
101
102
NAME
Sabhyata Sharma
Divya Arora
Commission
NULL
8900
103
Faizal Zaidi
NULL
What values will the following statements return ?
SELECT COUNT(*) FROM Employee;
SELECT COUNT(Commission) FROM Employee;
(g) (i) If you have not executed the COMMIT command, executing which
command will reverse all updates made during the current work session in
MySQL ?
(ii)What effect does SET AUTOCOMMIT have in transactions ?
3.
1
(a)
Define a class with reference to Object Oriented Programming.
(b) What will be the content of the jTextArea1 after executing the
following code :
INT n = 89;
jTextAreal.setText(Integer.toString(++n));
(c) Write the value of sum1 after execution of the following WHILE
loop :
int i = 1, sum1 = 0;
while (i<10)
{ sum1 =sum1+ i;
i =i+2;
}
(d) Rewrite the following program code using if else if statement
String remarks;
int num = Integer.parseInt(jTextField1.getText());
switch (num)
{
case 0: remarks = "You have not won any
points."; break;
case 1: remarks = " You have won one
point"; break;
case 2: remarks = " You have won two points";
break;
default: remarks = " All the best";
}
(e) The following code has some error(s). Rewrite the code
underlining all the corrections made
int z;
z = 14;
do;
z = z-2;
System.out.displayln(z);
}while z >= 2;
(f)
Write the output :
System.out.println(Math.pow(4.0,2.0));
System.out.println(Math.round(6.459));
(g) XYZ Pens Company sells each pen at the cost of < 25.00. The Programmer
has developed a GUI application as shown below :
The number of pens bought are entered by the user. The
Amount is Number of Pens * 25.00 If a person buying pens
is a Special Customer,
5% is given on the amount, otherwise no discount is given.
Amount to be paid = Amount Discount
Write code in Java to do the following :
(i) When Calculate button is clicked the Amount, Discount and Amount to be
Paid are calculated and should be displayed in
appropriate text fields.
(ii) When Clear button is clicked, all the Textfields and Checkbox
(iii)
4. (a)
are cleared.
When Stop button is clicked, the application is closed.
Write two examples of DML commands of SQL.
(b)Write the output of the following SQL queries :
(i)
SELECT RIGHT(software, 2);
(ii)
SELECT INSTR(twelve,lv);
(iii)
SELECT DAYOFMONTH(2014-03-01);
(iv) SELECT ROUND(76.987, 2);
(c) Consider the table FLIGHT given below. Write commands in SQL
for (i) to (iv) and output for (v) to (vii).
FLCODE
IC101
IC102
IC103
IC105
IC107
IC431
IC121
START
DELHI
MUMBAI
DELHI
KANPUR
MUMBAI
INDORE
DELHI
Table : FLIGHT
DESTINATION
NO_STOPS
AGARTALA
1
SIKKIM
1
JAIPUR
0
CHENNAI
2
KANPUR
0
CHENNAI
3
AHMEDABAD
2
NO_FLIGHTS
5
3
7
2
4
2
6
(i) Display details of all flights starting from Delhi.
(ii) Display details of flights that have more than 4 number of flights operating.
(iii) Display flight codes, starting place, destination, number of flights in
descending order of number of flights.
(iv) Display destinations along with flight destinations starting with A.
(v) SELECT MAX(NO_FLIGHTS) FROM FLIGHT;
(vi) SELECT DISTINCT(NO_STOPS) FROM FLIGHT;
(vii) SELECT START, COUNT(*) FROM FLIGHT GROUP BY Start;
5. a) Write an SQL query to create the table SALESPERSON with the
following structure :
Table : SALESPERSON
Field
Type
Size
Constraint
SCODE
Decimal
Primary Key
FIRSTNAME
Varchar
30
Not Null
LASTNAME
Varchar
30
Not Null
CITY
Varchar
30
SALES
Decimal
(b) In a database there are two tables CD and TYPE as shown below :
Table : CD
CODE
TITLE
DURATION
SINGER
CATEGORY
101 Sufi Songs
50 min
Zakir Faiz
12
102 Eureka
45 min
Shyama Mukherjee
12
103 Nagmey
23 min
Sonvi Kumar
77
104 Dosti
35 min
Bobby
Table : TYPE
CATEGORY
DESCRIPTION
Jazz
12
Classical
40
Country Side
(i)
78
Pop
Name the Primary key in CD table.
(ii)
Name the foreign key in CD table.
(iii)
Write the Cardinality and Degree of TYPE table.
(iv) Check every value in CATEGORY column of both the tables.
Do you find any discrepancy ? State the discrepancy.
(v) Write SQL statement to change the name of Singer Sonvi
Kumar to Sonvi Mehra in all the places wherever it occurs
in CD table.
(vi)
(vii)
6. (a)
Write MySQL statement to add a column Music_Director
which datetype Varchar and size as 30 in the table CD.
Write command in SQL to display code, Title and
corresponding description of all the CDs.
Write two features of a good interface.
How is e-business beneficial to shopkeepers ? Write two points.
(c) Shraddha works for a hospital. She wishes to create controls on a form for the
following functions. Suggest controls to her. Choose
appropriate controls from Text box, Label, Radio button, Check
box, List box, Combo box, Command button.
(b)
SNo
Control used to :
Enter Patient name
2
3
4
Choose Gender (out of
Male/Female)
Choose Department from a list
of available departments
Submit Form
Control
