SEE MODEL SOLVED
SEE 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
674
views
|
Visitors reactions:
56%
HAPPY
5%
SAD
20%
AMAZED
6%
EXCITED
14%
Comments
Post a Comment