Assignment Booklet
B. Tech.
in
Aerospace
Engineering
Programme
Second
Semester
Course Code
Course Title
ET

101B
Mathematics

II
BAS

004
Workshop Technology
BAS

00
5
Engineering Drawing
BAS

006
Computer Fundamentals
BME

021
Principles of Electrical and Electronic Science
S
chool of
E
ngineering
and
T
echnology
INDIRA GANDHI NATIONAL OPEN UNIVERSITY
Maidan Garhi, New Delhi

110 068
JANUARY, 2012
BTAE
2
B. Tech in Aerospace Engineering
Dear Student,
As we explained in the Programme Guide for B. Tech in Aerospace Engineering, you will have to do
one Tutor Marked Assig
nment (TMA) for each
course.
You will find that the qu
estion
s
in the
A
ssignments are analytical and descriptive so that you can
better understand and comprehend the concepts.
Bef
ore you attempt the
A
ssignments, p
lease read the instructions carefully provided in the
Programme Guide. It is important that you wr
ite the answer to all the TMA questions in your own
words. Your answers should be in brief and to the point. Remember, writing answers to assignment
questions will improve your writing skills and prepare you for the term

end examination.
You are to submit
the assignments to the Coordinator of your Centre. You must obtain a receipt
from the Centre for the
A
ssignments submitted and retain it with you. It is desirable to keep a
photocopy of the assignments submitted by you.
Once evaluated, the Centre will retu
rn the assignments to you. Please insist on this. The Centre will
send the marks to the SR&E Division at IGNOU, New Delhi.
Submission
You need to submit the
A
ssignment
s
within the stipulated date for being eligible to appear in
the
term

end examination.
Al
l
A
ssignments are to be submitt
ed by 31
st
March
,
2012
to the Coordinator of the Centre
allotted to you.
GUIDELINES FOR
SUBMITTING THE
ASSIGNMENT
S
We expect you to answer each question as per instructions in the assignment. You will find it useful
to keep
the following points in
mind:
Planning
Read the assignment carefully; go through the Units on which they are based. Make some
points regarding each question and then rearrange them in a logical order.
Organisation
Be a little selective and analytical befo
re drawing up a rough outline of your answer. Give
adequate attention to question’s introduction and conclusion.
Make sure that
(a)
The answer is logical and coherent.
(b)
It has clear connections between sentences and paragraphs.
(c)
The presentation is correct in y
our own expression and style.
Presentation
Once you are satisfied with your answer, you can write down the final version for submission.
It is mandatory to write the assignment neatly in your own handwriting. If you so desire, you
March
underline the point
s you wish to emphasize. Make sure that the answer is within the
stipulated word limit.
(
Ms
. S
weata Tiwari
)
Programme Coordinator
3
Q.1
(a)
The probability of
n
independent events is
P
1
,
P
2
, . . .
P
n
.
Find the probability that at least
one of
the events will happen. Using this, find the probability of obtaining at least one
6 in a throw of four dice
:
(b)
Suppose an assembly plant receives its voltage regulators from three different sources,
60% from
B
1
, 30% from
B
2
and 10% from
B
3
. Let 95%, 8
0% and 65% of the supply
received respectively from the source
B
1
,
B
2
and
B
3
perform as per specifications laid.
If
A
is the event that a voltage regulator received at the plant performs as per
specifications then find
P
(
A
)
.
Q.2
(a)
Two cards are drawn fr
om a pack of 52 cards. Find the probability that draw includes an
ace and a ten
.
(b)
In a production of iron rods the diameter
X
can be approximated to be normally
distributed with mean 2 inches and S.D. 0.008 inches
.
(i)
What percentage of defectives can
we expect if we set the acceptance limit at
2 ± 0.02 inches?
(ii)
How should we set the acceptance limits to allow for 4% defectives?
Q.3
(a)
Following data gives 11 measurements of the same object in the same instrument
2.7, 2.5, 2.3, 2.4, 2.3, 2.5, 2.7,
2.5, 2.6, 2.6, 2.5
a
t 1% level. Test the hypothesis that the
variance of the instrument is no more than 0.16
.
(b)
The test runs with six models of an experimental engine showed that they operated
respectively for 24, 28, 21, 23, 32 and 22 minutes with a ga
llon of fuel. Obtain a 99%
confidence interval for the average run time of engine with a gallon of fuel
.
Q.4
(a)
A problem of mechanics is given to three students
A
,
B
and
C
whose chances of solving
it are
1 1 1
,and
2 3 4
respectively. What is the
probability that the problem will be solved
.
(b)
If events
A
and
B
are independent and
( ) 0.15,( ) 0.45
P A P A B
then find
P
(
B
)
.
Q.
5
(a)
A machine contains a component
C
that is vital to its operation. The reliability of
component
C
is 80%. To improve the r
eliability of a machine, a similar component is
used in parallel to form a system. The machine will work provided that one of these
components functions correctly. Calculate the reliability of the system
.
(b)
India plays two matches each with West Indies a
nd Australia. In any match the
probability of India getting points 0, 1 and 2 are 0.45, 0.05, and 0.50
,
respectively.
Assuming that the outcomes are independent, find the probability of India getting at least
7 points
.
TUTOR MARKED ASSIGNMENT
ET

