QUESTION BANK WITH SOLUTIONS FOR SLOW BLOOMERS

BOOLEAN ALGEBRA

Q1. State & Prove Indempotence Law.
Ans: Law states that : X+X=X
Proof: By truth table:
If X=0
X+X 0+00
If X=1
X+X1+11 hence proved / Q1. State & Prove Indempotence Law.
Law states that : X.X=X
Proof: By truth table:
If X=0
X.X 0.00
If X=1
X.X1.11 hence proved
Q2. State & Prove Complementarity Law.
Ans: Law states that : X+X’=1
Proof: By truth table:
If X=0
X+X’ 0+11
If X=1
X+X’1+01 hence proved / Q2. State & Prove Complementarity Law.
Law states that : X.X’=0
Proof: By truth table:
If X=0
X.X’ 0.10
If X=1
X.X’1.00 hence proved
Q3. Draw a Logical Circuit Diagram for the following Boolean Expression:
A.(B+C’)
Ans:

Q4. Write the equivalent Boolean Expression for the following Logic Circuit

Ans: F(P,Q)=(P'+Q).(P+Q')
Q5. Write the equivalent Boolean Expression for the following Logic Circuit.

Ans: XY+(XY)’+X’
Q6: Convert the following Boolean expression into its equivalent Canonical Product of Sum form (POS):
A.B’.C + A’.B.C +A’.B.C’
Ans: A.B’.C + A’.B.C +A’.B.C’ = Π(0,1,4,6,7)
=(A+B+C).(A+B+C’).(A’+B+C).(A’+B’+C).(A’+B’+C’)
Q7: Write the POS form of a Boolean function F, which is represented in a truth table as follows:
U / V / W / F
0 / 0 / 0 / 1
0 / 0 / 1 / 0
0 / 1 / 0 / 1
0 / 1 / 1 / 0
1 / 0 / 0 / 1
1 / 0 / 1 / 0
1 / 1 / 0 / 1
1 / 1 / 1 / 1
Ans: F(U,V,W) = (U+V+W’).(U+V’+W’).(U’+V+W’)
Q8: A Boolean function F defined on three input variable X, Y, Z is 1 if and only if the number of 1(One) input is odd (e.g. F is 1 if X=1, Y=0, Z=0). Draw the truth table for the above function and express it in canonical sum of product form.
Ans:
X / Y / Z / F
0 / 0 / 0 / 0
0 / 0 / 1 / 1
0 / 1 / 0 / 1
0 / 1 / 1 / 0
1 / 0 / 0 / 1
1 / 0 / 1 / 0
1 / 1 / 0 / 0
1 / 1 / 1 / 1
Canonical SOP
XYZ’+XY’Z+XY’Z’+XYZ
Q9: Design (A+B).(C+D) using NAND Gate

Q12: If F(a,b,c,d)=∑(0,2,4,5,7,8,10,12,13,15), obtain the simplified form using K-Map.
Ans:

Quad 1 = c’d’
Quad 2 = bd
Quad 3 = b’d’
If F(a,b,c,d)=∑(=c’d’+bd+b’d’)
Q13.

Q14


Q (15)

DATA BASE MANAGAMENT SYSTEM(DBMS)
Q(1)NOTE : Write SQL commands for (b) to (g) and write the outputs for (h) on the basis of tables
FURNITURE and ARRIVALS.. Table : FURNITURE
(b) To show all information about the Baby cots from the FURNITURE table. 1
(c) To list the ITEMNAME which are priced at more than 15000 from the FURNITURE table. 1
(d) To list ITEMNAME and TYPE of those items, in which DATEOFSTOCK is before 22/01/02 from the FURNITURE table in descending order of ITEMNAME. 1
(e) To display ITEMNAME and DATEOFSTOCK of those items, in which the DISCOUNT percentage is more than 25 from FURNITURE table. 1
(f) To count the number of items, whose TYPE is “Sofa” from FURNITURE table.1
(g) To insert a new row in the ARRIVALS table with the following data :1
14, “Velvet touch”, “Double bed”, {25/03/03},25000, 30
(h) Give the output of following SQL statement : 2
NOTE : Outputs of the below mentioned queries should be based on original data given in both the
tables, i.e., without considering the insertion done in (g) part of this question :
(i) Select COUNT(distinct TYPE) from FURNITURE;
(ii) Select MAX(DISCOUNT) from FURNITURE, ARRIVALS;
(iii) Select AVG(DISCOUNT) from FURNITURE where TYPE = “Baby cot”;
(iii) Select SUM(PRICE) from FURNITURE where DATEOFSTOCK<{12/02/02};
2 (a) What do you understand by Union & Cartesian Product operations in relational algebra? 2
Consider the following tables WORKER and PAYYLEVEL and answer (b) and (c) parts of this question: Table: WORKER

