KENDRIYA VIDYALAYA SANGATHAN CHENNAI REGION
REVISION PAPER TERM 2
INFORMATICS PRACTICES
SUBJECT CODE : 065 (MARKING SCHEME)
Maximum Marks: 35 Time: 2 hours
General Instructions
The question paper is divided into 3 sections – A, B and C
Section A, consists of 7 questions (1-7). Each question carries 2 marks.
Section B, consists of 3 questions (8-10). Each question carries 3 marks.
Section C, consists of 3 questions (11-13). Each question carries 4 marks.
Internal choices have been given for question numbers 7, 8 and 12.
1. Section -A Each question carries 2 marks
QNo Part No Marks
1 Rohini wants to edit some privacy settings of the browser. How can she 2
accomplish her task? Also mention 2 examples of web browser.
Or
Hareesh wants to play a video in his browser but he is not able to do so. A
message on the screen instructs him to install the Adobe Flash Player
plugin. Help him to add it in the Browser. Also explain what is plugin
2 i I: 1
Children use me for the online classes
Am a technology
Makes audio and video calls possible from internet
Who am I?
ii Expand: 1
URL
DNS
3 Predict the output of the following queries: 2
i. Select substr(‘abcdefg’,3,4)
ii. Select mod(11,4)
Or
Briefly explain the purpose of following SQL functions
i. Round()
ii. Pow()
4 Shravya wants to create a website like flipkart. She is confused whether 2
she should create static webpages or dynamic webpages. Help her decide
which webpages should she make and why. What do you understand by
static and dynamic web pages
5 Help Rehana predict the outputs 2
select round(64.26446,3)
select round(234.789,-1)
6 i Harita is looking for the records of the school database and she wants to find out the 1
number of students in the school classwise. Help her select the appropriate query to
do the so through MySQL
ii After doing the above mentioned task, she wants to find out the classes where the 1
number of students are more than 50. Help her find the right clause to do so in
MySQL
7 ECode Name DOJ DOB 2
11 Rahe Shyam 13-Sep-2004 23-Aug-1981
12 Chander Nath 22-Feb-2010 12-Jul-1987
13 Fizza 14-Jun-2009 14-Oct-1983
14 Ameen Ahmed 19-Dec-2005 13-Mar-1983
Predict the output:
i. select max(year(DOB)) from emp;
ii. select min(year(DOJ)) from emp;
Or,
Write the queries for the following
i. Find the Eldest employee
ii. Find the Employee who joined most recently
SECTION B
Each question carries 3 marks
8 Predict the output for the following queries 3
i. select trim(TRAILING ‘.’ FROM ‘ To Be Continued...’)
ii. select left(‘preoccupied’, 4)
iii. select mid(‘informatics practices’, 6,4)
Or
Heena has created a table ‘ student’ with the attributes id varchar(20), name
varchar(50), city varchar(50), contactno varchar(11)
She wants to write the queries for the following. Help her write the queries for the
same
i. To extract the first four characters from the name
ii. To display the names in the lower case
iii. to display the characters from 4th position of column city
9 Answer the following: 3
i. Name two aggregate functions
ii. What is the use of order by clause
iii. Why do we need joins
10 A Write the name of MySQL functions which helps you perform the following 2
tasks:
i. To display the name of month in which you were born
ii. To display the day like “Monday”, “Tuesday”
B Write the MySQL query to trim a particular character from the beginning part
of the string
SECTION C
Each question carries 4 marks
11 No Name Stipend Stream mark Grade 4
1 Karan 400 CS 78 B
2 Kiran 500 IP 88 A
3 Robert 450 BIO 89 A
4 Rubina 200 CS 92 A
5 Vikas 300 BIO 95 A
6 Rohan 500 CS 80 NULL
Write the queries for the following table student:
1). Display the records in the ascending order of Name
ii). Display the number of students in a particular Stream
iii). Display the average marks of the students stream wise
iv). Display the student who got the maximum marks
12 Consider the table student of Q
Q.11 and find the output for the following queries:
queries 4
i) select sum
sum(mark) from student where Grade=’A’
ii) select count
count(distinct Stream) from student;
iii) select length
length(Name) from student where No=2;
iv) select Stream
Stream, count(*) from student
dent group by Stream;
Stream
Or
Or,
Give the output for the following and justify the same
i. select count
count(*) from student;
ii. select count
count(Grade) from student;
13 Indian School, in Mumbai is starting up the network between its different 4
wings. There are four Buildings named as SENIOR, JUNIOR, ADMIN
and HOSTEL as shown below:
The distance between various buildings is as follows:
Number of Computers in Each Building :
1. Suggest the cable layout of connections between the buildings.
2. Suggest the most suitable place (i.e., building) to house the server of
this school, provide a suitable reason.
3. Suggest the placement of the following devices with justification.
o Repeater
o Hub/Switch
4. Out of LAN, WAN and MAN, what type of network will be formed
if we interconnect different computers of the campus? Justify
