SEE Computer Science Examination Paper Solved 2073
 |
SEE Computer Science Examination Paper Solved 2073 |
SEE Examination 2073
Computer Science
Group “A”
Computer Fundamental [22 marks]
1. Answer the following questions. (2x5=10)
a. Write any two advantages of BUS topology.
Ans: The advantages of bus topology are listed below:
· It is easy to set up computers and other devices in bus topology.
· It is cheap.
b. Define computer security.
Ans: The security given to the computer for the protection of hardware, software and data from being lost or damaged due to accidental or intentional harm is known as computer security.
c. Write any two preventive measures to protect computer system from computer virus.
Ans: Any two preventive measures to protect computer from virus are listed below:
· Do not install pirated software
· Use antivirus software and scan for virus regularly.
d. What is multimedia?
Ans: Multimedia is the integration of multiple forms of media, which presents information in more interesting, effective and understandable way.
e. Write the use/function of File Transfer Protocol.
Ans: The use of File Transfer Protocol is to transfer the file from one computer to another computer. It helps to upload and download the files.
2. a. Perform the conversion as per the direction. (1x2=2)
i. (BAD)16 into binary
Soln:
B A D
1011 1010 1101
Therefore: (BAD)16 = (101110101101)2
ii. (1111001)2 into octal
Soln:
001 111 001
1 7 1
Therefore: (1111001)2 = (171)8
b. Perform the binary calculations. (1x2=2)
i. 11x10+11
Soln:
1 1
x1 0
0 0
+1 1 x
1 1 0
+1 1
1001
:. 11x10+11= 1001
i. 110 ÷ 10
Soln:
10)110(11
- 10
-10
00
:. Q = 11
:. R = 00
3. Match the following. (0.5x4=2)
Group A Group B
a. Malicious software UPS
b. Primary storage device Virus
c. Power protection Device Copyright
d. Intellectual property law RAM
CD-ROM
Answer
Group A Group B
a. Malicious software virus
b. Primary storage device RAM
c. Power protection Device UPS
d. Intellectual property law Copyright
4. State whether the following statements are true or false. (0.5x4=2)
a. Computer Network reduces the cost. True
b. WWW is an organization which controls Internet. False
c. Microwave transmission is an example of bound media. False
d. The parts of the computer which can be seen and touched are called hardware. True
5. Write the appropriate technical terms of the following. (0.5x4=2)
a. A type of network in which every computer works as both client and server. Peer-to-peer network
b. Protocol used to receive email from the mail server. POP
c. The moving graphics images. Animation
d. The law that controls cyber-crimes. Cyber Law
6. Write the full forms. (0.5x4=2)
a. LAN Local Area Network.
b. ROM Read Only Memory.
c. SMTP Simple Mail Transfer Protocol.
d. NOS Network Operating System.
Group B Database (10 Marks)
7. Answer the following questions. (2x3=6)
a. Define data and database.
Ans: Data can be numbers, letters or symbols representing facts and figures which may or may not give any sense. Database is a collection of related and organized information that can be used for different purpose.
b. What is primary key? Write its importance.
Ans: Primary key is a field of a table that uniquely identifies each record in a table of the database.
The importance of Primary key are listed below:
· It prevents from data redundancy.
· It helps to set relation between tables of the database.
c. Name any four data types used in MS-Access.
Ans: Any four data types of MS-Access are listed below:
· Text
· Auto number
· Memo
· Number
8. Select the correct answer. (0.5x4=2)
a. The columns in a database table are called………………………
i. Record ii. Field iii. Report iv. Memo
b. Which is the suitable data type to store video?
i. Text ii. Memo iii. Yes/No iv. OLE object
c. …………… object of MS-Access is used to print formatted data.
i. Query ii. Form iii. Report iv. Table
d. Which is not a type of query?
i. Search ii. Select iii. Update iv. All of the above
9. Match the following. (0.5x4=2)
Group A Group B
a. Query Printed format
b. Form Stores data
c. Table Allows view, edit, input data
d. Report Extracts selected record for view
DBMS
Answer
Group A Group B
a. Query Extracts selected record for view
b. Form Allows view, edit, input data
c. Table Stores data
d. Report Printed format
Group C Programming (18 Marks)
10. Answer the following questions. (1x3=3)
a. What is a loop?
Ans: Loop is the repetition of statements for several times used to achieve the desired result.
b. Write the functions of NAME and CLOSE statements.
i. The function of NAME statement is to rename a file.
ii. The function of CLOSE statement is to close one or all open files.
c. What is variable?
Ans: The symbol or character that stores the program data that may change during program execution is called a variable.
11. Re-write the given program after correcting the bugs. (0.5x4=2)
DECLARE SUB SUM(N)
INPUT “Any Number”; N
PRINTSUM(N)
END
SUB SUM (N)
S=0
WHILE N=0
R=R MOD 10
S=S + R
N=N /10
WEND
PRINT “Sum of digits”; s
END
Debugged Program
DECLARE SUB SUM(N)
INPUT “Any Number”; N
CALL SUM(N)
END
SUB SUM (N)
S=0
WHILE N< >0
R= N MOD 10
S=S + R
N=N \ 10
WEND
PRINT “Sum of digits”; S
END SUB
12. Write the output of the following program. (2)
DECLARE FUNCTION AREA (L, B)
CLS
LET L = 50
LET B = 10
LET ans = “; ans
PRINT “The area=”; ans
END
FUNCTION AREA (L, B)
Ar =L*B
AREA=Ar
END FUNCTION
OUTPUT: The area = 500
13. State the following program and answer the given questions. (1x2=2)
DECLARE FUNCTION Diff (A, B)
CLS
INPUT “Enter first number”; A
INPUT “Enter second number”; B
PRINT “The difference”; Diff (A, B)
END
FUNCTION Diff (A, B)
Difference= A – B
Diff = difference
END FUNCTION
a. List all the numeric variables used in the above program.
Ans: The numeric variables used in the above program are A, B and Difference
b. List the local variables used in the above program.
Ans: The local variables used in the above program is A, B and Difference
14 a. Write a program to calculate the area of four walls using Sub….End Sub. [Hint: Area=2H(L+B). (3)
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 to input a word in the main module and count the total number of vowel characters present in the word using FUNCTION…END FUNCTION. (3)
DECLARE FUNCTION COUNT (S$)
CLS
INPUT "ENTER ANY STRING"; S$
PRINT "TOTAL NO. OF VOWELS= "; COUNT(S$)
END
FUNCTION COUNT (S$)
C = 0
FOR I = 1 TO LEN(S$)
A$ = MID$(S$, I, 1)
B$ = UCASE$(B$)
IF B$ = "A" OR B$ = "E" OR B$ = "I" OR B$ = "O" OR B$ = "U" THEN
C = C + 1
END IF
NEXT I
COUNT = C
END FUNCTION
c. Create a data file to store the records of few employees having Name, Address, Post, Gender and Salary fields. (3)
OPEN “std.dat” FOR OUTPUT AS #1
CLS
DO
INPUT “Enter Name”; N$
INPUT “Enter Address”; A$
INPUT “Enter Post”; P$
INPUT “Enter gender”; G$
INPUT “Enter Salary”; S
WRITE #1, N$, A$, P$, G$, S
INPUT “Do you want to continue”; CH$
LOOP WHILE UCASE$(CH$) = ”Y”
CLOSE #1
END
Comments
Post a Comment