101 B
MATHEMATICS

II
Note :
All questions are compulsory and carry equal marks. This assignments is
based on all
Blocks of Mathematics

II.
Maximum Marks : 100
Weightage : 30%
Course Code
: ET

101 B
Last Date of Submission
: March 31, 2012
BTAE
4
Q.
6
(a)
A class consists of 80 studen
ts, 25 of them girls and 55 boys. While 10 of them are rich
and the remaining poor, it is found that 20 are fair complexioned. What is the probability
of selecting a fair complexioned rich girl or a poor boy who is not fair complexioned
?
(b)
Suppose the pr
obability for
A
to win a game against
B
is 0.4. If
A
has an option of
playing either a “best of 3 games” or a “best of 5 games” match against
B
, which option
should
A
choose so that the probability of his winning the match is higher? (No game
ends in a dra
w)
.
Q.
7
(a)
The chances that doctor
A
will diagnose a disease
X
is 60%. The chances that a patient
will die by his treatment after correct diagnosis is 40% and the chances of death by
wrong diagnosis is 70%. A patient of doctor
A
who had disease
X
, died. W
hat is the
chance that his disease was diagnosed correctly
?
(b)
Three urns
A
,
B
,
C
contain 6 red, 4 black balls, 2 red and 6 black balls and 1 red and
8 black balls respectively. An urn is chosen at a random and a ball is drawn from the urn.
If the ball dr
awn is red, find the probability that the ball was drawn from urn
A
.
Q.8
(a)
If 20% of the bolts produced by a machine are defective, determine the probability the
out of 4 bolts chosen at random
.
(i)
1
(ii)
zero
(iii)
at most 2 bolts will be defective.
(b
)
In a certain factory producing cycle tyres there is a small chances of 1 in 500 tyres to be
defective. The tyres are supplied in lots of 10. Using Poisson distribution, calculate the
approximate number of lots, containing no defective, one defective, and
two defective
tyres respectively, in a consignment of 10,000 lots
.
Q.9
(a)
The diameter of an electric cable is assumed to be continuous random variate with
probability density function
( ) 6 (1 ),0 1
f x x x x
(i)
Verify the above
is probability density funct
ion, and
(ii)
Also find the mean and variance
.
(b)
The mean life time of a sample of 100
fluorescent
light bulbs produced by a company is
computed to be 1570 hours with a standard deviation of 120 hours. The company claims
that the average life of the bulbs pr
oduced by it is 1600 hours. Using the level of
significance of 0.05, is the claim acceptable
.
Q.10
(a)
A machinist is making engine parts with axle diameter of 0.70 inch. A random sample of
10 parts shows mean diameter 0.742 inch with standard deviation of
0.04 inch. On the
basis of this sample, would you say that the work is inferior
?
(b)
The means of simple samples of sizes 1000 and 2000 are 67.5 cm and 68.0 cm
respectively. Can the samples be regarded as drawn from the same population of SD
2.5 cm
?
5
Q.1
(a)
The saw which is used for accurate cutting of wood in all directions Regardless of wood
grains :
(i)
Panel saw
(ii)
Dovetail saw
(iii)
Tenon saw
(i
v
)
Compass saw
(b)
Two wooden pieces of same section are joined at an angle su
ch that Line of joint bisect
the angle between two pieces. The joint is called
:
(i)
Mortise
(ii)
Mitre
(iii)
Tenon
(iv)
Dovetail
(c)
Colour coding is used on pattern. A black colour indicates
:
(i)
surface not be machined
(ii)
surface to be machined
(iii)
parting surface
(iv)
core prints
(d)
A core of shape of slab is made in core box of type
:
(i)
slickle
(
ii
)
loose piece
(iii)
split
(iv)
dump
(e)
A core suitable to produce a blind hole in casting is called
:
(i)
horizontal core
(ii)
vertical core
(iii)
balanced core
(iv)
cover core
(f)
In which pipe joint lead is used as packing to prevent leakage
:
(i)
Expansion joint
(ii)
Spigot and Socket joint
(iii)
Socket joint
(iv)
Flanged joint
(g)
In which of the tin

