Attempt all the questions.
Computer Fundamental (22 marks)
1. Answer the following questions:
a) Write any four advantages of computer network.
Ans: Any 4 advantages of computer network are as follows:
i) Computer in a network can access network connected hardware devices like printer, disk drives, etc.
ii) Information can be exchanged rapidly in computer network.
iii) Computers in a network environment can be updated from any computer.
iv) Software packages can be shared between network connected computers.
b) What is internet? Write the name of any two E-commerce sites.
Ans: Internet is an interconnection of several thousands of computers of different types belonging to the various networks all over the world.
c) What is computer ethic?
Group A Group B
a) RJ-45 a) Multimedia
b) WAN b) Duplicate copy
c) Back up c) Fiber optic cable
d) microphone d) Twisted pair cable
e) Internet
Answers
Group A Group B
a) RJ-45 a) Twisted pair cable
b) WAN b) Internet
c) Back up c) Duplicate copy
d) microphons d) Multimedia
Select the best answer:
a) Which is not unguided media?
i) Fiber optics ii) Microwave iii) Infrared iv) Radio wave
Ans: Fiber optics
b) Which is the internet service?
i) IRC ii) Telnet iii) E-mail iv) All of the above
Ans: All of the above
c) Which is not related to multimedia?
i) Printer ii) Sound card iii) Microphone iv) CD-ROM
Ans: Printer
d) Which virus infects boot sector files?
i) Macro virus ii) Multipartite virus iii) Boot sector virus iv) Program virus
Ans: Boot sector virus
5. Give appropriate technical terms:
a) Business through internet.
Ans: E-commerce
b) The software that protects computer virus.
Ans: Antivirus Software
c) Physical layout of LAN.
Ans: Topology
d) A sector word that gives user access to a particular program or computer
system.
Ans: Password
6. Write the full forms of:
a) VOIP = Voice Over Internet Protocol
b) MAN = Metropolitan Area Network
c) UTP = Unshielded Twisted Pair
d) WWW = World Wide Web
Group B
Database(10 marks)
Answer the following questions:
a) What is database? Give two examples.
Ans: Database is a collection of related and organized information that can be used for different purpose.
Two examples of database are:
i) Dictionary
ii) Telephone Directory
b) Write any two types of primary key.
Ans: The uses of Primary key are:
i) To reduce and control duplication of record in a table.
ii) To set the relationship between tables.
c) What is query?
Ans: Query is an object of Ms-Access which extracts and arranges information from a table.
Choose the best answer:
Ans: MS-Excel
b) Memory space consumed by a currency data type maximally is …………
i) 2 bytes ii) 4 bytes iii) 8 bytes iv) 1 GB
Ans: 8 bytes
c) The default data type of MS-Access is:
i) Number ii)Text iii) Memo iv) Auto number
Ans : Text
d) Row is also called …………
i) Record ii) Field iii) Database iv) Table
Ans : Record
Match the following:
Group A Group B
i) OLE a) Data Entry
ii) Hyperlink b) Formatted Hardcopy
iii) Report c) 1 GB
iv) Form d) Up to 255 characters
e) Up to 2048 characters
Answers
Group A Group B
i) OLE 1 GB
ii) Hyperlink Up to 2048 characters
iii) Report Formatted Hardcopy
iv) Form Data Entry
Group-C
Programming(18 marks)
a) What is meant by mode of data file?
Ans: Mode of data file means opening a sequential file for one of the three modes of operation like output mode, input mode and append mode.
b) Write any two characteristics of ‘C’ language.
Ans: The characteristics are :
i) It is a high level language with some features of low level language.
ii) It is mostly used to prepare system software.
c) Write the function of the following statements:
i) NAME
Ans: The NAME statement renames a file on a disk.
ii) KILL
Ans: The KILL statement deletes the file or files from the specified drive and directory.
Write the output of the following program
DELARE SUB NUMBER()
CLS
CALL NUMBER
END
SUB NUMBER
N=3
C=1
WHILE C<=5
PRINT N
N=N*10+3
C=C+1
WEND
END SUB
ANS:
3
33
333
3333
33333
Rewrite the given program after correcting the bugs:
REM display Records of students From Data File
OPEN “STDREC.DAT” FOR INP AS #1
PRINT “ROLL”,”NAME”,”ADDRESS”,”CLASS”,”SECTION”
DO WHILE NOT EOF
INPUT #1,RN,N$,AD$,CL,S$
PRINT RN,N$,AD$,CL,S$
NEXT
CLOSE #1
END
Debugged Program
REM display Records of students From Data File
OPEN “STDREC.DAT” FOR INPUT AS #1
PRINT “ROLL”, ”NAME”, ”ADDRESS”, ”CLASS”,
”SECTION”
DO WHILE NOT EOF (1)
INPUT #1, RN, N$, AD$, CL, S$
PRINT RN, N$, AD$, CL, S$
LOOP
CLOSE #1
END
Study the following program and answer the given questions:
DECLARE SUB EXAM(N$)
CLS
INPUT “Enter word”;WO$
CALL EXAM(WO$)
END
SUB EXAM (N$)
FOR I = 1 TO LEN (N$)
PRINT RIGHT$(N$,I)
NEXT I
END SUB
a) Write the names of two built-in functions used in the above program.
Ans: The names of two built-in functions used in above program are LEN( ) and RIGHT$( ) .
b) List the real parameter in the program.
Ans: The real parameter used in the above program is WO$.
a) Write a program to find the numbers of vowels in an input string using ‘FUNCTION…..END FUNCTION’.
DECLARE FUNCTION COUNT (S$)
CLS
INPUT “ENTER ANY STRING”; S$
PRINT “TOTAL NO. OF VOWELS= “; COUNT(S$)
END
FUNCTION COUNT (S$)
VC = 0
FOR I = 1 TO LEN(S$)
B$ = MID$(S$, I, 1)
C$ = UCASE$(B$)
IF C$ = “A” OR C$ = “E” OR C$ = “I” OR C$ = “O” OR C$
= “U” THEN
VC = VC + 1
END IF
NEXT I
COUNT = VC
END FUNCTION
b) Write a program using sub procedure module to print
the series 1,1,2,3,5,8.. up to ten terms.
DECLARE SUB SERIES ( )
CLS
CALL SERIES
END
SUB SERIES ( )
A = 1
B = 1
FOR I = 1 TO 10
PRINT A;
C = A + B
A = B
B = C
NEXT I
END SUB
c) Write a program to create a data file ‘teldir.dat’ to store Name, Address and Telephone number of employees according to the need of the user.
OPEN “teldir.dat” FOR OUTPUT AS #1
DO
CLS
INPUT “ENTER NAME”; N$
INPUT “ENTER ADDRESS”; A$
INPUT “ENTER TELEPHONE NUMBER”; T#
WRITE #1, N$, A$, T#
INPUT “DO YOU WANT TO CONTINUE(Y/N)”; CH$
LOOP WHILE UCASE$(CH$) = ”Y”
CLOSE #1
END