(b) Write SQL commands for the following statements:
(i) To display the details of all WORKERs in descending order of DOB.
(ii) To display NAME and DE;SIG of those WORKERs, whose PLEVEL is either P001 or P002.
(iii) To display the content of all the WORKERs table, whose DOB is in between '19-JAN-1984' and '18-JAN-1987'.
(iv) To add a new row with the following:
19, 'Daya Kishore', 'Operator', 'P003', '19-Jun-2008', '11-Jun-1984'
(c) Give the output of the following SQL queries: 2
(i) SELECT COUNT (PLEVEL), PLEVEL FROM WORKER GROUP BY PLEVEL;
(ii) SELECT MAX (DOB), MIN (DOJ) FROM WORKER;
(iii) SELECT Name, Pay FROM WORKER W, PAYLEVEL P
WHERE W. PLEVEL = S. PLEVEL AND P.ECODE<13 ;
(iv) SELECT PLEVEL, PAY+ALLOWANCE FROM PAYLEVEL WHERE PLEVEL= 'P003'
Q(3) Consider the following tables EMPLOYEE and SALGRADE and answer (b) and (c) parts of this question:

(b) Write SQL commands for the following statements: 4
(i) To display the details of all EMPLOYEEs, in descending order of DOJ
(ii) To display NAME and DE51G of those EMPLOYEEs, whose SALGRADE is either 502 or 503
(iii) To display the content of all the EMPLOYEEs table, whose DOJ is in between'09-Feb-2006' and '08-Aug-2009'.
(iv) To add a new row with the following:
109, 'Harish Roy', 'HEAD-IT', 'S02', '09-Sep-2007, '21-Apr-1983'
(c) Give :the output of the following SQL queries: 2
(i) SELECT COUNT (SGRADE), SGRADE FROM EMPLOYEE GROUP BY SGRADE;
(ii) SELECT MIN(DOB), MAX (DOJ) FROM EMPLOYEE;
(iii) SELECT NAME , SALARY FROM EMPLOYEE E, SALGRADE
S WHERE E.SGRADE= S.SGRADE AND E.ECODE<103;
(iv) SELECT SGRADE, SALARY+HRA ET:)M SALGRADE WHERE SGRADE='S02';
Q(4). 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): (6)
TABLE : DOCTOR
ID NAME DEPT SEX EXPERIENCE
101 John ENT M 12
104 Smith ORTHOPEDIC M 5
107 George CARDIOLOGY M 10
114 Lara SKIN F 3
109 K George MEDICINE F 9
105 Johnson ORTHOPEDIC M 10
117 Lucy ENT F 3
111 Bill MEDICINE F 12
130 MorphyORTHOPEDIC M 15
TABLE : SALARY
1D BASIC ALLOWANCE CONSULTATION
101 12000 1000 300
104 23000 2300 500
107 32000 4000 500
114 12000 5200 100
109 42000 1700 200
105 18900 1690 300
130 21700 2600 300
i. Display NAME of all doctors who are in “MEDICINE” having mo than 10 years experience fromthe table DOCTOR.
ii. Display the average salary of all doctors working in “ENT” department using the tables
DOCTOR and SALARY. Salary = BASIC + ALLOWANCE
iii. Display the minimum ALLOWANCE of female doctors.
iv. Display the highest consultation fee among all male doctors.
v. SELECT count( * ) from DOCTOR where SEX “F”
vi. SELECT NAME, DEPT, BASIC from DOCTOR, SALARY where DEPT = “ENT” and DOCTOR.ID =SALARY.ID
Q 5)Write SQL commands for i) to iv) and the outputs for v) on the basis of tables MOVIES. 6
MOVIES
No / Title / Type / Rating / Star / Qty / Price
1 / Australia / Comedy / G / Nicole Kidman / 4 / 35.95
2 / The Reader / Comedy / R / Jason / 2 / 69.95
3 / The Dark Knight / Action / PG / Heath Ledger / 7 / 49.95
4 / Slum Dog Millionaire / Drama / G / Anil Kapoor / 3 / 29.95
5 / Frost/Nixon / Drama / R / Frank Langella / 3 / 19.95
6 / The Curious Case of Benjamin Button / Drama / G / David Fincher / 2 / 44.95
7 / Revolutionary Road / Drama / PG / Kate Winslet / 2 / 31.95
8 / Crocodile Business / Comedy / PG13 / Harris / 2 / 69.95
9 / Michael Clayton / Action / R / George Clooney / 3 / 99.95
10 / No Country for Old Men / Action / R / Javier Bardem / 1 / 29.95
i) Display a list all movies with Price over 20 and sorted by Price.
ii) Display all the movies sorted by QTY in decreasing order.
iii) Display a report listing a Title, current price and replacement value for each movie as Qty * Price * 1.15
iv) Display all the movies and their price whose type is Drama.
v) Give the outputs for the following statements.
a) SELECT AVG(Price) FROM MOVIES WHERE Price < 30;
b) SELECT MAX(Price) FROM MOVIES WHERE Price > 30;
c) SELECT SUM(Price * Qty) FROM MOVIES WHRE Qty< 4;
d) SELECT COUNT(DISTINCT TYPE) FROM MOVIES;
Q(6)Given the following tables for a database LIBRARY
Table : Books