smithy joints solder is used ?
(i)
lap j
oint
(ii)
Flange joint
(iii)
Seam joint
(iv)
Hem joint
(h)
The solder contains lead and tin. The solder that contains 50% of each is:
(i)
E
lectronic solder
(ii)
S
oft solder
(iii)
P
lumbers solder
(iv)
M
edium solder
TUTOR MARKED ASSIGNMENT
BAS

004
WORKSHOP TECHNOLOGY
Note :
All the questions are compulsory and carry equal marks. This assignments is based on
all Blocks of Workshop Tech
nology.
Maximum Marks : 100
Weightage : 30%
Course Code : BAS

004
Last
Date of Submission:
March 31, 2012
BTAE
6
(i)
the welding processes in which electr
ode is not consumed are :
(i)
carbon arc and TIG
(ii)
TIG and MIG
(iii)
Manual arc and MIG
(iv)
MIG and atomic hydrogen
(j)
The gas flame extends from torch tip to certain length. The temperature is highest :
(i)
on the outside of the flame
(ii)
along the cent
re line of the flame
(iii)
at the torch tip inner core
(iv)
at the tip of the flame
Q
.
2
(a)
What do you understand by chiseling in woo
d work? Sketch three chiseling
operations.
(b)
Describe three types of wood pattern with the help of sketches.
(c)
Describe bri
efly the functions of coated electrodes.
Q
.
3
(a)
Describe types and properties of moulding sand.
(b)
Sketch cupola furnace and describe various zones. How cupola is
charged?
Q
.
4
(a)
Sketch a bench

vice and name its parts. What are other vices used in fitti
ng practice
?
(b)
Briefly state the fundamental difference between N

C and C

N

C machine tools.
Q
.
5
(a)
What are
fluxes?
Where are they used
? Describe some fluxing agents.
(b)
Describe the submerged arc welding and ele
c
tro

slag welding.
Q
.
6
(a)
What is
forging
?
What are different materials that are forged? Describe
forging
operations.
(b)
Why do we heat treat material? Describe different processes of heat Treatment.
(c)
Distinguish between Pressure welding and Fusion welding. Give examples of their uses.
Q
.
7
(a)
What i
s a lathe machine? Mention different types of lathes. Describe three
operations
that can be performed on lathe.
(b)
Differentiate the Electric Arc welding from Oxy

