SEE Computer Science Examination Paper Solved 2074
SEE Computer Science Examination Paper Solved 2074 |
SEE Examination 2074
Computer Science
Group “A”
Computer Fundamental [22 marks]
1. Answer the following questions. (2x5=10)
a. Define computer network.
Ans: The interconnection of two or more than two computers for data communication is called computer network.
b. Define Internet.
Ans: The world’s largest computer network that connects millions of computers across the world for data communication is called internet.
c. Write the importance of power protection device to protect the computer system.
Ans: The importance of power protection device to protect the computer system are listed below:
· It protects from power fluctuations.
· It supplies constant voltage.
· UPS provides backup power that helps to save computer data.
d. Write any two symptoms that can be seen when a computer is infected by computer virus.
Ans: The symptoms that can be seen when a computer is infected by computer virus are listed below:
· Computer becomes hang and perform slowly.
· Applications opens automatically.
e. What is cybercrime? Give any two examples.
Ans: Cyber-crime refers to any illegal activity that is done with the help of computer and internet.
Two cyber-crimes are listed below:
· Software piracy
· Hacking
2. a. Perform the conversion as per the direction. (1x2=2)
i. (523)8 into Binary
Soln:
Octal 5 2 3
Binary 101 010 011
Therefore: (523)8 = (101010011)2
b. Binary Calculation. (1x2=2)
i. 110 x 101
Soln:
1 1 0
x 1 0 1
1 1 0
0 0 0 x
+ 1 1 0 x x
1 1 1 1 0
:. 110 x 101 = 11110
ii.111010 ÷ 110
Soln:
110) 111010(1001
-110
X 1010
-110
100
:. Q= 1001 R=100
2. Match the following. (0.5x4=2)
Group A Group B
a. RJ 45 connector Duplicate copy
b. Back up Multimedia
c. Microphone Twisted pair cable
d. Hub/switch Ring Topology
Star Topology
Answer
Group A Group B
a. RJ 45 connector Twisted pair cable
b. Back up Duplicate copy
c. Microphone Multimedia
d. Hub/switch Star Topology
4. Select the best answer of the following. (0.5x4=2)
a. Which of the following is not a network protocol?
i. POP ii. FTP iii. TCP/IP iv. NOS
b. Which of these software is used for photo editing?
i. MS-Excel ii. Photoshop iii. Power-Point iv. MS-Word
c. Which device is used to connect multiple networks that uses the same protocol.
i. Bridge ii. NIC iii. Switch iv. Gateway
d. Process of arranging the scattered files into a contiguous manner.
i. Scandisk ii. Backup iii. Defragmentation iv. Debugging
5. Write the appropriate technical terms of the following. (0.5x4=2)
a. The physical layout of local area network. Topology
b. The business conducted through Internet. E-commerce
c. The law which controls the crime which is done with the help of computer and Internet. Cyber law
d. A computer or device which provides different services to other computers connected to the network. Server computer
6. Write the full forms of. (0.5x4=2)
a. SMTP Simple Mail Transfer Protocol
b. WAN Wide Area Network
c. URL Uniform Resource Locator
d. VOIP Voice Over Internet Protocol
Group B Database (10 Marks)
7. Answer the following questions. (2x3=6)
a. Define Database.
Ans: Database is the organized collection of information in a systematic way that can used for various purposes.
b. What is data redundancy? How can it be reduced in database?
Ans: The repetition of same record in a table is called data redundancy.
It can be reduced by using primary key.
c. Mention any four data types that can be used in MS-Access.
Ans: The four data types used in MS-Access are listed below:
· Text
· Memo
· Currency
· Date/Time
8. Select the correct answer. (0.5x4=2)
a. Which of the following is not accepted by primary key?
i. Number ii. Text iii. Null value iv. None
b. What is called rows in database table?
i. Field ii. Record iii. Form iv. None
c. Which data type consumes the least storage space?
i. Text ii. Yes/No iii. OLE object iv. Memo
d. Which is the default data type of MS-Access?
i. Memo ii. Number iii. Text iv. Auto number
9. Match the following. (0.5x4= 2)
Group A Group B
a. Data Input, view, edit data
b. Form Formatted output
c. Report Collection of raw facts
d. Table Question to the database
Stores data in database
Answer
Group A Group B
a. Data Collection of raw facts
b. Form Input, view, edit data
c. Report formatted output
d. Table Stores data in database
Group C Programming (18 Marks)
10. Answer the following questions. (3x1=3)
a. What is formal parameter?
Ans: The parameter used while declaring the procedure is called a formal parameter.
b. List any two data types used in C programming language.
Ans: The wo data types used in C programming language are listed below:
· Int
· Char
c. Write the function of KILL and CLOSE statements.
i. The function of KILL is to delete files on a disk.
ii. The function of CLOSE statement is to close open files.
11. Re-write the given program after correcting the bugs. (0.5x4=2)
REM TO find the factorial of a given number.
DECLARE FUNCTION FACTO (N$)
CLS
INPUT "Enter a number"; X
PRINT "The Factorial is: "; FACTO (N)
END
FUNCTION FACTO (N)
F = 1
WHILE N = 0
F = F*N
N = N - 1
WEND
F = FACTO
END FUNCTION
Debugged Program
REM TO find the factorial of a given number.
DECLARE FUNCTION FACTO (N)
CLS
INPUT "Enter a number”; N
PRINT "The Factorial is: "; FACTO (N)
END
FUNCTION FACTO (N)
F = 1
WHILE N <> 0
F = F*N
N = N - 1
WEND
FACTO = F
END FUNCTION
12. Write the output of the following program. (2)
DECLARE SUB Display (T$)
CLS
T$ = "COMPUTER"
CALL Display (T$)
END
SUB Display (T$)
FOR C = 1 TO LEN (T$) STEP 2
$ = MID$ (T$, C, 1)
PRINT D$;
NEXT C
END SUB
OUTPUT: C M U E
13. Study the following program and answer the given questions. (1x2=2)
DECLARE FUNCTION SUM (N)
CLS
INPUT "Enter any number"; N
S= SUM (N)
PRINT "The Sum of individual digit is:"; S
END
FUNCTION SUM (N)
WHILE N > 0 R = N MOD 10
S= T + R
N = N\10
WEND
SUM = T
END FUNCTION
a. State the purpose of using variable S in line 4 in the above program.
Ans: The purpose of using variable S is to call the function and store the value returned by the function.
b. Write the use of MOD in the above program.
Ans: The MOD is used to calculate the remainder.
14. a. Write a program to calculate the area of a circle using Sub..... End Sub. (3)
DECLARE SUB AREA (R)
CLS
INPUT” ENTER THE RADIUS”; R
CALL AREA(R)
END
SUB AREA(R)
A= (22/7) * R^ 2
PRINT” THE AREA OF CIRCLE IS “; A
END SUB
b. Write a program using FUNCTION... END FUNCTION to count the number of words in a sentence. (3)
DECLARE FUNCTION COUNT(S$)
CLS
INPUT” ENTER A SENTENCE”; S$
PRINT” TOTAL NUMBER OF WORDS”; COUNT(S$)
END
FUNCTION COUNT(S$)
W=1
FOR I = 1 TO LEN(S$)
C$=MID$(S$, I, 1)
IF C$ = ” “ THEN
W=W+1
END IF
NEXT I
COUNT=W
END FUNCTION
c. Write a program to store Roll no., Name, Class, and Address of any five students. (3)
OPEN “STD.DAT” FOR OUTPUT AS #1
CLS
FOR I = 1 TO 5
INPUT” ENTER ROLL NUMBER”; RN
INPUT” ENTER NAME”; N$
INPUT” ENTER CLASS”; C
INPUT” ENTER ADDRESS”; A$
WRITE #1, RN, N$, C, A$
NEXT I
CLOSE #1
END
Comments
Post a Comment