SOLVED SEE (Grade Promotion) 2079 (2023) ऐच्छिक द्वितीय कम्प्युटर विज्ञान

 

SEE (Grade Promotion) 2079 (2023)

ऐच्छिक द्वितीय कम्प्युटर विज्ञान

समय: १ घण्टा ३० मिनेट

पूर्णाङ्क : ५०

 

दिइएका निर्देशनका आधारमा आफ्नै शैलीमा सिर्जनात्मक उत्तर दिनुहोस् :

समूह 'क' (Group 'A')

१. तलका प्रश्नहरूको एक वाक्यमा उत्तर दिनुहोस् :

Answer the following questions in one sentence:   (६×१=६)

(क) वेब ब्राउजर भनेको के हो ?

What is web browser?

Ans: A web browser is an application software used to display web pages.

 

(ख) इन्टरनेटद्वारा प्रदान गरिने कुनै दुई सेवाहरू उल्लेख गर्नुहोस् ।

Mention any two services provided by Internet.

Ans: Any two services provided by Internet are E-Commerce and E-Mail

 

(ग) एम्. एस्. एक्सेस को फिल्डनेमको अधिकतम साइज कति हो ?

What is the maximum length of field name in MS-Access?

Ans: The maximum length of field name in MS-Access 64.

 

(घ) एम एस् एक्सेसको लजिकल डेटा कुन हो?

Which in the logical data type of MS-Access?

Ans: The logical data type of MS-Access is Yes/No.

 

(ङ) मोड्युलर प्रोग्रामिङ्को कुनै एक फाइदा लेख्नुहोस् ।

Write any one advantage of Modular Programming.

Ans: Any one advantage of Modular Programming is it is easy to design, code and test the program modules independently.

 

(च) C प्रोग्रामिङ भाषाको कुनै दुई आधारभूत डाटा प्रकारहरू उल्लेख गर्नुहोस् ।

Mention any two basic data types of C language.

Ans: Any two basic data types of C language are char and int

 

उपयुक्त प्राविधिक शब्द लेख्नुहोस् : Write appropriate technical term for the following: (२×१=२)

 

(क) सञ्जालहरूको सञ्जाल

Network of networks .

Internet

(ख) कम्प्युटर प्रोग्राम जसले कम्प्युटर भाइरसबाट कम्प्युटरलाई बचाउँछ ।

Computer program that protects computer from computer virus.

Antivirus Software

 

पूरा रूप लेख्नुहोस् :

Write the full form of the following. (२×१=२)

(क) POP – Post Office Protocol

(ख) IoT – Internet of Things

 

समूह 'ख' (Group 'B')

 

४. तलका प्रश्नहरूको उत्तर दिनुहोस् : Answer the following questions: (९×२=१८)

 

(क) कम्प्युटर नेटर्वक भनेको के हो ? यसका कुनै दुईओटा महत्त्वहरू सूचीकृत गर्नुहोस् ।

What is computer network? List any two importance of it.

Ans: A computer network means two or more computers connected with each other to share data, hardware, software and other resources.

Any two importance of computer network are:

·       Data in a network environment can be updated from any computer.

·       Information can be exchanged rapidly in computer network.

 

(ख) कम्प्युटर नैतिकता भनेको के हो ? यसका कुनै दुई नीतिहरू लेख्नुहोस् ।

What is computer ethics? Write down any two ethics of it.

Ans: Computer ethics can be defined as to follow the rules and regulation of computer technology and not to harm other computer users knowingly or unknowingly.

 

Any two computer ethics are:

a)     We should not use a computer to harm other people.

b)     We should not spread false and illegal information.

 

(ग) कम्प्युटरको सुरक्षा भन्नाले के बुझिन्छ लेख्नुहोस् । ? हार्डवेयर

What is computer security? Write any two hardware security measures.

Ans: The protection of computer systems and information from harm, theft, and unauthorized use is called computer security.

Any two hardware security measures are Insurance and Power Protection Device.

 

(घ) E-commerce र Traditional Commerce बिच दुई भिन्नता दिनुहोस् ।

Give two differences between E-commerce and Traditional Commerce.

Two differences between E-commerce and Traditional Commerce are

Traditional Commerce	E-commerce
Traditional Commerce comprises to be a branch of trade, which concentrates on the exchange of goods and services.	E-commerce means executing the transactions or exchange of data, on the internet.
delivery of goods is instant.	delivery of goods takes time.

 

(ङ) आर्टिफिसियल इन्टेलिजेन्स (AI) को परिभाषा लेख्नुहोस् । AI को कुनै दुईओटा प्रयोगहरू लेख्नुहोस् ।

Define artificial intelligence (AI). Write any two uses of AI.

Ans: Artificial intelligence (AI) is an area of computer science that emphasizes the creation of intelligent machines that work and reacts like humans.

Any two uses of AI are

·       AI can be used to detect fraud in financial transactions, such as credit card fraud.

·       AI can be used to diagnose diseases more accurately and efficiently than humans can.

 

(च) डिबिएम्एस्लाई कुनै दुई उदाहरणसहित परिभाषित गर्नुहोस् ।

Define DBMS with any two examples.

Ans: DBMS is a software which helps to extract, view and manipulate data in an organized way.

E.g.: MS-Access, Oracle.

 

 

 

 

(छ) एम्. एस्. एक्सेसमा रिपोर्ट भनेको के हो ? डेटाबेसमा रिपोर्टको महत्त्व लेख्नुहोस् ।

What is report in MS-Access? Mention the importance of report in database.

Ans: Report is an object of Ms-Access which displays the output in an effective way to present the data in a printed format.

Importance of report is to print documents according to user’s specifications of the summarized information through query or table.

 

