Sunday, 12 April 2020

SEE Model Set 4 Solution

MODEL QUESTION SET 4

1.      Answer the following questions.

a)      What do you mean by communication media? Give any two examples of unguided media.

Ans: The channels by which the data is transmitted from sender to reciever in a network is called communication media. The two examples of unguided media are Satelite, Bluetooth

b)      What is a backup? Why is backup vital to computer secuirity system.

Ans: To create the duplicate copies/extra copies of the data/ information/file/software for the future use is called backup. The backup is the measures to protect the software from being lost. If we create the backup of the software than we can get it easily even after any damage so it is very vital to create the backup.

c)      Enumerate four symptoms of computer virus?

The four symptoms of computer virus are

1. Computer will be hang.

2. Unneccessary messages or errors.

3. The file size is reduced automatically.

4. Computer programs will not respond properly or take more time to open or load.

d)      "Video game is incomplete in the absence of multimedia technology." Explain with reason.

Ans: Video game is incomplete in the absense of multimedia technology. multimedia means the use of graphics, text, audio, video or anmination to present the information to the users. hence without multimedia components it is impossible to play the video game. Because video game uses all the components of the multimedia so it is impossible for video game without multimedia.

e)      What is cyber law? Write any two ethical values for computer operators.

Ans: The laws to control or minimize the computer crime in the digital world are called cyber law. The two ethical values for computer opreations are

1. Should not steal the other computer's data or information.

3. Should not harrash the people by using internet or any electronic means.

2.      .

a)      Convert as indicated:

i)                    (101001)2 into hexadecimal                     ii) (1974AD)16 into Octal

b)      Perform binary calculation i) 100101001÷1011   ii) 1100011x1001

3.      Match the following:

Group 'A'                     Group 'B'

a)      Duplex                   b) Connects to the outer network

b)      Geteway                d) Unbounded

c)      SPX/IPX                  a) Two-way communication

d)      e-commerce         c) protocol

4.      Select the correct answer:

a)      Software associated with multimedia technology is ………

a.      QBASIC     b.  Adobe Reader    c. Window 7      d. Adobe Flash

b)      When was cyber law introduced in Nepal?

a.      2061 BS     b. 2062BS        c. 2060BS        d. 2059BS

c)      Defragmentation is the process of ……………………

a.      Formatting the disk

b.      Relocation of the disk

c.       Relocation of the files of the disk

d.      Formatting the files

d)      Chose the odd one:

a.      Bridge        b. Router         c. switch          d. modem

5.      Give the appropriate technical terms of the followoing:

a.      Rules and format to accept and transfer data in computer network. Network Protocol

b.      Moral rules to be following by computer and other professional. Cyber Ethics

c.       Making an extra copy of data and software. Backup

d.      A virus that corrupts system files of operating system. System infector

6.      Write the full forms:

a.      DNS-Domain Name Server

b.      ADSL-Asymetric Digital Subscribe Line          

c.       GBPS-Giga Byte Per Second   

d.      PDF-Portable Document Format

7.      Answer the followings questions:

a.      Differentiate between Database and DBMS. Write any two examoles of DBMS software.

Ans: Database is the collection of logical related Data. Eg is 1, ty,dfds45,56tt Whereas DBMS is a software which is used to manage the database digitally. eg are MSAccess, Dbase

b.      What is the role of query in DBMS? List the different types of query.

Ans: The query is an object of DBMS and used to extract the records from a table or tables according to the given condition or criteria. The different types of queries are

1. Select Query

3. Action Query

Delete and Update are the action queries

4. Make Table Query

c.       list any two major differences between forms and reports.

The main two differences between form and reports are as follows

1. Form is the attractive look of a table to store, modify or delete the records whereas the report is used to get records in the printed format.

2. Form is used to perform the activities like to add, delete, modify, the records whereas reports can show the records in hardcopy output format only.

8.      Selected the correct answer:

a.      Record of the table is also called …………………………

                                               i.      Tuple          ii. Entity           iii. Atteibute    iv. Field

