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
