Table of Contents
Q1. Communication between a computer and a keyboard
involves ______________ transmission
a) Automatic
b) Half-duplex
c) Full-duplex
d) Simplex
Transmission modes
• Transmission modes defines direction of the flow of information between two communication devices.
• Three types of transmission modes
• simplex • Half duplex
• Full duplex
Simplex mode
• In simplex transmission information is sent only in one direction
• There is no mechanism for information to be transmitted back to the sender
• Communication is unidirectional Examples of simplex mode Keyboards and traditional monitors.
Keyboard can only introduce input and the monitor can only accept output
Fire alarms,microphone.
In half duplex transmission data can be sent in both the directions , only one
direction at a time.
Both the connected devices can transmit and receive but not simultaneously
When one device is sending the other can only receive Half duplex.
In full duplex transmission data can be sent in both the directions
Both the connected devices can transmit and receive at the same time
bidirectional Full duplex
Q2.The first Network
a) CNNET
b) NSFNET
c) ASAPNET
d) ARPANET
Q3.A set of rules that governs data communication
a) Protocols
b) Standards
c) RFCs
d) None of the mentioned
TCP/IP
• It forms the base of present day internet
• TCP and IP are two protocols of this model TCP stands for the transmission
control protocol and IP stands for Internet protocol
• Initially used by Advanced research project agency network (ARPANET)
Four layers
Application layer
Internet layer
Transport layer
Host to network layer
Q4.Three or more devices share a link in ________ connection
a) Unipoint
b) Multipoint
c) Point to point
d) None of the mentioned
Q5.A __________ is a device that forwards packets between networks by
processing the routing information included in the packet.
a) bridge
b) firewall
c) router
d) all of the mentioned
What is router:
Router is a network layer (Layer 3) of the OSI reference model device that means it can
connect multiple computer networks via wired or wireless connections.
Network router can receive, analyze, perform the traffic directing functions and forwards
data packet from one network to its destination node.
Q7.Which of the following produces the best quality graphics reproduction?
A. Laser printer
B. Ink jet printer
C. Plotter
D. Dot matrix printer
Q8.The feature in database language that allows us to
access certain records in database is called __________.
(a) Query
(b) Forms
(c) Reports
(d) Tables
9.Which of the following shortcut keys is used to select the
entire document?
(a) Ctrl + L
(b) Alt + A
(c) Ctrl + A
(d) Shift + A
(e) Ctrl + K
10.#include is called
A. Preprocessor directive
B. Inclusion directive
C. File inclusion directive
D. None of the mentioned
11.The C language consist of ____ number of keywords.
A] 32
B] 40
C] 24
D] 56
12.Which of the following relational algebra operations require
the participating tables to be union-compatible?
(A) Union
(B) Intersection
(C) Difference
(D) Join
1.Union
UNION is used to combine the results of two or more Select statements. However it will eliminate duplicate rows from its result set. In case of union, number of columns and datatype must be same in both the tables.
Union compatible
The union operator requires that both relations are union-compatible. This means
that they are required to have the same set of attributes. Note that this
concept goes slightly beyond than sharing the same amount of attributes. This
is because it also considers the content of the attribute
EG: Consider the following relations:
• Person(FirstName, LastName)
• Country(Name, Population)
• In this case, Person and Country are not union-compatible as they do not
share the same set of attributes, even though they share the same amount of
attributes.
13) Which is valid string function ?
A] strpbrk
B] strlen
C] strxfrm
D] strcut
14.What is gutter margin ?
a) Margin that is added to right margin when printing
b) Margin that is added to the left margin when printing
c) Margin that is added to the outside of the page when
printing
d) Margin that is added to the binding side of page when printing
15. A supercomputer would be used for which of the following
applications?
(A) Business computing
(B) Desktop computing
(C) Weather forecasting
(D) Computer aided design
16.What is full form of BMP ?
a) Byte map
b) Bit map
c) Byte map process
d) Bit map process
17.What is full form of ISDN ?
a) Integrated Services Digital Network
b) Integrated Services Double Network
c) Inter Services Digital Network
d) Integrated Server Digital Network
18.The data link layer takes the packets from _________ and
encapsulates them into frames for transmission.
a) network layer
b) physical layer
c) transport layer
d) application layer
19.Which one of the following task is not done by data link layer?
a) framing
b) error control
c) flow control
d) channel coding
20.Automatic repeat request error management mechanism is
provided by
a) logical link control sublayer
b) media access control sublayer
c) network interface control sublayer
d) none of the mentioned
21.SDLC stands for
a) Software Development Life Cycle
b) System Development Life cycle
c) Software Design Life Cycle
d) System Design Life Cycle
22.Select * from employee .What type of statement is this?
a) DML
b) DDL
c) View
d) Integrity constraint
23.The metadata is created by the
(A) DML compiler
(B) DML pre-processor
(C) DDL interpreter
(D) Query interpreter
24.What is data integrity?
(A) It is the data contained in database that is non redundant.
(B) It is the data contained in database that is accurate and
consistent.
(C) It is the data contained in database that is secured.
(D) It is the data contained in database that is shared.
25.Relational Algebra does not have
(A) Selection operator.
(B) Projection operator.
(C) Aggregation operators.
(D) Division operator.
The fundamental operations of relational algebra are as follows −
Select
Project
Union
Set different
Cartesian product Rename
• The aggregation operators perform mathematical operations like Average,
Aggregate, Count, Max, Min and Sum, on the numeric property of the
elements in the collection.
26.What is extension of plain text file ?
a) .text
b) .tt
c) .txt
d) .tx
27.What is extension of Microsoft Word Document ?
a) .dcc
b) .doc
c) .xls
d) .ppt
WhatsApp