Write SQL queries for (b) to (g) and output of (h):
(b) To show Book name, Author name and Price of books of EPB. Publishers. 1
(c) To list the names from books of Fiction type. 1
(d) To display the names and price of the books in descending order of their price. 1
(e) To increase the price of all books of First Publ. Publishers by 50. 1
(f ) To display the Book_Id, Book_Name and Quantity_Issued for all books which have been issued.
(The query will require contents from both the tables.) 1
(g) To insert a new row in the table Issued having the following data :1
“F0002”, 4
(h) Give the output of the following queries based on the above tables :2
(i) SELECT COUNT(DISTINCT Publishers) FROM Books;
(ii) SELECT SUM(Price) FROM Books WHERE Quantity > 5;
(iii) SELECT Book_Name, Author_Name FROM Books WHERE Price < 500;
(iv) SELECT COUNT (*) FROM Books;

Question Bank

Networking and Communication Technologies

COMPUTER SCIENCE

For Slow Bloomers:

  1. Which Protocol is used for the transfer of hypertext document on the internet?

Ans: HTTP ( or Hyper Text Transfer Protocol)

  1. Two doctors in the same room have connected their Palm Tops using Bluetooth for workingon a Group presentation. Out of the following, what kind of Network they have formed?

LAN, MAN, PAN, WAN

Ans : PAN

  1. Arrange the following communication channels in ascending order of their data transmissionrates.

Ethernet Cable, Optical Fiber, Telephone Cable, Co-axial Cable?

Ans: Telephone Cable, Ethernet Cable, Co-axial Cable, Optical Fiber

  1. Jai Khanna is confused between the terms Domain Name and URL. Explain the differencewith the help of appropriate examples of each.

Ans: A URL (Uniform Resource Locator) is the complete address of a document on theweb, whereas a domain name specifies the location of document's web server. Adomain name is a component of the URL used to access web sites.For example the web address

a URL.In this URL is the domain name.

  1. Define any two threats to Network Security.

