SEE Computer Science Sample Question - 2076

[GROUP: ‘A’] COMPUTER FUNDAMENTAL – 22 MARKS 1. Answer the following questions: [5x2=10] a. Define LAN topology. Write any two advantage of linear topology. b. Why is the cyber law necessary in Nepal? c. What is Internet and E-mail? d. List any four reasons for creating computer virus. e. What is hardware security? Write any two methods to protect the computer Software. 2. Perform the following calculation.[4x1=4] a. (1101X11)2+110112 b. (100101/110)2 c. (4AB)16=(?)2 d. (426)8=(?)10 3. Match the following: [4x0.5=2] a. UTP i) Multimedia b. Microphone ii) Internet c. WAN iii) Protocol d. TCP/IP iv) Repeater v) Communication media 4. Write the technical term of the following: [4x0.5=2] a. The device used to connect PC with telephone line. b. A process that rearranges fragmented files. c. The artificial environment which is created using the computer hardware and software that present information as real. d. The set of moral values to be followed by computer user. 5. Write the full form: [4x0.5=2] a. ARPA b. Wifi c. ISDN d. SMTP 6. State whether the following statements are true or false:[4x0.5=2] a. A simplex device can transmit data in both directions at a time. b. The dust particles can damage hard disk of a computer. c. Computer viruses are created to stop the software piracy. d. Animation is the moving images of artwork. [GROUP: ‘B’] DATABASE – 10 MARKS 7. Answer the following questions:[3X2=6] a. What is DBMS? Explain with examples. b. What is query? List any two uses of queries. c. What is report? Write any two importance of report. 8. Match the following: [4X0.5=2] a. Yes/No i. Field property b. Form ii. Data type c. Report iii. Boolean Data Type d. Caption iv. Object v. Final output 9. Select the correct answer. [4X0.5=2] a. Field name can be upto ……. Characters long. i. 64 ii. 16 iii. 128 iv. 40 b. Which is the default field size of auto number data type? i. Integer ii. byte iii. Long integer iv. Double c. The filed size of logical data type is…….. i. 1 byte ii. 1 bit iii. 2 bytes iv. 2 bits d. Which of the following in not database. i. Phone Diary ii. Mark ledger iii. Dictionary iv. Report Card [GROUP C] PROGRAMMING – 18 MARKS 10. a. What is modular program? [1] b. Write any two features of C Language? [1] c. Write the functions of EOF and KILL statement. [1] 11. Rewrite the given program after correcting the bugs: [2] DECLARE SUB GREATEST (A,B) Rem to print sum of two numbers INPUT “ENTER FIRST TWO NUMBERS”; A,B CALL LARGEST (A,B) END FUNCTION LARGEST (A,B) IF A>B THEN DISPLAY A ELSE PRINT B END SUM 12. Write the output of the following program. [2] DECLARE FUNCTION TEST(X,Y) CLS LET X=10 LET Y=4 T=TEST(X,Y) PRINT T END FUNCTION TEST (X,Y) FOR P= X TO Y STEP -2 X=X*Y NEXT P TEST=X+Y END FUNCTION 13. Read the following program and answer the given questions: [2] DECLARE SUB EXAM(N$) CLS INPUT “Enter word”;WO$ CALL EXAM(WO$) END SUB EXAM(N$) FOR I=1 TO LEN(N$) PRINT RIGHT$(N$,I) NEXT I END SUB List down two built-in functions used in above program. List the real and formal parameter used in above program. 14. a. Write a program using SUB…END SUB to display whether the number is negative, positive or zero. [ 3] b. Write a program to find the reverse of the string using FUNCTION…END FUNCTION. [ 3] c. A sequential data file “result.dat” contains student symbol number, name and GPA. Write a program to display all the records of students whose GPA is more than 3.6. [ 3]