18691ptla - Xii Computer - Part 2

11.
DATA BASE CONCEPTS (2M) M001 JAYA SCIENCE

M002 ADITYA HUMANITIES
Model 1:For a given table, key/cardinality/ etc M003 HANSRAJ SCIENCE
M004 SHIVAK COMMERCE
1. Observe the following table and answer the
TABLE : RESULT
parts(i) and(ii) accordingly . 2019SP2
Table:Product NO MNAME STREAM
M002 ADITYA HUMANITIES
Ans) (i) SELECTION
Degree=3 Cardinality=1
4.Observe the table „Club‟ given below:(2017MP)
CLUB
Answer: (i) Write the names of most appropriate

columns, which can be considered as candidate
keys.
Ans) Candidate Key: Pno, Name
(ii) What is the degree and cardinality of the
above table?
Ans) Degree:4 Cardinality:5 i. What is the cardinality and degree of the above given
table?
2) Observe the following tables VIDEO and MEMBER ii. If a new column contact_no has been added and three
carefully and write the name of the RDBMS operation more members have joined the club then how these changes
out of (i) SELECTION (ii) PROJECTION (iii) UNION will affect the degree and cardinality of the above given
(iv) CARTESIAN PRODUCT, which has been used to table.
produce the output as shown below. Also, find the A) i. Cadinality: 4 Degree: 5
Degree and Cardinality of the final result. ii. Cardinality: 7 Degree: 6
2018
5.The following STUDENTS and EVENTS tables
TABLE: VIDEO
carefully and write the name of the RDBMS operation
VNO VNAME TYPE which will be used to produce the output as shown in
F101 The Last Battle Fiction
LIST ? Also, find the Degree and Cardinality of the
C101 Angels and Devils Comedy
LIST. (2016 D)
A102 Daredevils Adventure
TABLE : MEMBER
MNO MNAME
M101 Namish Gupta
M102 Sana Sheikh
M103 Lara James
TABLE : FINAL RESULT
VNO VNAME TYPE MNO MNAME
F101 The Last Battle Fiction M101 Namish
Gupta
F101 The Last Battle Fiction M102 Sana Sheikh
F101 The Last Battle Fiction M103 Lara James
C101 Angels and Comedy M101 Namish
Devils Gupta
C101 Angels and Comedy M102 Sana Sheikh
Devils
C101 Angels and Comedy M103 Lara James
Devils A) Cartesian Product
A102 Daredevils Adventure M101 Namish Degree = 4 Cardinality = 6
Gupta
A102 Daredevils Adventure M102 Sana Sheikh
6) Observe the following table carefully and write
A102 Daredevils Adventure M103 Lara James the names of the most appropriate columns, which
Ans) Cartesian Product can be considered as (i) candidate keys and (ii)
Degree = 5 Cardinality = 9 primary key. (2015)
3. Observe the following table MEMBER carefully and
write the name of the RDBMS operation out of (i)
SELECTION (ii) PROJECTION (iii) UNION (iv)
CARTESIANPRODUCT, which has been used to
produce the output as shown in RESULT. Also, find the
Degree and Cardinality of the RESULT. (2017)
MEMBER Ans) Candidate keys : Code, Item
No MNAME STREAM Primary keys : Code
XII Computer – PART 2 (Refer mrkcomputer.blogspot.in ) 1 PRAISE THE LORD
MODEL 2: THEORY QUESTION Keys. Out of the Candidate keys, one is selected as
KEYS Primary Key. while the rest are the Alternate Keys.
1) What do you understand by Primary Key? Give Ex: Table: Stock
a suitable example of Primary Key from a table Ino Item Qty
containing some meaningful data. (OD 2010) 2 101 Pen 560
Ans. An attribute or set of attributes which are used to 102 Pencil 780
identify a tuple uniquely is known as Primary Key. 104 CD 450
Table: Item 109 Floppy 700
105 Eraser 300
103 Duster 200
Here: Ino, Item – Candidate Keys,
Ino – Primary Key
Item – Alternate Key
Explain the concept of candidate key with the help
2) What is the importance of a primary key in a
of an appropriate example. (2013)(2010D)(D2009)2
table? Explain with suitable example. (OD 2007) 5) What is the purpose of a key in a table? Give an
Ans:Primary Key: A primary key is a set of one or more example of a key in a table. (OD 2009)2
attributes that can uniquely identify tuples within the Ans) An attribute/group of attributes in a table that
relations. A primary key comprises a single column
identifies each tuple uniquely is known as a Key.
or set of columns. No two distinct rows in a table can have
the same value (or combination of values) in those columns. OR
Depending on its designing, a table may have arbitrarily Any correct definition of Key / Primary Key /
many candidate keys but at most one primary key. The Candidate Key / Alternate Key
primary key is non redundant. Ie it does not have duplicate
values in the same relation.
Eg: Consider a table consists the following attributes:
AdmnNo,FirstName,LastName,SirName, M1, M2, M3,
Total,Avg,FName
Here we can uniquely identify the rows in the relation with
following key combinations:
a)AdmnNo
b)FirstName,LastName,SirName
c)FirstName,LastName,FName, etc.
We can set any one of the above candidate keys as primary
key, others are called as alternate keys.
3) Give a suitable example of a table with sample 6) Differentiate between Candidate key and
data and illustrate Primary and Candidate Keys in Primary key in context of RDBMS. (D2008)
it.(2012 D) Differentiate between Candidate Key and alternate
Ans A table may have more than one such Key in context of RDBMS. (OD 2008)
attribute/group of attribute that identifies Differentiate between primary key and alternate
a row/tuple uniquely, all such attribute(s) are known key. (D2007)
as Candidate Keys. Out of the Candidate keys, one is What is an alternate key? (D2006)
selected as Primary Key. What do you understand by the terms primary key
Ex: Table: Stock and degree of a relation in relational data base?
Ino Item Qty (D2005)
101 Pen 560 What do you understand by the candidate key and
102 Pencil 780 cardinality of a relation in relational data base?
104 CD 450 (OD 2005)
109 Floppy 700 What is primary key in a table? (2003)
105 Eraser 300
103 Duster 200 Ans) Candidate Key: All attribute combinations
Here: Ino – Primary Key inside a relation that can serve primary key are
Ino, Item – Candidate Keys, Candidate Keys as they are candidates for the primary
4) Give a suitable example of a table with sample key position.
data and illustrate Primary and Alternate Keys in Primary Key: A primary key is a set of one or more
it. (2012OD) attributes that can uniquely identify tuples within the
Ans A table may have more than one such relations.
attribute/group of attribute that Identifies a row/tuple Alternate Key: A candidate key that is not the
uniquely, all such attribute(s} are known as Candidate primary key is called an Alternate Key.

(Where Candidate Key: All attribute combinations StudentN StudentName Hosteler
inside a relation that can serve primary key(uniquely umber
identifies a row in a relation) are Candidate Keys as 1 Ravi Y
they are candidates for the primary key position.) 2 Robert N
Table: Stock 3 Raheem Y
Ino Item Qty Relation 2: Instructor
101 Pen 560 InstructorName Subject
102 Pencil 780 K.Suman Computer Science
104 CD 450 P.Pavan Electronics
109 Floppy 700 The Cartesian product of these two relations, Student
105 Eraser 300 X Instructor, will yield a relation that have a degree of
103 Duster 200 5(3+2:sum of degrees of Student and Instructor) and a
Here: Ino, Item – Candidate Keys, cardinality 6 (3 X 2: Product of cardinalities of two
Ino – Primary Key relations).
Item – Alternate Key The resulting relation is as follows:
Stude Student Ho Instructor Subject
7) What is a relation? What is the difference between a
nt Name ste Name
tuple and an attribute? (1998)
Numb ler
Ans: In relational data model, the data is organized er
into table (rows and columns). These tables are called 1 Ravi Y K.Suman Computer
relations. A row in a table represents a relationship Science
among a set of values. 1 Ravi Y P.Pavan Electronics
Rows of the relations are called as tuples and 2 Robert N K.Suman Computer
columns of the relations are called as attributes. Science
2 Robert N P.Pavan Electronics
8) What do you understand by Degree and Cardinality 3 Raheem Y K.Suman Computer
of a table? (MP109-10) (MP108-09)2 Science
Ans) Degree: Number of Columns in a table 3 Raheem Y P.Pavan Electronics
Cardinality: Number of rows in a table Resultant Relation = Relation1 X Relation2
Ex: TABLE : MEMBER The resulting relation contains all possible
MNO MNAME combinations of tuples of the two relations.
M101 Namish Gupta 10) What do you understand by Union & Cartesian
M102 Sana Sheikh
Product operations in relational algebra?(2011D)2
M103 Lara James
Ans) Union (binary operator): It operates on two
Here, Cardinality = 3, Degree = 2 relations and is indicated by U.
What do you understand by the candidate key and For example, R= R1 U R2 represents union operation
cardinality of a relation in relational data base? between two relations R1 and R2. The degree of R is
(OD 2005) equal to degree of R1. The cardinality of R is sum of
OPERATIONS cardinality of R1 and cardinality of R2.
9. Explain the concept of Cartesian Product Following have to be considered for the operation R1
between tables, with the help of appropriate U R2.
example. (2014)(2001) Degree of R1 = Degree of R2
Answer) Cartesian Product (binary operator): It jth attribute of R1 and jth attribute of R2
operates on two relations and is denoted by X. must have a common domain.
The Cartesian product of two relations Example : Relation R1
yields a relation with all possible combinations of Student_ID Name
the tuples of the two relations operated upon. S120 Raju
All tuples of first relation are concatenated S121 Nani
with all the tuples of second realtion to form the
tuples of the new relation. Relation R2
The Cartesian product of two relations A and Student_Code Student_Name
B is written as AXB. The Cartesian product yields a K550 Chinna
new relation which has a degree (number of attributes) K551 Munna
equal to the sum of the degrees of the two relations Resultant Relation : R = R1 U R2
operated upon. Student_ID Name
The number of typles (cardinality) of the new relation S120 Raju
is the product of the number of tuples of the two S121 Nani
relations operated upon. K550 Chinna
Eg: There are two relations as follows: K551 Munna
Relation 1: Student

11) What do you understand by Selection & Example: To create a table consisting the Admnno,
Projection operations in relational algebra? SName, Sub1, Sub2, Sub3, Total,Avg,Divison
(2011 OD)2 attributes.
Ans Selection for selecting the rows of table CREATE TABLE Student (AdmnNo integer,SName
char(20), Sub1 number(5,2), sub2 number(5,2),
Projection for selecting the columns of table
sub3 number(5,2), Total number(5,2),Avg
Ex: Table MEMBER number(5,2), Div Char(10));
No MNAME STREAM 2.Constraints:
M001 JAYA SCIENCE (i) NOT NULL : The attribute that contains this
M002 ADITYA HUMANITIES constraints should not be vacant.
M003 HANSRAJ SCIENCE (ii) Unique constraints: This constraint ensures that
M004 SHIVAK COMMERCE no two rows have the same value in the specified
column(s).
TABLE : TABSEL
(iii) Primary key constraints: This constraint declares
NO MNAME STREAM a column as the primary key of the table.(
M002 ADITYA HUMANITIES Primary keys cannot allow NULL values)
TABLE : TABPROJ (iv) Default constraints: A default value can be
No STREAM specified for a column using DEFAULT clause.
M001 SCIENCE When a user does not enter a value for the
M002 HUMANITIES column, automatically the defined default value
M003 SCIENCE is inserted in the field.
(v) Check constraints: this constraint limits values
M004 COMMERCE that can be inserted into a column of a table.
Here, Above table can be created using the constraints as
Table TABSEL is result of Selection operation follows:
Table TABPROJ is result of projection operation CREATE TABLE Student (AdmnNo number(4) NOT
NULL PRIMARY KEY, SName char(20), Sub1
DDL & DML number(5,2) CHECK(Sub1<=100.0), Sub2 number(5,2)
12) What are DDL and DML? (OD 2006) CHECK(Sub2<=100.0), Sub3 number(5,2)
(Differentiate between data definition language and data CHECK (Sub3<=100.0), Total number(5,2),Avg
manipulation language.(2002)) number(5,2),Div char(10));
Ans: DDL means Data Definition Language. SQL 3.INSERT Command:
DDL provides commands for defining relation INSERT INTO <tablename>[<column list>]
schemas, deleting relations, creating indexes and VALUES(<value>,<value>…);
modifying relation schemas. (Provides statements for Eg:
the creation and deletion of tables and indexes.) i) To insert our desired attributes only:
DML Means Data Manipulation Language. SQL INSERT INTO Student
DML provides statements to enter, update,delete data (Admnno,SName,Sub1,Sub2,Sub3)
Values (1000,‟pradeep‟,75.5,90.5,57.0);
and perform complex queries on these tables. ii) To insert all the attributes:
(includes a query language to insert, delete and INSERT INTO Student Values (1001,
modify tuples in the database) ‟sudeep‟,77.50,95.0,68.50, 41.0,80.33,‟First‟);
DML is used to put values and manipulate (for inserting number of rows in a easy way…)
them in tables and other database objects and DDL is INSERT INTO STUDENT(Admnno,SName,Sub1,Sub2,
used to create tables and other database objects. Sub3) VALUES (&Admnno, &SName, &Sub1, &Sub2,
&Sub3);
12.STRUCTURED QUERY LANGUAGE Then it will ask first student data….Enter the data…then
(6 Marks) press / at command prompt. It will ask you next student
STUDENT MARKS TABLE data, etc.)
In the following section many of the commands is Sample Data Inserted
explained through the example “Student marks table”. Adm SNam Sub Sub Sub Tot Avg Di
S.no Attribute Type n No e 1 2 3 al v
1000 Pradee 75.5 95.0 57.0
1 AdmnNo Integer
p
2 SName Character 1001 Sudee 77.5 95.0 68.5 241. 80.3 Firs
3 Sub1 Real Number p 0 3 t
4 Sub2 Real Number 1002 Philip 32.5 60.0 59.5
5 Sub3 Real Number 1003 Pradee 45.5 65.5 70.0
6 Total Real Number p
7 Avg Real Number 1004 Naidu 77.5 25.5 65.5
8 Divison Character 1005 Sudee 80.5 72.5 67.0
p
1. Create Table:
CREATE TABLE <table-name> (<column name><data 4.Select command: Select command of SQL lets you make
queries on the database. A query is a command that is given
type>[(size>)],<column name><data
type>[(size>)],…); to produce certain specified information from the database
table(s).
Simple Form: Pradeep
SELECT<column name>[,<column name>…] FROM Sudeep
<table name>; Pradeep
Eg: Select AdmnNo,SName from Student. Sudeep
(Will display only AdmnNo and SName attributes of the 8. Condition based on a Range using BETWEEN:
table student.) Eg: SELECT AdmnNo, SName FROM Student
Select * from Student. WHERE AdmnNo BETWEEN 1003 AND 1005;
(Will display all the attributes of the table Student.) AdmnNo SName
5.DISTINCT Keyword: This keyword eliminates 1003 Pradeep
duplicate rows from the results of a SELECT statement. 1004 Naidu
Eg: Select DISTINCT SName from Student 1005 Sudeep
Sname 9.ORDER BY:
Pradeep SELECT AdmnNo, SName from student ORDER BY
Sudeep SName ASC;
Philip Admn No SName
Naidu 1004 Naidu
6.ALL Keyword: This keyword will not eliminate 1002 Philip
duplicate rows from the results of a SELECT statement. 1000 Pradeep
Eg: Select ALL SName from student 1003 Pradeep
SName 1001 Sudeep
Pradeep 1005 Sudeep
Sudeep SELECT AdmnNo, SName from student ORDER BY
Philip AdmnNo DESC;
Pradeep
Naidu Admn No SName
Sudeep 1005 Sudeep
7. Selecting specific rows using WHERE clause with 1004 Naidu
SELECT: 1003 Pradeep
Syntax: SELECT <column name>[< column name>,…]
1002 Philip
FROM <table name> WHERE <condition>;
1001 Sudeep
Eg:
1000 Pradeep
SELECT Admnno,SName FROM Student WHERE
Sub1>=40 AND Sub2>=40 AND Sub3>=40; 10. UPDATE COMMAND:
SELECT SName FROM Student WHERE UPDATE Student SET Total= Sub1+Sub2+Sub3;
SName=‟Sudeep‟ OR SName=‟Philip; UPDATE Student SET Avg=Total/3;
SName UPDATE Student SET Div=‟First‟ WHERE (Avg>=60.0);
Sudeep UPDATE Student SET Div=‟Second‟ WHERE
Philip (Avg>=50.0 AND Avg<60.0);
Sudeep UPDATE Student SET Div=‟Third‟ WHERE (Avg>=35.0
SELECT SName FROM Student WHERE AND Avg<50.0);
SName<>‟Naidu‟ UPDATE Student SET Div=‟Fail‟ WHERE (Sub1<35.0
OR OR Sub2<35.0 OR Sub3<35.0);
SELECT SName FROM Student WHERE (NOT After the execution of the above commands, the sample
SName=‟Naidu‟) data will be as follows:
SName Admn SName Sub1 Sub2 Sub3 Total Avg Div
Pradeep No
1000 Pradeep 75.5 95.0 57.0 227.5 75.85 First
Sudeep 1001 Sudeep 77.5 95.0 68.5 241.0 80.33 First
Philip 1002 Philip 32.5 60.0 59.5 152.0 50.66 Fail
Pradeep 1003 Pradeep 45.5 65.5 70.0 181 60.3 First
Sudeep 1004 Naidu 77.5 25.5 65.5 168.5 56.16 Fail
SELECT Sname from student WHERE SName 1005 Sudeep 80.5 72.5 67.0 220 73.3 First
in(„Pradeep‟,‟Sudeep‟); 11. ALTER TABLE:
SName ALTER TABLE student MODIFY (Div Char(6));
Pradeep ALTER TABLE student ADD(CNo NUMBER(10));
Sudeep 12. Functions:
Pradeep SELECT Min(Sub1) FROM Student;
Sudeep (Will give the Minimum marks of Subject1)
SELECT SName FROM Student WHERE SName NOT Min(SUB1)
IN(„Sudeep‟,‟Pradeep‟); 32.5
SName SELECT Max(Sub2) FROM Student;
Philip (Will give the Maximum marks of Subject2)
Naidu MAX(SUB2)
SELECT SName FROM Student WHERE SName LIKE 95
„%eep‟ SELECT Sum(Sub3) FROM Student;
SName (Will give the Sum of marks of Subject3)

