KENDRIYA VIDYALAYA SANGATHAN, JAIPUR REGION
MONTHLY TEST (SEPTEMBER)
CLASS XII (SESSION: 2022-23)
SUBJECT: INFORMATICS PRACTICES (065)
MARKING SCHEME
Time: 90 Minutes Max. Marks: 40
Section – A (Any 8)
Q. No. Answer Marks
01 (a) Home Page 1
02 (c) Voice over Internet Protocol 1
03 (a) Local Area Network 1
04 (c) Switch 1
05 (d) File Explorer 1
06 (d) Both a & c 1
07 (b) MAN 1
08 (a) Group data by column 1
09 (b) Add 1
10 (d) All of these 1
Section – B (Any 4)
½ marks for each correct difference (any 4)
S.
LAN WAN
N.
LAN stands for Local Area WAN stands for Wide Area
1
Network. Network.
Ownership can be private or
2 Ownership is private.
public.
3 The speed of LAN is high. The speed is slower than LAN.
There is less congestion in While there is more congestion
4
LAN in WAN
11 2
LAN’s design and maintenance Design and maintenance are
5
are easy. difficult than WAN.
LAN covers small area i.e., While WAN covers large
6
within the building. geographical area.
LAN operates on the principle While WAN works on the
7
of broadcasting. principle of point to point.
LAN has a higher data transfer WAN has a lower data transfer
9
rate. rate as compared to LAN.
LANs is cheaply compared to WAN is costly compared to
10
WAN LAN.
Any 1 Advantage 1
a. Easy to install and the use for small networks.
b. Requires less cable
12
c. Failure of one node does not affect the network functioning.
d. New node can be easily added
Illustration 1
½ marks for each correct difference
S.
Static Web Page Dynamic Web Page
N.
In static web pages, Pages will In dynamic web pages, Content
1 remain same until someone of pages are different for
changes it manually. different visitors.
Static Web Pages are simple in Dynamic web pages are
2
terms of complexity. complicated.
In dynamic web page,
In static web pages,
3 Information is change
Information is change rarely.
13 frequently. 2
Static Web Page takes less
Dynamic web page takes more
4 time for loading than dynamic
time for loading.
web page.
In Static Web Pages, database In dynamic web pages,
5
is not used. database is used.
Static web pages are written in Dynamic web pages are written
6 languages such as: HTML, in languages such as: CGI, AJAX,
JavaScript, CSS, etc. ASP, ASP.NET, etc.
Static web pages require less Dynamic web pages require
7 work and cost in designing comparatively more work and
them. cost in designing them.
SELECT DeptCode, MAX(Salary)
14 FROM Employee 2
GROUP BY DeptCode;
Order By 1
15
Correct explanation with example 1
Section – C (Any 4)
1 mark for each correct difference
S.
Web Page Website
N.
It is a single document that is
displayed
It is a collection of many
by the web browser using a
16 documents. Web 3
specific URL
browsers are used to access
address that includes contents
1 such
like text,
documents using specific URL
media, etc. It also comprises
addresses
links to
attached to the website.
many other relevant
webpages.
S.
Web Page Website
N.
It usually contains content It usually contains content
2 regarding a regarding
single entity type. several entities.
It can be accessed using a It can be accessed through a
3 direct URL link domain
or through a website. address.
The web page URL includes The website URL does not
4 the extension. include any
i.e., the path of the file. extension.
It is comparatively less-
complex to It is comparatively more
5 develop because it is just a complex to
16 smaller part of develop.
the website.
Website address (domain) is
The web page address of any independent of
specific website the webpage address. In case
directly depends on the the webpage is
6 website address deleted due to any reason, the
(domain). This means, if the website will
domain is down, continue to work. All other
the webpage will not work. linked web pages
will also work as usual.
Contact Page, Registration
Page, Sign Up
Amazon.com, Wikipedia.org,
7 Page, About Page, or any other
KVS HQ, etc.
page like
this.
Correct explanation of a web-server 1
17 Correct explanation of web-hosting 1
Correct example 1
18 ½ marks for correct explanation of each listed network device. 3
Correct Purpose 1
19 Correct Difference 1
Example 1
1 mark for each correct difference (any 2)
S.
WHERE HAVING
N.
Used to filter the records from Used to filter record from the
20 1 the table based on the groups based on the specified 2
specified condition. condition.
Can be used without GROUP Cannot be used without GROUP
2
BY Clause BY Clause
Implements in column
3 Implements in row operations
operation
S.
WHERE HAVING
N.
Cannot contain aggregate
4 Can contain aggregate function
function
20 Can be used with SELECT, Can only be used with SELECT
5
UPDATE, DELETE statement. statement.
6 Used before GROUP BY Clause Used after GROUP BY Clause
Correct example 1
Section – D (All)
(a) 160000 with correct justification
½+½
(b) 50025.34 with correct justification
½+½
(c) 55000 with correct justification
21 ½+½
(d) 5
½+½
5
5 with correct justification
(a) SELECT * 1
FROM Product
ORDER BY Name ASC;
(b) SELECT Manufacturer, COUNT(*) 1
FROM Product
22 GROUP BY Manufacturer
(c) SELECT MAX(Price) 1
FROM Product;
(d) SELECT Manufacturer, MAX(Price) 1
FROM Product
GROUP BY Manufacturer;
(i)
1
23
(ii) Hub / Switch 1
(iii) Repeater may be placed when the distance between 2 buildings is 1
more than 100 meters.
(iv) WAN, as the given distance is more than the range of LAN and 1
MAN.
