SEE COMPUTER
SCIENCE 2080 MODEL SET 1
Subject: Opt. II Computer Science Full Marks: 50
Time: 2 hrs.
Candidates are required to write their answers
according to the instructions given.
Attempt all questions.
(Group 'A'
10×1=10)
1. Answer the following questions in one sentence: 6×1=6
a) What is web browser?
b) Mention any two services provided by Internet.
c) What is the maximum length of field name in MS-Access?
d) Which is the logical data type of MS-Access?
e) What is modular programming?
f) Mention any two basic data types of C language.
2. Write appropriate technical term for the following:
2×1=2
a) Network of Networks.
b) Computer program that protects computer from computer
virus.
3. Write the full form of the following: 2×1=2
a) FTP: b)
MAN:
(Group 'B')
4. Answer the following questions: 9×2=18
a)
What is network topology? List any two types of network topology.
b)
Define cyber law and cyber crime.
c)
What is password? Write any two importance of password protection.
d)
What is online payment? Write any two online payment in Nepal.
e)
Define virtual reality. Write any two areas where virtual reality is
used.
f)
What is DBMS? Write four objects of MS-Access.
g)
What are validation text and validation rule?
h)
What is form? Write any two advantages of it.
i)
What is foreign key? Why is primary key necessary in record?
5. Write the output
of the given program: Show with dry run in table. 2
DECLARE SUB
Series(A)
CLS
A=20
CALL
Series(A)
END
SUB
Series(A)
FOR K=1 to 5
PRINT A;
A=A+10
NEXT K
END SUB
6. Re-Write the given program after correcting
the bug: 2
REM Program
to make a word reverse
DECLARE
FUNCTION Rev$(N$)
CLS
INPUT “Enter
a word”: N$
DISPLAY
“Reversed is”; Rev$(N$)
END
FUNCTION
Rev$(N$)
FOR
K=LEN$(N$) to 1 STEP-1
B$=B$+MID$(N$,1,K)
NEXT K
B$=REV$
END FUNCTION
7. Study the
following program and answer the given questions: 2×1=2
OPEN
“EMP.DAT” FOR INPUT AS #1
DO
INPUT #1, N$, A$, S
IF UCASE$(A$)=”KATHMANDU” THEN
PRINT N$, A$, S
END IF
LOOP
WHILE NOT EOF(1)
CLOSE
#1
END
a.
Write
the use of statement “INPUT #1, N$, A$, S” in the above program.
b.
What
happens if you remove “UCASE$” from the above program?
8.
Convert/Calculate as per the instruction: 4×1=4
a) (10110011)2 –
(?)16 b)
(410)10 = (?)2
c) (1001 + 110)2 – (1000)2 d) (10110)2 / (101)2
9 a) Write a program to calculate Area of circle using Function
procedure and use SUB procedure to calculate its circumference in Q-Basic.
[Hint: [A=pr2], [C=2pr]
4
b) Write
a program to create a sequential data file named “Employee.dat” to store Name,
Post, Address and Salary for the number of employees. The program should
terminate on user’s choice. 4
10. Write a program in C language to input a number and
then check whether the number is positive, negative or zero number. 4
OR
Write a program in ‘C’ language to display the series with
their sum 1, 2, 3, 4 ,……up to 10th terms.
Best of Luck
SEE COMPUTER
SCIENCE 2080 MODEL SET 2
Subject: Opt. II Computer Science
Class: 10
Full Marks: 50
Time: 2 hrs.
Candidates are required to write their answers
according to the instructions given.
Attempt all questions.
(Group 'A' 10×1=10)
1. Answer the following questions in one sentence: 6×1=6
a)
What is search engine?
b) What is the business done through the internet called?
c) What is the default extension of MS-Access?
d) Which object of MS-Access is used to retrieve data
from the table?
e) Write any one advantage of Modular Programming.
f) Which is the structured programming language?
2. Write appropriate technical term for the following:
2×1=2
a) A system of copying data and information reading in
computer into another location.
b) A company which provides services of
Internet.
3. Write the full form of the following: 2×1=2
a) POP:
b) AI:
(Group 'B')
4. Answer the following questions: 9×2=18
a)
What is computer network? List any two importance of
computer network.
b)
Write any two advantages and
disadvantages of social media.
c)
Define software security. Write any
two protection measures for it.
d)
Define e-commerce. Write the name of
any two E-commerce sites.
e)
Why mobile computing is necessary in
present time? Write any two importance of it.
f)
What
is database? Give any two examples.
g)
What is primary key? Write any two
features of it.
h)
Define field and record.
i)
What
type of work is done in MS-Access using form and query object.
5. Write the output
of the given program: Show with dry run in table. 2
DECLARE SUB Result (C$)
C$= “COMPUTER"
CALL Result (C$)
END
SUB Result (C$)
FOR C=1 TO LEN(C$) STEP 2
M$=MIDS (C$,C,1)
N$=N$+MS
NEXT C
PRINT N$
END SUB
6. Re-Write the given program after correcting
the bug: 2
REM to display records from existing file.
OPEN "emp.text" FOR APPEND AS #1
WHILE NOT EOF (#1)
WRITE # 1, eN$, posts, salaryS
PRINT eN$, post$, salary
NEXT
CLOSE #1
END
7. Study the
following program and answer the given questions: 2×1=2
DECLARE
FUNCTION SUM(N)
CLS
INPUT”Enter
any number”: N
X=SUM(N)
PRINT”The
sum of individual digit is “; X
END
FUNCTION
SUM(N)
WHILE
N<>0
R=N MOD 10
S=S+R
N=INT(N/10)
WEND
SUM=S
END FUNCTION
a) Write
the function of INT.
b) How
many times the WHILE…..WEND LOOP repeats if the value of N is 123?
8.
Convert/Calculate as per the instruction: 4×1=4
i) (214) 10 = (?)2 iii)
(1011)2×(101) 2
ii) (ABC) 16 = (?)2 iv)
(10101)2 / (11)2
9 a) Write a program in Q-BASIC that asks length and breadth of a
room and calculate its area and perimeter. Create a user-defined FUNCTION to
calculate area and SUB program to calculate perimeter. [Hint: A=L×B, P=2(L+B)] 4
b) Students' name,
class, section and address are stored in a data file called
"STUDENT.DAT" Write a program to print all the records of students. 4
10.
Write a program C language that asks
any two numbers and displays the greatest among them. 4
OR
Write a program in C-language
to display the series 2, 4, 6, 8 up to the 10th term.
Best of Luck
SEE COMPUTER
SCIENCE 2080 MODEL SET 3
Full Marks: 50
Time: 2 hrs.
Candidates are required to write their answers
according to the instructions given.
Attempt all questions.
(Group 'A' 10×1=10)
1. Answer the following questions in one sentence: 6×1=6
a)
What is network
protocol?
b)
What is antivirus
software?
c)
What is the
default size of text field in MS-Access?
d)
Which data type is
used to store photo in MS-Access?
e)
What is looping?
f)
Write any two features
of C language.
2. Write appropriate technical term for the following:
2×1=2
a)
Law that governs
the legal issues of cyberspace.
b)
The smallest unit
to represent information on quantum computer.
3. Write the full form of the following: 2×1=2
a.
UTP: b. IoT:
(Group 'B')
4. Answer the following questions: 9×2=18
a)
Write
any two advantages and disadvantages of computer network.
b)
What is computer ethics? Write down any two ethics of it.
c)
What is computer security? Write any two hardware security measures.
d)
Give two differences between E-commerce and Traditional Commerce.
e)
Define artificial intelligence (AI). Write any two uses of AI.
f)
What is RDBMS? Write any two examples of DBMS.
g)
What is report in MS-Access? Mention the importance of report in
database.
h)
What is data sorting? List any two
advantages of using it.
i)
List the field name and records used in the following table structure.
|
Symbol_No |
Name |
Marks |
|
001009010 |
Hari Thapa |
85 |
|
00100901Q |
Binu Sharma |
91 |
5. Write the output
of the given program: Show with dry run in
table. 2
DECLARE SUB
ABC(A)
CLS
A=2
CALL ABC(A)
END
SUB ABC(A)
FOR J= 1 TO
5
PRINT A;
A=A+3;
NEXT J
END SUB
6. Re-Write the given program after correcting
the bug: 2
DECLARE SUB Series ( )
CLS
EXECUTE
Series
END
SUB
Series( )
REM Program
to generate 1 1 2 3 5 .....upto the 20th terms
A=1
B=1
FOR ctr=10
to 1
DISPLAY A:B:
A=A+B
B=A+B
NEXT ctr
END Series (
)
7. Study the
following program and answer the given questions: 2×1=2
OPEN
“Detail.dat” FOR INPUT AS #1
OPEN
“Temp.dat” FOR OUTPUT AS #2
INPUT
“Enter name of the students”; S$
FOR
I=1 TO 10
INPUT
#1, Nm$, Cl, A
IF
S$< >Nm$ THEN
WRITE
#2, Nm$, Cl, A
END
IF
NEXT
I
CLOSE
#1, #2
KILL
“Detail.dat”
NAME
“Temp.dat” AS “Detail.dat”
END
a.
What
is the main objective of the program given above?
Do you get any
problem in the above program if “Kill” statement is removed?
8.
Convert/Calculate as per the instruction: 4×1=4
i)
(11111101)2 = (?)16 i) (245)10 = (?)2
iii)
(1010) 2 x (101) 2 =(?)2 iv) (101110) 2 / (110) 2\
9 a) Write a program in QBASIC that will asks the user to input
length, breadth and height of a room then use SUB procedure calculate its
volume and FUNCTION procedure to calculate its area of four walls. 4
b) A sequential data file called “Record.dat” has stored data
under the field heading Roll No., Name, Gender, English, Nepali, Maths and
Computer. Write a program to display all the information of those students
whose marks in English is more than 40. 4
10.
Write a program in C
language that asks a number and check whether it is odd or even. 4
OR Write
a program in C language to display the series 1, 1, 2, 3, 5, 8 upto 10th
terms.
Best of Luck
SEE COMPUTER
SCIENCE 2080 MODEL SET 4
Full Marks: 50
Time: 2 hrs.
Candidates are required to write their answers
according to the instructions given.
Attempt all questions.
(Group 'A'
10×1=10)
1. Answer the following questions in one sentence: 6×1=6
a) What is internet?
b) Name any two popular antivirus software.
c) Which view is used to modify a table structure in
MS-Access?
d)
Which data type is
used to store alpha numeric characters or special symbols in MS-Access?
e) Which statement is used to call sub-procedure?
f) What is an operator in C language?
2. Write appropriate technical term for the following:
2×1=2
a) A malicious program of computer that damages data
and software.
b) Learning through the electronic media.
3. Write the full form of the following: 2×1=2
a)
G2G
b)
ISP
(Group 'B')
4. Answer the following questions: 9×2=18
a)
Define star topology with figure.
b)
What
is hardware security? Write the role of UPS in hardware security.
c)
What
is e-banking? Write any two uses of it.
d)
What
is m-commerce? Write any two important services.
e)
What
is IoT? Write any two importance of it.
f)
Write any two advantages of computerized database.
g)
What is query? Write down any two advantages of Query.
h)
Define data and information.
i)
List the field name from the
following table structure.
|
Symbol No. |
Name |
Marks |
|
00100200Q |
Surya Gurung |
85 |
|
00100201R |
Birendra Sharma |
91 |
5. Write the output
of the given program: Show with dry run in
table. 2
DECLARE
FUNCTION OUTPUT1(A)
CLS
N=135
CALL
OUTPUT1(N)
END
SUB
OUTPUT1(A)
DO
WHILE A < > 0
R
= A MOD 10
T
= T + R
A
= A \ 10
LOOP
PRINT
T
END
SUB
6. Re-Write the given program after correcting
the bug: 2
REM
to add record in an existing file
CLS
OPEN
“Record.Dat” FOR OUTPUT AS #1
AA:
INPUT
“Enter Name, Class and Roll No.”; Nm$, Cl, Rn
INPUT
#2, Nm$, Cl, Rn
INPUT
“More records”; Y$
IF
UCASE$(Y$)=”Y” THEN GOT aa
CLOSE
“Record.dat”
END
7. Study the
following program and answer the given questions: 2×1=2
DECLARE
FUNCTION TEST(X)
X=100
Z=TEST(X)
PRINT Z
END
FUNCTION
TEST(X)
FOR R=1 TO X
S=S+I
NEXT R
TEST=S
END FUNCTION
a)
How many parameters are used in the above program?
b)
How many times does the statement S=S+I execute in the above program?
8.
Convert/Calculate as per the instruction: 4×1=4
i) (11001101)2 = (?)16 ii) (524)10 = (?)2
iii) (1010)2 ×(110)2 –
(1011)2 = (?)2 iv)
(10110)2 ÷ (101)2
9 a) a. Write a program in QBASIC that asks
length, breadth and height of room and calculate its area and volume. Create a
user defined function to calculate area and sub-program to calculate volume.
Hint: [A=L×B], [V=L×B×H] 4
b) Write a program to create a
sequential data file “salary.dat” to store programmer’s name, salary and post
according to the need of the user. 4
10. Write a program in C language to input a number then check
whether the number is fully divisible by 5 or not 4
OR
Write a program in C
language to display first 10 odd numbers.
Best of Luck
SEE COMPUTER
SCIENCE 2080 MODEL SET 5
Full Marks: 50
Time: 2 hrs.
Candidates are required to write their answers
according to the instructions given.
Attempt all questions.
(Group 'A' 10×1=10)
1. Answer the following questions in one sentence: 6×1=6
a)
Write any two popular search engines
b)
What
is social media?
c)
Which
query is used to view the data stored in database?
d)
Name any two data types that can be defined in MS-ACCESS.
e) Write
down one difference between function and sub procedure.
f)
Write any two advantages of Structured programming.
2. Write appropriate technical term for the following:
2×1=2
a)
Crimes
committed using electronic devices and cyber space.
b)
A
program that can disinfect a file from virus.
3. Write the full form of the following: 2×1=2
a.
STP: b. WAP:
(Group 'B')
4. Answer the following questions: 9×2=18
a)
Give two-two difference between peer-to-peer and client/server
network architecture.
b)
List any two main aims of formulating cyber law in Nepal.
c)
Write any two symptoms of computer
virus.
d)
Write any two advantages and disadvantages of e-commerce.
e)
List any two-two advantages and
disadvantages of cloud computing.
f) What is table? Write any two importance of it.
g) What is data redundancy? How can it be reduced in database?
h)
While designing table structure which data types are suitable to
store information about teacher’s name, address, salary, and date of birth.
i)
Differentiate between select query and action query.
5. Write
the output of the given program: Show with dry run in table. 2
DECLARE
SUB SHOW(A)
CLS
N=87
CALL
SHOW(N)
END
SUB
SHOW(A)
DO
B=A
MOD 6+3
IF
B MOD 4=0 THEN GOTO AA
PRINT
B;
AA:
A=A-10
LOOP
WHILE A>=50
END
SUB
6. Re-Write the given program after correcting
the bug: 2
REM
to create a new file
CLS
OPEN
“ABC.DAT” FOR INPUT AS #1
DO
INPUT “Enter Name, Roll No &
Total. “; N$, R, T
INPUT #1, N$, R, T
INPUT “Supply more records Y/N”;
C$
LOOP
WHILE UCASE(Y$)=”Y”
CLOSE
#1
END
7. Study the
following program and answer the given questions: 2×1=2
DECLARE FUNCTION prod (A,B)
CLS
INPUT “Enter first number'; A
INPUT ‘Enter second number"; B
PRINT ‘“The product of the two number="; prod
(A,B)
END
FUNCTION prod (A,B)
P=A*B
prod=P
END FUNCTION
a)
List all the numerical variables used in the program
above.
b)
List the local variables used in program
above.
8.
Convert/Calculate as per the instruction: 4×1=4
a)
(ABC)16 = (?)8
b) (52)10 = (?)2
c)
(1010)2 + (110)2 – (1111)2 = (?)2 d) (1101101)2 ¸ (110)2
9 a) Write a
program in QBASIC that asks radius of a circle and calculate its Total Surface
Area and Volume
of sphere. Create a
user - defined function to calculate volume of sphere and sub procedure to
calculate Total Surface Area. [TSA=4pr2,
Volume= ]
b) A sequential data file called “Record.txt” has stored
data under the field heading Roll No., Name, Gender, English, Nepali, Maths and
Computer. Write a program to display all the information of those students
whose gender is “F” and obtained marks in computer is more than 90. 4
10. Write C program to find average number of any two numbers. 4
OR
Write a
program in C language to display first 15 even numbers.
Best of Luck