SUM(SUB3) WRITE SQL QUERIES
387.5
SELECT Avg(Sub1) FROM Student; i) To Display the Trainer name, City from table
(Will give the Average of Subject1) Trainer.
AVG(SUB1) A) SELECT TNAME, CITY from TRAINER;
64.83 ii) Display all details of table COURSE
SELECT Count(DISTINCT SName) FROM Student; A) SELECT * FROM COURSE;
( Will display 4)
iii) Display the Trainer Name, City & Salary in
COUNT(DISTINCT SNAME)
4 descending order of their Hiredate.
SELECT Count(SName) FROM Student; Ans:
( Will display 6) SELECT TNAME, CITY, SALARY FROM
COUNT(SNAME) TRAINER ORDER BY HIREDATE DESC;
6 iv) To display all the details of those trainers whose
Count – To count non-null values in a column
name ends with „A‟
Count(*) – To count total number of rows in a table.
13. Creating table from Existing Table:
A) select * from Trainer where Tname like „%A‟
CREATE TABLE PassStudent as (SELECT AdmnNo, v) Display all details from the table COURSE in
SName FROM Student WHERE (Sub1>=40.0 AND ascending order of their STARTDATE
Sub2>=40.0 AND Sub3>=40.0)); Ans:
14. Inserting the Results of a Query: SELECT * FROM COURSE ORDER BY
INSERT INTO PassStudent(admnno,sname)
SELECT AdmnNO, SName FROM Student
STARTDATE ASC;
WHERE (Sub1>=40.0 AND Sub2>=40.0 AND vi) To display CName and Fees of those Courses Whose
Sub3>=40.0); Fees range in between 10000-15000.
15. CREATE VIEW: A) select CName, Fees from Course where Fees
CREATE VIEW FailStudent AS SELECT * FROM between 10000 and 15000;
Student WHERE Div=‟Fail‟;
16. DELETE:
vii) To display total salary of trainers from city
DELETE FROM Student WHERE AdmnNo=1004; name ends with “I”.
(To delete a record, whose AdmnNo=1004) A) SELECT SUM(SALARY) FROM TRAINER
DELETE FROM Student; WHERE CNAME LIKE ‟%I‟;
(To delete all records of student)
17.DROP TABLE: viii) To display all Trainer Details from city “Mumbai”
DROP TABLE Student; Ans: SELECT * FROM TRAINER WHERE
18. DROP VIEW: CITY = ' Mumbai ' ;
DROP VIEW Failstudent;
19.Commit (To save the changes) ix) To display CName, Fees and StartDate of all
20.Rollback (for Undo) Courses which are started before 15th July 2018
Ans)
MODEL 1(VERY IMP) : TWO TABLES SELECT CNAME,FEES,STARTDATE FROM
1.Write SQL queries for (i) to (iv) and find COURSE WHERE STARTDATE< ' 2018-07-15;
outputs for SQL queries (v) to (viii), which are
based on the tables. 2019SP6 x) To display the last date (recent most) HIREDATE
from the table TRAINER
TRAINER
Ans: SELECT MAX(HIREDATE) FROM
TRAINER;
xi) To display the TNAME and CITY of Trainer
who joined the Institute in the month of
December 2001.
Ans:
SELECT TNAME, CITY FROM TRAINER
WHERE HIREDATE BETWEEN „2001-12-01‟
COURSE AND „2001-12-31‟;
OR
WHERE HIREDATE >= „2001-12-01‟ AND
HIREDATE<=„2001-12-31‟;
OR
WHERE HIREDATE LIKE „2001-12%‟;

xii) To display TNAME, HIREDATE, CNAME, (h) select TNAME, CITY, SALARY from
STARTDATE from tables TRAINER and TRAINER T, COURSE C where T.TID!=C.TID;
COURSE of all those courses whose FEES is less A) TNAME CITY SALARY
than or equal to 10000. ManiPrabha Chennai 69000
Ans:
SELECT TNAME,HIREDATE,CNAME, Note: 3 to 4 recent questions models are
STARTDATE FROM TRAINER, COURSE merged in the above question.
WHERE TRAINER.TID=COURSE.TID AND 2.Write SQL queries for (i) to (iv) and find outputs
FEES<=10000; for SQL queries (v) to (viii), which are based on the
xiii) To display CNAME, Fees, TName,City from tables (2016)
tbales Trainer and Course of all those persons
whose Hiredate Before Year 2000.
Ans) SELECT CNAME, FEES, TNAME, CITY
from TRAINER, COURSE WHERE
TRAINER.TID=COURSE.TID AND
HIREDATE<‟2000-01-01‟;
(XiV) To display number of Trainers from each
city.
Ans)SELECT CITY,COUNT(*) FROM TRAINER;
WRITE SQL OUTPUTS
(a) SELECT TID, TNAME, FROM TRAINER
WHERE CITY NOT IN(„DELHI‟,„MUMBAI‟);
Ans:
TID TNAME
103 DEEPTI
106 MANIPRABHA
(b) SELECT DISTINCT TID FROM COURSE;
Ans: DISTINCT TID
101 (i) To display CNO, CNAME, TRAVELDATE from
103 the table TRAVEL in descending order of CNO.
102 Ans SELECT CNO, CNAME, TRAVELDATE
104
105
FROM TRAVEL ORDER BY CNO DESC;
c) SELECT TID, COUNT(*), MIN(FEES) (ii) To display the CNAME of all the customers from
FROM COURSE GROUP BY TID HAVING the table TRAVEL who are traveling by vehicle with
COUNT(*)>1; code V01 or V02.
Ans: Ans SELECT CNAME FROM TRAVEL WHERE
TID COUNT(*) MIN(FEES) VCODE=„V01‟ OR VCODE=‟V02‟;
101 2 12000 OR
d) SELECT COUNT(*), SUM(FEES) FROM SELECT CNAME FROM TRAVEL WHERE
COURSE WHERE STARTDATE< „2018-09-15‟; VCODE IN („V01‟, „V02‟);
Ans: (iii) To display the CNO and CNAME of those
COUNT(*) SUM(FEES) customers from the table TRAVEL who
4 65000 travelled between „2015-12-31‟ and „2015-05-01‟.
(e) SELECT MIN(STARTDATE) FROM Ans SELECT CNO, CNAME from TRAVEL
COURSE; WHERE TRAVELDATE >=„2015-05-01‟
Ans) MIN(STARTDATE) AND TRAVELDATE <= „2015-12-31‟;
2018-07-02 OR
(f). SELECT MAX(STARTDATE), MIN(FEES) SELECT CNO, CNAME from TRAVEL
WHERE TRAVELDATE BETWEEN „2015-05-01‟
FROM COURSE;
A) max(StartDate) min(Fees) AND „2015-12-31‟ ;
2018-10-01 9000 OR
SELECT CNO, CNAME from TRAVEL
(g) SELECT CITY, SUM(SALARY) FROM
WHERE TRAVELDATE <= „2015-12-31‟
TRAINER GROUP BY CITY HAVING
AND TRAVELDATE >= „2015-05-01‟ ;
COUNT(*)>1 ;
OR
A) CITY SUM(SALARY)
SELECT CNO, CNAME from TRAVEL
MUMBAI 18,5000
WHERE TRAVELDATE BETWEEN „2015-12-31‟
DELHI 15,8000
AND „2015-05-01‟;
(iv) To display all the details from table TRAVEL for Ans SELECT Eno,Name FROM Employee
the customers, who have travel distance more than WHERE DOB BETWEEN „1987-01-01‟ AND „1991-12-01‟
120 KM in ascending order of NOP. OR
Ans SELECT * FROM TRAVEL SELECT Eno,Name FROM Employee
WHERE DOB >=„1987-01-01‟ AND DOB <=„1991-12-01‟ ;
WHERE KM > 120 ORDER BY NOP; OR
(v) SELECT COUNT(*),VCODE FROM TRAVEL SELECT Eno,Name FROM Employee
GROUP BY VCODE HAVING COUNT(*)>1; WHERE DOB >„1987-01-01‟ AND DOB <„1991-12-01‟;
Ans COUNT(*) VCODE (iv) To count and display FEMALE employees who
2 V01 have joined after '1986‐01‐01'.
2 V02 Ans SELECT count(*) FROM Employee
(vi) SELECT DISTINCT VCODE FROM TRAVEL; WHERE GENDER=‟FEMALE‟ AND DOJ > „1986-01-01‟;
Ans DISTINCT VCODE OR
V01 SELECT * FROM Employee
V02 WHERE GENDER=‟FEMALE‟ AND DOJ > „1986-01-01‟;
V03 (v) SELECT COUNT(*),DCODE FROM
V04 EMPLOYEE
V05 GROUP BY DCODE HAVING COUNT(*)>1;
vii) SELECT A.VCODE,CNAME, VEHICLETYPE Ans COUNT DCODE
FROM TRAVEL A,VEHICLE B WHERE 2 D01
A.VCODE=B.VCODE AND KM<90; 2 D05
Ans VCODE C NAME VEHICLETYPE (vi) SELECT DISTINCT DEPARTMENT FROM
V02 Ravi Anish AC DELUXE BUS DEPT;
V04 John Malina CAR Ans Department
(viii) SELECT CNAME,KM*PERKM INFRASTRUCTURE
FROM TRAVEL A,VEHICLE B MARKETING
WHERE A.VCODE=B.VCODE AND MEDIA
A.VCODE=‟V05‟; FINANCE
Ans CNAME KM*PERKM HUMAN RESOURCE
Sahanubhuti 2700 (vii) SELECT NAME, DEPARTMENT FROM
3. Consider the following DEPT and EMPLOYEE EMPLOYEE E, DEPT D WHERE
tables. Write SQL queries for (i) to (iv) and find E.DCODE=D.DCODE AND EN0<1003;
outputs for SQL queries (v) to (viii). (2015) Ans NAME DEPARTMENT
Table: DEPT George K INFRASTRUCTURE
Ryma Sen MEDIA
(viii) SELECT MAX(DOJ), MIN(DOB) FROM
EMPLOYEE;
Ans MAX(DOJ) MIN(DOB)
2014-06-09 1984-10-19
4.Answer the question (b) and (c) on the basis of
the following tables SHOPPE and ACCESSORIES.
(2014)
Table: SHOPPE
ID SName Area
S01 ABC Computronics CP
S02 All Infotech Media GK II
S03 Tech Shopee CP
S04 Geeks Techno Soft Nehru Place
S05 Hitech Store Nehru Place
Table: ACCESSORIES
ID Iname Price Sno
(i) To display Eno, Name, Gender from the table A01 Mother Board 12000 S01
EMPLOYEE in ascending order of Eno. A02 Hard Disk 5000 S01
Ans SELECT Eno,Name,Gender FROM Employee A03 Keyboard 500 S02
ORDER BY Eno; A04 Mouse 300 S01
A05 Mother Board 13000 S02
(ii) To display the Name of all the MALE employees
A06 Keyboard 400 S03
from the table EMPLOYEE. A07 LCD 6000 S04
Ans SELECT Name FROM Employee WHERE A08 LCD 5500 S05
Gender=‟MALE‟; A09 Mouse 350 S05
(iii) To display the Eno and Name of those employees A10 Harddisk 4500 S03
from the table EMPLOYEE w ho are born between
'1987‐01‐01' and '1991‐12‐01'.
Write a SQL query (1 to 4) 4 Table: SUPPLIERS
1. To display Name and Price of all the Accessories in SUPCODE SNAME CITY
ascending order of their Price. S01 GET ALL INC KOLKATA
A) Select Name, Price from ACCESSORIES order by
S03 EASY MARKET DELHI
Price.
CORP
2. To display Id and Sname of all Shopee located in Nehru S02 DIGI BUSY CHENNAI
Place; GROUP
A) Select Id, Sname from SHOPPE where Area = (b) To display the details of all the products in ascending
„Nehru Place; order of product names (ie PNAME)
3. To display Minimum and Maximum price of each Name A) SELECT * FROM PRODUCTS ORDER BY
of Accessories. PNAME;
A) Select Min(Price), Max(Price) from ACCESSORIES (c) To display product name and price of all those products
group by Name; whose price is in range of 10000 and 15000 (both values
inclusive).
4. To display Name, Price of all the Accessories and their A) SELECT PNAME, PRICE FROM PRODUCTS
respective SName where they are available. WHERE PRICE >=10000 AND PRICE >=15000;
A) Select Name, Price, SName from SHOPPE, (d) To display the number of products, which are supplied
ACCESSORIES where SHOPPE.Id= supplier. Ie, the expected output should be
ACCESSORIES.ID; S01 2
Write the output of the following SQL command S02 2
(1 to 4) ( 2014 ) 2 S03 1
1. SELECT DISTINCT NAME FROM A) SELECT SUPCODE, COUNT(SUPCODE) FROM
ACCESSORIES WHERE PRICE>=5000; PRODUCTS GROUP BY SUPCODE;
(E) To display the price, product name and quantity (ie qty) of
INAME those products which have quantity more than 100
Mother Board A) SELECT PRICE,PNAME, QTY FROM
Hard Disk PRODUCTS WHERE QTY>100;
LCD (f) To display the names of those suppliers, who are either
from DELHI or from CHENNAI.
2.SELECT AREA, COUNT(*),FROM SHOPPE A) SELECT SNAME FROM SUPPLIERS WHERE
GROUP BY AREA; CITY=”DELHI” OR CITY=”KOLKATA”;
AREA Count(*) (g) To display the name of the companies and the name of
CP 2 the products in descending order of company names.
GK II 1 A) SELECT COMPANY, PNAME FROM PRODUCTS
ORDER BY COMPANY DESC.
Nehru Place 2
3. SELECT COUNT(DISTINCT AREA) FROM (h) Obtain the outputs of the following SQL queries
based on the data given in tables PRODUCTS and
SHOPPE;
SUPPLIERS above.
COUNT(DISTINCT AREA) (h1) SELECT DISTINCT SUPCODE FROM PRODUCTS;
3 A)
SUPCODE
4. SELECT NAME, PRICE*0.05 DISCOUNT FROM S01
ACCESSORIES WHERE SNO IN(„S02‟,‟S03‟); S02
INAME DISCOUNT S03
Keyboard 25
(h2) SELECT MAX(PRICE), MIN(PRICE) FROM
Motherboard 650 PRODUCTS;
Keyboard 20 A)
Hard Disk 225 MAX (PRICE) MIN(PRICE)
5.Write SQL queries for (b) to (g) and write the outputs 28000 1100
for the SQL queries mentioned shown in (h1) to (h4) on (h3) SELECT PRICE*QTY AMOUNT FROM
basis of tables PRODUCTS and SUPPLIERS. (2013) PRODUCTS WHERE PID=104;
Table: PRODUCTS A)
PI PNAME QT PRIC COMPA UPC AMOUNT
D Y E NY ODE 55000
101 DIGITIAL 120 12000 RENIX S01 (h4) SELECT PNAME, SNAME FROM PRODUCTS P,
CAMERA 14X SUPPLIERS S WHERE P.SUPCODE=S.SUPCODE AND
102 DIGITAL PAD 11i 100 22000 DIGI POP S02 QTY>100;
104 PEN DRIVE 16 GB 500 1100 STOREKI S01
NG PNAME SNAME
106 LED SCREEN 32 70 28000 DISPEX S02 DIGITAL CAMERA 14X GET ALL INC
PERTS PEN DRIVE 16GB GET ALL INC
105 CAR GPS 60 12000 MOVEON S03
SYSTEM

6) Constider the following tables CARDEN and COUNT(*) Make
CUSTOMER and answer (b) and (c) parts of this 2 SUZUKJ:
question: (2012) 1 TATA
Table: CARDEN 1 TOYOTA
1 MERCEDES
Ccode CarName Make Color Cap Char
acit ge (iv) SELECT CarName FROM CARDEN WHE~ Capacity = 4;
y Ans CarName
501 A-Star Suzuki RED 3 14 Sx4
503 Indigo Tata SILVER 3 12 C Class
502 Innova Tovota WHITE 7 15 7) Consider the following tables EMPLOYEE and
509 SX4 Suzuki SILVER 4 14 SALGRADE and answer (b) and (c) parts of this
510 C Class Mercedes RED 4 35 questions. (2011)
Table: CUSTOMER
CCode Cname Ccode
1001 Hemant Sahu 501
1002 Raj Lal 509
1003 Feroza Shah 503
1004 Ketan Dhal 502
(b) Write SQL commands for the following
statements: 4
(i) To display the names of all silver colored Cars.
Ans SELECT CarName FROM CARDEN
WHER Color = „SILVER';
(ii) To display name of car, make and capacity of cars in
descending order of their sitting capacity.
Ans SELECT CarName, Make, Capacity FROM
CARDEN ORDER BY Capacity DESC;
(iii) To display the highest charges at which a vehicle can
be hired from CARDEN.
Ans SELECT MAX(Charges) FROM CARDEN ; (b) Write SQL commands for the following statements:
OR (i) To display the details of all EMPLOYEEs, in descending
SELECT CarName, MAX(Charges)FROM CARDEN order of DOJ
GROUP BY CarName; Ans SELECT * FROM EMPLOYEE ORDER BY DOJ
(iv) To display the customer name and the corresponding DESC;
name of the cars hired by them. (ii) To display NAME and DE51G of those EMPLOYEEs,
Ans SELECT CName, CarName FROM CUSTOMER, whose 5ALGRADE is either 502 or 503
CARDEN WHERE CUSTOMER.Ccode = Ans SELECT NAME, DESIG FROM EMPLOYEE
CARDEN.Ccode; OR WHERE SGRADE = 'S02' OR SGRADE= 'S03';
SELECT CUSTOMER. CName, CARDEN. CarName OR
FROM CUSTOMER, CARDEN WHERE SELECT NAME, DESIG FROM EMPLOYEE
CUSTOMER.Ccode = CARDEN.Ccode; WHERE SALGRADE ='S02' OR SALGRADE='S03';
OR (iii) To display the content of all the EMPLOYEEs table,
SELECT CName, CarName FROM CUSTOMER A, whose DOJ is in between'09-Feb-2006' and '08-Aug-2009'.
CARDEN B WHERE A.Ccode = B.Ccode; Ans SELECT * FROM EMPLOYEE
OR WHERE DOJ BETWEEN '09-Feb-2006'and '08-Aug-
SELECT A. CName, B. CarName FROM CUSTOMER 2009'; OR
A, CARDEN B WHERE A.Ccode = B.Ccode; SELECT * FROM EMPLOYEE WHERE DOJ > = '09-
Fab-2006' and DOJ <='08-Aug-2009';
(c) Give the output of the following SOL queries:
(i) SELECT COUNT (DISTINCT Make) FROM OR
CARDEN; SELECT * FROM EMPLOYEE
Ans COUNT (DISTINCT Make) WHERE DOJ > '09-Feb-2006' and DOJ <' 08-Aug-
4 2009" ;
(iv) To add a new row with the following:
(ii) SELECT MAX (Charges), MIN (Charges) FROM 109, 'Harish Roy', 'HEAD-IT', 'S02', '09-Sep-2007, '21-Apr-
CARDEN; 1983'
Ans MAX (Charges) MIN (Charges) Ans INSERT INTO EMPLOYEE
35 12 VALUES(109,'Harish Roy' ,'HEAD-IT' ,'S02' ,'09-Sep-
(iii) SELECT COUNT (*), Make FROM CARDEN; 2007' ,'21-Apr-1983' ) ;
Ans (Ignoring Make for display)
COUNT (*) (c) Give :the output of the following SQL queries: 2
5 (i) SELECT COUNT (SGRADE),SGRADE FROM
OR EMPLOYEE GROUP
(assuming the presence of GROUP By Make) BY SGRADE;
Ans COUNT (SGRADE) SGRADE b2)Give the output of the following SQL queries:2
1 S01 Note: In all output Questions ignore Column
2 S02 Headings
2 S03 (i) SELECT COUNT(DISTINCT Scode) FROM
(ii) SELECT MIN(DOB), MAX (DOJ) FROM Store;
EMPLOYEE; Ans. COUNT(DISTINCT Scode)
Ans MIN (DOB) MAX (DOJ) 3
13-Jan-1980 12-Feb-2010
(ii) SELECT Rate*Qty FROM Store WHERE
(iii) SELECT NAME , SALARYFROM EMPLOYEE E, ItemNo=2004;
SALGRADE S WHERE Ans. RATE*QTY
E.SGRADE= S.SGRADE AND E.ECODE<103; 880
Ans Name Salary (iii) SELECT Item,Sname FROM Store S, Suppliers P
Abdul Ahmad 24000
WHERE S.Scode=P.Scode AND ItemNo=2006;
Ravi Chander 32000
Ans. ITEM SNAME Gel Pen Classic Premium
(iv) SELECT SGRADE, SALARY+HRA ET:)M Stationers
SALGRADE WHERE SGRADE= 'S02'; (iv) SELECT MAX(LastBuy) FROM Store;
Ans SGRADE SALARY+HRA Ans. MAX (LASTBUY)
S02 44000
24-Feb-10
8) Consider the following tables STORE and
9) Consider the following tables GARMENT and FABRIC.
SUPPLIERS and answer (bl) and (b2) parts of this Write SQL commands for the statements (i) to (iv) and give
question: (D 2010) outputs for SQL queries (v) to (viii) (D2009)6
b1)Write SQL commands for the following