Ans: Denial of Service: It refers to any threat that prevents the legitimate users fromaccessing the network resources or processing capabilities.

Snooping: It refers to any threat that results in an unauthorized user obtaininginformation about a network or the traffic over that network.

  1. What do you mean by a computer network?

Ans:- Computer network is an interconnection of autonomous computers connected together usingtransmission media.

  1. What is the need for networking the computers?

Ans:- 1. Sharing of Information,

2. Reliability

3. Reduces cost

4. Time saving

  1. What is the full form of ARPANET?

Ans:- Advanced Research Projects Agency Network

  1. What are various data transmission modes?

Ans:- There are three modes of data transmission

  • Simplex
  • Half-duplex
  • Full-duplex
  1. What is the difference between Simplex and half duplex transmission?

Ans:- In simples transmission mode, the data can be transferred in only one direction where as in halfduplex transmission mode, the data can be transmitted in both directions but one at a time.

  1. What do you mean by MODEM?

Ans:- MODEM stands for MODulatorDEModuator. It is a device that can convert an analog signal intodigital signal and vice versa.

  1. Define the terms Bandwidth.

Ans:- Bandwidth is the range of frequencies that is available for the transmission of data. Wider thebandwidth of a communication channel, the more data it can transmit in a given period of time.

  1. What are various types of transmission media?

Ans:- There are two broad categories of transmission media

  • Guided media
  • Unguided Media
  1. Explain in brief the advantages and disadvantages of Twisted pair Cable.

Ans:- Advantages

  • Inexpensive
  • Often available in existing phone system
  • Well tested and east to get

Disadvantages

  • Susceptible to noise (sound, energy etc.)
  • Not as durable as coaxial cable
  • Does not support high speed
  1. What do you mean by communication protocol?

Ans:- A protocol is a set of rules to enable computers to connect with one another and to exchangeinformation with minimum possible error.

AT A GLANCE

  1. List various functions of Communication protocol.

Ans:- Data sequencing, Data Formatting, Flow control, Error Control,Connection Establishment andtermination,Data Security

  1. List commonly used protocols.

Ans:- HTTP, TCT/IP, FTP, SLIP, PPP, SMTP, POP, ICMP

  1. What are the main functions of TCP

Ans:- The TCP does the following activities

  • It breaks the data into packets that the network
  • Verifies that all the packets arrived at the destination
  • Reassembles the data
  1. What do you mean by network topology?

Ans:- Topology is how the nodes/computers are interconnected together.

  1. List various types of Networks.

Ans:- LAN, MAN, WAN

  1. Give names of various networking topologies in LAN.

Ans:- 1.Star Topology

2. Ring topology

3. Bus topology

4. Mesh Topology

  1. Write two advantages and two disadvantages of STAR topology.

Ans:- Advantages of STAR topology

  • It is easy to modify and add new computers to a star network without disturbing the rest of the network.
  • Troubleshooting a star topology network is easy

Disadvantages

  • All the nodes are dependent on the central system. Hub. Failure of hub result in shutting down of whole of the system
  • Long cable length is required
  1. What is NFS?

Ans:- NFS stands for Network File System. NFS is a protocol that allows a set of computers to accesseach others files.

  1. Differentiate between Star and Bus Topology of networks.

Ans: Star Topology: It is characterized by central switching node (communicationcontroller) and unique path (point to point link) for each host. It is easy to add andremove hosts easily.

Bus Topology: It is characterized by common transmission medium shared by all theconnected hosts, managed by dedicated nodes. It offers simultaneous flow of data andcontrol.

  1. Define a network.

Ans : A computer network is a system in which computers are connected to shareinformation and resources.

  1. Write two advantages of networks.

Ans. : Advantages:

I. Data or information can be shared among the users.

ii. Fast communication can be achieved.

iii. Expensive hardware or software can be shared among the users.

  1. Write two disadvantages of networks.

Ans: Disadvantages of networks:

i. Sophisticated Hardware and software technology is required.

ii. Expensive to install network.

iii. Threat to security of data and information.

  1. What is MAC Address?

