SLC SUPPLEMENTARY 2068 SOLVED


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

Comments

Post a Comment

Popular posts from this blog

PROGRAM TO FIND SQUARE, CUBE, SQUARE ROOT AND CUBE ROOT OF GIVEN NUMBER

7. Display square of an input number. REM PROGRAM TO DISPLAY SQUARE OF AN INPUT NUMBER CLS INPUT “ENTER ANY NUMBER”; N S = N ^ 2 PRINT “SQUARE OF NUMBER ”; S END USING SUB PROCEDURE DECLARE SUB SQUARE (N) CLS INPUT “ENTER ANY NUMBER”; N CALL SQUARE(N) END SUB SQUARE (N) S = N ^ 2 PRINT “SQUARE OF NUMBER “; S END SUB USING FUNCTION PROCEDURE DECLARE FUNCTION SQUARE (N) CLS INPUT “ENTER ANY NUMBER”; N S = SQUARE(N) PRINT “SQUARE OF NUMBER “; S END FUNCTION SQUARE (N) SQ= N ^ 2 SQUARE = SQ END FUNCTION 8. Display cube of an input number. REM PROGRAM TO DISPLAY CUBE OF AN INPUT NUMBER CLS INPUT “ENTER ANY NUMBER”; N C = N ^ 3 PRINT “CUBE OF NUMBER ”; C END USING SUB PROCEDURE DECLARE SUB CUBE (N) CLS INPUT “ENTER ANY NUMBER”; N CALL CUBE(N) END SUB CUBE (N) C = N ^ 3 PRINT “CUBE OF NUMBER “; C END SUB USING FUNCTION PROCEDURE DECLARE FUNCTION CUBE (N) CLS INP
Read more

PROGRAM TO DISPLAY SUM, PRODUCT, DIFFERENCE AND PRODUCT OF TWO / THREE NUMBERS

1. Enter any two numbers and display its sum. REM PROGRAM TO DISPLAY SUM OF TWO NUMBERS CLS INPUT “ENTER FIRST NUMBER”; A INPUT “ENTER SECOND NUMBER”; B S = A + B PRINT “SUM OF TWO NUMBERS”; S END USING SUB PROCEDURE DECLARE SUB SUM (A, B) CLS INPUT “ENTER FIRST NUMBER”; A INPUT “ENTER SECOND NUMBER”; B CALL SUM(A, B) END SUB SUM (A, B) S = A + B PRINT “SUM OF TWO NUMBERS”; S END SUB USING FUNCTION PROCEDURE DECLARE FUNCTION SUM (A, B) CLS INPUT “ENTER FIRST NUMBER”; A INPUT “ENTER SECOND NUMBER”; B S = SUM(A, B) PRINT “SUM OF TWO NUMBERS”; S END FUNCTION SUM (A, B) SU = A + B SUM = SU END FUNCTION 2. Enter any two numbers and display its difference. REM PROGRAM TO DISPLAY DIFFERENCE OF TWO NUMBERS CLS INPUT “ENTER FIRST NUMBER”; A INPUT “ENTER SECOND NUMBER”; B D = A - B PRINT “DIFFERENCE OF TWO NUMBERS”; D END USING SUB PROCEDURE DECLARE SUB DIFF (A, B) CLS INPUT “ENTER FIRST NUM
Read more

PALINDROME AND ARMSTRONG PROGRAMS

120.  WAP to input any number and check whether the given no. is palindrome or not. CLS INPUT "ENTER ANY NUMBER"; N A = N S = 0 WHILE N < > 0 R = N MOD 10 S = S * 10 + R N = N \ 10 WEND IF A = S THEN PRINT A; "IS PALINDROME" ELSE PRINT A; "IS NOT PALINDROME" END IF END USING SUB PROCEDURE DECLARE SUB PALIN (N) CLS INPUT "ENTER ANY NUMBER"; N CALL PALIN (N) END SUB PALIN (N) A = N S = 0 WHILE N < > 0 R = N MOD 10 S = S * 10 + R N = N \ 10 WEND IF A = S THEN PRINT A; "IS PALINDROME" ELSE PRINT A; "IS NOT PALINDROME" END IF END SUB USING FUNCTION PROCEDURE DECLARE FUNCTION PALIN (N) CLS INPUT "ENTER ANY NUMBER"; N P = PALIN ((N)) IF P = N THEN PRINT N; "IS PALINDROME" ELSE PRINT N; "IS NOT PALINDROME" END IF END FUNCTION PALIN (N) S = 0 WHILE N < > 0 R = N MOD 10
Read more