Thursday, January 2, 2025

SOLVED TRITON SEE MODEL QUESTIONS | OPT.II Computer Science - Set 2

 

 SOLVED TRITON SEE MODEL QUESTIONS | OPT.II Computer Science - Set 2





COMPUTER - SEE Model Question (Set-II)

Time: 2 Hours                                                                       F.M.: 50

 

Group A ' 10 marks'

 

1.   Answer the following questions in one sentence. (6 × 1 = 6)’

 

a.     Define WIFI.

Wi-Fi is a technology that enables electronic devices to connect to the internet or communicate wirelessly within a local area network (LAN).

 

b.     What is digital citizenship?

Digital citizenship refers to the responsible and ethical use of technology and the internet by individuals.

 

c.      Name any two e-commerce sites in Nepal.’

Any two e-commerce sites in Nepal are daraz and hamrobazar.

 

d.     Define relationship in MS-Access.

A relationship refers to the association or connection between two tables based on a common field or fields.

 

e.      What do you mean by modular programming?

Modular programming is a technique which divides program into many small logical, manageable and functional modules or blocks

 

f.      Write any two looping statements used in C language.

Any two looping statements used in C language are for loop and while loop.

 

2.   Give the appropriate technical terms of the following: (2 × 1 = 2)

a.      Hacking done with permission from the client. Ethical Hacking

 

b.     The process of identifying an individual usually based on username and password. Authentication

 

3.   Write the full forms for the following: (2 × 1 = 2)

a.      SMTP – Simple Mail Transfer Protocol

 

b.     AC/DC - Alternating Current/Direct Current

 

Group B ' 24 Marks'

 

4.   Answer the following questions. (9 × 2 = 18)

 

a.     "Computer network reduces the operation cost." Justify the statement.

Computer network reduces the operation cost as it allows to share software and hardware in the network, so extra hardware or software copies is not needed to install for each and every computer in the network.

 

b.     What is computer security? Write two software security measures to protect it.

Computer security refers to protecting computer and its content from damage, theft or misuse and action to prevent such incidents.

Any two software security measures to protect it are password and backup.

 

 

c.      What is e-governance? Write any two advantages of e-governance.

Ans: E-governance is a set of services provided by the government to public via electronic media especially using Internet.

The advantages of e-governance are:

·       Citizens can access government services and information conveniently from anywhere.

·       Corruption will be reduced as there will be direct interaction with the system and public without any intermediaries.

 

d.     What is e-commerce? Write any two advantages of it.

E-commerce refers to buying and selling of goods, products, or services through Internet.

Any two advantages of it are:

·       Faster buying/selling procedure, as well as easy to find products.

·       Buying/selling anytime and anywhere.

 

e.      What is IoT? Write the characteristics of IoT.

The Internet of Things (IoT) is a network of physical devices that can transfer data to one another without human intervention.

The characteristics of IoT are:

·       IoT devices can connect and communicate with each other and the internet.

·       Tasks can be performed automatically without human intervention.

 

f.      List any four data types of MS-Access. Also, mention its function.

Any four data types of MS-Access and its function are:

Date/Time

Used for dates and time data

Currency

Used for currency values.

Auto Number

Used for unique sequential (incrementing by 1).

Yes/No

Used for data that can be only one of two possible values, such as Yes/No (Boolean values)

 

g.     Define record and field in database.

A record is a row in a table which contains information about single items in a database. Record is complete set of information.

A field is a column in a table which contains information about a certain type for all records. Field is a smallest unit of information.

 

h.     What is primary key? Write its importance.

Primary Key is a special field or group of fields in the table that uniquely identifies each record from the database.

The importance of primary key are:

·       To identify each record of a table uniquely.

·       To reduce and control duplication of the record in a table.

 

i.       What is query in MS-Access? List the different types of query in MS-Access.

Query is an object of database that is used to view, retrieve, change and analyse records from a table or multiple linked tables based on specified condition.

There are two main types of Query used in Access.

Select Query and Action Query : Update Query, Delete Query and Append Query.


 

5.   Write the output of the given program showing the dry run table. (2)

     DECLARE SUB SERIES ()

     CLS

     CALL SERIES

     END

     SUB SERIES ()

     A=77777

     C=5

     WHILE C>=1

     PRINT A;

     A=A\10

     C=C-1

     WEND

     END SUB

 

Dry Run

Variable

Condition Check

PRINT A;

A=A\10

C=C-1

A

C>=5

 

 

 

77777

5>=1 Yes

77777

77777 \10=7777

5-1=4

7777

4>=1 Yes

7777

7777\10=777

4-1=3

777

3>=1 Yes

777

777\10=77

3-1=2

77

2>=1 Yes

77

77\10=7

2-1=1

7

1>=1 Yes

7

7\10=0

1-1=0

0

0>=1 No

Loop Exits

 

 

 

 The output of the program is:

77777  7777  777  77 7

 

6.   Debug the following program. (2)

     Rem to store name, address in the file ' Shop.dat"

     CLS

     OPEN " Shop.dat" FOR INPUT AS #1

     DO

     INPUT" Enter name"; name$

     INPUT " Enter address"; address

     WRITE name$, address$

     INPUT " do you want to continue"; ans$

     LOOP WHILE UCASE$(ans$) = "Y"

     CLOSE#2

     END

 

     Debugged Program

     Rem to store name, address in the file ' Shop.dat"

     CLS

     OPEN " Shop.dat" FOR OUTPUT AS #1

     DO

     INPUT" Enter name"; name$

     INPUT " Enter address"; address

     WRITE #1, name$, address$

     INPUT " do you want to continue"; ans$

     LOOP WHILE UCASE$(ans$) = "Y"

     CLOSE #1

     END