Acetylene welding from the points of view
of temperature of welding, heat concentration and oper
ating cost.
(c
)
Explain the terms “Gate” and “Riser” as referred to foundry technology.
Q
.
8
(a)
Explain with a neat sketch how a Gear T
ooth can be cut using a Milling
machine.
(b)
Explain the terms Tolerance, Allowance and Limit.
(c)
Why is inspection of a manufac
tured part necessary? State the primary responsibility of
the Inspection Department.
Q
.
9
(a)
Briefly describe how t
wo
pieces of steel can be
joined together by electric arc
welding?
(b)
What are the different types of flames that ca
n
be produced in an Oxy

Acetylene flame?
Explain how they are formed and their uses.
(
c)
State the advantages of hydraulic press for press forging.
Q
.
10
(a)
What are the main constituents of steel? Explain how the different alloying elements
(at
least three elements) in steel imp
rove its properties.
(b)
Explain the functions and applications of N

C machines.
(c)
Discuss the advantages and disadvantages of hot working of metal.
7
Q.1
Answer the following questions in brief
(i)
The Trimmed size of a drawing sheet of size A
1
and A
3
are ___
___ and ______ in mm.
(ii)
Define Representative Factor (R.F).
(iii)
By line diagram indicate any four ‘types of solids, which are commonly used in
Engineering Drawing
(iv)
Define Ellipse.
(v)
Define two conic sections except ellipse. Write the names of se
ctions.
(vi)
What are the different positions which a point can take with respect to the Reference
planes. (HP and VP)?
(vii)
Different
iate
between Isometric view and Isometric projections.
Q.2
(a)
Draw the projections of the following points.
(i)
Point
A
is 30 mm below HP and 35 mm behind VP.
(ii)
Point
B
is 40 mm behind VP and 35 mm above HP.
(b)
Construct an Isometric Scale to read upto 70 mm.
(
c)
Construct a plain scale of R.F
=
1
6250
to read upto 10 km. Show on the scale a length of
5
70 km.
Q.
3
A line
AB
65 mm long has its
End
A
in the HP and 20 mm in

front of VP. The line is inclined at
30
to the HP an
d 45
with VP. Draw its Projections
.
Q.4
Construct a parabola when the distance of focus from the directrix is 50 mm.
Q.5
Draw three
views of a regular pentagon of 40 mm sides, having one of its side parallel to HP
and the surface of the pentagon is inclined at 30
to HP and perpendicular to VP.
Q.6
Two Views of a Hexagonal pyramid are given below. Draw its Isometric view.
TUTOR MARKED ASSIGNMENT
BAS

005
ENGINEERING DRAWING
Note :
All quest
ions are carry marks. This assignments is based on all Blocks of Engineering
Drawing.
Maximum Marks : 100
Weightage : 30%
Course Code : B
AS

005
Last Date of Submission :
March 31, 2012
BTAE
60
X
Y
25
8
Q
.
7
(a)
Fig
ure
1 shows cap of a journal bearing. Draw three views
(i) Elevation
,
(ii) Plan
and
(iii) Side
view (sectioned)
.
Figure 1
(b)
Draw
:
(i)
Elevation
,
(ii)
Plan and
(iii)
Side view For part in Fig
ure
2.
Figure 2
Q
.
8
(a)
With one side of 2.5 cm
draw a regular heptagon.
(b)
Draw a regular hexagon about a circle of diameter 40 mm with two of its sides vertical.
Draw an other regular hexagon about
circle of 40 mm diameter with sides making
30
angle with sides of first hexagon.
Q
.
9
(a)
Draw an ellipse f
or which focus is 40 mm from directrix and eccentricity is 2/3.
(b)
A hexagonal pyramid, 25 mm side of base has axis 50 mm long. One edge of the base is
on the ground and axis is inclined at 30
to the ground and parallel to V.P. Draw its
projections.
Figure 3
A hexagonal pyramid with base
ABCD
is cut by planes
PQ
and
QR
. Draw the
development of lateral surface of
PQRDCBA
. (Fig
ure
3)
9
Q
.
10
(a)
A vertical cone having base diameter of 70 mm and axis 80 mm penetrates into a
cylinder of diameter 45 mm suc
h that the axes of cone and cylinder are parallel and at
distance of 10 mm, and both axes are in V.P. Draw the projections showing curves of
intersection.
(b)
In free hand draw the isometric view of the object for which elevation and top view are
shown in Fig
ure
4.
Figure 4
10
Q
.
1
(a)
What is a transformer? Draw its labeled diagram and Write the relation between input
and output voltage and number of turns.
(b)
A three phase squirrel cage induction m
otor is operating on 400 V, 50 Hz supply and is
wound for 6 number of poles. What is the synchronous speed of rotating magnetic field
in the air gap?
(c)
Draw the symbol
s
and
explain
the characteristics of MOSFET and SCR.
(d)
Explain the operation of single phase
half wave rectifier circuit and its waveform.
(e)
Draw and explain OP