statements:4 (i) To display details of all the items in
the Store table in ascending order of LastBuy.
Ans. SELECT * FROM STORE ORDER BY
LastBuy;
(i) To display GCODE and DESCRIPTION of each
(ii) To display ItemNo and Item name of those items
GARMENT in descending order of GCODE
from Store table whose Rate is more than 15 Rupees. Ans SELECT GeODE, DESCRIPTION FROM
Ans. SELECT ItemNo, Item..In FROM STORE GARMENT ORDER BY GCODE DESC;
WHERE Rate >15; (ii) To display the details of all the GARMENTs, which
(iii) To display the details of those items whose have READYDA TE in between 08-DEC-07 and 16-JUN-
Supplier code (Scode) is 22 or Quantity in Store (Qty) 08(inclusive of both the dates).
is more than 110 from the table Store. Ans) SELECT * FROM GARMENT WHERE READYDATE
Ans. SELECT * FROM STORE WHERE Scode = BETWEEN‟ 08-DEC-07‟AND , 16-JUN-08‟ ;
OR
22 OR Qty >110; SELECT * FROM DRESS WHERE LAUNCHDATE >= „08-
(iv) To display Minimum Rate of items for each DEC-07‟ AND LAUNCHDATE<=‟16-JUN-08‟;
Supplier individually as per Scode from the table (iii) To display the average PRICE of all the GARMENTs,
Store. which are made up of FABRIC with FCODE as F03.
Ans. SELECT Scode, MIN(Rate) FROM STORE Ans) SELECT AVG (PRICE) FROM GARMENT
GROUP BY Scode; WHERE FCODE = „F03‟;
(iv) To display FABRIC wise highest and lowest price of Ans SELECT * FROM DRESS WHERE
GARMENTs from GARMENT table. (Display FCODE of LAUNCHDATE BETWEEN „05-DEC-07‟ AND ‟20-
each GARMENT along with highest and lowest price) JUN-08‟ OR
Ans SELECT FCODE, MAX (PRICE), MIN(PRICE) SELECT * FROM DRESS WHERE LAUNCHDATE
FROM GARMENT GROUP BY FCODE; >= „05-DEC-07‟ AND LAUNCHDATE<= ‟20-JUN-08‟
(v) SELECT SUM (PRICE) FROM GARMENT WHERE (iii) To display the average PRICE of all the dresses which
FCODE = „F01‟ ; are made up of material with MCODE as M003.
Ans SUM (PRICE) Ans SELECT AVG(PRICE) FROM GARMENT
2600 WHERE MCODE = „M003‟
(vi) SELECT DESCRIPTION, TYPE FROM GARMENT, (iv) To display materialwise highest and lowest price of
FABRIC WHERE GARMENT.FCODE = dresses from DRESS table. (Display MCODE of each dress
FABRIC.FCODE AND GARMENT. PRICE > = 1260 ; along with highest and lowest price)
Ans) DESCRIPTION TYPE Ans SELECT MCODE, MAX(PRICE), MIN (PRICE)
INFORMAL SHIRT COTTON FROM DRESS GROUP BY MCODE
INFORMAL PANT COTTON (v) SELECT SUM(PRICE) FROM DRESS WHERE
FORMAL PANT TERELENE MCODE=„M001‟;
Ans SUM(PRICE)
(vii) SELECT MAX (FCODE) FROM FABRIC;
2700
Ans MAX (FCODE)
(vi) SELECT DESCRIPTION, TYPE FROM DRESS,
F04
MATERIAL WHERE DRESS.DCODE =
(viii) SELECT COUNT (DISTINCT PRICE) FROM
MATERIAL.MCODE AND DRESS.PRICE>=l250;
GARMENT ;
Ans DESCRIPTION TYPE
Ans COUNT(DISTINCT PRICE)
(NO OUTPUT)
7
(vii) SELECT MAX(MCODE) FROM MATERIAL;
(10) Consider the following tables DRESS and Ans MAX (MCODE)
MATERIAL. Write SQL commands for the statements MOO4
(i) to (iv) and give outputs for SQL queries (v) to (viii). (viii) SELECT COUNT(DISTINCT PRICE) FROM
(2009 OD) 6 DRESS;
Ans COUNT(DISTINCT PRICE)
6
11) Consider the following tables Product and Client.
Write SQL commands for the statement (i) to (iv) and
give outputs for SQL queries (v) to (viii) (D 2008)
Table: PRODUCT
P_ID Product Name Manufact Price
urer
TP01 Talcom Powder LAK 40
FW05 Face Wash ABC 45
BS01 Bath Soap ABC 55
SH06 Shampoo XYZ 120
FW12 Face Wash XYZ 95
Table: CLIENT
C_ID Client Name City P_ID
01 Cosmetic Shop Delhi FW05
06 Total Health Mumbai BS01
12 Live Life Delhi SH06
15 Pretty Woman Delhi FW12
16 Dreams Banglore TP01
(i) To display the details of those Clients whose city is
Delhi.
Ans: Select all from Client where City=”Delhi”
(ii)To display the details of Products whose Price is in the
range of 50 to 100 (Both values included).
Ans: Select all from product where Price between 50
and 100
(i) To display DCODE and DESCRIPTION of each dress in
ascending order of DCODE. (iii) To display the ClientName, City from table Client, and
Ans SELECT DCODE. DESCRIPTION FROM DRESS ProductName and Price from table Product, with their
ORDER BY DCODE ; corresponding matching P_ID.
(ii) To display the details of all the dresses which have Ans: Select ClientName,City, ProductName, Price
LAUNCHDATE in between 05-DEC‟-07 and 20-JUN-08 from Product,Client where Product.P_ID= Client.P_ID.
(inclusive of both the dates). (iv) To increase the Price of all Products by 10
Ans: Update Product Set Price=Price +10

(v)SELECT DISTINCT Address FROM Client. (iii)To display the CustomerName, City from table
Ans: ( The above question may consist DISTINCT City. If Customer, and ItemName and Price from table Item, with
it is DISTINCT City, the following is the answer) their corresponding matching I_ID.
City Ans: SELECT CUSTOMERNAME,CITY,
----- ITEMNAME, PRICE FROM ITEM,CUSTOMER
Delhi WHERE ITEM.I_ID=CUSTOMER.I_ID.
Mumbai (iv) To increase the Price of all Items by 1000 in the table
Bangalore Item.
Ans: UPDATE ITEM SET PRICE=PRICE+1000
(vi)SELECT Manufacturer, MAX(Price), Min(Price),
Count(*) FROM Product GROUP BY Manufacturer; (v)SELECT DISTINCT City FROM Customer.
Ans: Ans: City
Manufacturer Max(Price) Min(Price) Count(*) Delhi
LAK 40 40 1 Mumbai
ABC 55 45 2 Bangalore
XYZ 120 95 2 (vi)SELECT ItemName, MAX(Price), Count(*) FROM
(vii)SELECT ClientName, ManufacturerName FROM Item GROUP BY ItemName;
Product, Client WHERE Client.Prod_Id=Product.P_Id; Ans: ItemName Max(Price) Count(*)
Ans: ClientName ManufacturerName Personal Computer 37000 3
Cosmetic Shop ABC Laptop 57000 2
Total Health ABC (vii)SELECT CustomerName, Manufacturer FROM
Live Life XYZ Item, Customer WHERE Item.Item_Id=Customer.Item_Id;
Pretty Woman XYZ Ans: CustomerName ManufacturerName
Dreams LAK N.Roy PQR
(viii)SELECT ProductName, Price * 4 FROM Product. H.Singh XYZ
ProductName Price*4 R.Pandey COMP
Talcom Poweder 160 C.Sharma PQR
Face Wash 180 K.Agarwal ABC
Bath Soap 220 (viii)SELECT ItemName, Price * 100 FROM Item
Shampoo 480 WHERE Manufacturer = „ABC‟;
Face Wash 380 Ans: ItemName Price*100
Personal Computer 3500000
12) Consider the following tables Item and Customer. Laptop 5500000
Write SQL commands for the statement (i) to (iv) and
give outputs for SQL queries (v) to (viii) (OD 2008) 13) Consider the following tables Consignor and
Consignee. Write SQL command for the
Table: ITEM statements(i)to(iv) And give outputs for the SQL quries
I_ID Item Name Manufa Price (v) to ( viii). (OD2007) 6
cturer TABLE : CONSIGNOR
PC01 Personal ABC 35000 CnorI CnorNa CnorAddress City
Computer D me
LC05 Laptop ABC 55000 ND01 R singhal 24,ABC New Delhi
PC03 Personal XYZ 32000 Enclave
Computer ND02 Amit 123,Palm New Delhi
PC06 Personal COMP 37000 Kumar Avenue
Computer MU15 R Kohil 5/A,South,Street Mumbai
LC03 Laptop PQR 57000 MU50 S Kaur 27-K,Westend Mumbai
TABLE : CONSIGNEE
Table: CUSTOMER Cnee CnorI CneeNam CneeAddress Cnee
C_I Customer Name City I_ID ID D e City
D MU0 ND01 Rahul 5,Park Avenue Mum
01 N.Roy Delhi LC03 5 Kishore bai
06 H.Singh Mumbai PC03 ND08 ND02 P Dhingra 16/j,Moore New
12 R.Pandey Delhi PC06 Enclave Delhi
15 C.Sharma Delhi LC03 KO19 MU15 A P Roy 2A,Central/av Kolka
16 K.Agarwal Banglore PC01 enue ta
(i) To display the details of those Customers whose city is MU3 ND02 S mittal P 245, AB Mum
Delhi. 2 Colony bai
Ans: SELECT ALL FROM CUSTOMER WHERE ND48 MU50 B P jain 13,Block New
CITY=”DELHI” d,a,viha Delhi
(ii)To display the details of Item whose Price is in the range (i)To display the names of all consignors from Mumbai.
of 35000 to 55000 (Both values included). Ans: SELECT CNORNAME FROM CONSIGNOR
Ans: SELECT ALL FROM ITEM WHERE WHERE CITY=”MUMBAI”;
PRICE>=35000 AND PRICE <=55000 (ii)To display the cneeID, cnorName, cnorAddress,
CneeName, CneeAddress for every Consignee.

Ans: SELECT CNEEID, CNORNAME, Ans: SELECT * FROM SENDER ORDER BY
CNORADDRESS, CNEENAME, CNEEADDRESS SENDERNAME;
FROM CONSIGNOR,CONSIGNEE WHERE (iv)To display number of Recipients from each city.
CONSIGNOR.CNORID=CONSIGNEE.CNORID; Ans: SELECT RECCITY,COUNT(*) FROM
(iii)To display the consignee details in ascending order of RECIPIENT GROUP BY RECCITY;
CneeName.
Ans: SELECT * FROM CONSIGNEE ORDERBY (v) SELECT DISTINCT SenderCity FROM Sender;
CNEENAME ASC; Ans: DISTINCT(SENDERCITY)
(iv)To display number of consignors from each city. NewDelhi
Ans: SELECT CITY, COUNT(*) FROM Mumbai
(vi) SELECT A.SenderName A, B.RecName FROM
CONSIGNORS GROUP BY CITY;
Sender A, Recipient B WHERE A.SenderID=B. SenderID
(v)SELECT DISTINCT City FROM CONSIGNEE; AND B.RecCity=‟Mumbai‟;
Ans: CneeCity Ans: SenderName RecName
Mumbai R.Jain H.Singh
New Delhi S.Jha P.K.Swamy
Kolkata (vii)SELECT RecName,RecAddress FROM Recipient
(vi) SELECT A.CnorName A, B.CneeName B FROM WHERE RecCity Not IN („Mumbai‟, Kolkata‟);
Consignor A, Consignee B WHERE A.CnorID=B.CnorID Ans: RecName RecAddress
AND B.CneeCity=‟Mumbai‟; S Mahajan 116, A Vihar
S Tripati 13, B1 D, Mayur Vihar
(viii) SELECT RecID, RecName FROM Recipient
WHERE SenderID = „MU02‟ OR SenderID = „ND50‟;
Ans) Ans: RecID RecName
(vii)SELECT CneeName,CneeAddress FROM Consignee ND08 S Mahajan
WHERE CneeCity Not IN („Mumbai‟, „Kolkata‟); ND48 S Tripathi
Ans:
CneeName CneeAddress 15) Study the following tables FLIGHTS and FARES
P Dhingra 16/J,Moore Enclave and write SQL commands for the questions (i) to (iv)
B P Jain 13,Block D,A Vihar and give outputs for SQL quires (v) to(vi). (OD 2006)
(viii) SELECT CneeID, CneeName FROM Consignee TABLE: FLIGHTS
WHERE CnorID = „MU15‟ OR CnorID = „ND01‟;
Ans: CneeID CneeName
MU05 Rahul Kishore
KO19 A P Roy
14)Consider the following tables. Write SQL command
for the statements (i)to(iv)and give outputs for the SQL
quries (v) to (viii). (D2006) 6
TABLE : SENDER
SenderI SenderNa Sender Sender
D me Address City
ND01 R jain 2,ABC Appts New Delhi
MU02 H sinha 12, Newton Mumbai
MU15 S haj 27/ A,Park Street New Delhi TABLE:FARES
ND50 T Prasad 122-K,SDA Mumbai
TABLE :RECIPIENT
Sender ReCName RecAddress ReCCit
RecID ID y
KO05 ND01 R Bajpayee 5,Central Avenue Kolkata
ND08 MU02 S Mahajan 116, A Vihar New
Delhi
MU19 ND01 H sing 2A,Andheri East Mumbai
MU32 MU15 P K swamy B5, CS Terminus Mumbai
ND48 ND50 S Tripathi 13, B1 D,Mayur New
Vihar Delhi (i) Display FL_NO and NO_FLIGHTS from “KANPUR”
(i)To display the names of all senders from Mumbai. TO “BANGALORE” from the table FLIGHTS.
Ans:SELECT * FROM SENDER WHERE Ans: SELECT FL_NO, NO_FLIGHTS FROM
SENDERCITY=‟MUMBAI‟; FLIGHTS WHERE STARTING=”KANPUR” AND
(ii)To display the recID, senderName, senderAddress, ENDING=”BANGALORE”
RecName, RecAddress for every recipt. (ii) Arrange the contents of the table FLIGHTS in the
Ans: SELECT RECID, SENDERNAME, ascending order of FL_NO.
SENDERADDRESS, RECNAME, RECADDRESS Ans: SELECT * FROM FLIGHTS ORDER BY FL_NO;
FROM SENDER, RECIPIENT WHERE (iii) Display the FL_NO and fare to be paid for the flights
SENDER.SENDERID=RECIPIENT.RENDERID; from DELHI to MUMBAI using the tables FLIGHTS and
(iii)To display the sender details in ascending order of FARES, where the fare to be paid =
SenderName. FARE+FARE+TAX%/100.
Ans: SELECT FL_NO, FARE+FARE+(TAX%/100) (iv) Display the highest consultation fee among all male
FROM FLIGHTS, FARES WHERE doctors.
STARTING=”DELHI” AND ENDING=”MUMBAI” Ans: SELECT MAX(CONSULATION) FROM
(iv) Display the minimum fare “Indian Airlines” is offering DOCTOR,SALARY WHERE SEX=”M” AND
from the tables FARES. DOCTOR.ID=SALARY.ID
Ans: SELECT MIN(FARE) FROM FARES WHERE
AIRLINES=”INDIAN AIRLINES” (v) SELECT count (*) from DOCTOR where SEX = “F”
Ans: 4
v)Select FL_NO,NO_FLIGHTS, AIRLINES from
FLIGHTS, FARES Where STARTING = “DELHI” AND (vi) SELECT NAME, DEPT , BASIC from DOCTOR,
FLIGHTS.FL_NO = FARES.FL_NO SALRY Where DEPT = “ENT” AND DOCTOR.ID =
Ans: SALARY.ID
Ans: Name Dept Basic
Jonah Ent 12000
17) Consider the following tables EMPLOYEES and
EMPSALARY. write SQL commands for the
Statements (i) to (iv) and give outputs for SQL quires (v)
(vi) SELECT count (distinct ENDING) from FLIGHTS. to (viii).(D2005)
Ans: 7 EMPLOYEES
16) Study the following tables DOCTOR and SALARY
and write SQL commands for the questions (i) to (iv)
and give outputs for SQL queries (v) to (vi) (D2006):
TABLE: DOCTOR
EMPSALRAY
TABLE: SALARY
(i) To display Firstname, Lastname, Address and City of

(i) Display NAME of all doctors who are in “MEDICINE” all employees living in Paris from the table
having more than 10 years experience from the Table EMPLOYEES.
DOCTOR. Ans: SELECT FIRSTNAME, LASTNAME,
Ans: SELECT NAME FROM DOCTOR WHERE ADDRESS,CITY FROM EMPLOYEES WHERE
DEPT=”MEDICINE” AND EXPERIENCE>10 CITY=”PARIS”
(ii) Display the average salary of all doctors working in (ii) To display the content of EMPLOYEES table in
“ENT”department using the tables DOCTORS and descending order of FIRSTNAME.
SALARY Salary =BASIC+ALLOWANCE. Ans: SELECT * FROM EMPLOYEES ORDER BY
Ans: SELECT AVG(BASIC+ALLOWANCE) FROM FIRSTNAME DESC
DOCTOR,SALARY WHERE DEPT=”ENT” AND
DOCTOR.ID=SALARY.ID (iii) To display the Firstname, Lastname, and Total Salary
(iii) Display the minimum ALLOWANCE of female of all managers from the tables, where Total Salary is
doctors. calculated as Salary+Benifts.
Ans: SELECT MIN(ALLOWANCE) FROM Ans: SELECT FIRSTNAME, LASTNAME,
DOCTRO,SALARY WHERE SEX=”F” AND SALARY+BENEFITS FROM EMPLOYEES,
DOCTOR.ID=SALARY.ID EMPSALARY WHERE DESIGNATION =

”MANAGER” AND EMPLOYEES.EMPID (ii) To display the content of workers table in ascending
=EMPSALARY.EMPID order of LASTNAME.
(iv) To display the Maximum salary among Managers and Ans:SELECT * FROM WORKER ORDER BY
Clerks from the table EMPSALARY. LASTNAME ASC
Ans: SELECT DESIGNATION,MAX(SALARY) (iii) To display the FIRSTNAME, LASTNAME and Total
FROM EMPSALARY WHERE Salary of all Clerks from the tables WORKERS And
DESIGNATION=”MANAGER” OR DESIG, where Total
DESIGNATION=”CLERK” salary is calculated as Salary + benifts.
(v) SELECT FIRSTNAME,SALARY FROM Ans: SELECT FIRSTNAME, LASTNAME,
EMPLOYEES,EMPSALARY WHERE DESTINATION SALARY+BENEFITS WHERE WORKER.W_ID=
=‟Salesman‟ AND DESG.W_ID AND DESIGNATION=”CLERK”
EMPOLYEES.EMPID=EMPSALARY.EMPID; (iv) To display the minimum salary among managers and
Ans: Firstname Salary Clerks from the tables DESIG.
Rachel 32000 Ans:
Peter 28000 SELECT MIN(SALARY), DESIGNATION FROM DESIG
(vi) SELECT COUNT (DISTINT DESIGNATION ) WHERE DESIGNATION IN ('MANAGER'.'CLERK')
FROM EMPSALARY GROUP BY DESIGNATION;
Ans: 4 OR
SELECT MIN(SALARY), DESIGNATION FROM DESIG
(vii) SELECT DESIGNATION , SUM(SALARY)
WHERE DESIGNATION= „MANAGER‟ OR
FROM EMPSALARY GROUP BY DESIGNATION DESIGNATION='CLERK' GROUP BY DESIGNATION;
HAVING COUNT(*)>2; OR
Ans: Designation Sum(Salary) SELECT MIN(SALARY) FROM DESIG WHERE
Manager 215000 DESIGNATION=„MANAGER‟ OR
Clerk 135000 DESIGNATION='CLERK';
(viii)SELECT SUM (BENEFITS) FROM EMPSALARY OR
WHERE DESIGNATION=‟Clerk‟; SELECT MIN(SALARY) FROM DESIG WHERE
Ans: 32000 DESIGNATION IN („MANAGER‟,„CLERK‟);
18) Consider the following tables WORKERS and (v) SELECT FIRSTNAME, SALARY FROM WORKERS,
DESIG. Write SQL commands for the statements (i) to DESIG WHERE DESIGINATION = “MANAGER” AND
(iv) and give outputs for SQL queries (v) to (viii).(OD WORKERS.W_ID = DESIGN.W_ID
2005) Ans: FIRSTNAME SALARY
WORKERS Sam 75000
Manila 70000
George 75000
(vi)SELECT COUNT(DISTINCT DESIGNATION)
FROM DESIGN ;
Ans: 4
(vii) SELECT DESIGNATION, SUM(SALARY) FROM
DESIG GROUP BY DESIGNATION HAVING COUNT
(*) < 3;
Ans: Designation Sum(Salary)
Director 85000
Salesman 60000
(viii) SELECT SUM(BENIFTS) FROM DESIG WHERE
DESIGINATION=”salesman”;
Ans: 15000
DESIG 19. Give the following table for database a LIBRARY.
(2004)
TABLE : BOOKS
(i) To display W_ID Firstname, address and City of all

