Computer for SEE and NEB

It is a complete SEE and NEB solution for computer science. It includes Computer Fundamentals, Database (SQL), Programming in C QBASIC, CSS, JavaScript, and PHP for beginners.

Breaking

Post Top Ad

Your Ad Spot

Monday, March 25, 2024

Grade 10 Computer Science Question Models with Solutions for SEE

Grade 10 Computer Science Question Models with Solutions for SEE





Subject: Opt. II (Computer Science)

Full Marks: 50                                                            Time: 2:00 hrs
Candidates are required to give their answers according to the instructions.

Attempt all the questions.

Group 'A' (10 Marks)

1. Answer the following questions in one sentence: [6×1=6]

a) What is data communication?

Ans: Data communication is the process of transferring data between two or more devices using a transmission medium such as wire or wireless.

 

b) What is computer virus?

Ans: A computer virus is malicious software that replicates and infects computers, causing harm.

 

c) Name two types of data file in Qbasic.

Ans: Twp data files in Qbasic are: i) Sequential data file ii) Random access file

 

d) What is primary key?

Ans: A primary key is a unique identifier for each record in a database table.

 

e) What is field?

Ans: A field is an individual piece of data or attribute in a database or record, like a name or phone number.

 

f) What is 'C' Language?

Ans: C language is a high-level programming language developed in the early 1970s, widely used for system and application development.

 

2. Write appropriate technical term for the following. 2×1=2

a) A network limited toterms a room or building.

Ans: LAN

 

b) Commercial transactions through mobile devices.

Ans: M-Commerce

 

3. Write the full form of the following: 2×1=2

a. UPS: Uninterruptible Power Supply

b. WWW: World Wide Web

 

4. Answer the following questions: 9×2=18

a. What is transmission media? Write its types.

Ans: Transmission media refers to the physical pathways that enable communication between devices. Following are the different types of transmission media.

i) Guided communication media. (Twisted pair cable, coaxial cable, fiber optic cable)

ii) Un-guided communication media. (radio waves, microwaves, Bluetooth etc.)


b. What is IoT? Write any two importance of it.

Ans: IoT, or Internet of Things, is a network of interconnected devices that collect and share data over the internet.

Following are the two importance of IoT:

i. Enhances everyday life with smart homes, healthcare monitoring, and personalized services, contributing to convenience and well-being.

ii. Enables real-time monitoring and control of devices and systems from remote locations, improving convenience and safety.

 

c. Write any four opportunities and threats in social media.

Ans: Opportunities of social media:

i. Build relationships, connect with like-minded people, and foster a sense of belonging.

ii. Reach a large audience, promote your business or ideas, and engage with customers.

iii. Share your creativity, learn new things, and discover diverse perspectives.

iv.  Mobilize people for a cause, raise awareness, and effect positive change.

Threats of social media:

i. Encountering false information that can be misleading or harmful.

ii. Sharing personal information online can lead to privacy breaches or stalking.

iii. Excessive use can lead to social isolation, anxiety, and depression.

iv.  Facing online abuse or negativity that can impact mental well-being.

 

d. What is E-commerce? Write its types.

Ans: E-commerce refers to buying and selling goods or services using the Internet.

Types of e-commerce include:

i) B2C (Business-to-Consumer)

ii) B2B (Business-to-Business)

iii) C2C (Consumer-to-Consumer)

iv) C2B (Consumer-to-Business)

 

e. What is information security? Write any two ways to protect data.

Ans: Information security is the practice of protecting electronic data from unauthorized access, use, disclosure, disruption, modification, or destruction.

Two ways to protect data include:

i) Use complex passwords and update them regularly.

ii) Keep software and systems updated to protect against vulnerabilities.

 

f. What is database? Write any two examples.

Ans: A database is a well-organized collection of data that is easy to access and manage.

Following are the four examples of DBMS:

i. MS-Access

ii. Oracal


g. What is table? Write the basic components of table.

Ans: Table is the object of database that stores data in rows and columns.

Following are the basic components of table:

i) Field

ii) Records

iii) Data types

iv) primary key

 

h) What is action query? Write its type.

Ans: An action query in a database is a type of query designed to perform operations that modify or manipulate the data in the database.

Following are the types of action query:

i) Delete query

ii) Append query

iii) Update query

iv) Make-table query

 

i) Define input mask and validation rule.

Ans:  Input mask: An input mask is a template that specifies the format in which data must be entered into a database field.

Validation rule: A validation rule is a criterion that limits the type or range of data that can be entered into a database table's fields.

 

5. Write the output of the given program. Show with dry run in table. 2

DECLARE SUB series ()