Amp as an amplifier.
Q
.
2
(a)
Discuss the concept of Tristate?
(b)
What is Flip

Flop? Explain JK Flip

Flop with truth table.
(c)
Explain the operation of any one type of Shift Register.
(d)
Discuss the
architecture and hardware aspects of 8085 microprocessor.
(e)
Discuss the difference, similarity and applications of microprocessor, microcontroller and
digital signal processor.
Q
.3
(a)
List the main components of a power transformer. What do you mean by st
ep

up and
step

down transformers. How a transformer is used in economic transmission of power?
(b)
A ring has a mean diameter of 21 cms and a cross

sectional area of 10 cm
2
. The ring is
made up of semicircular sections of cast iron and cast steel; with each jo
int having an
air

gap of 0.2 mm. Find the ampere

turns required to produce a flux of 8
10
–
4
Wb. The
relative permeabilities of cast iron and cast steel are 166 and 800 respectively.
(c)
Give relationship between voltage
V
applied across a capacitor
C
an
d charge
Q
developed on it. Three capacitors
C
1
,
C
2
,
C
3
are connected in series. Find out equivalent
capacitance
C
.
(d)
The capacitors 10
F, 20
F, and 30
F are connected in parallel, calculate
(i)
charge on each capacitors when the network is impressed wit
h a 200 volt d
c
supply, and
(ii)
equivalent capacitance of the network.
(e)
Explain the architecture of 8085 microprocessor with neat diagram and briefly describe
its different subsystems.
TUTOR MARKED ASSIGNMENT
BME

021
PRINCIPLES OF ELECTRICAL AND ELECTRONI
CS SCIENCES
Note :
All questions are compulsory and carry equal marks. This assignment is based on all
Blocks of Principles of Electrical and Electronics Sciences.
Maximum Marks : 100
Weightage : 30%
Course Code : BME

021
Last Date of Submission : March 31, 2012
BTAE
11
Q
.
4
(a)
I
n F
igure
1, find the value of voltage
V
at node a, and curren
ts
I
1
,
I
2
,
I
3
using Kirchhoff’s
current law.
(Resistances are in ohms.)
Figure 1
(b)
Show phase relationship of current and voltage drop across
R
,
L
and
C
in series
RLC
circuit
.
(c)
In the circuit
as shown in
F
igure 2,
evaluate following
:
(i)
Value of capa
citor C to give resonance
(ii)
Current at resonance,
I
0
.
(iii)
Q
factor of the circuit.
Figure 2
(d)
Show a series resonant circuit diagramatically and give conditions under which it would
resonate. Also give the resonance frequency in terms of inductance
L
and
capacitance
C
.
(e
)
What is a hysterisis loop as
applied to mag
netic materials? Describe; how it is
generated?
Q
.
5
(a)
How
NPN
transistors is formed using n

type and p

type semiconductor materials?
(b)
How are the two junctions bi