employees living in New York from the Table WORKERs
Ans: SELECT W_ID , FIRSTNAME,ADDRESS, CITY
FROM WORKERS WHERE CITY=”NEW YORK”

TABLE:ISSUED TABLE:NEWONES
Write SQL queries from b to g.

(b)To show Book name, Author name and Price of books of
EPB publisher. (b) To show all information about the sofas from the
Ans: SELECT BOOK_NAME,AUTHOR_NAME, INTERIORS table.
PRICE FROM BOOKS WHERE PUBLISHER =”EPB” Ans: SELECT * FROM INTERIORS WHERE TYPE=
(c) To list the names of the books of FICTIONS type. “SOFA”
Ans: SELECT BOOK_NAME FROM BOOKS (d) To list ITEMNAME and TYPE of those items, in which
WHERE TYPE=”FICTION” DATEOFSTOCK is before 22/01/02 from the INTERIORS
(d) To display the names and prices of the books in table in descending order of ITEMNAME.
descending order of their price. Ans: SELECT ITEMNAME,TYPE FROM
Ans: SELECT BOOK_NAME, PRICE FROM BOOKS INTERIORS WHERE DATEOFSTOCK<‟22/01/02‟
ORDER BY PRICE DESC; ORDER BY ITEMNAME
(e) To increase the price of all books of First Pub.by 50. (e) To display ITEMNAME and DATEOFSTOCK of those
Ans: UPDATE BOOKS SET PRICE= PRICE+50 items in which the Discount percentage is more than 15
WHERE PUBLISHERS = “FIRST PUBL” from INTERIORS.
(f) To Display the Book_ID, Book_Name and Quantity Ans: SELECT ITEMNAME,DATEOFSTOCK FROM
Issued for all books Which have been issued. INTERIORS WHERE DISCOUNT>15
Ans:SELECT BOOK_ID, BOOK_NAME, (f) To count the number of items whose type is “Double
QUANTITY_ISSUED FROM BOOKS,ISSUED bed”;
WHERE BOOKS.BOOKID= ISSUED.BOOKID; Ans: SELECT COUNT(*) FROM INTERIORS
(g) To insert a new row in the table Issued having the WHERE TYPE=”DOUBLE BED”
following data: “F0002”,4 (g) To insert new row in the NEWONES table with the
Ans: INSERT INTO ISSUED VALUES(“F0002”,4) following data: 14, “True Indian “, “Office Table “,
{28/03/03},15000,20
(h) Give the output of the following queries on the above Ans: INSERT INTO NEWONES VALUES (14,”TRUE
tables INDIAN”,”OFFICE TABLE”,‟28/03/03‟,15000,20)
(i) Select Count(Distinct Publishers) From Books
(h) Give the outputs for the following SQL statements.
Ans: 3
(ii) Select Sum(Price) From Books Where Quantity>5 (i) Select COUNT (distinct TYPE) from INTERIORS;
Ans: 1350 Ans: 5
(iii) Select Book_Name,Author_Name From Books Where (ii) Select AVG(DISCOUNT)from INTERIORS where
Price<500 TYPE =”Baby cot”;
Ans: Book_Name Author_Name Ans: 13
My First C++ Brian & Brooks (iii) Select SUM(price)from INTERIORS where
C++ Brainworks A.W.Rossaine DATEOFSTOCK<{12/02/02};
Fast Cook Lata Kapoor Ans: 53000
(iv) Select Count(*) From Books 21)Consider the following tables ACTIVITY and
Ans: 5 COACH and answer (b) and (c) parts of this question:
20.Write SQL commands for (b) to (g) and write the (MP109-10)
outputs for (h) on the basis of tables TNTERIORS and
NEWONES. (2003)
TABLE: INTERIORS

b)Write SQL commands for the flowing statements:4 Ans) SELECT * FROM Games ORDER BY
(i) To display the names of all activities with their Acodes ScheduleDate;
in descending order. (iv) To display sum of PrizeMoney for each Type of
Ans) SELECT Acodes, ActivityName FROM GAMES
ACTIVITY ORDER BY Acode DESC; Ans) SELECT SUM(Prizemoney),Type FROM Games
(ii) To display sum of PrizeMoney for the Activities played GROUP BY Type;
in each of the Stadium separately.
c) Give the output of the following SQL queries: 2
Ans) SELECT SUM(PrizeMoney), Stadium FROM
(i) SELECT COUNT(DISTINCT Number) FROM
ACTIVITY GROUP BY Stadium;
GAMES;
(iii) To display the coach's name and ACodes in ascending
Ans) 2
order of ACode from the table COACH
Ans) SELECT Name, Acode FROM COACH ORDER (ii) SELECT MAX(ScheduleDate), MIN(ScheduleDate)
BY Acode; FROM GAMES;
(iv) To display the content of the Activity table whose Ans) 19-Mar-2004 12-Dec-2003
ScheduleDate earlier than 01/01/2004 in ascending order of (iii) SELECT Name, GameName FROM GAMES G,
ParticipantsNum. PLAYER P WHERE G.Gcode=P.Gcode AND
Ans) SELECT * FROM ACTIVITY WHERE G.PrizeMoney>10000;
SchduleDate<'01-Jan-2004' ORDER BY Ans) Ravi Sahai Lawn Tennis
ParticipantsNum; (iv) SELECT DISTINCT Gcode FROM PLAYER;
Ans) 3
c) Give the output of the following SQL queries:2
(i) SELECT COUNT(DISTINCT ParticipantsNum) FROM 23)Consider the following tables ACTIVITY and
ACTIVITY; COACH. Write SQL commands for the statements (i) to
Ans) 3 (iv) and give outputs for SQL queries (v) to (viii)
(ii)SELECT MAX(ScheduleDate), MIN(ScheduleDate) (MP108-09) 6
FROM ACTIVITY;
Ans) 19-Mar-2004 12-Dec-2003
(iii) SELECT Name,ActivityName FROM ACTIVITY
A,COACH C WHERE A.Acode= C.Acode AND
A.ParticipantsNum = 10;
Ans) Ravinder Discuss Throw
(iv) SELECT DISTINCT Acode FROM COACH;
Ans) 1001
1003
1008
22) Consider the following tables GAMES and PLAYER

and answer (b) and (c) parts of this question (MP209-10)
i)To display the name of all activities with their Acodes in

descending order.
Answer: SELECT ActivityName, ACode FROM
ACTIVITY ORDER BY Acode DESC;
(ii) To display sum of PrizeMoney for each of the Number
of participants groupings (as shown in column
ParticipantsNum 10,12,16)
Answer: SELECT SUM(PrizeMoney), ParticipantsNum
FROM ACTIVITY GROUP BY ParticipantsNum;
(iii) To display the coach‟s name and ACodes in
ascending order of ACode from the table COACH
Answer: SELECT Name, ACode FROM COACH
ORDER BY ACode;
(iv) To display the content of the ACTIVITY table whose
ScheduleDate earlier than 01/01/2004 in ascending order of
ParticipantsNum.
b)Write SQL commands for the flowing statements:4
Answer: SELECT * FROM ACTIVITY WHERE
(i) To display the name of all GAMES with their GCodes
ScheduleDate<‟01-Jan-2004‟ ORDER BY
Ans) SELECT GameName,Gcode FROM GAMES;
ParticipantsNum;
(ii) To display details of those GAMES which are having
PrizeMoney more than 7000. v)SELECT COUNT(DISTINCT ParticipantsNum) FROM
Ans) SELECT * FROM Games WHERE ACTIVITY;
Prizemoney>7000; Answer: 3
(iii) To display the content of the GAMES table in (vi)SELECT MAX(ScheduleDate), MIN(ScheduleDate)
ascending order of Schedule Date. FROM ACTIVITY;
Answer: SUM(PERIODS) SUBJECT
19-Mar-2004 12-Dec-2003 51 ENGLISH
(vii) SELECT SUM(PrizeMoney) 76 PHYSICS
FROM ACTIVITY; 24 MATHS
Answer: 54000 27 CHEMISTRY
(viii) SELECT DISTINCT (vi) SELECT TEACHERNAME, GENDER FROM
ParticipantsNum FROM ACTIVITY; SCHOOL, ADMIN WHERE DESIGNATION
Answer: 16 =‟COORDINATOR‟ AND
10 SCHOOL.CODE=ADMIN.CODE;
12 TEACHERNAME GENDER
24) Consider the following tables SCHOOL and PRIYA RAI FEMALE
ADMIN. Write SQL commands for the statements LISA ANAND FEMALE
(i) to (iv) and give outputs for SQL queries (v) to (vii) SELECT DESIGNATION, COUNT(*) FROM
(viii). ADMIN GROUP BY DESIGNATION HAVING
TABLE: SCHOOL COUNT(*)>1;
COD TEACHE SUBJECT DOJ PERI EXP DESIGNATION COUNT(*)
E RNAME ODS ERI COORDINATOR 2
ENC HOD 2
E
1001 RAVI ENGLISH 12/03/2000 24 10 SENIOR TEACHER 2
SHANKAR (viii) SELECT COUNT(DISTINCT SUBJECT) FROM
1009 PRIYA PHYSICS 03/09/1998 26 12 SCHOOL;
RAI COUNT(*)
1203 LISA ENGLISH 09/04/2000 27 5
ANAND 4
1045 YASHRAJ MATHS 24/08/2000 24 15
1123 GAMAM PHYSICS 16/07/1999 28 3 MODEL 2 : SINGLE TABLE
1167 HARISH B CHEMISTRY 19/10/1999 27 5 25. Given the following Teacher Relation. (2002)
Write SQL Commands fro (b) to (g)
1215 UMESH PHYSICS 11/05/1998 22 16
TABLE: ADMIN
CODE GENDER DESIGNATION
1001 MALE VICE PRINCIPAL
1009 FEMALE COORDINATOR
1203 FEMALE COORDINATOR
1045 MALE HOD
1123 MALE SENIOR TEACHER
1167 MALE SENIOR TEACHER
1215 MALE HOD
(i) To decrease period by 10% of the teachers of
English subject.
UPDATE SCHOOL SET PERIOD = (b) To select all the information of teacher in computer
PERIOD*0.90; department
(ii) To display TEACHERNAME, CODE and Ans: Select * from Teacher where
Department=”Computer”
DESIGNATION from tables SCHOOL and ADMIN
whose gender is male. (c ) To list the name of female teachers in History
SELECT S.TEACHERNAME,S.CODE, Department.
A.DESIGNATION FROM SCHOOL, ADMIN A Ans: Select Name from Teacher Where Sex=”F” And
Department=”History”
WHERE GENDER=‟MALE‟ AND (d) To list all names of teachers with date of admission in
S.CODE=A.CODE; ascending order.
(iii) To display number of teachers in each subject. Ans: Select Name from Teacher Order By Dateofjoining
SELECT SUBJECT, COUNT(*) FROM SCHOOL Asc
GROUP BY SUBJECT; (e) To display Teacher's Name, Department, and Salary of
(iv) To display details of all teachers who have joined female teachers
the school after 01/01/1999 in descending order of Ans: Select Name,Department,Salary from Teacher
experience. Where Sex=”F”
SELECT S.CODE,S.TEACHERNAME, (f)To count the number of items whose salary is less than
S.SUBJECT, S.DOJ,S.PERIODS, 10000
Ans: Select Count(*) from Teacher Where
S.EXPERIENCE,A.GENDER,A.DESIGNATION
Salary<10000
FROM SCHOOL S, ADMIN A WHERE (g) To insert a new record in the Teacher table with the
DOB>‟01/01/1999‟ AND S.CODE=A.CODE following data:
ORDER BY EXPERIENCE DESC; 8,”Mersha”,”Computer”,(1/1/2000),12000,”M”.
(v) SELECT SUM(PERIODS), SUBJECT FROM Ans: Insert into Teacher values ,”Mersha”,
SCHOOL GROUP BY SUBJECT; ”Computer”,{1/1/2000),12000,”M”);
26) Write the SQL commands for (i) to (vii) on the basis (d) To display a report, showing coachname, pay, age and
of the table SPORTS (2001) bonus(15% of pay) for all coaches.
TABLE: SPORTS Ans:
Select Coachname,Pay,Age,Pay*0.15 from Club
(e) To insert a new row in the CLUB table with following
data: 11,”PRAKASH”,37,”SQUASH”,
{25/02/98},2500,”M”
Ans: Insert into Club Values
(11,”PRAKASH”,37,”SQUASH”,{25/02/98}, 2500,”M”)
(f) Give the output of the following SQL statements:
(i) select COUNT (distinct SPORTS)from CLUB;
Ans: 4
(ii) select MIN(AGE) from CLUB where
SEX =”F”;
Ans: 34
(i) Display the names of the students who have grade „C‟ in (iii) select AVG(PAY) fromCLUB where SPORTS =
either Game1 or Game2 or both. “KARATE”;
Ans: Select Name From Sports Where Grade1=”C” OR Ans: 1100
Grade2=”C” (iv) select SUM(PAY) from CLUB where
(ii) Display the number of students getting grade „A‟ in DATAOFAPP>{31/01/98};
Cricket. Ans: 7800
Ans: Select Count(*) from Sports Where (G) Assuming that there is one more table COACHES in
(Game1=”Cricket” and Grade1=”A”) or the database as shown below:
(Game2=”Cricket” and Grade2=”A”) TABLE:COACHES
(iii) Display the names of the students who have same game
for both game1 and game2
Ans: Select Name From Sports Where Game1=Game2
(iv) Display the games taken up by the students, whose
name starts with „A‟.
Ans: Select Game1,Game2 From Sports Where Name
Like “A%”
(v) Add a new column named „marks‟. What will be the output of the following query:
Ans: Alter Table Sports Add Marks Number(5); SELECT SPORTS PERSON, COACHNAME
(vi) Assign a value 200 for marks for all those who are FROM CLUB,COACHES
getting grade „B‟ or „A‟ in both Game1 and Game2. WHERE COACH_ID=COACH_NO
Ans: (Children, Try This Answer as an assignment)
(vii) Arrange the whole table in the alphabetical order of
name.
Ans: Select * from Sports Order By Name
Ans)
27. Write SQL commands for the (b) to (e) and write the
28) Given the following Teacher relation: Write SQL
outputs for (g) on thse basis of table CLUB. (2000)
commands for questions (b) to (g). (1999)
TABLE: CLUB
TEACHER
(b) To show all information about the swimming coaches in (b)To show all information about the teachers of history
the club. department.
Ans: Select * from Club where SPORTS= ”SWIMMING” Ans:select * from teacher where department=‟history‟;
(c) To list names of all coaches with their date of (c) To list names of female teacher who are in math
appointment (DATOFAPP) in descending order. department.
Ans: Select COACHNAME,DATEOFAPP from Club Ans: select name from teacher where sex=‟female‟ and
order by DATEOFAPP desc; department=‟maths‟;

d) To list names of all teacher with their date of joining in 13. BOOLEAN ALGEBRA
ascending order. Laws:
Ans:Select Name From Teacher order by dateofjoing; (1)Properties of 0 and 1:
(f) To count the number of teachers with age >23. 0 + X = X, 1 + X = 1,
Ans: Select count(name) from teacher where age>23; 0.X = 0, 1.X = X
(g) To insert a new row in the teacher table with the (2) Idempotence Law:
following data: (a)X +X = X (b)X.X = X
9, “raja‟, 26, “computer”, {13/5/95 }, 2300, “M”.
Ans: Insert into Teacher values(9,”raja”,26, (3) Involution Law: =A
”computer”, {13/05/95},2300,”M”); (4)ComplementaryLaw:
(a)X + =1 (b)X. =0
29. Write SQL commands for (b) to (g) and write (5)Commutative Law:
the outputs for (h) on the basis of (a) X+Y =Y+X (b)X.Y=Y.X
table HOSPITAL (1998) (6) Associative Law:
(a)X + (Y+Z)=(X+Y)+Z
(b)X.(Y.Z)=(X.Y).Z
(7) Distributive Law:
(a) X(Y+Z)=XY+XZ (b) X+YZ=(X+Y)(X+Z)
(8) Absorption Law:
(a) X+XY=X (b)X(X+Y)+X
(c)X+X‟Y = X+Y (d) X.(X‟+Y) = X.Y
X+X‟Y = X+Y is also known as third distributive law.
(9) Demorgan‟s Theorems
(a) (b)
Model 1: Boolean Laws (2 Marks)
Model 1A: Boolean Laws (Truth Table) (2M)

(b) To select all the information of patients of all cardiology
department. 1.State any one Distributive Law of Boolean
Ans: Select all from Hospital where Algebra and Verify it using truth table.
department=”Cardiology” 2019MP (2007D) (D2006) (2002)(1999) 2
(c) To list the names of female patients who are in ent
department. Ans) Distributive Law:
Ans:select name from Hospital where (i)A (B+C) = AB + AC (ii) A+BC=(A+B)(A+C)
Department=”Ent” and Sex=”F” Verification of first distributive law using Truth
(d) To list names of all patients with their date of admission Table: A (B+C) = AB + AC
in ascending order.
Ans: Select name,dateofadm from Hospital dateofadm.
(e) To display patients name, charges, age, for only female
patients.
Ans: Select Name,Charges,age from Hospital where
sex=”F”
(f) To count the number of patients with age <30.
Ans: Select count(*) from hospitals where age<30
(g) To insert the new row in the hospital table with the
following data: 11, “aftab”, 24, “surgery”, {25/2/98}, 300,
“M”. Comparing Column 5 and 8, Distributive law is
Ans: insert into Hospital values(11, “aftab”, 24, verified
“surgery”, {25/02/98}, 300, “M”) OR
(h) Give the output of the following SQL statements: Verification of second distributive law using
(i) Select count (distinct charges)from hospital; Truth Table:
Ans: 5
(ii) Select min(age) from hospital where sex = “f‟;
Ans: 16
(iii) Select sum(charges) from hospital where department =
“ent”;
Ans: 750
(iv) Select avg(charges) from hospital where date of
admission is <{12/02/98};
Ans:380
Comparing Column 5 and 8, Distributive law is