Ans: In computer networking, a Media Access Control address (MAC address) is aunique identifier assigned to most network adapters or network interface cards (NICs)by the manufacturer for identification, and used in the Media Access Control protocolsub-layer.

  1. What is IP address?

Ans: A unique number consisting of 4 parts separated by dots, e.g. 165.113.245.2

Every machine that is on the Internet has a unique IP number - if a machine does nothave an IP number, it is not really on the Internet.

  1. What is domain name? How is it alternatively known?

Ans: The unique name that identifies an Internet site. Domain Names always have 2or more parts, separated by dots. The part on the left is the most specific, and the parton the right is the most general. E.g.: matisse.net

  1. What are the various types of networks?

Ans 8: Network can be classified on the basis of their size, complexity and geographical

spread. On the basis of geographical spread it can be classified as Local Area Network,

Metropolitan Area Network and Wide Area Network.

  1. What is the difference between MAN and WAN?

Ans. 9: A metropolitan area network (MAN) is a large computer network that usually

spans a city or a large campus.

WAN is a network that covers an area larger than a single building or campus such asacross the cities or countries.

  1. What is protocol? How many types of protocols are there?

Ans. When computers communicate each other, there needs to be a common set of rules andinstructions that each computer follows. A specific set of communication rules is called a protocol. Someprotocol: PPP, HTTP, SLIP, FTP, TCP/IP

  1. What is the difference between Networking and Remote Networking?

Ans. The main difference between Networking and Remote Networking, is the network which we usein offices or other places locally such LAN or INTERNET and remote networking is one which we useTERMINAL Services to communicate with the remote users such WAN.

  1. What is meant by Topology? Name some popular topologies.

Ans: Network topology is defined as the interconnection of the various elements(links, nodes, etc.) of a computer network. In computer networking, topology refers tothe layout of connected devices.

• Bus topology

• Star topology

• Ring topology

• Tree topology

• Mesh topology

  1. What are the factors that must be considered before making a choice for the topology?

Ans: Cost of Expenses required for implementation of network, Reliability of a particulartopology and flexibility of system for future adjustment; are the various factors that must beconsidered before making a choice for the topology.

  1. What are the similarities and differences between bus and tree topologies?

Ans: In bus topology each machine is connected to a single cable. Each computer orserver is connected to the single bus cable through some kind of connector.

Tree topology is a network with the shape of an inverted tree in which a single linkbetween two nodes.

  1. What are the limitations of star topology?

Ans: i. Central node dependency: In this topology central node is a controller ofthe network. If the central node fails, the entire network will be failed.

ii. Difficult to expand: The addition of a new node to a network involves a connectionall the way to the central node.

  1. When do you think, ring topology becomes the best choice for a network?

Ans: In case if we need less connection of wires, very fast communication speed; aring topology becomes the best choice for a network. This is because optical fiberoffers the possibility of very high seed transmissions in one direction.

  1. Write the two advantages and two disadvantages of star topology in network.

Ans: i. The star topology is considered the easiest topology to design andimplement.

ii. An advantage of the star topology is the simplicity of adding additional nodes.

  1. Write the disadvantages if twisted pair cables.

Ans: i. A twisted pair cable is incapable carrying a signal over long distances withoutthe use of repeaters.

ii. Its low bandwidth capabilities are unsuitable for broadband applications.

iii. Its supports maximum data rates 1mbps without conditioning and 10 mbps withconditioning.

  1. Define Hub.

Ans : The central connecting device in a computer network is known as a hub. Whendata packets arrives at hub, it broadcast them to all the LAN cards in a network and thedestined recipient picks them and all other computers discard the data packets.

  1. Define switch.

Ans: A Switch is a device that is used to segment networks into different subnetworks called subnets or LAN segments. Segmenting the network into smallersubnets, prevents traffic overloading in a network.

  1. What are the goals of network?

Ans:. Goals of network:

?Resource sharing: The aim to make all programs, data and peripheralsavailable to anyone on the network irrespective of the physical location of theresources and the users.