junction transistors b
iased for its operation?
(c)
Find out the
relationship between emitter current, collector current and base
current
in a
BJT.
(d
)
Why
is
an operational amplifier called so? What
type of
operations
can it perform?
(e
)
Show how an operational amplifier can be
used as a summing amplifier.
Q
.6
(a)
A 6 pole, 50 Hz, 400 V, three phase induction motor is operating at a slip of
2
5%. Find
its actual speed and slip speed.
(b)
Discuss the load characteristics of dc shunt generator. State its applications also.
(c)
Expl
ain the speed control methods of dc series motor.
(d)
Describe the different types of losses taking place in a transformer. The efficiency of
transformer is higher than that of any electrical machine
.
Why?
(e)
State the importance and methods of safety in
Electrical Installations.
12
Q
.
7
(a)
Draw symbols and Truth t
ables of AND, and OR Logic gates.
(b)
What is the main difference between asynchronous (ripple) and synchronous counters?
Give s
c
heme of a 4

element ripple counter using T

flip f
lops along with tim
ing diagram at
different outputs.
(c
)
A conductor of 0.7 mm diameter wire has a resistance
of 250
. Find the resistance of
the same length of wire if its diameter is doubled.
(d)
Find the current in 18
resistor using super position theorem
as shown in
Fig
ure
3
.
Figure 3
(e)
Explain the construction and operation of synchronous generator.
Q.8
(a)
Draw and discuss a typical residential wiring system.
(b)
Explain the construction and operation of a typical Permanent Magnet Moving Coil
(PMMC) instrumen
t.
(c)
Describe the three OP

amp base instrumentation amplifier. What is CMRR?
(d)
Determine the output
voltage of following circuit as shown in Fig
ure
4
.
Figure 4
(e)
Design an OP

amp based oscillator circuit to oscillate at a frequency of 100 kHz usi
ng
inductor and capacitors. Hence find the value of resistor for
C
= 0.01
F.
Q.9
(a)
Explain the application of Cathode Ray Oscillator (CRO)
for phase measurement.
(b)
Write shorts notes on the following
:
(i)
Flip Flops
(ii)
Multiplexer
(iii)
Counters
(iv)
Arithmetic Logic Unit
(ALU)
(v)
Interrupts
(c)
What is the clock cycle time of an 8085 microprocessor working with a crystal of
4 MHz
frequency?
(d
)
Describe the effect of temperature on resistance.
(e)
A coil has a resistance of 15
when its temp
erature is 20
C and 25
when its
temperature is 60
C. Find its temperature when the resistance is 20
.
13
Q
.
10 (
a)
Develop the expression of self

indu
ctance of a solenoid of length l
metre, cross

section
area A m
2
having N turns.
(b)
The steel pole piece of a
permanent magnet has a cross

sectional area of
1.6
10
–
3
m
2
.
What is the flux density when the total flux in the pole piece is
1.35
10
–
3
Wb
?
(c)
For the circuit shown
in Fig
ure
5
below, calculate the power consumed in watts.
Figure 5
(d)
Why
do we neglect copper losses in open circuit test of a single phase transformer?
(e)
Calculate the current flowing through 5
resistor in circuit
as shown in Fig
ure
6
using
Norton’s Theorem.
Figure 6
14
Q
.
1
(a)
Fill in t
he b
lanks from the choices given below
:
(i)
___________ are the most powerful computers made, and physically they are
some of the largest.
(ii)
The most common type of memory is called ________
(iii)
Application software tells the computer how to accompli
sh _________ task.
(i
v
)
_________ is an error in a computer program.
(
v
)
__________ is a type of optical device that allows user to record, erase, and
re

record data on a special disc.
(vi)
A _________ is a diagram of the program control flow
(vii)
_______
__ is a search engine.
Choices
:
(i
)
ROM
,
(ii)
Super
,
(iii)
Google
,
(iv)
RAM
,
(v)
interne
t, (
vi)
Bug
,
(vii) DVD
,
(viii)
Specific
,
(ix)
Microsoft
and
(x)
Flowchart
.
(b)
State True or False
(i)
The Acronym ‘DOS’ stands for distributed operating system.
(ii)
Local Are
a Network (LAN) is a data communication system such as computers and
printers.
(iii)
An important features of any LAN is its topology.
(iv)
ATM is a protocol designed by the power industry.
(v)
ISDN is a compact disc telephone service.
(vi)
Satellite service provide two

