Friday, March 19, 2021

Solved Computer Science Supplementary Examination 2068

 


Solved Computer Science Supplementary Examination 2068
Group A
Computer Fundamental (22 marks)
1. Answer the following questions:a) Define Computer network.
Ans: A computer network means two or more than two computers connected to each other to share data, hardware, software and other resources.
b) What is E-mail? Give an example of valid E-mail I.D.
Ans: E-mail is one of the most popular service provided by the internet which is used to send and receive mail through the internet.
An example of valid E-mail I.D. is shr_ram01@gmail.com
c) Write any two advantages of multimedia in educational field.
Ans: Any two advantages of multimedia in educational field are:
·         It helps to present the information in more interactive and understandable way.
·         It makes studying much more interesting.

d) What is a computer hardware security?
Ans: The security given to various hardware tools and equipment from being lost or damaged due to accidental or intentional harm is known as computer hardware security. For e.g.: fire detector, protection from theft, etc.
e) What is a computer virus?
Ans: A type of computer program which is written by the programmer with the intent of damaging or destroying the data and programs residing in the computer system is known as computer virus.


 









































3. Match the following:   Group A       Group B
a) LAN                        i) Within a city
b) MAN           ii) Internet protocol
c) UPS             iii) Within a city
d) IPX/SPX      iv) Power supply device
                        v) Between countries
Ans:
Group A                      Group B
a) LAN                        -           Within a building
b) MAN           -           Within a city
c) UPS             -           Power supply device
d) IPX/SPX      -           Internet protocol
                        

4. Select the best answer:
a) Which of the following is not a guided data communication media?
i) Coaxial cable                        ii) Fiber optic               iii) twisted pair             iv) Satellite
Ans: Satellite
b) Process of arranging the scattered parts of file into a contiguous manner.
i) Backup                     ii) Defragmentation      iii) Debugging              iv) All of the above
Ans: Defragmentation
c) Which of the following is remote login service?
i) Video conferencing              ii) Telnet          iii) FTP             iv) TCP/IP
Ans: Telnet
d) Which of the following is an anti-virus program?
i) NAV             ii) Windows                 iii) Photoshop              iv) All of the above
Ans: NAV

5. Write the appropriate technical term:a) The data carrying capacity of communication channel.
Ans: Bandwidth
b) Hub or switch based network topology.
Ans: Star Topolgy
c) A computer virus that damages the documents created in MS-Word & MS-Excel.
Ans: Macro virus
d) The moral principles that control cyber-crime.
Ans: Cyber law

6. Write the full forms of:a) bps               - bits per second
ii) MAN           - Metropolitan Area Network
iii) FTP-           -File Transfer Protocol
iv) URL           -Uniform Resource Locator
Group B
Database (10 marks)
7. Answer the following questions:

a) What is database?
Ans: Database is a collection of related and organized information that is used to store, organize and extract data.
b) What data types are used to store salary and date of the birth?
Ans: The data types that are used for:
·         Salary – Currency
·         Date of birth – Date/Time

c) What is query?
Ans: Query is an object of MS-Access which allows selecting specific data from one or more tables.

8. Select the best answer:
a) The maximum size of text field in MS-Access is …………
i) 50                 ii) 10                iii) 6400                       iv) 255
Ans: 255
b) The default data type in MS-Access is ……..
i) Number        ii) Date/Time    iii) Memo         iv) Text
Ans: Text
c) Report can be generated by using data from …………
i) Table                        ii) Query          iii) Forms         iv) Both (i) &(ii)
Ans: Both (i) & (ii)
d) …………….. query changes value in main table.
i) Select                        ii) Update         iii) Both (i) &(ii)                      iv) None of the above
Ans: Update


9. Match the following:
Group A                      Group B
a) Indexing data                       i) Retrieves data conditionally
b) Long Text                ii) DBMS
c) Fox Pro                    iii) Memo field
d) Query                      iv) Searching fast
                                    v)Report
Ans:
Group A                                  Group Ba) Indexing data                       -           Searching fast
b) Long Text                -           Memo field
c) Fox Pro                    -           DBMS
d) Query                      -           Retrieves data conditionally
Group C
Programming (18 marks)
10. a) Mention the types of procedure.
Ans: The types of procedures are:
        i.            Function Procedure
      ii.            Sub Procedure

b) Write any one difference between Q-Basic and C language.
Ans: The difference between Q-Basic and C language are as follows:
Q-Basic
C language
It is mostly used to design application software.
It is mostly used to prepare system software.

c) 
Write the functions of the following:
i) KILL                        ii) RMDIR
Ans: The function of:
        i.            KILL: It deletes the file or files from the specified drive or directory.
      ii.            RMDIR: It removes or deletes only sub directory from a disk

11. Rewrite the following program after correcting the bugs.Rem to display the contents of a data file.
OPEN “Marks.dat” FOR OUTPUT AS #1
CLS
WHILE EOF(1)
            INPUT #1, Name$, Age, Add$
            DISPLAY Name$, Age, Add$
WEND
CLOSE 1
END
Ans:
Rem to display the contents of a data file.
OPEN “Marks.dat” FOR INPUT AS #1
CLS
WHILE NOTEOF(1)
            INPUT #1, Name$, Age, Add$
            PRINT Name$, Age, Add$
WEND
CLOSE #1
END


12. Write down the output of the following program:DECLARE FUNCTION area(L,B)
LET L=10
LET B=5
PRINT “The area=”; area(L,B) 
END

FUNCTION area(L,B)
            A=L*B
            area=A
END FUNCTION






13. Analyse the program and answer the following question:
DECLARE SUB ABC(X,Y,Z)
FOR P=1 TO 3
            READ A,B,C
CALL ABC(A,B,C)
NEXT P
DATA 5,4,3,2,1,6,7,8,4
END
SUB ABC(X,Y,Z)
            T=X+Y+Z
            IF T MOD 2 = 0 THEN
                        PRINT T
            END IF
END SUB
a)      List any two variables used in the above program.
Ans: Any two variables used in the above program are: A and B

b)      How many times SUB-procedure will be called when program is executed?
Ans: SUB-procedure will be called 3 times when the program is executed.

14.a) Write a program in QBASIC  to find the total surface area of a box using FUNCTION….END FUNCTION.
Ans:
DECLARE FUNCTION TSA(L,B,H)
CLS
INPUT “Enter length, breadth and height”; L,B,H
PRINT “The total surface area of box=”; TSA(L,B,H)
END

FUNCTION TSA(L,B,H)
T=2*(L*B+B*H+L*H)
TSA=T
END FUNCTION

b) Write a program to input three different numbers in the main module then find the greatest number using SUB….END SUB.
Ans:
DECLARE SUB GREAT(A,B,C)
CLS
INPUT “Enter any three numbers”; A,B,C
CALL GREAT(A,B,C)
END

SUB GREAT(A,B,C)
IF A>B AND A>C THEB
PRINT A;”is greatest number”
ELSEIF B>A AND B>C THEN
PRINT B;”is greatest number”
ELSE
PRINT C;”is greatest number”
END IF
END SUB

c) Write a program to view those records from “Employee.dat” sequential data file having employee’s name, department, appointment data and salary whose salary is more than Rs.5000.
Ans:
OPEN “EMPLOYEE.DAT” FOR INPUT AS #1
CLS
WHILE NOT EOF(1)
INPUT #1, N$, D$, AD$, S
IF S > 5000 THEN PRINT N$, D$, AD$, S
WEND
CLOSE #1
END
***

No comments:

Post a Comment