Solved SEE 2074 [Computer Science]
Group A
Computer Fundamentals (22 Marks)
1. Answer the following questions: [5×2=10]a. Define computer network.
Ans: Computer network can be defined as a connection between computers and other
electronic devices to share the resources and information.
b. Define Internet.
Ans: A global computer network providing a variety of information and communication
facilities is called internet.
c. Write the importance of power protection device to protect computer system.
Ans: The importance of power protection device to protect computer system are:
i) To protect the hardware against damage from unexpected power failures.
ii) To protect files and programs being corrupted due to sudden power failure.
d. What is computer virus? Mention any two symptoms that can be seen when a computer is infected by computer virus.
Ans: A computer program which is capable of copying itself and typically has a detrimental
effect, such as corrupting the system or destroying data. Or any other suitable answer.
Two symptoms of computer virus in a computer are:
i) Unexpected computer behavior
ii) Computer becomes slower
e. What is cyber crime? Give any two examples.
Ans: The criminal activities involving the information technology with the help of computer is
known as cyber crime.
Any two examples of cyber crimes are: software piracy and hacking
2.a) Perform the conversion as per the direction: [2×1=2]
b) Perform the binary calculations: [2×1=2]
3. Match the following: [4×0.5=2]
Group 'A' Group 'B'
a) RJ 45 connector i) Duplicate copy
b) Backup ii) Multimedia
c) Microphone iii) Twisted pair cable
d) Hub / switch iv) Ring Topology
v) Star Topology
Answers:
Group 'A' Group 'B'
a) RJ 45 connector i) Twisted pair cable
b) Backup ii) Duplicate copy
c) Microphone iii) Multimedia
d) Hub / switch iv) Star Topology
4. Select the best answer of the following: [4×0.5=2]
a) Which of the following is not a network protocol?
i) POP ii) FTP iii) TCP/IP iv) NOS
Ans: NOS
b) Which of these software is used for photo editing?
i) Ms-Excel ii) Photoshop iii) Power-Point iv) MS-Word
Ans: Photoshop
c) Which device is used to connect multiple networks that use the same protocol
i) Bridge ii) NIC iii) Switch iv) Gateway
Ans: Bridge
d) Process of arranging the scattered files into a contiguous manner.
i) Scandisk ii) Backup iii) Defragmentation iv) Debugging
Ans: Defragmentation
5. Write the appropriate technical terms of the following: [4×0.5=2]
a) The physical layout of local area network.
Ans: Topology
b) The business conducted through internet.
Ans: E-commerce
c) The law which controls the crime which is done with the help of computer and Internet.
Ans: Cyber law
d) A computer or device which provides different services to other computers connected to the
network.
Ans: Server
6. Write the full form: [4×0.5=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)
a) Define database.
Ans: Database can be defined as an organized collection of data which can be easily accessed, managed and updated.
b) What is data redundancy? How can it be reduced in database?
Ans: The repetition of same piece of data in a database in more than one location is called data redundancy. Data redundancy can be minimized by normalization of database.
c) Mention any four data types that can be used in Ms-Access.
Ans: Any four data types that can be used in Ms-Access are
i) Text
ii) Memo
iii) Currency
iv) Number
8. Select the correct answer: [4×0.5=2]
a) Which if the following is not accepted by primary key?
i) Number ii) Text iii) Null value iv) None
Ans: Null value
b) Which is called rows in database table?
i) Field ii) Record iii) Form iv) None
Ans: Record
c) Which data type consumes the least storage space?
i) Text ii) Yes/No iii) OLE object iv) Memo
Ans: Yes/No
d) Which is the default data type of Ms-Access?
i) Memo ii) Number iii) Text iv) Auto number
Ans: Text
9. Match the following: [4×0.5=2]
Group 'A' Group 'B'
a) Data i) Input, view, edit data
b) Form ii) Formatted output
c) Report iii) Collection of raw facts
d) Table iv) Questions to the database
v) Stores data in database
Answers:
Group 'A' Group 'B'
a) Data i) Collection of raw facts
b) Form ii) Input, view, edit data
c) Report iii) Formatted output
d) Table iv) Stores data in database
Group C
Programming (18 Marks)
10. a) What is formal parameter? [1]
Ans: The variable which is used in the function definition is called formal parameter.
b) List any two data types used in C programming language. [1]
Ans: Any two data types used in C programming language are
i) char
ii) int
c) Write the function of KILL and CLOSE statements. [1]
Ans: The function of KILL is to delete the file
The function of CLOSE is to close any opened file
11. Re-write the given program after correcting the bugs: [4×0.5=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", X
PRINT "The Factorial is :", FACTO (X)
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
D$ = MID$(T$, C, 1)
PRINT D$;
NEXT C
END SUB
Output:
CMUE
13. Study the following program and answer the given questions: [2×1=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
T = T + R
N = N \ 10
WEND
SUM = T
END FUNCTION
a) State the purpose of suing variable S in line 4 in above program.
Ans: Variable S is used to store the value returned by the function Sum.
b) Write the use of MOD in the above program.
Ans: MOD is used to get the remainder of the division.
14. a) Write a program to calculate area of a circle using Sub......End Sub. [3]
DECLARE SUB Area (r)
CLS
INPUT "Enter radius of circle", r
CALL Area (r)
END
SUB Area (r)
A = 3.14*r*r
PRINT "Area of circle :" ; A
END SUB
b) Write a program using FUNCTION.....END FUNCTION to count the number of words in a sentence. [3]
DECLARE FUNCTION WCount (S$)
CLS
INPUT "Enter a sentence", S$
C = WCount (S$)
PRINT "The number of words is :" ; C
END
FUNCTION WCount (S$)
W = 1
FOR I = 1 To LEN (S$)
C$ = MID $ (S$, I,1)
IF C$ = " " THEN W = W + 1
NEXT I
WCount = W
END FUNCTION
c) Write a program to store Roll no., Name, Class and Address of any five students. [3]
OPEN "Student.dat" FOR OUTPUT AS #1
FOR I = 1 TO 5
INPUT "Enter Roll No.", r
INPUT "Enter Name", n$
INPUT "Enter Class", c
INPUT "Enter Address", a$
WRITE #1, r, n$, c, a$
NEXT I
CLOSE #1
END
***
Answer Source of all SEE Questions 2074 : Click here
You can also download the SEE Questions 2074 by Clicking here
