PABSON
SLC Send Up Examination 2067(2011)
Subject: Computer Science Full marks: 50
Time: 1hrs Pass marks:16
Candidates are requested to give their answer in their own words as far as practicable.
Attempt ALL the questions.
Group’A’
[Computer Fundamentals- 22 marks]
1. Answer the following question: (5X2=10)
a) Define is LAN? How does computer network reduce the cost of operation?
è A local Area Network (LAN) is a network of computers that connects two or more computers within a local area, such as a room or a building.
A computer network helps to reduce initial and operation cost. A computer network allows sharing of resources like hardware, software and services. For example, a printer or one Internet connection can be shared by all users of a network. In this way it helps to save the cost of buying extra hardware or service. Problems of the computers in a network can be solved by one or a few experts from one place. This saves the cost of hiring experts for all the branches of an office and the cost of travel by the expert to different branches.
b) Write down any four uses of internet.
è The four uses of internet are:-
i. The internet facilitates the speedy sharing of information among research and education communities.
ii. Businesses and institutions use the Internet for video conferencing and other forms of communication that enables people to telecommunicate or work from distance.
iii. Individuals use the Internet for communication, entertainment, finding information, and to buy and sell goods and services.
iv. Media and entertainment companies use the Internet to broadcast audio and video, including live radio and television programs.
c) What is Cyber Law? Write any two ethical standards to be followed by computer user.
è Cyberlaw is a generic term which refers to all the legal and regulatory aspects of Internet and the World Wide Web.
è The two ethical standard s to be followed by computer user are:-
i. Do not use a computer to harm others
ii. Do not use a computer to steal
d) Why is power protection devices needed to our computer system? Name any two power protection devices.
è Power protection device is needed to our computer system to maintain constant voltage level and produce electricity during the power cuts and surges.
è The two power protection devices are :-
i. Uninterruptible Power Supply(UPS)
ii. Voltage Guard
e) How can we protect computer from methods.
è We can protect computer from methods :
i) Antivirus software can detect and remove viruses.
ii) Scan disk check folder , bad sector and other errors of the disk and fix them.
iii) Regular Maintenance helps to keep computer in good condition.
iv) Power protection device protects computer from surges and provides backup to save important files during power cut up.
2 a) Convert as instructed: (2X1=2)
b) Perform binary calculation. (2X1=2)
3. Match the following: (4X0.5=2)
Group A Group B
a) Communication Channel i) Router
b) Multimedia Device ii)Network of networks
c) Internet iii)CD-ROM
d) Network Device iv)Network within LAN
v)Fiber optic
Ans:-
Group A Group B
a) Communication Channel i) Fiber optic
b) Multimedia Device ii)CD-ROM
c) Internet iii) Network of networks
d) Network Device iv) Router
4. Select the correct answer: (4X0.5=2)
a) Component of multimedia
i) Text, Audio-visual & Animation ii) Text, Graphics & Animation
iii) Text, Graphics & Soundiv) Text, Graphics, Audio-visual & Animation
è Text, Graphics, Audio-visual & Animation
b) Which is not a network OS?
I) Windows NT
II )GNU/Linux
III) MS-DOS
IV) UNIX
è MS-DOS
c) Data communication means
i) We can easily send and receive the messages.
ii) Data computing system is fastest in the network.
iii) The process of transferring data and information.
iv)None of the above.
è The process of transferring data and information
d) Computer software security include
i) Use of password ii) Use of Genuine software
iii)Use of hard lock key. iv)All of the above.
è All of the above
5. Give the appropriate technical terms of the following: (4X0.5=2)
a) Online mail service through internet.
Electronic - mail
b) Cabling structure of LAN.
Topology
c) Making an extra copy of data and software.
Backup
d) A program that is attached to other programs.
Computer Virus
6. Write the Full forms of the following: (4X0.5=2)
a) UPS – Uninterruptible Power Supply
b)UTP – Unshielded Twisted Pair
c)TCP/IP - Transmission Control Protocol/Internet Protocol
d)DVD – Digital Versatile Disk
Group’B’
[MS-ACCESS – 10 marks]
7. Answer the following questions: (3X2=6)
a) Define database and DBMS
è Database is a collection related and organised information that is used to store, organise and extract data.
DBMS is a software which is used to manage data, manipulate them and provide the information.
b) What is data sorting? How does it differ from filtering?
è Data sorting means grouping all the records in a table either ascending or descending based on a key field of the record.
è The differences between sorting and filtering are:-
c) What is form? Write any two advantages of forms.
è Form is an object in MS- Access which provides a user friendly interface to enter data in a table or multiple linked table.
è Two advantages of forms are:
i) It provides an interactive platform for input of data into the database.
i) It helps to display data in more presentable form than a datasheet can.
8. State True Or False. (4X0.5=2)
a) A primary key does not accept null value.True
b) Rows in database are called fields.False
c) We can’t change data type in design view.False
d) The extension file name of MS-ACESS is .DBM(dot DBM).False
9. Match the following: (4X0.5=2)
Group A Group B
a) Ye/No i) Up to 1 GB
b)Query ii) Used for logical operation
c) Caption iii) retrieving information conditionally
d) OLE Field iv) 255 characters
v) Field property
Ans: Group A Group B
a) Yes/No i) Used for logical operation
b)Query ii) retrieving information conditionally
c) Caption iii)Field property
d) OLE Field iv) Up to 1 GB
Group ‘C’
[QBASIC Programming – 18 Marks]
10. a)Define Local and Global variable. 1
è Local variable are those variables which are declared inside a function and are not visible to other modules or functions.
è Global variables are those variables which are declared outside of any functions and are visible to other functions or modules.
b) Write any two advantages of “C” Language. 1
è The two advantages of C language are:
i) It is a high level language with some features of low level language.
ii) It is mostly used to prepare system software.
ii) It is mostly used to prepare system software.
c) State the function of the following statements. . 1
i) WRITE# :
è It sends one or more data items to the specified file.
ii) ii) EOF()
è It detects the End Of the File marker reading the data from an OPEN sequential file.
11. Write the output of the following program. 2
DECLARE FUNCTION A(X)
X=10
Z=A(X)
PRINT Z
END
FUNCTION A(X)
FOR I = 1 TO X
S=S+I
NEXT I
A=S
END FUNCTION
12. Re-write the given program after correcting the bugs. 2
REM ’to calculate sum of digits of a number’
DECLARE FUNCTION XYZ (N)
CLS
INPUT”ANY NUMBER”; N
DISPLAY XYZ (N)
END
FUNCTION XYZ (N)
S=0
WHILE N>0
R= N MOD 10
S=S+R
N=(N/10)
LOOP
S=XYZ
END FUNCTION
Debugged Program
REM ’to calculate sum of digits of a number’
DECLARE FUNCTION XYZ (N)
CLS
INPUT”ANY NUMBER”; N
PRINT XYZ (N)
END
FUNCTION XYZ (N)
S=0
WHILE N>0
R= N MOD 10
S=S+R
N= INT(N/10)
WEND
XYZ=S
END FUNCTION
13. Study the following program and answer the given questions. (2x1=2)
DECLARE SUB WORD(N$)
CLS
N$=”PABSON”
CALL WORD(N$)
END
SUB WORD(N$)
B=LEN(N$)
C=1
WHILE C<B
M$=MID$(N$, B, 1)
PRINT M$
C=C+2
END SUB
Questions:-
a) List the string and numeric variables used in the program.
è The string variables are :-
i) M$
ii) N$
è The numeric variable used are :
i) B
ii) C
b) What is the value of B in the program?
è Value of B in following is 6.
14. a) Write a program to calculate the volume of cylinder using
FUNCTION……………END FUNCTION .[Hints:-v=pie*r2 h]
è DECLARE FUNCTION VOLU(R,H)
CLS
INPUT”ENTER RADIUS AND HEIGHT”; R, H
PRINT “THE VOLUME OF CYLINDER IS”;VOLU(R,H)
END
FUNCTION VOLU(R,H)
V = 3.14 * R^2 * H
VOLU = V
END FUNCTION
b) Using SUB………………END SUB, write a program to generate series
81,64,49,………………………10th term 3
è DECLARE SUB CHECK()
CLS
CALL CHECK
END
SUB CHECK
FOR I = 9 to 1 STEP-1
PRINT I^2
NEXT I
END SUB
c) Write a program to search and display only those records whose percentage is more than 60% from the data file “RESULT.DAT” which contains Student’s Symbol number, Date of Birth, Total Marks, Percentage and Division. 3
è OPEN “RESULT.DAT” FOR INPUT AS #1
CLS
WHILE NOT EOF(1)
INPUT #1 , SN , D$ , M , P , DV$
IF P> 60 THEN PRINT SN , D$ , M , P ,DV$
WEND
CLOSE #1
END
Solved By: Manish Shakya
No comments:
Post a Comment