verified
2) Yerify the following using Truth Table: 2 5.State DeMorgan‟s Laws of Boolean Algebra and
X+Y. Z=(X+Y).(X+Z) verify them using truth table.
(2017) (OD2007) (2003)(1998)
Ans)(i) (X+Y)‟ = X‟.Y‟ (ii) (X.Y)‟ = X‟+Y‟
3) State any one Absorption Law of Boolean

Algebra and verify it using truth table
(2018)(OD2009)(OD2008)(OD2005)(2002) 2
Ans) Absorption Laws:
(a) X+XY=X (b)X(X+Y)=X
(c)X+X‟Y = X+Y (d) X.(X‟+Y) = X.Y
State and verify De Morgan‟s law in Boolean

Algebra. (D2008) (MP108-09 2
6)State and verify AssociativeLaw. (OD2006) 2
Ans) (D2005)
OR
7) Verify the following using truth table: (2012)2

(i) X,X' = 0
4. Name the law shown below and verity it using a

truth table. (2014)
This is absorption law (In some books it is written as as 8) Verify X‟Y + X.Y‟ + X‟Y‟ = (X‟ + Y‟) using
third distributive law.) truth table. (D2009) 2
Ans)
= X‟.Y‟.(Z+Z‟) + X‟.Y.(Z+Z‟) + X.Y‟.Z
= X‟.Y‟ + X‟.Y + X.Y‟.Z
= X‟.(Y‟+Y) +X.Y‟.Z
= X‟ + X.Y‟.Z
= (X‟ + X).(X‟ + Y‟.Z)
= X‟ + Y‟.Z
= LHS
4.Verify the following using Boolean Laws.
Model 1B: Boolean Laws – Algebraic Method U‟+ V= U‟V‟+U‟.V +U.V (2015)
(2Marks) L.H.S =U‟+ V
1) State and verify De Morgan‟s law in Boolean =U‟.(V+V‟)+ V.(U‟+ U)
Algebra. (MP109-10) (D2008) 2 =U‟.V + U‟.V‟ + U‟.V + U.V
=U‟.V+U‟.V‟+U.V
Ans) (i) (X+Y)‟= X‟.Y‟ (ii) (X.Y)‟= X‟+Y‟ =R.H.S
Verification OR
(X+Y)'.(X+Y) = X'.Y'.(X+Y) R.H.S =U‟V‟+U‟.V +U.V
0 = X'.Y'.X + X'.Y'.Y =U‟.(V‟+ V)+ U.V
0 = X'.X .Y'+ X'.0 =U‟.1 + U.V
0 = 0 .Y'+ 0 =U‟+ U.V
0=0+0 =U‟+ V =L.H.S
0=0 5) Verify the following using Boolean Laws
L.H.S = R.H.S X+Z = X + X‟.Z + Y.Z (2013) 2
2) State and verify Absorption Law in Boolean Ans: RHS X + X‟.Z + Y.Z
= X + Z + YZ (X + X‟Y = X+Y)
algebra.(OD2008) (OD2005)(2004) (MP208-09)2 = X + Z.1 + Z.Y
Ans)(a) X+XY = X (b)X(X+Y) = X = X + Z (1 + Y)
(c)X+X‟Y = X+Y (d) X.(X‟+Y) = X.Y = X + Z.1
Algebraic Verification: =X+Z LHS
(a) X+XY = X 6)Verify the following algebraically 2
LHS X+X.Y = X.1+X.Y (A‟+B‟).(A +B)=A‟.B+A.B‟ (2011)
= X.(1+Y)
=X.1
Ans. LHS
=X RHS (A‟ +B‟ ) . (A+B)
Verified = A‟.A + A‟.B + A.B‟ + B‟.B
OR = 0 + A‟.B + A.B‟+ 0
(b)X(X+Y) = X = A‟.B + A.B‟
LHS X.(X+Y) = XX+X.Y = RHS (Verified)
= X.1+X.Y 7)Verify the following algebraically:(OD 2010)2
= X.(1+Y)
= X.1 X‟.Y + X.Y‟ = (X‟+Y‟).(X+Y)
=X RHS Ans. R. H . S
Verified (X‟+y‟).(x+y)
OR = x‟.(x+y)+y‟.(x+y)
(c)X+X‟Y = X+Y = x.x‟+X‟.y+y‟.x+y‟.y
LHS X+X‟. Y = (X+X‟)(X+Y) = x‟.y+y‟.X
= 1.(X+Y) = x‟.y+x.y‟
= X+Y RHS
So L.H.S=R.H.S
Verified
OR OR
(d) X.(X‟+Y) = X.Y L.H.S.
LHS X(X‟+Y) = XX‟+X.Y X‟.Y + X.Y‟
= 0+X.Y = (X‟.Y+X) (X‟.Y+Y‟)
= X.Y RHS = (X‟+X).(Y+X).(X‟+Y‟).(Y+Y‟)
Verified = 1.(X+Y).(X‟ +Y‟).1 = (X+Y).(X‟+Y‟) = R.H.S.
3. Verify the following using Boolean Laws. (2016)2 8) Verify X.Y‟Z+X.Y‟Z‟+X‟.Y‟Z = X.Y‟ + Y‟.Z
X‟+ Y‟Z = X‟.Y‟.Z‟+ X‟.Y.Z‟+ X‟Y.Z+ X‟.Y‟.Z+ algebraically. (2003)
X.Y‟.Z 9) Prove XY + YZ + Y‟Z =XY + Z, algebraically.
Ans LHS =X‟ + Y‟.Z (2002) 2
= X‟.(Y + Y‟).(Z + Z‟) + (X + X‟).Y‟.Z 10) Prove algebraically:
= X‟.Y.Z + X‟.Y.Z‟ + X‟.Y‟.Z + X‟.Y‟.Z‟ + X.Y‟.Z
x‟y‟z‟+x‟y‟z+x‟yz‟+x.y‟z=x‟+y‟ (2001)
+ X‟.Y‟.Z
= X‟.Y.Z + X‟.Y.Z‟ + X‟.Y‟.Z + X‟.Y‟.Z‟ + X.Y‟.Z
11) Prove X‟.Y+Y‟.Z= X‟.Y.Z+X‟.Y‟.Z‟+
= X‟.Y‟.Z‟ + X‟.Y.Z‟ + X‟.Y.Z + X‟.Y‟.Z + X.Y‟.Z X.Y‟.Z+X‟.Y‟.Z algebraically. (2000)
= RHS 12) Prove x+x'y=x+y algebraically. (1999)
OR 13) Prove X+Y'Z=(X+Y'+Z')(X+Y'+Z)(X+Y+Z)
RHS=X‟.Y‟.Z‟ + X‟.Y.Z‟ + X‟.Y.Z + X‟.Y‟.Z + X.Y‟.Z algebraically. (1998)
= X‟.Y‟.Z + X‟.Y‟.Z‟ + X‟.Y.Z + X‟.Y.Z‟ + X.Y‟.Z
Model 1C: Correct the Boolean Laws/Statements 1) Derive a canonical POS expression for a
(2Marks) Boolean function FN, represented by the
Correct the following boolean statements: following truth table. (2018)
1. X+1 = X 2. (A')'=A' X Y Z FN(X,Y,Z)
3. A+A'=0 4. (A+B)' = A.B (2017 MP) 0 0 0 1
A) 1. X+1 =1 or X+0=X 2. ((A‟)‟) = A 0 0 1 1
3. A + A‟= 1 or A . A‟=0 4. (A+B)‟ = A‟ . B‟ 0 1 0 0
Model 2A: Write SOP Form (1 Mark) 0 1 1 0
(Consider Only 1‟s combinations from the Result Column.
Here Variable Value is 1 ) 1 0 0 1
1.Derive a Canonical SOP expression for a 1 0 1 0
Boolean function F(X,Y,Z) represented by the 1 1 0 0
following truth table: 2019MP1 1 1 1 1
Ans: FN(X,Y,Z)=
(X+Y‟+Z).(X+Y‟+Z‟).(X‟+Y+Z‟).(X‟+Y‟+Z)
OR
FN(X,Y,Z)= Π (2,3,5,6)
2. Write the POS form of a Boolean Function F,
which is represented in a truth table as follows:
(2017 MP)
P Q R F
Ans: F(X,Y,Z)= X‟Y‟Z‟+X‟Y‟Z+XY‟Z‟+XYZ 0 0 0 0
OR 0 0 1 1
F(X,Y,Z)=Σ(0,1,4,7) 0 1 0 1
2) Write the SOP form of a Boolean Function F, 0 1 1 1
Which is represented by the following truth table: 1 0 0 0
(D2005)1 1 0 1 1
1 1 0 0
1 1 1 1
A) F(P,Q,R) = (P+Q+R).(P‟+Q+R).(P‟+Q‟+R)
3) Write the POS form of a Boolean function H,
(D2009) 1
Ans) A'.B'.C' + A'.B.C + A.B.C' + A.B.C
3) Write the SOP form of a Boolean function G,
(MP208-09)1
Ans) H(A,B,C) = (A+B+C).(A‟+B+C‟).(A‟+B‟+C)

OR
H(A,B,C) = (0, 5, 6)
Ans) G(P,Q,R) = P‟.Q.R‟+P.Q‟.R‟+P.Q.R‟+P.Q.R 4) Try following:
4) Try following:
Model 2B: Write POS Form (1 Mark) Model 3A: Write the Equivalent Boolean
(Consider Only 0‟s combinations from the Result Column. Expression (2 Marks)
Here Variable Value is 0 )

1.Write the Boolean Expression for the result of
the Logic Circuit as shown below: (2016)
OD200
P.Q‟ + P.R + Q.R‟ 6
2) Write the equivalent expression for the following
Logic Circuit : (OD2005) 2
MP10
Ans) U.V‟+U‟.V+U‟.V 9-10
3) Write the equivalent Boolean expression for the
following Logic Circuit: (D2005) 2
Model 3B: Draw the Logic Circuit (2 Marks)

Ans) (X+Y‟)(X‟+Y)(X‟+Y‟) 1.Draw the Logic Circuit of the following
4)Write the equivalent Boolean Expression for the Boolean Expression:
following Logic Circuit (MP108-09) 2 ((U + V‟).(U + W)). (V + W‟) 2019MP2
Ans) F(P,Q)=(P‟+Q).(P+Q‟)
2014
2) Draw the Logic Circuit of the following Boolean
Expression: (U‟+V).(V‟+W‟) (2018)2
2013
3.Draw the equivalent logic circuit for the following

OD201 Boolean expression: (A.B)+C (2017MP)
0
OD200
7 4. Draw the Logic Circuit for the following Boolean
Expression : (X‟+Y).Z+W‟ (2015)
D2007

5) Draw a logical circuit diagram for the following
Boolean Expression: (OD2008) 1
A.(B+C‟)
Ans) Answer: X‟Z‟+Y‟W‟+Y‟Z+XZW‟

6) Draw a Logical Circuit Diagram for the
2) Reduce the following Boolean Expression to
following Boolean Expression. (D2008) 1
X‟.(Y‟+Z) its simplest form using K-Map:2018 (3)
G(U,V,W,Z) = ∑ (3,5,6,7,11,12,13,15)
7) Draw a logical circuit diagram for the following

Boolean expression: A‟.(B+C) 1
Model 3B: Draw the Logic Circuit Using NAND or
NOR gates (2 Marks)
1. Draw the Logic Circuit of the following Boolean
Expression using only NOR Gates:
F(U,V,W,Z)= VZ + WZ + UVW‟+ U‟VW
( A+B).(C+D) (2017) 2 3. Reduce the following Boolean expression to its
simplest form using K-Map: (2017)
E(U,V,Z,W)= Σ (2,3,6,8,9,10,11,12,13)
2) Represent the Boolean expression X‟Y+Y‟Z with

the help of NAND gates only. (2000)
3) Represent the Boolean expression
(X+Y)(Y+Z)(X+Z) with help of NOR gates only.
(2002) 1
4) Represent the Boolean expression (x+y)(y+z)(z+x)
with the help of NOR gates only. (1999) E(U,V,Z,W) = UZ‟ + V‟Z + U‟ZW‟
5) Represent the Boolean expression X+Y.Z' with the K-MAP (SOP) Year
help of NOR gates only. (1998) F(A,B,C,D) = Σ (0,1,3,5,6,7,9,11,13,14,15) 2017
REPRESENT X‟Y‟ + X‟Z + Y‟Z‟ using NAND gates only F(P,Q,R,S) = ∑ (0,4,5,8,9,10,11,12,13,15) 2016
F(X,Y,Z,W) = Σ(0,1,4,5,6,7,8,9,11,15) 2015
F(A,B,C,D) = Σ(1,3,4,5,6,7,12,13) 2014
F(U,V,W,Z) = Σ (0,1,2,3,6,7,8,9,10,13,15) 2013
F(A, B, C, D) = Σ (2, 3, 4, 5, 6, 7, 8, 10, 11) 2012, D2010
F(A, B,C, D) =(0,1, 2, 4, 5, 6, 7, 8, 10) 2011
F(U, V, W, Z) = (3, 5, 7, 10, 11, 13, 15) D2010
F (A,B,C,D) = (3,4,5,6, 7,13,15) OD2010
F(P,Q,R,S) = ∑ (1,2,3,5,6,7,9,11,12,13,15) D2009
H(U,V,W,Z) = ∑( 0,1,4,5,6,7,11,12,13,14,15) OD2009
F(A,B,C,D) = ∑(0,1,2,,4,5,8,9,10,11) OD2008
F(A,B,C,D) = ∑(0,2,3,4,6,7,8,10,12) D2008
F(U, V, W, Z) = ∑(0,1,2,3,4,10,11) D2007
F(P, Q, R, S,) = ∑(0,3,5,6,7,11,12,15) D2006
Model 4A: Reduce the Boolean Expression using
F(A, B, C, D,) = ∑(0,1,2,3,4,5,10,11,15) OD2005
K-Map (3 Marks)
F(a,b,c,d) = ∑(0,1,2,4,5,7,8,9,10,11,14) 2004
1.Reduce the following Boolean Expression to its F(U,V,W,Z,)=∑(0,2,3,4,7,9,10,13,14,15) 2003
simplest form using K-Map: 2019SP3 F(w,x,y,z)=∑(2,3,6,10,11,14) 2002
F(X,Y,Z,W)= Σ (0,1,2,3,4,5,8,10,11,14) F(x,y,z,w)= ∑ (1,3,4,5,7,9,11,12,13,15) 2000
F ( w,x,y,z) = ∑ (0,4,8,12 1999
F( U, V, W,Z) = ∑(0,1,3,5,7,9,10,11,12,13,14,15) 1998
F(A,B,C,D)=  (0,1,2,4,5,6,8,10) MP108-09
F(A,B,C,D)=(0,1,2,4,5,6,8,10) MP109-10

Model 4B: Reduce the Boolean Expression using Model 5B: Convert the expression into POS
K-Map Π (3 Marks) (1Mark)
1) Reduce the following Boolean expression using K
1) Convert the following Boolean expression into
– Map : (OD2006) 3
its equivalent Canonical Product of sum form
F(P, Q, R, S,) = Π (0,3,5,6,7,11,12,15)
(POS): A.B‟C + A‟.B.C + A‟.B.C‟. (OD200) 2
Ans) A.B‟C + A‟.B.C + A‟.B.C‟
= m5 + m3 + m2
= ∑(2,3,5)
=  (0,1,4,6,7)
= (A+B+C)((A+B+C’)(A’+B+C)(A’+B’+C)(A”+B’+C’)
2) Write the equivalent canonical product of sum
expression for the following sum of product
expression: (OD2007) 2
F(X, Y,Z) = ∑ (0, 2,4,5)
Ans)F(X, Y, Z) =  (1, 3, 6, 7)
OR
F=(X+Y+Z‟)(X+Y‟+Z‟)(X‟+Y‟+Z)(X‟+Y‟+Z‟)
2) Reduce the following Boolean expression using
K – Map : (D2005) 3 Model 6A: Express the following in SOP (1 Mark)
F(A, B, C, D,) = Π (0,1,2,3,4,5,10,11,15)
Ans) F(A, B, C, D,) = Π (0,1,2,3,4,5,10,11,15) 1) Express P +Q‟R in canonical SOP form.
(D2006)1
(P + Q‟R) = P.1.1 + 1.Q‟.R
= P ( Q+Q‟)(R+R‟) + (P+P‟)Q‟R
= (PQ +PQ‟) (R + R‟) + PQ‟R + P‟Q‟R
= PQR + PQ‟R + PQR‟ + PQ‟R‟ + PQ‟R+ P‟Q‟R
= PQR + PQ‟R + PQR‟ + PQ‟R‟ + P‟Q‟R
Model 6B: Express the following in POS (1 Mark)

1) Express P +Q‟R in POS form. (OD 2006)1
P +Q‟R = (P+Q‟).(P+R)
K-MAP (POS) Year = (P+Q‟+0).(P+0+R)
OD2007 = (P+Q‟+RR‟).(P+QQ‟+R)
F(A, B, C, D,) = Π (5, 6, 7, 8, 9, 12, 13, 14, 15)
= (P+Q‟+R) (P+Q‟+R‟) (P+Q+R)(P+Q‟+R)
F(a,b,c,d) = Π (0,1,3,4,5,7,8,9,11,12,13,15) 2001
= (P+Q‟+R).(P+Q‟+R‟).(P+Q+R)
F(U,V,W,Z)=  (0,1,2,4,5,6,8,10) MP208-09
Model 7: Mislleneous Models
F(A,B,C,D)=  (1,3,4,5,7,9,11,12,13,14) Write the dual of the followins Boolean Expression
F(U,V,W,Z)=  (0,1,2,4,5,6,8,10) MP209-10
(B’+C).A 2003
Model 5A: Convert the expression into SOP (x+y).(x'+y') 1999
(1Mark) (U+W)(V'U+W) 1998
1) Convert the following Boolean expression into 2) Seven inverters are cascaded one after another.
its equivalent Canonical Sum of Product Form What is the output if the input is 1? (2001)
(SOP): (D2008) 2 3) Given the following circuit:
(X‟+Y+Z‟).(X‟+Y+Z).(X‟+Y‟+Z).(X‟+Y‟+Z‟)
Ans) F(X,Y,Z) =  (4,5,6,7)
= ∑ (0,1,2,3) What if the output if (i) both inputs are FALSE(0)
=X’Y’Z’ + X’Y’Z + X’YZ’ + X’YZ (ii) one is FALSE and the other is TRUE.
4) State and verify Duality Principle. (2001)
Write equivalent Canonical SOP for Year
following
F(X, Y,Z) = Π (1,3,6,7) D2007
(U‟+V‟+W‟).(U+V‟+W‟).(U+V+W).