way d
ata communication between the customer and the
internet.
(vii)
Marco is a list of commands, key strokes, or other actions that had been saved and
given a name.
Q
.
2
(a)
How do you search for a webpage using Internet? Explain the steps involved.
(b)
What is the ne
ed for creating a website? What are the differences between static
website and dynamic website?
(c)
What do you understand by a tool bar? Write the procedure of getting an access to a
tool bar, in MS word, which is not open.
(d)
Explain the access mechanis
m of optical disk.
(e)
Describe in detail the ‘mail merge’.
TUTOR MARKED ASSIGNMENT
BAS

006
COMPUTER FUNDAMENTALS
Note :
All questions are compu
lsory. This assignment is based on all Blocks of Computer
Fundamentals.
Maximum Marks : 100
Weightage : 30%
Course Code : BAS

006
Last Date of Submission : March 31, 2012
BTAE
15
Q
.
3
Differentiate
between the following with the help of an example of each
:
(i)
First Generation Vs. Second Generation
(ii)
Input and output device
(iii)
External and Internal Drive
(iv)
GUI and
CUI
(v)
impact” and “non impact” printer
Q
.
4
W
rite
down
yours views
in brief for
the following
:
(i)
Intel is historically the leading provider of chips of PC.
(ii)
Computer can communication information to you in several ways.
(iii)
Online shopping means
buying a product or service through website.
Q
.
5
(a)
Write down the configuration of a compute
r, you would like to buy for
your personal
purpose
(b)
Enlist carious types of input devices. Describe any one of them.
(c)
What is the difference between e

mail and ch
at?
Q
.
6
Write short notes on the following
:
(i)
Task bar
(
ii
)
Touch screen
(
iii
)
LCD monitor
(iv)
Pen

drive
(
v
)
looping
.
Q
.
7
Answer the following
:
(a)
Explain MOD function of MS

Excel.
(b)
Magnetic tape is the example of sequential access method (True/False).
(c)
Gi
ve the example of two input devices.
(d)
What is the full form of ‘DBMS’
(e)
‘Find’ and ‘Replace’ option is available in Edit menu (True/False).
(f)
‘Array’ is the basic data type of ‘C’. (True/False)
(g)
Floppy disk is the example of an optical disk
(True/False)
(h)
Write an
y two default icon.
(i)
ENIAC stands for ___________
(j)
Convert (67)
8
to decimal.
Q
.
8
(a)
Write a program to check whether the given number is even or odd.
(b
)
Draw a block diagram of computer and explain it in detail
(c)
What is a cache memory?
(d
)
Find the com
plement of the following binary numbers:
(i)
011011
(ii)
10110001
(iii)
101
(iv)
01010
(v)
0111
(e
)
Divide (1101)
2
by (101)
2
.
16
Q
.
9
(a)
A disk pack consist of 8 disk plates each plate has 500 tracks and there are 100 sectors
per track. If 512 bytes can be s
tored per sector calculate the total number of bytes, which
can be stored.
(b)
What is DBMS? How it differs from RDBMS?
(c
)
Write SQL commands/verbs/clause with one example each:
(i)
Create
(ii)
I
nsert
(iii)
D
elete table
(d
)
Explain
‘
Sum function’ of Microsoft
Excel.
Q
.1
0
(a)
What are the advantages of using functions in ‘
C
’ programming? Write a function for
addition of given two numbers.
(b)
Brief explain the term ‘array’.
(c)
Draw the U
nix file system structures and explain it in brief.
(d)
Explain any two c
ommands of ‘
U
nix’.
Σχόλια 0
Συνδεθείτε για να κοινοποιήσετε σχόλιο