CLS

CALL series

END

 

SUB series

a=4

b=5

PRINT a

PRINT b

FOR i= 1 to 5

c=a+b

PRINT c

a=b

b=c

NEXT i

END SUB

 

Var. a

Var b

Print a,b

Loop check?

Var c

Print c

4

5

4   5

1 to 5? Yes

C=4+5=9

9

5

9

 

2 to 5? Yes

C=5+9=14

14

9

14

 

3 to 5? Yes

C=9+14=23

23

14

23

 

4 to 5? Yes

C=14+23=37

37

23

37

 

5 to 5? yes

C=23+37=60

60

37

60

 

6 to 5? No

Exit from loop

 

 

 The final output:

4

5

9

14

23

37

60

 

6. Re-write the given program after correcting the bug: 2

REM add some more records on a sequential data file "emp.dat"

CLS

OPEN "emp.dat" for INPUT AS #1

UP:

INPUT "Enter name";n$

INPUT "Enter Department";d$

INPUT "Enter post";p$

INPUT "Enter salary";sl

WRITE #2, n$,d$,p$,sl

INPUT "Do you want to add more records? (Y/N)"ans

IF UCASE$(ans$)="Y" THEN GOTO UP

CLOSE

END

 

Debugged program:

REM add some more records on a sequential data file "emp.dat"

CLS

OPEN "emp.dat" for APPEND AS #1

UP:

INPUT "Enter name";n$

INPUT "Enter Department";d$

INPUT "Enter post";p$

INPUT "Enter salary";sl

WRITE #1, n$,d$,p$,sl

INPUT "Do you want to add more records? (Y/N)"ans$

IF UCASE$(ans$)="Y" THEN GOTO UP

CLOSE #1

END

 

7. Study the following program and answer the given questions: 2×1=2

DECLARE FUNCTION test$ (a$)

CLS

a$="KATHMANDU"

b$=test$(a$)

PRINT b$

END

 

FUNCTION test$(a$)

FOR i= 1 TO LEN(a$)

d$=MID$(a$,I,1)

IF I MOD 2= 0 HEN

c$=c$+UCASE$(d$)

ELSE

c$=c$+LCASE$(d$)

ENDIF

test$=c$

END FUNCTION

a. What is the name of function procedure?

Ans: test$

b. List the different library function used in the program.

Ans:  LEN, MID$, LCASE$, UCASE$

 

8. Convert/Calculate as per the instructions: 4×1=4

i) (511)10 into binary                          ii) (756)10 into Hexadecimal number

iii) 1001×101-11                                 iv)  1001001÷11001

 

9.a) Write a program in Qbasic that ask the radius and height of a cylinder then calculate its volume and total surface area. Create a user define function VLM(r,h) to calculate volume and sub procedure TOTSA(r,h) to calculate total surface area of a hemisphere. [Hints: TSA=2Ï€r(r+h), V=Ï€r2h]    4

Ans:

DECLARE FUNCTION vlm (r, h)

DECLARE SUB tosta (r, h)

CLS

INPUT "Enter radius and height"; r, h

PRINT  "Volume: ";vlm(r, h)

CALL tosta(r, h)

END

 

SUB tosta (r, h)

v = 22 / 7 * r * r * h

PRINT " Surface area of a hemisphere";v

END SUB

 

FUNCTION vlm (r, h)

tsa = 2 * 22 / 7 * r * (r + h)

vlm = tsa

END FUNCTION

 

b) A sequential data file called "marks.dat" has stored data under the field heading students name, Eng, Nep, and Math. Write a program to display all the records whose marks is greater than 35 in all subjects.         4

Ans:

CLS

OPEN "marks.dat" FOR INPUT AS #1

DO WHILE NOT EOF(1)

INPUT #1, name$,eng,math,nep

IF eng>=35 AND math>=35 AND nep>=35 THEN PRINT name$,eng,math,nep

LOOP

CLOSE #1

END

 

 10. Write a program in C language to ask to enter a number then find out whether it is odd or even.        4

#include <stdio.h>

int main()

{

    int number;

    printf("Enter a number: ");

    scanf("%d", &number);

     if(number %2==0)

printf("even number");

            else

            printf("odd number");

        return 0;

}

OR

Write a C program to display the sum of the first 20 even numbers.      4

#include<stdio.h>

int main()

{

            int x,a=2;

            for(x=1;x<=20;x++)

            {

                        printf("%d\t",a);

                        a=a+2;

            }

            return 0;

}

 

 You may also read:


SEE Computer Science solved practice question model


No comments:

Post a Comment

Post Top Ad

Your Ad Spot

Pages