14.COMMUNICATION AND 2) Daniel has to share the data among various
NETWORK CONCEPTS computers of his two offices branches situated in
the same city. Name the network (out of LAN,
Theory Question: Fundamental Concepts WAN, PAN and MAN) which is being formed in
this process. (2017MP)1
1) Mention one advantage of networking(2001). 1 Ans : MAN
Ans: Advantages/Need for networking or
3.Differentiate between PAN and LAN types of
Network Goals:
(i) Resource Sharing: Hardware Resources like networks. (2016) 1
printers, Softwares can be shared between all PAN (Personal Area LAN (Local Area Network)
computers in the network. Network)
(ii) Reliability: A file can have copies in two or more A personal area LAN interconnects a high
computers. network PAN is a number of access or node
(iii) Cost Factor computer network points or stations within a
(iv) Communication Medium: Using a network, it is organized around an confined physical area
possible for managers, working far apart, to prepare individual person. upto a kilometer
financial report of the company, etc 4. Which type of network (out of LAN, PAN and
MAN) is formed, when you connect two mobiles
2) What was the role of ARPANET in the
using Bluetooth to transfer a Video. 2013
Computer Network? (D2010)1m
Ans: PAN (Personal Area Network)
OR
What is the significance of ARPANET in the 5 In networking, what-is WAN? How is it
network? (MP108-10) 1 different from LAN? (2011) 1
Ans) The first evolution of network was jointly Ans A WAN (wide area network), is not restricted to
designed by The Advanced Research Projects Agency a geographical location, although it might be confined
(ARPA) and Department of Defence (DoD) of united within the bounds of a state or country. A WAN
states in 1969 and was called ARPANET. It was an connects several LANs, and may be limited to an
experimental project, which connected a few enterprise (a corporation or an organization) or
computers of some of the reputed universities of USA accessible to the public. The technology is high speed
and DoD. ARPANET allowed access and use of and relatively expensive. The Internet is an example
computer resource sharing projects. This ARPANET of a worldwide public WAN.
was handed over to Defence Communication Agency A LAN (local area network) is a group of
(DCA) for further development. computers and network devices connected together,
usually within the same building or campus.
3) What is NFS? (2001) 1 6) What is the difference between LAN and WAN?
4) Differentiate between Internet and Intranet (OD2009) 1
(D2006) 1 Ans LAN (Local Area Network):
Ans)Internet is a network of computer networks Interconnects a high number of access or node points
which operates world-wide using a common set of or stations within a confined physical area. An
communications protocols. example is the territory covered in a single office
Intranet is an inter-connected network within one building that houses various departments/offices. All
organization that uses Web technologies for the these areas are interconnected using a LAN.
sharing of information internally.
5) What do you understand by a backbone
network? (1998)1
Ans: A backbone is central interconnecting structure
that connects one or more networks just like the trunk
of a tree or the spine of a human being.
WAN (Wide Area Network)
LAN,MAN,WAN,PAN It is used to connect systems with no limitation of
1.Assume that 50 employees are working in an geographical area. It is used to serve many locations
organization. Each employee has been allotted a distributed over a large geographical area. A system of
separate workstation to work. In this way, all overnight teller machines used by a banking
computers are connected through the server and organisation covering the North of India is an example
all these workstations are distributed over two of a WAN. Internet is also an example of the same.
floors. In each floor, all the computers are 7) What is the difference between MAN and WAN?
connected to a switch. Identify the type of (2003)(1999) 1m
network? 2019MP1 8) What is the difference between LAN and WAN?
Ans: LAN(Local Area Network) (2000) 1m

LAN WAN Optical Fibre Ethernet Cable
Diameter of not more Span entire countries Very Fast Slower as compared to Optical
than a few kilometers. Fiber
A total data rate of Data rate less than 1 Expensive Less Expensive as compared to
atleast several Mbps Mbps(Megabits per Optical Fiber
Second) Immune to Prone to electromagnetic
Complete ownership by a Owned by multiple electromagnetic interference
single organization organization interference
Very low error rates Comparatively higher 3. Out of the following, which is the fastest (i) wired
error rates and (ii) wireless medium of communication? (2015)1
Infrared, Coaxial Cable, Ethernet Cable, Microwave,
9) What is the difference between LAN and MAN? Optical Fiber
(1998) 1
Ans (i) Wired - Optical Fiber
SWITCHING TECHNIQUES (ii) Wireless ‐ Infrared OR Microwave
1) Name two switching techniques used to transfer 4. Write two advantages of using an optical fibre
data between two terminals(computers). cable over an Ethernet cable to connect two service
(D2009)1 stations, which are 200m away from each other.
Ans Circuit Switching , Message Switching and (2014) 1
Packet Switching Ans: Two advantages of using an optical fibre
2) What is the difference between Message cable over an Ethernet cable:
Switching technique and Packet Switching Provides high speed
technique? (2015) (D2005)(2002) 1m Electrical and magnetic interference does not affect
Ans: the transmission.
Message Switching Packet Switching 5. How is Coaxial cable different from Optical
The source computer The source computer Fibre? (D2008) (OD2005) 1
sends data (message) to sends data (message) in Ans) Coaxial Cable: Comparatively Slow, Economic,
the switching office, a fixed size of Packet to convenient to lay down, used in Bus topology of
which stores data in a the switching office, networks
buffer. It then looks for which stores data in Optical Fibre: Very fast, expensive, reliable, no
a free link to another main memory. It then interference
switching office and looks for a free link to 6) Write one difference between Coaxial and
sends data to that another switching office optical cable? (2004) 1
office. This process and sends data to that 7) Write an advantage and a disadvantage of using
continues until data is office. This process optical fibre cables? (2003) 1
delivered to the continues until data is
destination computer delivered to the 8) Name two transmission media for networking.
(OD2006) 1m
destination computer
Ans) Optical Fiber,Ethernet Cable or twisted pair
Message Switching Packet Switching cable or UTP or STP,Co-axial Cable,,Infrared, Radio
follows store and follows store and Link OR Radiowave, Microwave link OR Microwave,
forward principle for forward principle for Satellite Link
complete message. fixed packets
9) Name two communication channels used in
No limit on block size. Fixes an upper limit for networking and explain any one. (2001) 2
packet size
3) Define Packet switching? (2004) 1m TOPOLOGIES:
4) Compare any two Switching techniques. MP109-10)1 1) Differentiate between Bus Topology and Star
Topology of Networks. What are the advantages
GUIDED & UNGUIDED MEDIA and disadvantages of Star Topology over Bus
1. Your friend wishes to install a wireless Topology? (2018)(D2009)(D2006)
network in his office. Explain him the difference Ans:
between guided and unguided media. (2019MP)1 Bus Topology: It is characterised by common
Answer: Guided media uses cables to connect transmission medium shared by all the connected
computers, whereas unguided media uses waves. hosts, managed by dedicated nodes. It offers
2.Differentiate between communication using simultaneous flow of data and control.
Optical Fiber and Ethernet Cable in context of
wired medium of communication technologies.
(2017)2
Ans)
Star Topology: It is characterised by central Ans Cable length required for this topology is the
switching node (communication controller) and least compared to other networks.
unique path (point to point link) for each host. It is Illustration of 4 computers connected with each
easy to add and remove additional hosts by upgrading other using star topology of network.
the centralised node.
Advantages of Star Topology over Bus Topology: ●

Faster communication as compared to Bus topology
● Independent line of connection allows freedom of
removing or adding nodes from the network
Theory Question : Communication Devices
*Fault detection is easy.
*Fault isolation is easy. 1)What is the purpose of using a repeater in the
Disadvantages of Star Topology over Bus context of networking? (2003)1
Topology: ● Expensive as compared to Bus topology 2) What are repeaters? (1998)1
● Long cable length A) A repeater is a network device that amplifies and
restores signals for long distance transmission.
2) Write two advantages and two disadvantages for It is used in long network lines, which exceed the
STAR topology? (2004)1 maximum rated distance for a single run.
3) Write one advantage and one disadvantage of the Repeaters are of two types:
following topologies in network: (2003)2 (i)Amplifier : amplifies all incoming signals over the
i)STAR Topology ii)BUS Topology network. (it amplifies both the signal and any
4) Mention one difference between Linear and Star concurrent noise)
topologies in networking. (2001)1 (ii) Repeater : collected inbound packet and then
5) Write the two advantages and two disadvantages of retransmits the packet as if it were starting form the
BUS Topology in network? (2000)2 source station.
6) Write two advantages and disadvantages of the 3) What is a Hub? (D2008)1
following topologies in a Network. (2002)1 Ans)A Hub is used for a central connection between
i) BUS ii)RING two or more computers on a network.
7) Give two advantages and disadvantages of OR
following network topologies: (1999)2 A Hub is a network device used to connect two or
i)BUS ii) Tree more computers. OR
8) Identify the type of topology on the basis of the A Hub is an unintelligent network device to connect
following: (2017MP) computers.
a. Since every node is directly connected to the server, Hubs are of two types:
a large amount of cable is needed which increases the (i) Active hubs: electrically amplify the signal as it
installation cost of the network. moves from one connected device to another.
b. It has a single common data path connecting all the (ii) Passive hubs: allow the signal to pass from one
nodes. 2 computer to another without any change.
Ans: a. Star Topology b. Bus Topology 3) What is a Modem? (OD2008)1
9. Illustrate the layout for connecting 5 computers Ans) Modem is a Modulation Demodulation device
in a Bus and a Star topology of Networks. that converts analog signal to digital signal and vice
(2015) 2 versa.
4) What is the purpose of using a MODEM?(2000)1
5) What is a Modem? (2002)1
6) What is a bridge? (1999)1
A) A bridge is a device that lets you link two networks
together. Bridges are smart enough to know which
computers are on which side of the bridge, so they
only allow those messages that need to get to the other
side to cross the bridge. This improves performance
on both sides of the bridge.
10) Write one advantage of Bus Topology of As a packet arrives at the bridge, the bridge
network. Also, illustrate how 4 computers can be examines the physical destination address of the
connected with each other using star topology of packet. The bridge then decides whether or not to let
network. (2012)2 the packet cross.
OR information from internet using an internet browser is
A bridge is a network device that establishes an :TCP/IP OR HTTP
intelligent connection between two local networks 3) What is protocol? Which protocol is used to
with the same standard but with different types of copy a file from/to a remotely located server?
cables. (OD2009)1
7) What are Routers? (2000)1 Ans A protocol is the set of rules for governing
A) A router is a network device that is used to communication between two communication devices.
separate different segements in a network to improve It also infers documentation, negotiations and
performance and reliability. A router works like a establishment of rules. Protocol used to copy a file
bridge but can handle different protocols. from/to a remotely located server is FTP (File
Compared to hubs and switches, routers are smarter Transfer Protocol)
still. Routers use a more complete packet address to
determine which router or workstation should receive 4. What is the difference between HTTP and FTP.
each packet next. Based on a network road map (2013) 1
called arouting table routers can help ensure that Ans:
packets are travelling the most efficient paths to their
destination. If a link between routers fails, the
sending router can determine an alternate route to
keep traffic moving.
DATA TRANSFER UNITS
1) Define the term Bandwidth. Give any one unit of
Bandwidth. (MP208-10)(MP209-10)1
Ans) The amount of data that can be transmitted in a
fixed amount of time is known as bandwidth. 5) What is the purpose of using FTP? (1999) 1
For digital devices, the bandwidth is usually expressed
in bits per second(bps) or bytes per second. For analog SECURITY
devices, the bandwidth is expressed in cycles per
second, or Hertz (Hz) 1.Arun opened his e-mail and found that his
OR inbox was full of hundreds of unwanted mails. It
Bandwidth is referred to the volume of information took him around two hours to delete these
per unit of time that a transmission medium (like an unwanted mails and find the relevant ones in his
Internet connection) can handle. inbox. What may be the cause of his receiving so
2 ) Which of the following is not an unit for data many unsolicited mails? What can Arun do to
transfer rate? (D2010) 1 prevent this happening in future?
(i) bps (ii) abps (iii) gbps (iv) kbps 2019MP2
Ans. (ii)abps Ans: Arun‟s email has been attacked with spam.
These may be promotional mails from different
2) Which of the following is not a unit for data advertisement groups. Arun must have checked
transfer rate? (OD2010)1
some promotional offers while surfing the Internet.
(i) mbps (ii) kbps (iii) sbps (iv) gbps
Ans. (iii) sbps
He should create filters in his email to stop
3) Which of the following unit measures the speed receiving these unwanted mails.
with which data can be transmitted from one node to 2. Janish Khanna used a pen drive to copy files
another node of a network? Also, give the expansion from his friend‟s laptop to his office computer.
of the suggested unit. (D2007)1 Soon his office computer started abnormal
i) Mbps ii) KMps iii) MGps functioning. Sometimes it would restart by itself
Ans) Mbps (Mega Bits Per Second) and sometimes it would stop different applications
running on it. Which of the following options out of
Theory Question : Protocols (i) to (iv), would have caused the malfunctioning of
1.Which protocol helps us to transfer files to and from the computer? Justify the reason for your chosen
a remote computer? (2016)1 option:
Ans FTP OR Telnet OR TCP (i) Computer Virus (ii) Spam Mail
2) What is protocol? Which protocol is used to (iii) Computer Bacteria (iv) Trojan Horse (2017)
search information from internet using an internet Ans) (i) Computer Virus OR (iv) Trojan Horse
browser? (D2009) 1 Justification:
Ans A protocol is the set of rules for governing ● Pen drive containing Computer Virus / Trojan Horse
communication between two communication devices. was used before the abnormal functioning started,
It also infers documentation, negotiations and which might have corrupted the system files.
establishment of rules. Protocol used to search
● Computer Virus/ Trojan Horse affects the system Ans. TROJAN HORSE: “Malware” computer
files and start abnormal functioning in the computer programs presented as useful or harmless in order to
3. Ms. Raveena Sen is an IT expert and a induce the user to install and run them.
freelancer. She recently used her skills to access the VIRUS: Virus is a malicious program that damages
Admin password for the network server of Super data and files and causes harm to computer system.
Dooper Technology Ltd. and provided confidential 11) What is the difference between Virus and
data of the organization to its CEO, informing him Worms in the computers? (OD2010)1
about the vulnerability of their network security. Ans.Virus: Virus is a malicious program that
Out of the following options (i)to (iv), which one damages data and files and causes harm to computer
most appropriately defines Ms.Sen? system.
Justify the reason for your chosen option: Worms: Worms disrupt services and create system
(i) Hacker (ii) Cracker management problems. In some cases worms can
(iii) Operator (iv) Network Admin (2017)2 install viruses that cause damage to system.
Ans) (i) Hacker : A Hacker is a person who breaks
into the network of an organization without any 12) How Trojan Horses are different from Worms?
malicious intent. Mention any one difference. (MP209-10)1
Ans)A Trojan horse is a term used to describe
4) Who is a hacker? (2017MP)1 malware that appears, to the user, to per form a
Ans: A computer enthusiast, who uses his computer desirable function but, in fact, facilitates unauthorized
programming skills to intentionally access a computer access to the user's computer system.
without authorization is known as A computer worm is a self-replicating computer
hacker. A hacker accesses the computer without the program. It uses a network to send copies of itself to
intention of destroying data or maliciously harming other nodes (computers on the network) and it may do
the computer. so without any user intervention.
5)How is a Hacker different from a Cracker? 13) What term we use for a software/hardware
(OD2008)1 device, which is used to block, unauthorized access
Ans)Hackers are the ones who get into someone‟s while permitting authorized communications. This
code or computer without any malicious intentions, term is also used for a device or set of devices
where as Crackers are the one‟s who get into configured to permit, deny, encrypt, decrypt, or
someone‟s code or computer with malicious proxy all (in and out) computer traffic between
intentions. different security domains based upon a set of rules
6) Difference between Hackers and Crackers? and other criteria. (D2010)1
(OD2006)1 Ans. Firewall
Ans)Hackers: Computer enthusiasts who enjoy Firewall: Any of a number of security schemes
learning about computer systems and get into other (hardware/software) that
system/network for gaining more knowledge or may prevent unauthorized users from gaining access to a
find flaws in the system for rectification purposes. computer network or that monitor transfers of
Crackers: Malicious programmers who break into information to and from the network.
secure systems for stealing and corrupting/spoiling
14)Define the term firewall. (MP208-10)1
data.
Ans) Firewall is a feature used for Network Security.
7) What is the basic difference between Computer In a Network there is always danger of information
Worm and Trojan Horse? (2016)1 leaking out or leaking in. Firewall is a feature which
Trojan Horse Computer Worm forces all information entering or leaving the network
It is a ‘Malware’ It is a self replicating to pass through a check to make sure that there is no
computer program computer program unauthorized usage of the network.
presented as useful or which uses a network to 15) How firewall protect our Network? (MP209-10)1
harmless in order to send copies of itself to Ans)A firewall is a part of a computer system or
induce the user to other computers on the network that is designed to block unauthorized access
install and run them. network and it may do while permitting authorized communications. It is a
so without any user device or set of
intervention. devices configured to permit, deny, encrypt, decrypt,
or proxy all (in and out) computer traffic between
8) What is Trojan Horse? (2015) 1 different security domains based upon a set of rules
Ans A Trojan Horse is a code hidden in a program, and other criteria.
that looks safe but has hidden side effects typically
causing loss or theft of data, and possible system 16) What do you mean by IP Address? How is it
harm. useful in Computer Security? 1
Ans) An Internet Protocol (IP) address is a numerical
10) What is the difference between Trojan Horse identification and logical address that is assigned to
and Virus in terms of computers? (D2010)1 devices connected in a computer network.An IP
Address is used to uniquely identify devices on the URL‟s have three parts: the protocol , the
Internet and so one can quickly know the location of DNS name of the machine on which the page is
the system in the network. located and a local name uniquely indicating the
17) What do you mean by Spam Mails? How can specific page(generally the filename).
you protect your mailbox from Spams? (2000) 6) Write two advantages of 3G over 2G Mobile
Ans) Spam mails, also known as junk e-mail, is a Telecommunication Technologies in terms of speed
subset of spam that involves nearly identical messages and services? (2016)1
sent to numerous recipients by e-mail. Ans Speed ‐
We can protect our mailbox from spams by creating ● Faster web browsing
appropriate filters. ● Faster file transfer
Service ‐
18)Give two major reasons to have network ● Better video clarity
security. (MP108-10)1 ● Better security
Ans)Two major reasons to have Network Security are
(i) Secrecy: Keeping information out of 7. What is WEB2.0? (2011)1
the reach of unauthorized users. Ans The term Web 2.0 is associated with web
(ii) Authentication: Determining the authorized applications that facilitate participatory
user before sharing sensitive information with or information sharing, interoperability, user-centered
entering into a business deal. design, and collaboration on the World Wide Web.
Web 2.0 is also used for social networking. Example:
INTERNET : OTHERS Social Networking Sites, Blogs, Facebook, Video
1. What is the difference between E-Mail and Sharing Sites, Video Conferencing Applications etc.
Chat? (2014)1 8. Write two characteristics of Web 2.0. (2016) 1
Ans: In Email, it is not necessary that receiver should Ans ● Makes web more interactive through online
be present online when the receiver is sending the E- social medias
mail, whereas in Chat, it is must that the ● Supports easy online information exchange
communicators should be online at the time of ● Interoperability on the internet
communication. ● Video sharing possible in the websites
2) Name any two common Web browsers. (OD2010)1 9. Write two characteristics of Wi-Fi. 2014 (1)
Ans. Internet explorer,Firefox,Netscape Navigator, Ans: The characteristics of Wi-Fi are as follows:
Google Chrome, Opera, Safari 1. It allows the devices to connect with the netwok
3)What is the purpose of using a Web Browser? without any wire.
Name any one commonly used Web Browser. 2. Group of devices can be connected with single
(MP108-10)1 internet connection.
Ans) The Web Browser fetches the page requested, 10. Write any two important characteristics of
interprets the text and formatting commands that it Cloud Computing. 2014
contains, and displays the page properly formatted on Ans:Two characteristics of Cloud Computing are:
the screen. (i) It is controlled by entity and restricted to their
Example of a Web Browser: authorized user.
Mozilla Firefox OR Internet Explorer OR Netscape (ii) It is delivered through internet 24 X 7.
Navigator OR Safari OR OPERA 11. Describe the following in brief:2m (1998)
4) Give one suitable example of each URL and i)MOSAIC ii)Usenet
Domain Name (2012)1
Ans URL Example: http://www.w3schools. Theory Question : Cyber Crimes
com/htmlldefault.asp OR (1) Out of the following, which all comes under
www.youtube.com cyber crime? (2015)1
Domain Name Example: w3schools.com (i) Stealing away a brand new hard disk from a
OR showroom.
Any other correct URL and Domain Name Examples (ii) Getting in someone's social networking account
Note: Domain names in both the examples may/may without his consent and posting on his behalf.
not be same (iii) Secretly copying data from server of a
organization and selling it to the other organization.
5) What is the importance of URL in networking? (iv) Looking at online activities of a friends blog.
(MP208-10) (MP209-10)1 Ans (ii) & (iii)
Ans) URL stands for Uniform Resource Locator. 2) Which out of the following comes under Cyber
Each page that is created for Web browsing is Crime? (2012)1
assigned a URL that effectively serves as the page‟s (i) Operating someone's Internet banking account, without
worldwide name or address. . A URL is also referred his knowledge.
to as a Web address. (ii) Stealing a keyboard from someone's computer.

