SLC Model Questions Set 4 (Solved)
Group A
Fundamental [22 marks]
1. Answer
the following questions: |5x2=10|
a. What
do you mean by communication media? Write any two examples of guided media.
Ans: `Communication
media is an electronic path used to transmit data from one device to another
device. Any two examples of guided media are twisted pair and coaxial cable.
b. Define
e-mail. List out any two importance of e-mail.
Ans: E-mail is an
electronic method of sending and receiving message. Any two importance of email
are:
i) It is cheaper, faster and free of
cost.
ii) An e-mail can be send to number of
person to any part of the world any time.
c. Write
any two positive and any two negative impact of computer in our society.
Ans:
Any two positive impact of computer in our society are:
i) Computer is extensively used in
education field to teach students in an efficient way.
ii) Communication is cheaper, faster and
reliable
Any two negative impact of computer in our
society are:
i) Cyber crime increasing day by day,
because people using computer for criminal activity.
ii) Unemployment increasing, because
computer can do work of many people.
d. What
is computer virus? Give any two symptoms of computer virus.
Ans:
Virus is a destructive computer program that can make lot of damages to
computer hardware and software if succeed to infect computer system. Any two
symptoms of computer virus are:
i) Computer take longer time to boot.
ii) Appearance of unknown file and
messages.
e. What
is Backup? Write the importance of backup system.
Ans: Backup is a
method of making duplicate copy of file which can be used in the event of data
loss or corrupt due to intentional or accidental reason. The importance of
backup system is to use extra copy in case if original file is lost or damaged.
2.a.
Convert as instructed: |2x1=2|
i) (450)10 into Binary
Answer:
Hence, (450)10 =
(111000010)2
ii) (111101)2 into Octal
Answer: Binary digits in 3 bits group –
111 101
Equivalent octal digits – 7
5
Hence, (111101)2 = (75)8
b. Perform binary calculations:
i) 10111 x 110
Solution:
10111
x110
00000
10111
10111
.
10001010
Hence, 10111
x 110 = 10001010
ii) 101101 ¸ 101
Solution:
Hence,
Quotient = 1001 and Remainder = 0
3. Match
the following pairs: |4x0.5=2|
a)
Cyber ethics i) graphics, text, sound
b)
Virus
ii) main computer
c)
Server iii)
moral principle
d)
Multimedia iv)
damage data
v) Internet
Answer:
a)
Cyber ethics i) moral principle
b)
Virus ii) damage data
c)
Server iii)
main computer
d)
Multimedia iv)
graphics, text, sound
4. State
whether the following statements are True or False: |4x0.5=2|
a) MAN
connects two or more LAN together.
Ans: True
b) Dialup
connection is the easiest way to connect a computer to the internet.
Ans: False
c) Cyber
space is a virtual space used in ICT.
Ans: True
d) I
Love You is a kind of antivirus used in ICT.
Ans:
False
5. Give
the suitable technical terms of the followings: |4x0.5=2|
a) Doing
business through online.
Ans: E-commerce
b) The
secret word, phrase that gives user access to a particular program.
Ans: Password
c) The
computer that acts the central authority on a network.
Ans: Server Computer
d) Intentionally,
gaining unauthorized access to an information system.
Ans: Hacking
6. Give
the full form of the followings: |4x0.5=2|
a) FTP– File Transfer Protocol
b) Wi-Fi - Wireless Fidelity
c) CPAV- Central Point Antivirus
d) ISP= Internet Service Provider
Group B
Database Management System (10 marks)
6. Answer
the following questions: |3x2=6|
a) Define field and record with example.
Ans: Field
is a column in a table that store data item for a record. Example : Name,
Address, Salary etc.
Record is a set of related field of
information about an entity. Example: Name- Ram, Address – Nijgadh-7,
Salary-7000 etc
b) What is table? Write its importance in
database creation.
Ans:
Table is an important object in database that contains data in the form of rows
and column,
The importance of table in database is
that it is basic building block for database from which information can be
retrieved using appropriate program.
c) What is primary key? Write the use of
primary key.
Ans: Primary key
is a set of attributes that uniquely identify the records in the table.
The use of primary key is that it
doesn't allow null or duplicate value in the field as used in creating
relationship between multiple tables.
8. State
whether the following statements are True or False: |4x0.5=2|
e) The
extension of MS-Access is .dbf.
Ans: False
f) In
query calculation also can be done.
Ans: True
g) We
cannot insert picture in database.
Ans: False
h) With
the help of wizard also we can create a form.
Ans:
True
9. Match
the following groups: |4x0.5=2|
Group A Group
B
i.
Currency field a
) 1 GB
ii.
YES/No field b
) 255 characters
iii.
OLE field c ) 1 bit
iv.
Text field
d) 1 MB
e ) 8 bytes
Answer:
Group A Group
B
i.
Currency field a
) 8 bytes
ii.
YES/No field b
) 1 bit
iii.
OLE field
c ) 1 GB
iv.
Text field
d) 255 characters
Group C
QBASIC Programming (18 marks)
10.a) Define
user defined function |1|
Ans: User define
function is a block of statement declared by the user to perform a specific
type of task.
b) Why
is C called middle level language? |1|
Ans: C is called
middle level language because programmer can write the program in both low
level language and high level language.
11. Write
down the function of INPUT and PRINT statements. |1|
Ans: The function are as follow:
INPUT : To accept value from the
users.
PRINT
: To display final output on the screen.
12. Debug
the following program. |2|
REM to input any five no and display
the sum of entered no.
CLS
DECLARE FUNCTION sum(n())
DIM n(5)
FOR x = 1 to 5
ENTER "Input no = ";n(x)
NEXT x
su = sum(n())
print "Sum=";sum
END
FUNCTION sum(n())
s = 0
FOR x = 1 to 5
s = s + n(x)
NEXT x
s = sum
END FUNCTION
Ans:
After debugging the program.
REM to input any five no and display
the sum of entered no.
CLS
DECLARE FUNCTION sum(n())
DIM n(5)
FOR x = 1 to 5
INPUT "Input no = ";n(x)
NEXT x
su = sum(n())
PRINT "Sum=";su
END
FUNCTION sum(n())
s = 0
FOR x = 1 to 5
s = s + n(x)
NEXT x
sum = s
END FUNCTION
13. Write
the output of the given program. |2|
DECLARE SUB res(st$)
CLS
DATA 4, 6, 11, 1, 3, 7, 5, 13
CALL res(st$)
END
SUB res(st$)
st$ = "BOOKREADKEYED"
FOR x = 1 to 8
READ n
PRINT MID$(st$, n, 1)
NEXT x
END SUB
Ans: OUTPUT
–
14. Read
the following program and answer the following questions: |2|
DECLARE SUB res(a$)
CLS
a$ = "KATHMANDU"
CALL res(a$)
END
SUB res(a$)
L = LEN(a$)
FOR x = L to 1 STEP -2
PRINT MID$(a$, x, 1);
NEXT x
END SUB
a.
What will be the value of L in the second
loop if a$ = "POKHARA"?
Ans: The value of L in the second loop
will be 5.
b.
What happen if we remove the statement
line "CALL res(a$)" ?
Ans: If we remove the statement line
"CALL res(a$)" then the program cannot invoke sub module and generate
error message.
15.a. Write a
program to check whether entered number is perfect cube or not using SUB …… END
SUB statement.|3|
DECLARE SUB pcube(N)
CLS
INPUT "ENTER ANY NUMBER";N
CALL pcube(N)
END
SUB pcube(N)
P = N^(1/3)
IF P = INT(P) THEN
PRINT "NUMBER
IS PERFECT CUBE"
ELSE
PRINT "NUMBER
IS NOT PERFECT CUBE"
END IF
END SUB
b. Using FUNCTION …… END FUNCTION. Write a
program to convert given Nepali currency into US dollar. [Hints 1US$ = 98 NC] |3|
DECLARE FUNCTION convert(NC)
CLS
INPUT "ENTER NEPALI
CURRENCY";NC
PRINT "EQUIVALENT US DOLLAR =
"; convert(NC)
END
FUNCTION convert(NC)
USD = NC / 98
convert = USD
END FUNCTION
c. A sequential data file named
"STUDENT.DAT" contains name, class, roll no and address of the
students. Write a program to display all the students' records whose name
starts from the alphabet "B" or "b". |3|
OPEN "STUDENT.DAT" FOR
INPUT AS#1
PRINT "NAME",
"CLASS", "ROLL NO.", "ADDRESS"
DO WHILE NOT EOF(1)
INPUT #1, N$, C, R, ADD$
IF UCASE$(LEFT$(N$,1))="B"
THEN
PRINT N$, C, R, ADD$
END IF
LOOP
CLOSE #1
END
**********************
