Solved Computer Science SLC Examination 2068 (2012)
Optional II [Computer Science]
Examinees are required to answer in their own words as far as practicable. Credit shall be given to clarity and originality, not rote learning.
Time: 1 hour 30 minutes Full Marks: 50
Pass Marks:20
Attempt all the questions.
Computer fundamental (22 marks)
1. Answer the following questions:
a) Define LAN topology and write any two types of LAN topology.
1. Answer the following questions:
a) Define LAN topology and write any two types of LAN topology.
Ans: The arrangement or connection pattern of computers or nodes and other devices of the network is known as LAN topology.
Any two types of LAN topology are
i) Bus topology
ii) Star topology
b) Write any four services of Internet.
b) Write any four services of Internet.
Ans: Any four services of internet are
i) E-mail (Electronic mail)
ii) FTP (File Transfer Protocol)
iii) IRC (internet Relay Chat)
iv) E-commerce
ii) FTP (File Transfer Protocol)
iii) IRC (internet Relay Chat)
iv) E-commerce
c) Write any two advantages of multimedia in education field.
Ans: Any two ad advantages of multimedia in education field are
i) It makes teaching/learning easier in classroom.
iv) It makes presentation of related subject matter attractive.
d) Write any two software security measures.
d) Write any two software security measures.
Ans: Any two software security measures are:
i) Backup
ii) Password
e) Write any four symptoms that show, computer is infected by computer virus.
e) Write any four symptoms that show, computer is infected by computer virus.
Ans: Any four symptoms that show, computer is infected by computer virus are :
i) Program takes long time to load.
ii) The floppy disk or hard disk is suddenly accessed without a logical reason.
iii) Increased use of disk space and growth in file size.
iv) Corrupting the system data.
ii) The floppy disk or hard disk is suddenly accessed without a logical reason.
iii) Increased use of disk space and growth in file size.
iv) Corrupting the system data.
3. Match the following:
Group A Group B
a) Microwave a) Multimedia
b) Volt guard b) Protocol
c) Sound card c) Unguided media
d) TCP/IP d) Power protection devices
e) Guided media
Group A Group B
a) Microwave a) Multimedia
b) Volt guard b) Protocol
c) Sound card c) Unguided media
d) TCP/IP d) Power protection devices
e) Guided media
Answers
Group A Group B
a) Microwave Unguided media
b) Volt guard Power protection devices
c) Sound card Multimedia
d) TCP/IP Protocol
4. Select the best answers:
a) Which of the following is not a protocol?
i) POP ii) TCP/IP iii) NOS iv) FTP
a) Microwave Unguided media
b) Volt guard Power protection devices
c) Sound card Multimedia
d) TCP/IP Protocol
4. Select the best answers:
a) Which of the following is not a protocol?
i) POP ii) TCP/IP iii) NOS iv) FTP
NOS
b) Which device protects hardware?
i) UPS ii) MODEM iii) Gateway iv) All of the above
UPS
c) In which communication media data transfer high?
i) Twisted pair ii) Co-axial cable iii) Fiber optics
iv) Microwave
Fiber optics
d) Which computer virus damages the master boot record?
i) Macro virus ii) File virus iii) New folder virus
iv) Boot sector virus
Boot sector virus
5. Write the appropriate technical terms:
a) The device used to connect PC with telephone line.
a) The device used to connect PC with telephone line.
MODEM
b) The rules that make the network communication possible.
Protocol
c) A program that effect the normal functioning of computer.
Computer Virus
d) A main computer in the computer network.
Server
6. Write down the full forms:
a) bps = bits per second
6. Write down the full forms:
a) bps = bits per second
b) MAN = Metropolitan Area Network
c) FTP = File Transfer Protocol
iv)URL = Uniform Resource Locator
Group B-Database Management(10 marks)
7. Answer the following questions:
a) What is database?
Group B-Database Management(10 marks)
7. Answer the following questions:
a) What is database?
Ans: Database is a collection of related and organized information that can be used for different purpose.
b) What is data sorting?
Ans: Data sorting means grouping all the records in a table either in ascending or descending order based on a key field of the record.
c) What is a form?
Ans: Form is an object of MS-Access which provides a user friendly interface to enter data in a table or multiple linked tables.
8. Select the best answers:
a) ………………. Is not a data type of MS-Access.
i) Number ii) Text iii) Memo iv) Form
a) ………………. Is not a data type of MS-Access.
i) Number ii) Text iii) Memo iv) Form
Form
b) Primary key does not accept ……….
i) Text ii) Number iii) Null value iv) None of the above
Null value
c) ……………….. object of access is used to print formatted data.
i) Query ii) Form iii) Report iv) Table
i) Query ii) Form iii) Report iv) Table
Report
d) In MS-Access data are stored in ………………
i) Form ii) Query iii) Table iv) All of the above
Table
9. Match the following:
Group A Group B
a) Indexing a) Limits the value
b) Report b) Data type
c) Validation Rule c) Error messages
d) Hyper link d) Final output
e) Search fast
9. Match the following:
Group A Group B
a) Indexing a) Limits the value
b) Report b) Data type
c) Validation Rule c) Error messages
d) Hyper link d) Final output
e) Search fast
Answers
Group A Group B
a) Indexing Search fast b) Report Final output c) Validation Rule Limits the value
d) Hyper link Data type
a) Indexing Search fast b) Report Final output c) Validation Rule Limits the value
d) Hyper link Data type
Group C- Programming (18 marks)
10. a) What is loop?
Ans: Loop means executing a statement or group of statements a certain number of times depending upon the condition.
b) List any two data types supported by ‘C’ language.
Ans: Any two data types supported by ‘C’ language are:
i) char
ii) int
c) State the function of the following statement:
i) EOF
Ans: It detects the end of the file marker reading the data from an open sequential file.
ii) MKDIRAns: It creates a subdirectory which is used to manage files.
11. Re-write the given program after correcting the bugs:
CREATE FUNCTION Square(A)
Rem to print square of a number
CLS
Get “a number”; A
CALL square(A)
END
FUNCTION square(A)
Ans=A^2
Square=Ans
END Square(A)
CREATE FUNCTION Square(A)
Rem to print square of a number
CLS
Get “a number”; A
CALL square(A)
END
FUNCTION square(A)
Ans=A^2
Square=Ans
END Square(A)
Debugged ProgramDECLARE FUNCTION Square(A)
Rem to print square of a number
CLS
INPUT “a number”; A
PRINT square(A)
END
FUNCTION square(A)
Ans=A^2
Square=Ans
END FUNCTION
Rem to print square of a number
CLS
INPUT “a number”; A
PRINT square(A)
END
FUNCTION square(A)
Ans=A^2
Square=Ans
END FUNCTION
13. Analyze the program given below and answer the questions:
Declare function count(N$)
Input “Enter a word”; R$
C= Count(R$)
Declare function count(N$)
Input “Enter a word”; R$
C= Count(R$)
Print C
END
Function count(N$)
For k=1 to LEN(n$)
X$=MID$(N$,K,1)
IF UCASE$(X$)=”A” then
X=X+1
End if
Next K
Count = X
End function
i) List any two library functions used in the above program.
END
Function count(N$)
For k=1 to LEN(n$)
X$=MID$(N$,K,1)
IF UCASE$(X$)=”A” then
X=X+1
End if
Next K
Count = X
End function
i) List any two library functions used in the above program.
Ans: Any two library functions used in the above program are
1) UCASE$( )
2) MID$( )
ii) Write the use of variable ‘C’ inline 3 [i.e. C=Count(R$)] given in the above program.Ans: The use of variable ‘C’ inline 3 [i.e. C=Count(R$)] given in the above program is to call the function and store the value returned by the function count.
14. a) Write a program to calculate the area of four walls using SUB…END SUB.
DECLARE SUB AREA (L, B, H)
CLS
INPUT “ENTER LENGTH”; L
INPUT “ENTER BREADTH”; B
INPUT “ENTER HEIGHT”; H
CALL AREA (L, B, H)
END
SUB AREA(L, B, H)
A = 2 * H * (L + B)
PRINT “AREA OF FOUR WALLS=”; A
END SUB
b) Write a program using FUNCTION…..END FUNCTION to get a word
from the user and print it in reverse order.
DECLARE FUNCTION REV$ (S$)
CLS
INPUT "ENTER ANY WORD"; S$
PRINT "REVERSED WORD IS "; REV$(S$)
END
FUNCTION REV$ (S$)
FOR I = LEN(S$) TO 1 STEP -1
B$ = MID$(S$, I, 1)
W$ = W$ + B$
NEXT I
REV$ = W$
END FUNCTION
c) A sequential data file called “student.dat” contains some records under the
field’s name, English, Nepali and Computer. Write a program to add some
more records in the same sequential data file.
OPEN “student.dat” FOR APPEND AS #1
DO
CLS
INPUT “ENTER NAME”; N$
INPUT “ENTER MARKS IN ENGLISH”; E
INPUT “ENTER MARKS IN NEPALI”; N
INPUT “ENTER MARKS IN COMPUTER”; C
WRITE #1, N$, E, N, C
INPUT “DO YOU WANT TO CONTINUE”; CH$
LOOP WHILE UCASE$(CH$) = “Y”
CLOSE #1
END
***
No comments:
Post a Comment