b.      ………………… is not a field size of yes/No data type is …………….

                                               i.      Required     ii. index            iii. Format        iv. Search

c.       The field size of Yes/No data type is ………………..

                                               i.      1 Bytes        ii. 1 Nibble       iii. 1 Word       iv. None of them

d.      …………………….. Is/are DBMS (s). [Choose all that apply]

                                               i.      Ms- Excel    ii. Ms-SQL Server         iii. Oracle         iv. Foxpro

9.      Match the following:

Group A                       Group B

                                               i.      Query                      iv. Printed format

                                              ii.      Form                       iii. Stores data

                                            iii.      Table                       ii. Allows view, edit, input data

                                            iv.      Report                      Data redundancy

i . Extracts selected record for view

10.  Answer the following questions:

a.      Differentiate between User- defined functions and sub- Programs in QBASIC.

Ans:User define functions are the set of function define and created by programmer to perform a specific task.

Sub programs are the small program or modules in the modular programing to perform specfic task using sub…end sub statement.

b.      List any two data type used in C language.

Ans: int and float ar the two data types used in C language.

c.       Write the function of following statements:

                                               i.      LINE INPUT #- To extract a single record from a data file and store in a string variable.

                                              ii.      PRINT # To print the record from a data file

11.  Debug the given program:

REM To count the number of characters of a string

DECLARE FUNCTION char (a$)

CLS

INPUT : Enter any string"; a

ch = char (a$)

PRINT "Total number of Character is "; a$

END

===================================

FUNCTION char (a$)

FOR X = 1 TOLEN (a$)

C = X+1

NEXT X

C= char

END FUNCTION

The correct program is

REM To count the number of characters of a string

DECLARE FUNCTION char (a$)

CLS

INPUT "Enter any string"; a$

ch = char (a$)

PRINT "Total number of Character is "; ch

END

===================================

FUNCTION char (a$)

FOR X = 1 TO LEN (a$)

C = C+1

NEXT X

char=C

END FUNCTION

 

12.  Write the output of the following program:

DECLARE SUB sum (A)

A = 2

CALL sum (A)

END

==================================
SUB sum (A)

WHILE A <=20

            IF A MOD 4 = 0 THEN

            S= S+A

            END IF

            A = A+1

WEBD

PRINT S

END SUB

 

The output of the program is 60

13.  Read the given program and answer the given question:

DECLARE sub check ( )

CLS

CALL check

END

SUB check

c$ = "APPLE"

c=1

DO

            b$ = MID$ (c$,c,1)

                        d$ = d$ + b$

                        c = c+1

            LOOP WHILE c<=5

            PRINT d$

            END SUB

a.      what will be the output of the above prohram?

                                   i.      LEPPA    ii. ELAPP          iii. ELPAP         iv. APPLE

b.      What will be the output of the above program if the line LOOP WHILE c<=5 is replaced with LOOP UNTIL c>=5?

The output of the program will be same as APPLE

14.  a. write a program to generate the series using a SUB procedure. 5 10 20 35 55 810 110 … … up to 10th terms.

b.      Write a program that asks any number and calculates its factorial using a FUNCTION procedure.

DECLARE FUNCTION FACT(A)

CLS

INPUT "ENTER A NUMBER";A

PRINT FACT(A)

END

FUNCTION FACT(A)

F=1

FOR I=1 TO A

F=F*A

NEXT I

FACT=F

END FUNCTION

c.       A Sequential data file "pass. dat" has several records having fields student's name and marks in English, Math and computer. Write a program that reads all the records and displays only those records and displays only those records whose name starts with 'A' and also counts the total number of records stored in the file.

OPEN "PASS.DAT" FOR INPUT AS #1

WHILE NOT EOF(1)

INPUT #1, N$,E,M,C

C=C+1

IF LEFT$(N$,1)="A" THEN

PRINT N$,E,M,C

ENDIF

WEND

PRINT "TOTAL NUMBER OF RECORDS";C

CLOSE #1

END


No comments:

Post a Comment

MCQ Question Bank Microsoft PowerPoint