SEDIPS SEE EFFICIENCY TEST 2079 [COMPUTER SCIENCE]
Group-A
(Very Short Questions-10 Marks)
1)
Answer the following questions:
a) Define Bandwidth.
Ans: Bandwidth can be defined as
the maximum volume of data that can be transmitted through a communication
system.
b) What is digital citizenship?
Ans: Digital citizenship refers
to the responsible use of technology by anyone who uses computer,
the Internet and digital devices
to engage with the society on any level.
c) Name any to modes of
Electronic Payments.
Ans: Any two modes of electronic
payments are:
i) Debit Card
ii) E wallet
d) Define relationship.
Ans: Relationship is a link
between two tables that defines how they are related to each other by a common
field.
e) What do you mean by modular
programming?
Ans: Modular Programming is a
technique used to divide a program into many small, manageable, logical and
functional modules or blocks.
f) Write any two data types used
in C language.
Ans: Any two data types used in C
language are:
i) int
ii) char
2)
Give the appropriate technical terms of the following:
a) Hacking done with permission
from the client. Ethical Hacking
b) The process of identifying an
individual usually based on a username and password. Authentication
3)
Write the full forms for the following:
SMTP- Simple Mail Transfer
Protocol
VRML- Virtual Reality Modeling
Language
Group-B
(Short Questions-24 Marks)
4)
Answer the following questions:
a) Define data communication. Write
its components.
Ans: Data communication is the
process of transferring data electronically from one place to other using
different transmission mediums.
Its components are:
i) Data
ii) Sender
iii) Medium
iv) Receiver
v) Protocol
b) Write any two Opportunities
and Threats in Social Media.
Ans: Any two Opportunities in
Social Media are:
i) It is very fast way of
exchanging the information.
ii) Communication mechanism is
very simple and easy.
Threats in Social Media are:
i) More chances of creating fake
accounts.
ii) Create health problems.
c) What is software security?
List any two security mechanism of Computer Hardware Security.
Ans: The security given to the
software and data from being lost or damaged due to accidental or intentional
harm is called software security.
Any two security mechanism of
Computer Hardware Security are:
i) Insurance
ii) Regular maintenance
d) Define M-commerce. Write any
four examples of M-Commerce.
Ans: M-Commerce is the process of
buying and selling goods and services through the internet using wireless
handheld devices such as mobile phones, tablets and Personal Digital
Assistant(PDAs).
Any four examples of M-Commerce
are:
i) Book movie tickets
ii) Make railway reservations
iii) Order books
iv) Access email
e) What do you mean by Iot? List
its any two advantages.
Ans: IoT is a technology that
connects all electronic devices together and prompts them to exchange
information without any human intervention.
Its two advantages are:
i) Accessing information is easy.
ii) Communication between the
connected devices becomes more transparent and easier.
f) What is DBMS. Write any two
advantages of DBMS.
Ans: DBMS is a computerized
system that stores data, processes them and provide information in an organized
form.
Any two advantages of DBMS are:
i) It helps to reduce data
redundancy which means duplication of data.
ii) It can store large volume of
data.
g) Define the term Validation
Rule and Validation Text.
Ans: A field property which
enables to limit values that can be accepted into a field is known as validation
rule.
A field property which allows
type text to be displayed if the user input value is prohibited by the
validation rule is known as validation text.
h) Differentiate between select
query and update query.
|
Select Query |
Update Query |
|
- A select query
is the most common category which is used to extract specific information
from one or more tables in a database. - The Select
query is used to select data from a database. |
- Update query is
a type of action query which makes global changes to a group of records in
one or more tables. - The Update
query is used to update existing records in a table. |
i)Define Data types. List any
four names of the data types.
Ans: Data type is an attribute
for a field that determines what type of data it can contain.
Any four names of data types are:
i) Text
ii) Number
iii) Memo
iv) Currency
FIND
OUTPUT ALONG WITH DRY RUN
DECLARE SUB SERIES ( )
CLS
CALL SERIES
END
SUB SERIES
A$="NEPAL"
B=1
FOR I=1 TO LEN(A$) STEP 2
IF B < > 3 THEN
PRINT MID$(A$,B,I)
ELSE
PRINT MID$(A$,1,I)
END IF
B=B+1
NEXT I
END SUB
DRY
RUN
|
VAR. |
VAR. |
VAR. |
LOOP CHECK |
CONDITION CHECK |
O/P |
|
A$ |
B |
I |
1 TO 5 STEP 2 |
B< > 3 |
|
|
NEPAL |
1 |
1 |
1 TO 5 YES |
1 < > 3 YES |
N |
|
|
2 |
3 |
3 TO 5 YES |
2 < > 3 YES |
EPA |
|
|
3 |
5 |
5 TO 5 YES |
3 < > 3 NO |
NEPAL |
|
|
4 |
7 |
7 TO 5 NO LOOP EXITS |
|
|
OUTPUT
N
EPA
NEPAL
Debug
DECLARE FUNCTION vowel(S$)
w$=we love our country
v=vowel(w$)
PRINT "The total no. of
vowel::"; v
END
FUNCTION vowel$(S$)
c=0
FOR K=1 TO length(S$)
B$=MID$(S$, K, 1)
B$=LCASE$(B$)
SELECT CASE B$
CASE "a", "e",
"i", "o", "u"
c=c+1
END SELECT
NEXT K
C=vowel
END FUNCTION
Debugged
Program
DECLARE FUNCTION vowel(S$)
w$="we love our country"
v=vowel(w$)
PRINT "The total no. of
vowel::"; v
END
FUNCTION vowel(S$)
c=0
FOR K=1 TO LEN(S$)
B$=MID$(S$, K, 1)
B$=LCASE$(B$)
SELECT
CASE B$
CASE "a", "e",
"i", "o", "u"
c=c+1
END SELECT
NEXT K
vowel
= c
END FUNCTION
Analytical
Questions
OPEN “MARKINFO.TXT” FOR INPUT AS #1
OPEN “TEMP.TXT” FOR OUTPUT AS #2
CLS
DO UNTIL EOF(1)
INPUT #1, REGISTRATIONNUMBER,
STUDENTNAME$, ENGLISH, NEPALI, MATHEMATICS
IF MATHEMATICS<20 THEN
MATHEMATICS=MATHEMATICS+10
END IF
WRITE #2, REGISTRATIONNUMBER, STUDENTNAME$,
ENGLISH, NEPALI, MATHEMATICS
LOOP
CLOSE#1
CLOSE #2
KILL “MARKINFO.TXT”
NAME “TEMP.TXT” AS “MARKINFO.TXT”
END
a)
What is the main objective of the
program given above?
The main objective of the program
given above is to increase marks of math by 10 whose marks in math is less than
20.
b)
Do you get any problem in above program
if “Kill” statement is removed? Give reason.
Yes, there will be a problem in the
above program if the "KILL" statement is removed. If the
"KILL" statement is removed, the program will not be able to delete
the existing "MARKINFO.TXT" file.
8)
Calculate/Convert as per the instructions:
a)
(101010)2 × (101011)2-(100101)2
b) (1001011)2 ÷ (10101)2
c) (DEF42)16 =(?)8
c) (986)10 = (?)2
9. a)
Write a QBASIC program that asks length, breadth, height and calculate Volume
of Cuboid and Total Surface Area. Create a USER DEFINED FINCTION to calculate
Volume of Cuboid and SUB-PROGRAM to calculate Total Suface of Area.
DECLARE
FUNCTION VOL(L,B,H)
DECLARE
SUB TSA(L,B,H)
CLS
INPUT”Enter
length”;L
INPUT”Enter
breadth”;B
INPUT”Enter
height”;H
PRINT”Volume
of cuboid= “;VOL(L,B,H)
CALL
TSA(L,B,H)
END
FUNCTION VOL(L,B,H)
VOL=L*B*H
END
FUNCTION
SUB
TSA(L,B,H)
T=2*(L*B+B*H+L*H)
PRINT”Total
surface area of cuboid=”;T
END SUB
b) A sequential data file"records.dat"
contains S.NO., Name, Address, Telephone No and Email Address. WAP to count and
display those records whose email address ends in "yahoo.com" domain.
Your display should be in tabular format having the fields Name, Address and
Email address only.
OPEN "records.dat"
FOR INPUT AS #1
CLS
WHILE
NOT EOF(1)
INPUT #1,
SN, N$, A$, T, E$
IF LCASE$(RIGHT$(E$,9))="yahoo.com"
THEN
PRINT N$,A$,E$
C=C+1
WEND
PRINT
"TOTAL NO. OF HAVING YAHOO EMAIL ADDRESS ARE"; C
CLOSE #1
END
10. Write
a program in C language that asks a number check whether number is Positive,
Negative or zero.
#include<stdio.h>
int
main()
{
int n;
printf("Enter any number: ");
scanf("%d",&n);
if(n>0)
printf("The given number is
positive");
else
if(n<0)
printf("The given number is
negative");
else
printf("The given number is
zero");
return 0;
}
OR
Write a
program in C language to display the series with their sum 7, 10, 13, 16…… upto
10th term.
#include<stdio.h>
int
main()
{
int n=7,i,s=0;
for(i=1;i<=10;i++)
{
printf("%d ",n);
s=s+n;
n=n+3;
}
printf("\nsum= %d",s);
return 0;
}
