SEE COMPUTER SCIENCE MODEL SET 1 to 5 COLLECTIONS 2080

 

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)₂ – (?)₁₆                                            b) (410)₁₀ = (?)₂

c) (1001 + 110)₂ – (1000)₂                                      d) (10110)₂ / (101)₂

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=pr²], [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 10^th 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 20^th 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)₂ = (?)₁₆                                                 i) (245)₁₀ = (?)₂

iii) (1010) ₂ x (101) ₂ =(?)₂                        iv) (101110) ₂ / (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 10^th 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)₂ = (?)₁₆                                      ii) (524)₁₀ = (?)₂

iii) (1010)₂ ×(110)₂ – (1011)₂ = (?)₂                    iv) (10110)₂ ÷ (101)₂

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)₁₆ = (?)₈                                       b) (52)₁₀ = (?)₂

c) (1010)₂ + (110)₂ – (1111)₂ = (?)₂           d) (1101101)₂ ¸ (110)₂

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=4pr², 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