7.   Read the following program and answer the following questions. (2)

     DECLARE SUB string (x$)

     CLS

     x$="KATHMANDU"

     CALL string(x$)

     END

     SUB string(x$)

     L=LEN(x$)

     FOR A = L to 1 step -2

     PRINT MID$(x$, A, 1);

     NEXT A
     END SUB

     Questions:

a.     What is the value of L in the above program?

The value of L in the above program is 9

 

b.     List the numeric and string variable in the above program.

Numeric variable = L, A          String variable = x$

 

Group C '16 Marks'

 

8.   Calculate/Convert as per instructions: (4  × 1 = 4)

a.      (101010) × (101011) – (100101)2

 

 

 

 

 

 

1

0

1

0

1

0

 

 

 

 

 

×

1

0

1

0

1

1

 

 

 

 

 

 

1

0

1

0

1

0

 

 

 

 

 

1

0

1

0

1

0

×

 

 

 

 

0

0

0

0

0

0

×

×

 

 

 

1

0

1

0

1

0

×

×

×

 

 

0

0

0

0

0

0

×

×

×

×

+

1

0

1

0

1

0

×

×

×

×

×

 

1

1

1

0

0

0

0

1

1

1

0

 

 

 

 

 

-

1

0

0

1

0

1

 

1

1

0

1

1

1

0

1

0

0

1

(101010) × (101011) – (100101)2 = (11011101001)2

 

b.     1001011 ÷ 10101

10101)

1

0

0

1

0

1

1

(11

 

-

1

0

1

0

1

 

 

 

 

1

0

0

0

0

1

 

 

 

-

1

0

1

0

1

 

 

 

0

0

1

1

0

0

 

 

Q = 11

R = 1100

 

c.      (DEF42)16 = (  ?   )

Convert each hex digit to 4 binary digits

D = 1101

E = 1110

F = 1111

4 = 0100

2 = 0010

Convert each 3 binary digits to octal digits.

= 11 011 110 111 101 000 010

011 = 3

011 = 3

110 = 6

111 = 7

101 = 5

000 = 0

010 = 2

= 3367502

(DEF42)16 = (  3367502   )

 

d.     (489)10 = (  ?  )2

Divide by the base 2 to get the digits from the remainders:

Division
by 2

Quotient

Remainder

(Digit)

(489)/2

244

1

(244)/2

122

0

(122)/2

61

0

(61)/2

30

1

(30)/2

15

0

(15)/2

7

1

(7)/2

3

1

(3)/2

1

1

(1)/2

0

1

= (111101001)2

(489)10 = (  111101001  )2

 

9.   Answer the following questions. (4  × 2 = 8)

a.      Write a QBASIC program that ask length, breadth and height, and calculate the volume of cuboid and total surface area. Create a USER-DEFINED FUNCTION to calculate the volume of the cuboid and SUB-PROGRAM to calculate the total surface area.

 

DECLARE FUNCTION VOL(L,B,H)

DECLARE SUB TSA(L,B,H)

CLS

INPUT”Enter length”;L

INPUT”Enter breadth”;B

INPUT”Enter height”;H

PRINT”Volume of cuboid= “;VOL(L,B,H)

CALL TSA(L,B,H)

END

 

FUNCTION  VOL(L,B,H)

VOL=L*B*H

END FUNCTION

 

SUB TSA(L,B,H)

T=2*(L*B+B*H+L*H)

PRINT”Total surface area of cuboid=”;T

END SUB

 

b.     A sequential data file "records.dat" contains S_No., Name, Address, Telephone NO. and Email Address. WAP to count and display those records whose email address ends in "yahoo.com" domain. Your display should be in a tabular format having the fields Name, Address and Email address only.

 

OPEN "records.dat" FOR INPUT AS #1

CLS

C = 0

WHILE NOT EOF(1)

INPUT #1, SN, N$, A$, T, E$

IF LCASE$(RIGHT$(E$,9))="yahoo.com"

THEN PRINT N$,A$,E$

C=C+1

WEND

PRINT "TOTAL NO. OF HAVING YAHOO EMAIL ADDRESS ARE"; C

CLOSE #1

END

 

10.  Write a program in C language that asks a number and check whether the number is positive, negative or zero. (4)

 

#include<stdio.h>

#include<conio.h>

int main()

{

int n;

printf("Enter any number: ");

scanf("%d", &n);

if(n>0)

printf("%d is positive number",n);

else if(n<0)

printf("%d is negative number",n);

else

printf("%d is zero number",n);

return 0;

}

 

 

OR,

Write a program in C language to display the series with their sum 7, 10, 13, 16, …. up to 10th term.

 

#include<stdio.h>

int main()

{

    int n=7, i, s=0;

    for(i=1;i<=10;i++)

    {

        printf("%d  ",n);

        s=s+n;

        n=n+3;

    }

    printf("\nsum= %d",s);

    return 0;

}

 

¯¯¯¯¯

No comments:

Post a Comment