(ज) प्राइमरी कि को परिभाषा लेख्नुहोस् । यसको विशेषताहरु लेख्नुहोस् ।

Define Primary Key. Write its features.

Ans: A key that uniquely identifies each record in a database is called primary key.

Its features are:

i) To reduce and control duplication of record in a table.
ii) To set the relationship between tables.

 

 

(झ) निम्न तालिका संरचनामा प्रयोग भएको field name and records उल्लेख गर्नुहोस् : List the field name and records used in the following table structure.

Symbol_No	Name	Marks
001009010	Hari Thapa	85
00100901Q	Binu Sharma	91

Ans:

Field Names = Symbol_No, Name and Marks

Record = 00100900P   Hari Thapa  85   and    00100901Q   Binu Sharma   91

 

५. तलका प्रोग्रामको आउटपुट लेख्नुहोस् । Dry run table मा देखाउनुहोस् :                                                २

Write down the output of the given program. Show in dry run table.

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$

ENF SUB

Dry Run

C$	C=1 To LEN(C$) STEP 2	MS=MID$(C$,C,1)	N$=N$+M$	PRINT N$
COMPUTER	1 to 8 step 2	MID$(COMPUTER,1,1) =C	C
	3 to 8 step 2	MID$(COMPUTER,3,1) =M	C+M=CM
	5 to 8	MID$(COMPUTER,5,1) =U	CM+U=CMU
	7 to 8	MID$(COMPUTER,7,1) =E	CMU+E=CMUE
	9 to 8 Loop exits			CMUE

 

Output

CMUE

तल दिइएको प्रोग्राममा रहेका गल्तीहरूलाई सच्याएर पुनः लेख्नुहोस् :

Rewrite the given program after correcting the bugs:

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

 

Debugged Program

REM to display records from existing file.

OPEN "emp.txt" FOR INPUT AS #1

WHILE NOT EOF (1)

INPUT # 1, eN$, posts, salary$

PRINT eN$, post$, salary

WEND

CLOSE #1

END

 

तल दिइएको प्रोग्रामलाई अध्ययन गरी दिइएका प्रश्नहरूको उत्तर दिनुहोस् : (२×१=२)

Study the following program and answer the given questions.

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

 

(क) माथिको प्रोग्राममा प्रयोग भएको न्युमेरिक भेरिएबलहरू लेख्नुहोस् ।

List all the numerical variables used in the program above.

Ans: The numerical variables used in the program above are A, B and P

 

ख) माथिको प्रोग्राममा प्रयोग भएको लोकल भेरिएवलहरू लेख्नुहोस् ।

List the local variables used in   program above.

Ans: The local variables used in the program above are A, B and P

 

समूह 'ग' (Group 'C')

८. निर्देशनअनुसार रूपान्तर र हिसाब गर्नुहोस् :

Convert/Calculate as per the instruction:

i) (214) 10 = (?)2

iii) (1011)2×(101) 2

ii) (ABC) 16 = (?)2

iv) (10101)2 + (11)2

 

 

९. तलका प्रश्नहरूको उत्तर लेख्नुहोस् :

Answer the following questions: (४x२=८)

(क) कुनै एउटा कक्षाकोठाको लम्बाई र चौडाई दिएर उक्त कोठाको क्षेत्रफल र परिधि पत्ता लगाउने Q-BASIC प्रोगाम प्रयोग गरि लेख्नुहोस । क्षेत्रफल गणना गर्न user- defined FUNCTION र परिधि गणना गर्न SUB procedure प्रयोग गरि बनाउनुहोस ।

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)]

 

DECLARE FUNCTION AREA(L,B)

DECLARE SUB PER(L,B)

CLS

INPUT “ENTER LENGTH”; L

INPUT “ENTER BREADTH”; B

PRINT “AREA OF A ROOM=”; AREA(L,B)

CALL PER(L,B)

END

 

FUNCTION AREA(L,B)

AREA=L*B

END FUNCTION

 

SUB AREA(L,B)

P=2*(L+B)

PRINT “PERIMETER OF RECTANGLE=”; P

END SUB

 

(ख) “STUDENT.DAT” file मा विद्यार्थीहरूको नाम, कक्षा, सेक्सन र ठेगाना भण्डारण गरिएको छ । विद्यार्थीहरूको नाम, कक्षा, सेक्सन र ठेगाना प्रिन्ट गर्ने प्रोग्राम लेख्नुहोस् ।

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.

 

OPEN “STUDENT.DAT” FOR INPUT AS #1

CLS

WHILE NOT EOF(1)

INPUT #1, N$, C, S$, A$

PRINT N$, C, S$, A$

WEND

CLOSE #1

END

 

१०. C ल्याङ्ग्वेजको प्रयोग गरेर प्रयोगकर्ताबाट कुनै दुईवटा नम्बरहरु मागेर र सो नम्बहरुको

औषत निकाल्ने प्रोग्राम लेख्नुहोस् । Write C program to find average number of any two numbers. (४)

 

#include <stdio.h>

int main()

{

    int num1, num2;

    float avg;

    printf("Enter first number: ");

    scanf("%d",&num1);

    printf("Enter second number: ");

    scanf("%d",&num2);

    avg= (num1+num2)/2;

    printf("Average of two number is: %f",avg);

    return 0;

}

 

वा (OR)

 

C-language को प्रयोग गरी दिइएको अनुक्रम देखाउने (२, ४, ६, ८.१० औं पद) प्रोग्राम लेख्नुहोस् ।

Write a program in C-language to display the series 2, 4, 6, 8 up to the 10th term.

 

#include<stdio.h>

void main( )

{

int i,a=2;

for(i=1;i<=10;i++)

{

printf(“%d”, a);

a=a+2;

}

}

The END