(iii) Working on someone's computer with his/her restricted to a limited set of tags defined by
permission. proprietary vendors.
Ans (i) Operating someone's Internet banking account, Rather than waiting for standards bodies to adopt tag
without his knowledge. set enhancements (a process which can take quite
3) What is the significance of Cyber law? some time), or for browser companies to adopt each
(OD2007) (D2007)1 other's standards (yeah right!), with XML, you can
Ans) Cyber law encompasses a wide variety of create your own set of tags at your own pace.
political and legal issues related to the Internet and
other communications technology, including Theory Question : Scripts & Cookies
intellectual property, privacy, freedom of expression, 1) Classify each of the following Web Scripting as
and jurisdiction. Client Side Scripting and Server Side Scripting:
OR (2018)
Cyber law helps prevent Cyber Crime, Hacking, Data (i) Java Scripting (ii) ASP
theft, Software Piracy and protects rights of Cyber (iii) VB Scripting (iv) JSP
Users. Ans: (i) Client Side Scripting / Server Side Scripting
OR (ii) Server Side Scripting
Restricting unauthorized access to user accounts. (iii) Client Side Scripting
Promoting, coordinating and controlling e-business. (iv) Server Side Scripting
4) Write two application of Cyber Law. (D2005)1 2)Categories the following under Client side and
Ans)Cyber law encompasses a wide variety of Server Side script category? (2016)(2011)
political and legal issues related to the Internet and (i) Java Script (ii) ASP
other communications technology, including (iii) VB Sript (iv) JSP
intellectual property, privacy, freedom of expression, Client Side Scripts Server Side Scripts
and jurisdiction. VB Script ASP
Java Script JSP
5) If someone has hacked your Website, to whom 3) Name one server side scripting language and one
you lodge the Complain? (MP1 09-10)1 client side scripting language. (2012)1
Ans) The complaint has to be lodged with the Police Ans
under IT Act.
Ex. Of Client Side Ex. Of Server side
Theory Question : XML & HTML Scripts Scripts
1. Differentiate between XML and HTML. (2011) VB Script ASP
(OD2005) 1 Java Script JSP
HTML XML Peril Tcl PHP
Full form is Hyper Text Full form of XML is TK CGI
Mark Up Language extensible mark up REXX Perl
language 4) Which of the following is not a Client Side
It contains predefined tags It contains user defined script: (MP109-10)1
tags (i) VB Script (ii) Java Script
(iii) ASP (iv) PHP
predominant markup Initially visualized as a Ans)(iii)ASP and (iv) PHP are not client side scripts
language for the creation language for defining new 5.What are cookies? (2011)
of web pages. document formats for the Ans A small piece of information that a server sends
World Wide Web to a client. When a person visits a Web site with
It provides a means to XML is textbased formats cookie capabilities, its server sends certain
describe the structure of that provide mechanisms information about him/her to the browser, which is
text-based information in for describing document stored on his/her hard drive as a text file. At some
a document by denoting structures with the help of later time (such as returning to the site the next day),
certain text as headings, user defined Tags. the server retrieves the cookie.
paragraphs, lists, and to
6) What kind of data gets stored in cookies and
supplement that text with
how is it useful? (2015)1
interactive forms,
Ans When a Website with cookie capabilities is
embedded images, and
other objects using
visited , its server sends certain information about the
predefined Tags.
browser, which is stored in the hard drive as a text
file. It's a way for the server to remember things about
2) When do you prefer XML over HTML and
the visited sites.
why? (MP209-10)1
Ans) The first benefit of XML is that because you are 7) What do you understand by the terms Cookies
writing your own markup language, you are not and Firewall? (OD2005)1

Ans)Cookies: A small piece of information that a Ans)Open Source's proponents often claim that it offers
server sends to a client When you visit a Web site significant benefits when compared to typical Proprietary
with cookie capabilities, its server sends certain Software. Proprietary Software typically favour visible
information about you to your browser, which is features (giving marketing advantage) over harder-to
measure qualities such as stability,security and similar less
stored on your hard drive as a text file. At some later
glamorous attributes.
time (such as returning to the site the next day),the Open Source Software developers are evidently motivated
server retrieves the cookie. It‟s a way toi the server to by many factors but favouring features over quality is not
remember things about you. noticeable amongst them. For many developers, peer review
and acclaim is important, so it's likely that they will prefer
Theory Question : Open Source Softwares to build software that is admired by their peers. Highly
1. Write the name of any two popular Open Source prized factors are clean design, reliability and
Software which are used as operating systems. 2014 maintainability, with adherence to standards and shared
Ans: Linux and Unix are two open source operating community values preeminent.
systems. 8)Compare freeware and Shareware. (MP209-10)1
Ans)Freeware, the name derived from words "free"
(2) Write two advantages of using open source and"software". It is a computer software that is available for
software over proprietary software. 2013 use at no cost or for an optional fee. Freeware is generally
A) Two advantages of using open source software proprietary software available at zero price, and is not free
over proprietary software are: software. The author usually
Open Source Software is software whose source code restricts one or more rights to copy, distribute, and make
derivative works of the software.
is available to customer and it can be modified and
Shareware is usually offered as a trial version with certain
redistributed without any limitations whereas source features only available after the license is purchased, or as a
code of proprietary software is not available. full version, but for a trial period. Once the trial period
Open Source software may come free of cost or with has passed the program may stop running until a license is
payment of normal charges whereas proprietary purchased. Shareware is often offered without support,
software is neither open nor freely available. updates, or help menus, which only become available with
the purchase of a license. The words "free trial" or "trial
(3) Name two Proprietary softwares along with version" are indicative of shareware.
their application. (2012)1 Mislleneous
Ans Microsoft Office - For office applications 1) The following is a 32 bit binary number usually
Adobe Photoshop - For design related works represented as 4 decimal values, each representing 8
Autocad - For professional Design bits, in the range 0 to 255 (known as octets) separated by
MAYA - For professional animations & Movie decimal points. 140.179.220.200
making 3D Studio - For 3 dimensional objects What is it? What is its importance? (2017MP)1
Tally - For accounting Ans: It is an IP Address.It is used to identify the computers
Oracle Database - For database management on a network.
2) What out of the following, will you use to have an
(4) Compare Open Source Software and audio-visual chat with an expert sitting in a far-away
Proprietary Software. (2011)1 place to fix-up a technical issue? 2012
Ans Open source software refers to a program or (i) VolP(ii) Email(iii) FTP
software in which the source code (the form of the Ans (ii) VolP
program when a programmer writes a program in a
particular programming language) is available to the
general public for use and/or modification from its
original design free of charge.
Proprietary software is software that is owned by an
individual or a company (usually the one that
developed it). There are almost always major
restrictions on its use, and its source code is almost
always kept secret.
6) Write one advantage of each for Open Source
Software and Proprietary Software. 1
Ans. An Open Source Software is freely and liberally
licensed because of which users have right to study,
change. and improve its design and source code. A
Proprietary Software has a copyright owner, who can
restrict the user's control over the software, its
modification, or restrictions in publishing of modified
or unmodified versions.
7) Mention any two advantages of Open Source
Software over Proprietary Software. (2000)
NETWORKS FULL FORMS AUI – Attachment Unit Interface
ARPANET - Advanced Research Projects SNA – Systems Network Architecture
Agency Network VFIR – Very Fast Infrared
URI – Uniform Resource Identifier
CDMA – Code Division Multiple Access URN – Uniform Resource Name
FTP - FILE TRANSFER PROTOCOL P-P - Point to Point
FSF - FREE SOFTWARE FOUNDATION MIME – Mail and Multipurpose Internet Mail
Extensions
GPRS – General Packet Radio Service POP – Post Office Protocol
GNU - GNU‟s not Unix NNTP – Network News Transfer Protocol
GSM – Global System for Mobile HTTP – Hyper Text Transfer Protocol
(communication) NTP – Network Time Protocol
IMAP – Internet Mail Transfer Protocol
HTML - Hyper Text Markup Language SLIP – Serial Line Internet Protocol
HTTP – Hyper Text Transfer Protocol SIP – Session Initiation Protocol
MAN - Metropolitan Area Network PPP - Point to Point Protocol
MODEM - Modulator - Demodulator IPCP – IP Control Protocol
NCP – Network Control Protocol
PPP - Point To Point Protocol LCP – Link Control Protocol
SMS - Short Message/Messaging Service ITU – International Telecommunications Union
SMTP – Simple Mail Transfer Protocol PC – Personal Computer
TCP/IP - Transfer Control Protocol/Internet ISP – Internet Service Provider
SIM – Subscriber Identity Module
Protocol TDMA – Time Division Multiple Access
URL – Uniform Resource Locator TDM – Time Division Multiplexing
VoIP - Voice Over Internet Protocol IDEN – Integrated Digital Enhanced Network
WAN - Wide Area Network WCDMA –Wideband CDMA
PSTN – Public Switched Telephone Network
WLL(WiLL) – Wireless in Local Loop 1G, 2G, 3G, 4G, 5G – Fifth Generation
WWW - World Wide Web UMTS – Universal Mobile Telecommunications
XML – eXtensible Markup Language System / Universal Mobile Telephone System
EDGE – Enhanced Data rates for Global Evolution
SMSC – Short Message Service Center
THE ABOVE FULL FORMS ARE HLR – Home Location Register
PREVIOUSLY ASKED QUESTIONS Email – Electronic Mail
Fax – Fascimile
NSFNET - National Science Foundation Network VSNL – Videsh Sanchar Nigam Limited
LAN - Local Area Network DNS – Domain Name Server
PAN - Personal Area Network DHTML– Dynamic Hyper Text Markup Language
NIU - Network Interface Unit DECnet – Digital‟s family of communication protocols
NIC - Network Interface Card IE – Internet Explorer
TAP - Terminal Access Point(NIU = NIC = TAP) WiFi - Wireless Fidelity
bps - Bits Per Second LTE – Long Term Evolution
Bps - Bytes Per Second HDTV – High Definition Television
Kbps – Kilo bits Per Second WiMAX -Worldwide Interoperability for Microwave Access
KBps – Kilo Bytes Per Second ISD - International Subscriber Dialing
Mbps - Mega Bits Per Second ISDN - Integrated Services Digital Network
MBps – Mega Bytes Per Second IRC - Internet Relay Chat
Gbps - Giga Bits Per Second BWA – Broadband Wireless Access
GBps – Giga Bytes Per Second PHP - Hypertext Preprocessor
KHz – Kilo Hertz (earlier called,Personal Home Page)
MHz – Mega Hertz UNCITRAL – United Nation‟s Commission for
GHz – Giga Hertz International Trade related laws.
THz – Tera Hertz IT Act – The Information Technology Amendment Act
NFS – Network File System IP – Intellectual Property
VGM – Voice Grade Medium FAT – File Allocation Table
DGM – Data Grade Medium
STP – Shielded Twisted Pair “If wealth is lost, nothing is lost,
UTP – Unshielded Twisted Pair
LED – Light Emitting Diode If health is lost, something is lost,
LD – Laser Diode If character is lost, everything is lost”
OFC – Optic Fiber Cable, Fiber Optic Cable
PDA – Personal Digital Assistants
AM – Amplitude Modulation “THE FEAR OF THE
FM - Frequency Modulation
PM –
A/F –
Phase Modulation
Audio Frequency LORD
(Txd – Transmit, Rxd – Receive,
RTS – Request to Send, CD –Carrier Detect, IS THE BEGINNING
DSR – Data Set Ready, CTS – Clear to Send
DTR – Data Terminal Ready)
RJ45 – Registered Jack – 45 OF WISDOM”
BNC – Bayone – Neill – Concelman
4Marks Problem : Model 1(All in a single city) (ii) Name the most suitable wing where the Server
should be installed. Justify your answer.
1. Multipurpose Public School, Bangluru is Answer:
Setting up the network between its Different Wing Senior(S)- Because it has maximum number
Wings of school campus. There are 4 wings of computers.
Named as SENIOR(S),JUNIOR(J), ADMIN(A) (iii) Suggest a device/software and its placement
and HOSTEL(H). 2019MP4 that would provide data security for the entire
network of the School.
Multipurpose Public School, Bangluru Answer: Firewall - Placed with the server at Senior
(iv) Suggest a device and the protocol that shall be
needed to provide wireless Internet access to all
smartphone/laptop users in the campus of
Multipurpose Public School, Bangluru.
Answer:
Device Name: WiFi Router OR WiMax OR RF
Router OR Wireless Modem OR RFTransmitter
Protocol : WAP OR 802.16 OR TCP/IP OR VOIP
OR MACP OR 802.11
Distance between various wings are given below: 2) CASE STUDY BASED QUESTION: (2018)
Ayurveda Training Educational Institute is setting up
its centre in Hyderabad with four specialized
departments for Orthopedics, Neurology and
Pediatries along with an administrative office in
separate buildings. The physical distances between
these department buildings and the number of
computers to be installed in these departments and
administrative office are given as follows. You, as a
network expert, have to answer the queries as raised
by them in (i) to (iv)
Number of Computers installed at various wings are Shortest distances between various locations in
as follows: meters:
Administrative office to Orthopedics 55
Unit
Neurology Unit to Administrative 30
Office
Orthopedics Unit to Neurology Unit 70
Pediatrics Unit to Neurology Unit 50
Pediatrics Unit to Administrative 40
Office
Pediatrics Unit to Orthopedics Unit 110
(i) Suggest the best wired medium and draw the Number of Computers installed at various locations
cable layout to efficiently connect various wings of are as follows:
Multipurpose PublicSchool, Bangluru. Pediatrics Unit 40
Answer: Administrative Office 140
Best wired medium: Optical Fibre OR CAT5 OR Neurology 50
CAT6 OR CAT7 OR CAT8 OR Ethernet Cable Orthopedics Unit 80

(i) Suggest the most suitable location to install the As a network expert, provide the best possible answer
main server of this institution to get efficient for the following queries:
connectivity. i) Suggest a cable layout of connections between the
Ans: Administrative Office buildings.
(ii) Suggest the best cable layout for effective network
connectivity of the building having server with all the
other buildings.
Ans:
OR
Administrative Office is connected to Orthopedic,
Radiology, Pediatrics units
directly in a Star Topology
(iii) Suggest the devices to be installed in each of ii) Suggest the most suitable place (i.e. buildings) to
these buildings for connecting computers installed house the server of this organization.
within the building out of the following: Ans) The most suitable place/ building to house the
* Gateway * Modem * Switch server of this organization would be building Research
Ans: Switch Lab, as this building contains the maximum number of
(iv)Suggest the topology of the network and network computers.
cable for efficiently connecting each computer iii) Suggest the placement of the following device
installed in each of the buildings out of the following: with justification: a) Repeater b) Hub/Switch
Topologies: Bus Topology, Star Topology a) For layout1, since the cabling distance between
Network Cable: Single Pair Telephone, Coaxial Accounts to Store is quite large, so a repeater would
Cable, Ethernet Cable. ideally be needed along their path to avoid loss of
Topology : Star Topology signals during the course of data flow in this route.
Network Cable: Ethernet Cable / Coaxial Cable For layout2, since the cabling distance between Store
3) Rehaana Medicos Center has set up its new to Recresearch Lab is quite large, so a repeater would
center in Dubai. It has four buildings as shown in ideally be placed.
the diagram given below: (2017MP) b) In both the layouts, a Hub/Switch each would be
needed in all the buildings to interconnect the group of
cables from the different computers in each building.
iv) Suggest a system (hardware/software) to prevent
unauthorized access to or from the network.
A) Firewall
4) 2014

(ii) Suggest the most appropriate layout to connect all
three blocks for efficient communication.
(iii) Which type of network out of the following is

formed by connecting the computers of these three
blocks?
LAN MAN WAN
A)LAN
(iv) Which wireless channel out of the following
should be opted by RCI to connect to students from all
over the world?
Infrared Microwave Satellite
A) Satellite.
6.Great Studies University is setting up its
Academic schools at Sunder Nagar and planning to
set up a network. The university has 3 academic
schools and one administration center as shown in
the diagram below: (2011) 4
5)2013
Expected computers to be installed in each block

Block Computers
Administrative Block 30
Finance Block 20
Faculty Recording 100
Block
(i) Suggest the most appropriate block, where RCI
should plan to install the server.
A) Faculty Recording Block is most appropriate block
(i) Suggest the most suitable place (i.e. School/
to install the server.
Center) to install the server of this university with a
suitable reason. 1
Ans Option 1 : Admin center as it has the most
number of computers
Option 2.Business School as it will require minimum
cable length to connect other blocks
(ii) Suggest an ideal layout for connecting these
schools/ center for a wired connectivity. 1
Ans Option 1:
Option 2:
(e2) Suggest the most suitable place (i.e. building) to

house the server for this NGO. Also, provide a
suitable reason for your suggestion.
Ans. Training Building as it contains maximum
number of computers.
(e3) Suggest the placement of the following devices
(iii) Which device will you suggest to be placed/installed in with justification:
each of these schools /
(i) Repeater(ii) Hub/Switch
center to efficiently connect all the computers within these
Ans. (i) A Repeater should be placed when the
schools / center? 1
Ans Switch distance between any two connecting buildings
(iv) The university is planning to connect its admission exceeds 70 m.
office in the closest big city, which is more than 350 km (ii) Every building will need one Hub / Switch, to
from the university. Which type of network out of LAN, send signals to all of the workstations connected to it
MAN or WAN will be formed? Justify your answer.1 (e4) The NGO is planning to connect its International
Ans WAN as the distance is more than the range of LAN or office situated in Delhi. Which out of the following
MAN. 1 wired communication links, will you suggest for a
7) “Vidya for All” is an educational NGO. It is setting very high speed connectivity ?
up its new campus at Jaipur for its web-based activities. (i) Telephone Analog Line(ii) Optical Fiber
The campus has four buildings as shown in the diagram
(iii) Ethernet Cable
below: (2010 OD) 4
Ans. (ii) Optical Fibre
8) “Hindustan Connecting World Association “is
planning to start their offices in four major cities in
India to provide regional IT infrastructure support in
the field of Education & Culture. The company has
planned to set up their head office in New Delhi in
three locations and have named their New Delhi
offices as “Sales Office “,”Head Office “and “Tech
Office “.The company‟s regional offices are located at
“Coimbatore”,”Kolkata”and “Ahmadabad”. A rough
layout of the same is as follows: (2007OD) 4

