Supplementary Examination 2066
Group A
Computer Fundamentals (22 marks)
1. Answer the following questions:
a) What is bandwidth?
Ans: The data handling capacity of a communication system is known as bandwidth.
b) What is network topology?
Ans: The arrangement or connection pattern of computers or nodes and other devices of the network is known as network topology.
c) How can multimedia help in education?
Ans: Multimedia technology is very much useful in education. It helps to present the information about various topics in more interesting and interactive way which makes the learner easy to understand. It helps to give better ideas and concept to the students with good vocabulary.
d) Write any four safety measures to protect computer form virus.
Ans: Any four safety measures to protect computer from viruses are:
i. Write-protect your floppy disk when using them on other computers.
ii. Do not install pirated software, especially computer games.
iii. Always scan files downloaded from the internet or transferred over the network before executing them.
iv. Do not interchange internal disk among the computers.
e) What is computer hardware and software security?
Ans: The security given to various hardware tools and equipment from being lost or damaged due to accidental or intentional harm is known as hardware security. For e.g: protection from theft, power protection device, etc.
The security given to various software and data from being lost or damaged due to accidental or intentional harm is known as software security. For e.g: defragmentation, scan disk, etc.
3. Match the following
Group A Group B
i) Bandwidth a) ISP
ii) Internet b) FAT
iii) Network c) bps
iv) Software security d) NAV
e) NIC
Ans:
Group A Group B
i) Bandwidth - a) bps
ii) Internet - b) ISP
iii) Network - c) NIC
iv) Software security - d) NAV
4. Choose the correct answer:
a) Which is NOT a guided media?
i) UTP Cable ii) STP Cable iii) Satellite iv) Fiber Optics
Ans: Satellite
b) Which device is necessary to operate internet?
i) CD-ROM ii) ISP iii) MODEM iv) All of the above
Ans: MODEM
c)Modem converts
i) Sound into digital ii) Digital into sound iii) Both i) and ii)
iv) None
Ans: Both i) and ii)
d) Which is not an internet service?
i) e-mail ii) e-telephone iii)e-fax iv) e-commerce
Ans: e-telephone
5. Write the technical terms of the following:a) Making extra copies of data or program.
5. Write the technical terms of the following:a) Making extra copies of data or program.
Ans: Backup
b) A card used to connect network cable to computer.
Ans: NIC (Network Interface Card)
c) Device used for power protection.
Ans: Volt guard
d) Program used to detect and eliminate computer virus.
Ans: Anti-virus
6. Write the full forms of:a) WWW- World Wide Web
6. Write the full forms of:a) WWW- World Wide Web
b) UPS- Uninterruptible Power Supply
c) NOS- Network Interface Card
d) UTP- Unshielded Twisted Pair
Group B
Database (10 marks)
Database (10 marks)
7. Answer the following questions:
a) Define database.
Ans: Database is a collection of related and organized information that is used to store, organize and extract data.
b) Write any four data type used in MS-Access.
Ans: Any four data types used in MS-Access are as follows:
i. Number
ii. Text
iii. Memo
iv. Autonumber
c) What is query?
Ans: Query is an object of MS-Access which allows selecting specific data from one or more tables.
8. State whether the following statements are true or false:a) Primary key does not accept null value. True
b) The extension of database file created by MS-Access is .BDF. False
c) Memo data type cannot be indexed. True
d) The default size of text data type is 50.True
9. Match the following: Group A Group B
a) OLE i) Formatted output
b) Primary key ii) Interface
c) Form iii) 64,000 characters
d) Report iv) Unique Field
v) Picture
8. State whether the following statements are true or false:a) Primary key does not accept null value. True
b) The extension of database file created by MS-Access is .BDF. False
c) Memo data type cannot be indexed. True
d) The default size of text data type is 50.True
9. Match the following: Group A Group B
a) OLE i) Formatted output
b) Primary key ii) Interface
c) Form iii) 64,000 characters
d) Report iv) Unique Field
v) Picture
Ans:
Group A Group Ba) OLE - Picture
b) Primary key - Unique Field
c) Form - Interface
d) Report - Formatted output
b) Primary key - Unique Field
c) Form - Interface
d) Report - Formatted output
Group C
Programming (18 marks)
Programming (18 marks)
10. a) What is user defined function?
Ans: The function which is defined by the user according to the need is known as user-defined function.
b) List any two data types used in C language.
Ans: The data types used in C language are:
· Char
· Int
c) Write down the function of the following statements:
i) KILL ii) FILES
i) KILL ii) FILES
Ans: The function of:
i. KILL: It deletes the file or files from the specified drive and directory.
ii. FILES: It displays all the files of the current subdirectory or specified sub directory.
11. Write the output of the given program: DECLARE SUB Result
CALL Result
END
SUB Result
For I = 1 to 9 STEP 2
Sum=Sum +I^2
Next I
PRINT Sum
END SUB
CALL Result
END
SUB Result
For I = 1 to 9 STEP 2
Sum=Sum +I^2
Next I
PRINT Sum
END SUB
12. Rewrite the following program after correcting the bugs:REM to store Name, post and salary
OPENEMP.DOCFOROUTAS#1
INPUT “Enter Name”; N
INPUT “Enter post”; P$
INPUT “Enter salary”; S
WRITE #2, N$,P$,S
CLOSE #1
END
OPENEMP.DOCFOROUTAS#1
INPUT “Enter Name”; N
INPUT “Enter post”; P$
INPUT “Enter salary”; S
WRITE #2, N$,P$,S
CLOSE #1
END
Ans:
REM to store Name, post and salary
OPEN “EMP.DOC” FOR OUTPUT AS #1
INPUT “Enter Name”; N$
INPUT “Enter post”; P$
INPUT “Enter salary”; S
WRITE #1, N$,P$,S
CLOSE #1
END
13. Study the following program and answer the following questions:
OPEN “EMP.DOC” FOR OUTPUT AS #1
INPUT “Enter Name”; N$
INPUT “Enter post”; P$
INPUT “Enter salary”; S
WRITE #1, N$,P$,S
CLOSE #1
END
13. Study the following program and answer the following questions:
DECLARE FUNCTION COUNT(A$)
Input “Enter a word”; W$
END
Function Count(A$)
B=LEN(A$)
C$=UCASE$(A$)
FOR I=1 TO B
E$=MID$(C$,I,1)
IF E$=”A” OR E$=”E” OR E$=”I” OR E$=”O” OR E$=”U” THEN C=C+1
END IF
NEXT I
COUNT=C
END FUNCTION
a) List the string Library functions used in the above program.
Input “Enter a word”; W$
END
Function Count(A$)
B=LEN(A$)
C$=UCASE$(A$)
FOR I=1 TO B
E$=MID$(C$,I,1)
IF E$=”A” OR E$=”E” OR E$=”I” OR E$=”O” OR E$=”U” THEN C=C+1
END IF
NEXT I
COUNT=C
END FUNCTION
a) List the string Library functions used in the above program.
Ans: The string Library functions used in the above program are as follows:
· LEN
· MID$
· UCASE$
b) Write down the missing statements in the main module to execute the program.
Ans: The missing statements in the main module to execute the program is :
PRINT COUNT(W$).
14. a) Write a program using FUNCTION…..END FUNCTION to find the average of any two numbers given by the user.
14. a) Write a program using FUNCTION…..END FUNCTION to find the average of any two numbers given by the user.
Ans:
DECALRE FUNCTION AVE(A,B)
CLS
INPUT “Enter any two numbers”; A,B
PRINT “The average of two numbers=”; AVE(A,B)
END
FUNCTION AVE(A,B)
AV=(A+B)/2
AVE=AV
END FUNCTION
b) Write a program using SUB……END SUB to check whether the number given by the user is positive or negative.
Ans:
DECLARE SUB CHECK(N)
CLS
INPUT ”Enter any number”; N
CALL CHECK(N)
END
SUB CHECK(N)
IF N>0 THEN
PRINT N;”is positive number”
ELSEIF N<0 THEN
PRINT N;”is negative number”
END IF
END SUB
c) A data file “LIB.TXT” consists of book’s name, author’s name and price of books. Write a program to count and display the total number of records present in the file.
Ans:
OPEN “LIB.TXT” FOR INPUT AS #1
CLS
WHILE NOT EOF(1)
INPUT #1, N$, A$, P
C=C+1
WEND
PRINT “The total number of records=”; C
CLOSE #1
END
***
No comments:
Post a Comment