Approximate distance between these offices as per 9) INDIAN PUBLIC SCHOOL in Darjeeling is
network survey team is as setting up the network between its different wings.
follows There are 4 wings named as SENIOR(S),
JUNIORS (J), ADMIN (A) and HOSTEL (H).
(2006OD)
Distance between various wings is given below:
Number of Computers
Wing A 10
Wing S 200
In continuation of the above, the company experts Wing J 100
have planned to install the following number of
computers in each of their offices: Wing H 50
Head Office 100 i) Suggest a suitable Topology for networking the
Sales Office 20 computer of all wings.1
Tech Office 50 Ans)Star Topology OR Bus Topology
Kolkata Office 50 ii) Name the wing where the server to be installed.
Ahmadabad Office 50 Justify your answer. 1m
Coimbatore Office 50 Ans)Wing S
1) Suggest network type(out of LAN,MAN,WAN) for as it has the maximum number of computers
connecting each of the following set of their offices: OR
Head Office and Tech Office WingA as it is placed in the Admin Wing (for security
Head Office and Coimbatore Office reasons)
Ans) Head Office and Tech Office: LAN iii) Suggest the placement of Hub/Switch in the
Head Office and Coimbatore Office: WAN network.
2) Which device you will suggest to be produced by Ans) Inside all the four wings
the company for connecting all the computers with in iv) Mention in economic technology to provide
each of their offices out of the following devices? internet accessibility to all wings.
Modem Telephone Switch/Hub 1m
Ans) Switch / Hub Ans:Any one of the following:
3) Which of the following communication media, will Dialup, TCP/IP, DSL, Modem, Broadband, Cable,
suggest to be procured by the company for connecting ISDN, Telephone Line, Co-axial, Ethernet Cable,
their local offices in New Delhi for very effective and Radiowave
fast communication?
Ethernet Cable, Optical Fibre,Telephone Cable 10) The Cyber Mind Organization has set up its
Ans) Optical Fibre new Branch at Mizoram for its office
O and web
4) Suggest a cable/writing layout for connecting the based activities. It has 4 Wings of buildings as
company‟s local offices located in New Delhi. Also, shown in the diagram: (OD 2005)
suggest an effective method /technology for
connecting the company‟s regional offices at
“Kolkata”,”Coimbatore”and “Ahmadabad”.
Ans) Optical Fiber/Star Topology
Wireless
Center to center distances between various blocks
Wing X to Wing Z 40 m
Wing Z to Wing Y 60 m
Wing Y to Wing X 135 m
Wing Y to Wing U 70 m
OR Wing X to Wing U 165 m
Wing Z to Wing U 80 m
Number of computers
Wing X 50
Wing Z 130
Wing Y 40
Wing U 15
1) Suggest a most suitable cable layout of connections
between the Wings, and topology. 1m
2) Suggest the most suitable place (i.e., Wing) to house the
server of this organization with a suitable reason, with
justification. 1m
Ans) Wing Z as it has largest number of computers
3) Suggest the placement of the following devices with
justification:1m
(i)Repeater (ii) Hub/Switch
4) The organization is planning to link its head office
situated in Delhi with the offices at Srinagar.1m Suggest an e2) Suggest the most suitable place (i.e. block) to
economic way to connect it; the company is ready to house the server of this organization with a suitable
compromise on the speed of connectivity. Justify your reason.
answer. 2m Ans) The most suitable place / block to house the
Ans)TCP/IP Dial Up (Most Suitable answer 1)
server of this organisation would be Block C, as this
OR
Telephone Link (Most Suitable answer 2) block contains the maximum number of computers,
OR thus decreasing the cabling cost for most of the
Microwave computers as well as increasing the efficiency of the
OR maximum computers in the network.
Radio Link/Radio Wave e3) Suggest the placement of the following devices
OR with justification
Satellite Link (i) Repeater (ii) Hub/Switch
OR Ans) (i) For Layout 1, since the cabling distance
WAN between Blocks A and C, and that between B and C
11)Knowledge Supplement Organisation has set up its are quite large, so a repeater each, would ideally be
new center at Mangalore for its office and web based
activities. It has 4 blocks of buildings as shown in the
needed along their path to avoid loss of signals during
diagram below: (MP109-10)4 the course of data flow in these routes.
For layout 2, since the distance between Blocks A and

C is large so a repeater would ideally be placed in
between this path.
(ii) In both the layouts, a hub/switch each would be

needed in all the blocks, to interconnect the group of
cables from the different computers in each block.
e1) Suggest a cable layout of connections between the

blocks.
Ans)
e4) The organization is planning to link its front office
situated in the city in a hilly region where cable
connection is not feasible, suggest an economic way
to connect it with reasonably high speed?
Ans)The most economic way to connect it with a
reasonable high speed would be to use radio wave
transmission, as they are easy to install, can travel
long distances, and penetrate buildings easily, so they
are widely used for communication, both indoors and
outdoors. Radio waves also have the advantage of e2) Suggest the most suitable place (i.e. building) to
being omni directional, which is they can travel in all house the server of this organization with a suitable
the directions from the source, so that the transmitter reason.
and receiver do not have to be carefully aligned Ans)The most suitable place / block to house the
physically. server of this organisation would be Raj Building, as
this block contains the maximum number of
12) Ravya Industries has set up its new center at computers, thus decreasing the cabling cost for most
Kaka Nagar for its office and web based activities. of the computers as well as increasing the efficiency
The company compound has 4 buildings as shown of the maximum computers in the network.
in the diagram below: (MP209-10) 4 e3) Suggest the placement of the following devices
with justification:
(i) Internet Connecting Device/Modem
(ii) Switch
Ans)(i)Raj Building
(ii) In both the layouts, a hub/switch each would be
needed in all the buildings, to interconnect the group
of cables from the different computers in each block
e4) The organisation is planning to link its sale
counter situated in various parts of the same city,
which type of network out of LAN, MAN or WAN
will be formed? Justify your answer.
Ans)The type of network that shall be formed to link
the sale counters situated in various parts of the same
city would be a MAN, because MAN (Metropolitan
Area Networks) are the networks that link computer
facilities within a city.
13)Knowledge Supplement Organisation has set up

its new center at Mangalore for its office and
web based activities. It has 4 blocks of
buildings as shown in the diagram below:
(MP108-09)
e1) Suggest a cable layout of connections between the

buildings.
Ans)

e1) Suggest a cable layout of connections between
the blocks.1
Ans)Layout 1:
Layout Option 2:
Since the distance between Block A and Block B is
quite short e4) The organization is planning to link its front office
situated in the city in a hilly region where cable connection
is not feasible, suggest an economic way to connect it with
reasonably high speed? 1
Ans) The most economic way to connect it with a
reasonable high speed would be to use radio wave
transmission, as they are easy to install, can travel long
distances, and penetrate buildings easily, so they are widely
used for communication, both indoors and outdoors. Radio
e2) Suggest the most suitable place (i.e. block) to waves also have the advantage of being omni directional,
house the server of this organisation with a suitable which is they can travel in all the directions from the
reason. 1 source, so that the transmitter and receiver do not have to be
Ans) The most suitable place / block to house the carefully aligned physically.
server of this organisation would be Block C, as this 4Marks Problem : Model 2 (Between 2 distant places)
block contains the maximum number of computers, 1)Hi Standard Tech Training Ltd is a Mumbai based
thus decreasing the cabling cost for most of the organization which is expanding its office set-up to
computers as well as increasing the efficiency of the Chennai. At Chennai office compound, they are
maximum computers in the network. planning to have 3 different blocks for Admin,
e3) Suggest the placement of the following Training and Accounts related activities. Each block
devices with justification 1 has a number of computers, which are required to be
i)Repeater ii)Hub/Switch connected in anetwork for communication, data and
Ans) For Layout 1, since the cabling distance resource sharing.
between Blocks A and C, and that between B and C As a network consultant, you have to suggest the best
are quite large, so a repeater each, would ideally be network related solutions for them for issues/problems
needed along their path to avoid loss of signals during raised by them in (i) to (iv), as per the distances
the course of data flow in these routes between various blocks/locations and other given
parameters. (2017)
For layout 2, since the distance between Blocks A

and C is large so a repeater would ideally be placed in
between this path
In both the layouts, a hub/switch each would be

needed in all the blocks, to interconnect the group of
cables from the different computers in each block
i) Suggest the most appropriate block/ location to Number of Computers installed at various
house the SERVER in the CHENNAI Office (out of locations are as follows:
the 3 blocks) to get the best and effective connectivity.
Justify your answer. (1)
Ans)Training Block - Because it has maximum
number of computers.
ii) Suggest the best wired medium and draw the cable
layout (Block to Block) to efficiently connect various Note: In Villages, there are community centers, in which
blocks within the CHENNAI office compound. 1 one room has been given as training center to this
Ans) Best wired medium: organization to install computers.The organization has got
Optical Fibre OR CAT5 OR CAT6 OR CAT7 OR financial support from the government and top IT
companies.
CAT8 OR Ethernet Cable (i) Suggest the most appropriate location of the SERVER in
the YHUB (out of the 4 locations), to get the best and
effective connectivity. Justify your answer. 1
Ans YTOWN
Justification
● Since it has the maximum number of computers.
● It is closest to all other locations.
(ii) Suggest the best wired medium and draw the cable
layout (location to location) toefficiently connect various
locations within the YHUB. 1
Ans Optical Fiber
iii) Suggest a device/software and its placement that
would provide data security for the entire network of
the CHENNAI office. (1)
Ans) Firewall - Placed with the server at the Training
Block OR
Any other valid device/software name
iv) Suggest a device and the protocol that shall be
needed to provide wireless Internet access to all
smartphone/laptop users in the CHENNAI office(1)
A)Device Name: WiFi Router OR WiMax OR RF (iii) Which hardware device will you suggest to connect all
the computers within each location of YHUB? 1
Router OR Wireless Modem OR RF Transmitter
Ans Switch OR Hub
Protocol : WAP OR 802.16 OR TCP/IP OR VOIP (iv) Which service/protocol will be most helpful to conduct
OR MACP OR 802.11 live interactions of Experts from Head Office and people at
YHUB locations? 1
2)Intelligent Hub India is a knowledge community Ans Videoconferencing OR VoIP OR any other correct
aimed to uplift the standard of skills and knowledge in service/protocol
the society. It is planning to setup its training centers in
multiple towns and villages pan India with its head 3) Xcelencia Edu Services Ltd. is an educational
offices in the nearest cities.They have created a model of organization. It is planning to set up its India campus at
their network with a city, a town and 3 villages as Hyderabad with its head office at Delhi. The Hyderabad
follows: (2016) 4 campus has 4 main buildings ‐
As a network consultant, you have to suggest the best ADMIN, SCIENCE, BUSINESS and MEDIA.
network related solutionsfor their issues/problems
raised in (i) to (iv), keeping in mind the distances You as a network expert have to suggest the best
between various locations and other given parameters. network related solutions for their problems raised in (i)
to (iv), keeping in mind the distances between the
buildings and other given parameters. (2015)

(i) Suggest the most suitable place (Le. building) to
house the server of this organization. Also give a
reason to justify your location.
(i) Suggest the most appropriate location of the server Ans Building "RED", since it contains maximum
inside the HYDERABAD campus (out of the 4 buildings), number of computers OR
to get the best connectivity for maximum no. of computers. Building "BLUE", since it is closest to "GREEN" and
Justify your answer.1 "RED"
Ans ADMIN (due to maximum number of computers) (ii) Suggest a cable layout of connections between the
(ii) Suggest and draw the cable layout to efficiently connect buildings inside the campus.
various buildings 'within the HYDERABAD campus for
Ans Layout 1:
connecting the computers.
(iii) Which hardware device will you suggest to be

procured by the company to be installed to protect and Layout 2
control the intemet uses within the campus?1
Ans Firewall OR Router
(iv) Which of the following will you suggest to establish
the online face‐to‐face communication between the people
in the Admin Office of HYDERABAD campus and DELHI
Head Office?
(a) E‐mail (b) Text Chat (c) Video Conferencing
(d) Cable TV 1
Ans Video Conferencing
4)Workalot Consultants are setting up a secured

network for their office campus at Gurgaon for
their day-to-day office and web-based activities. (iii) Suggest the placement of the following devices
They are planning to have connectivity between 3 with justification:
buildings and the head office situated in Mumbai (1) Switch (2) Repeater
Answer the questions (i) to (iv) after going through Ans (1) Switch:
the building positions in the campus and other In each of the buildings, since a network switch is a
details, which are given below: (2012) 3 networking device that joins multiple computers
together within one local area network (LAN).
(2) Repeater:
For the Layout 1 drawn in (e2)- Between buildings
"GREEN" and "RED", since distance between these
two buildings is greater than 70 m which will
otherwise lead to loss of signal intensity for data to be
transferred.
For the Layout 2 drawn in (e2): Repeater is not
needed, since distance between both the buildings
connected to "Ganga" is less than 70 m, not leading to
any signal loss OR

Any other placement of Repeater with proper (E2) Suggest the most suitable place (i.e. building) to house
justification the server of this organisation, with a suitable reason. 1
(iv) The organization is planning to provide a high Ans Academic Building as it contains maximum number of
speed link with its head office situated in the computers.
(E3) Suggest an efficient device from the following to be
MUMBAI using a wired connection. Which of the
installed in each of the buildings to connect all the
following cable will be most suitable for this job? computers : 1
(i) Optical Fibre (ii) Co-axial Cable (iii) Ethernet (i) GATEWAY (ii) MODEM (iii) SWITCH
Cable Ans SWITCH
Ans (i) Optical Fibre (E4) Suggest the most suitable (very high speed) service to
provide data connectivity between Admission Building
5) Eduminds University of India is starting its first located in Delhi and the campus located in Par am pur from
campus in a small town Parampur of Central India the following options: 1
with its center admission office in Delhi. The _ Telephone line
university has 3 major buildings comprising of _ Fixed-Line Dial-up connection
_ Co-axial Cable Network
Admin Building, Academic Building and Research
_ GSM
Building in the 5 KM area Campus. As a network _ Leased line
expert, you need to suggest the network plan as per _ Satellite Connection
(E1) to (E4) to the authorities keeping in mind the Ans Satellite Connection OR Leased line
distances and other given parameters. (2009 OD)
6)”China Middleton Fashion” is planning to expand their
network in India, starting with two cities in India to provide
infrastructure for distribution of their product. The company
has planned to setup their main office in Chennai at three
different locations and have named their offices as
“Production Unit”, “Finance Unit” and “Media Unit “.The
Company has its corporate unit in Delhi. A rough layout of the
same is as follows: (2008 OD)
Approximate distance between these Units is as follows:
In continuation of the above, the company experts have planned to

install the following number of computers in each of their offices:
(E1) Suggest to the authorities, the cable layout amongst

various buildings inside the university campus for
connecting the buildings. 1 1) Suggest the kind of network required (out of LAN, MAN,
WAN) for connecting each of the following office units: i)
Production Unit and Media Unit
ii) Production Unit and Finance Unit
Ans) Production Unit and Media Unit : MAN
Production Unit and Finance Unit : LAN
2) Which one of the following devices will you suggest for
connecting all the computers with in each of their office units? i)
Switch/Hub ii) Modemii) Telephone
Ans) Switch / Hub
Ans)

3) Which of the following communication media, you will suggest
to be procured by the company for connecting their local office
units in Chennai for very effective (High Speed) communication?
i) Telephone cable ii) Optical Fibre iii) Ethernet Cable
Ans) Optical Fibre
4) Suggest a cable/wiring layout for connecting the company‟s
local office units located in Chennai. Also, suggest an effective
method/technology for connecting the company‟s office unit
located in Delhi.
Ans)
For Any Doubts or for good

suggestions……….
Please feel free to contact:
MRK
[email protected]
VERY IMPORTANT NOTICE

DEAR READER,
This material is meant only for slow learners
to give an idea of questions pattern. If any
student systematically practice these models,
will get good marks (but not full marks).
Especially we cannot guess the theory
questions. Theory questions will come from
any corner of the syllabus. (Some times only
theory questions were asked from the previous
questions)
BUT STUDENTS ARE ADVISED TO
READ ENTIRE SYLLABUS TO GET FULL
MARKS.
As I collected this material from various
sources, there might be some typing errors or
technical errors, etc.

18691ptla - Xii Computer - Part 2

Uploaded by

Copyright:

Available Formats

18691ptla - Xii Computer - Part 2

Uploaded by

Document Information

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

18691ptla - Xii Computer - Part 2

Uploaded by

Copyright:

Available Formats

11.

DATA BASE CONCEPTS (2M) M001 JAYA SCIENCE

Answer: (i) Write the names of most appropriate

XII Computer – PART 2 (Refer mrkcomputer.blogspot.in ) 2 PRAISE THE LORD

XII Computer – PART 2 (Refer mrkcomputer.blogspot.in ) 3 PRAISE THE LORD

XII Computer – PART 2 (Refer mrkcomputer.blogspot.in ) 5 PRAISE THE LORD

XII Computer – PART 2 (Refer mrkcomputer.blogspot.in ) 6 PRAISE THE LORD

XII Computer – PART 2 (Refer mrkcomputer.blogspot.in ) 9 PRAISE THE LORD

b1)Write SQL commands for the following

XII Computer – PART 2 (Refer mrkcomputer.blogspot.in ) 12 PRAISE THE LORD

XII Computer – PART 2 (Refer mrkcomputer.blogspot.in ) 13 PRAISE THE LORD

(i) To display Firstname, Lastname, Address and City of

XII Computer – PART 2 (Refer mrkcomputer.blogspot.in ) 15 PRAISE THE LORD

(i) To display W_ID Firstname, address and City of all

XII Computer – PART 2 (Refer mrkcomputer.blogspot.in ) 16 PRAISE THE LORD

Write SQL queries from b to g.

XII Computer – PART 2 (Refer mrkcomputer.blogspot.in ) 17 PRAISE THE LORD

22) Consider the following tables GAMES and PLAYER

i)To display the name of all activities with their Acodes in

XII Computer – PART 2 (Refer mrkcomputer.blogspot.in ) 20 PRAISE THE LORD

Model 1: Boolean Laws (2 Marks)

Model 1A: Boolean Laws (Truth Table) (2M)

Comparing Column 5 and 8, Distributive law is

3) State any one Absorption Law of Boolean

State and verify De Morgan‟s law in Boolean

7) Verify the following using truth table: (2012)2

4. Name the law shown below and verity it using a

Ans) H(A,B,C) = (A+B+C).(A‟+B+C‟).(A‟+B‟+C)

XII Computer – PART 2 (Refer mrkcomputer.blogspot.in ) 24 PRAISE THE LORD

Model 3B: Draw the Logic Circuit (2 Marks)

3.Draw the equivalent logic circuit for the following

XII Computer – PART 2 (Refer mrkcomputer.blogspot.in ) 25 PRAISE THE LORD

Ans) Answer: X‟Z‟+Y‟W‟+Y‟Z+XZW‟

7) Draw a logical circuit diagram for the following

2) Represent the Boolean expression X‟Y+Y‟Z with

XII Computer – PART 2 (Refer mrkcomputer.blogspot.in ) 26 PRAISE THE LORD

Model 6B: Express the following in POS (1 Mark)

XII Computer – PART 2 (Refer mrkcomputer.blogspot.in ) 27 PRAISE THE LORD

XII Computer – PART 2 (Refer mrkcomputer.blogspot.in ) 28 PRAISE THE LORD

Advantages of Star Topology over Bus Topology: ●

XII Computer – PART 2 (Refer mrkcomputer.blogspot.in ) 33 PRAISE THE LORD

XII Computer – PART 2 (Refer mrkcomputer.blogspot.in ) 34 PRAISE THE LORD

XII Computer – PART 2 (Refer mrkcomputer.blogspot.in ) 37 PRAISE THE LORD

XII Computer – PART 2 (Refer mrkcomputer.blogspot.in ) 38 PRAISE THE LORD

(iii) Which type of network out of the following is

Expected computers to be installed in each block

(e2) Suggest the most suitable place (i.e. building) to

XII Computer – PART 2 (Refer mrkcomputer.blogspot.in ) 40 PRAISE THE LORD

Center to center distances between various blocks

For layout 2, since the distance between Blocks A and

(ii) In both the layouts, a hub/switch each would be

e1) Suggest a cable layout of connections between the

13)Knowledge Supplement Organisation has set up

e1) Suggest a cable layout of connections between the

XII Computer – PART 2 (Refer mrkcomputer.blogspot.in ) 43 PRAISE THE LORD

For layout 2, since the distance between Blocks A

In both the layouts, a hub/switch each would be

XII Computer – PART 2 (Refer mrkcomputer.blogspot.in ) 45 PRAISE THE LORD

(iii) Which hardware device will you suggest to be

4)Workalot Consultants are setting up a secured