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

 

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

 

 

COMPUTER - SEE Model Question (Set-IV)

Time: 2 Hours                                                                       F.M.: 50

Group A ' 10 marks'

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

a.     Define the internet.

The Internet is a global network of interconnected computers and servers that allows the exchange of information and communication between devices.

 

b.     What is the business done through the internet?

The business done through the internet is e-commerce.

 

c.      What is IoT?

The Internet of Things (IoT) is a network of physical devices to exchange information over a network without human intervention.

 

d.     Define foreign key.

A foreign key is a field (or a set of fields) in a database table that establishes a link between two tables.

 

e.      Which view is used to modify a table in MS-Access?

Design view is used to modify a table in MS-Access.

 

f.      Write any two features of C Programming.

Any two features of C Programming

Portability: C code can be compiled and executed on different systems with minimal modifications.

C is a case-sensitive programming language. It understands the capital alphabets and small alphabets as different values.

 

2.   Write the appropriate technical term for the following.         (2x1=2)

 

a.      A device that is used to translate analog signals into digital and vice versa. MODEM

b.     The smallest unit to represent information on a quantum computer. qubit (quantum bit)

 

3.   Write the full form of the following.      (2x1=2)

a.      VSAT- Very Small Aperture Terminal

b.     UHF- Ultra High Frequency

 

4.   Answer the following questions: (9x2=18)

a.     What is a computer network? List any two importance of it.

Computer network is a group of two or more computers and devices connected to each other through wired or wireless media to exchange data and information and share hardware, software and other resources.

           Any two importance of computer network:

·       A network connected computers can share hardware devices such as scanner, printer, hard disk, etc.

·       Networking also provides the facility of data and software backup system.

b.     What is meant by computer ethics? Write down any two ethics of it.

Computer ethics is a set of moral principles or code of conducts that regulate the use of computers systematically without making harm to other users.

Any two ethics of it are:

·       Do not use a computer to harm other people.

·       Do not use a computer to publish fake information.

 

c.      What is computer security? Write any two hardware security measures.

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

Any two hardware security measures are: insurance and power protection device.

 

d.     Write any two differences between e-commerce and traditional commerce.

Traditional Commerce	E-commerce
Traditional commerce is the buying and selling of goods and services through physical stores and in-person transactions, without using digital technology.	Ecommerce refers to the buying and selling of goods or services using the internet.
Delivery of goods is instant.	Delivery of goods takes time.

 

e.      Define online payment and list any two applications used for online payment.

Online payment refers to the payment for buying goods or services through the Internet using different online payment gateway.Any two applications used for online payment are esewa and khalti.

 

f.      Define DBMS with any two examples.

Database management system (DBMS) is a computerized system that stores data, processes them and provides information in an organized form.

Example of DBMS are: MS-Access, Oracle, MySQL, Fox Pro.

 

g.     What is a report in MS-Access? Mention the importance of it in the database.

Report is an object of Ms-Access which is used to present information in an effective and organized format that is ready for printing.

The importance of report are:

Reports enable users to summarize, analyze, and visualize data in meaningful ways.

Reports provide a formatted presentation of data that is easy to read and understand.

 

h.     Define the primary key and write its features.

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

Its features are:

·       It sets the relationship between tables.

·       It reduces and controls duplication of record in a table

 

i.       What is meant by data redundancy? How can we minimize it?

Data redundancy is the duplication of data within a database.

Data redundancy can be controlled by normalizing the database, eliminating duplicate data and storing it in separate tables.

5.   Write down the output of the given program and show them in the dry run table.2

DECLARE SUB CITY (K$)

CLS

CALL CITY ("KATHMANDU")

END

SUB CITY (K$)

FOR K=1 TO LEN (K$)

C$=MID$ (K$, K, 1)

IF K MOD 2 = 1 THEN

C$=UCASE$ (C$)

ELSE

C$=LCASE$(C$)

END IF

X$=X$+C$

NEXT K

PRINT X$

END SUB

 

Dry Run

K$	K=1 TO LEN (K$)	C$=MID$ (K$, K, 1)	IS K MOD 2 = 1?	YES C$=UCASE$ (C$)	NO C$=LCASE$ (C$)	X$=X$+C$	PRINT X$
KATHMANDU	1 TO 9 YES	K	1 MOD 2=1 NO		k	K
	2 TO 9 YES	A	2 MOD 2=0 YES	A		kA
	3 TO 9 YES	T			t	kAt
	4 TO 9 YES	H		H		kAtH
	5 TO 9 YES	M			m	kAtHm
	6 TO 9 YES	A		A		kAtHmA
	7 TO 9 YES	N			n	kAtHmAn
	8 TO 9 YES	D		D		kAtHmAnD
	9 TO 9 YES	U			u	kAtHmAnDu
	10 TO 9 NO LOOP EXITS						kAtHmAnDu

The output of the program is

kAtHmAnDu

 

 

6.   Rewrite the given program after correcting the bugs. (2)

DECLARE FUNCTION vowel (S$)

w$=we love our country

v=vowel (w$)

PRINT "The total no. of vowel..";v

END

FUNCTION vowel$(S$)

c=0

FOR K=1 TO length (S$)

B$=MID$(S$, K, 1)

B$=LCASE$(B$)

SELECT CASE B$

CASE "a", "e", "i", "o", "u"

c=c+1

END SELECT

NEXT K

C=vowel

END FUNCTION

 

Debugged Program

 

DECLARE FUNCTION vowel (S$)

w$=²we love our country”

v=vowel (w$)

PRINT "The total no. of vowel..";v

END

 

FUNCTION vowel(S$)

c=0

FOR K=1 TO LEN (S$)

B$=MID$(S$, K, 1)

B$=LCASE$(B$)

SELECT CASE B$

CASE "a", "e", "i", "o", "u"

c=c+1

END SELECT

NEXT K

vowel = c

END FUNCTION

 

7.   Study the following program and answer the given questions. (2)

DECLARE FUNCTION TEST (A)

X=10

Z=TEST (X)

PRINT Z

END

 

FUNCTION TEST (B)

FOR I=1 TO B

S=S+I*I

NEXT I

TEST=S

END FUNCTION

a)   How many times the program loops?

Program loops 10 times.

b)  Write the name of the function procedure.

The name of the function procedure is TEST( ).

 

8.   Calculate as per the instruction: (4x1=4)

(i)    (110111)₂ = (?)₈       

 

Convert every 3 binary digits to octal digit

110111

110 = 6

111 = 7

= 6 7

(110111)₂ = (67)₈ 

     

(ii)    (25AF)₁₆ = (?)₁₀

_{(25AF)₁₆ =}

_{(2 × 16³) + (5 × 16²) + (10 × 16¹) + (15 × 16⁰)}

_{= (2 × 4096) + (5 × 256) + (10 × 16) + (15 × 1)}

 

_{= (2 × 4096) + (5 × 256) + (10 × 16) + (15 × 1)}

_{=8192 + 1280 + 160 + 15}

_{= (9647)₁₀}

(25AF)₁₆ = (₉₆₄₇)₁₀

 

(iii)  110110+100011            

 

	1	1	0	1	1	0
+	1	0	0	0	1	1
1	0	1	1	0	0	1

 

110110+100011 = 1011001

         

(iv)   (1110001) ÷ (101)

101)	1	1	1	0	0	0	1	(10110
	-1	0	1
		1	0	0	0
	-		1	0	1
		0	0	1	1	0
			-	1	0	1
				0	0	1	1
						-	0
						1	1

 

Q = 10110

R = 11

 

 

9.   (a)  Write a program in QBASIC that asks length, breadth and height of a room and calculate its area and volume. Create a User Defined Function to calculate Area and Sub Program to calculate the volume.

 

DECLARE FUNCTION AREA (L, B)

DECLARE SUB VOLUME (L, B, H)

CLS

INPUT “ENTER LENGTH”; L

INPUT “ENTER BREADTH”; B

INPUT “ENTER HEIGHT”; H

PRINT “AREA OF ROOM ”; AREA(L, B)

CALL VOLUME(L, B, H)

END

 

FUNCTION AREA (L, B)

AREA = L * B

END FUNCTION

 

SUB VOLUME (L, B, H)

V = L * B * H

PRINT “VOLUME OF ROOM =”; V

END SUB

 

(b)  Employee's name, address, gender and salary are stored in the "EMP.DAT" sequential data file. Write a QBASIC program that displays all information about personnel whose salaries exceed 60,000.

 

OPEN "EMP.DAT" FOR INPUT AS #1

CLS

WHILE NOT EOF (1)

  INPUT #1, N$, A$, G$, S

    IF S > 60000 THEN PRINT N$, A$, G$, S

WEND

CLOSE #1

END

 

10.   Write a program in 'C' language to find simple interest where user need input Principle, Rate and Time.

 

#include<stdio.h>

#include<conio.h>

int main()

{

float p, t, r, i;

printf("Enter principal: ");

scanf("%f", &p);

printf("Enter time: ");

scanf("%f", &t);

printf("Enter rate: ");

scanf("%f", &r);

i = (p*t*r)/100;

printf("Simple Interest = %.2f", i);

return 0;

}

OR,

 

 

Write a program in 'C' language to display the series with their sum. 1,2,3,4, … up to 10^th term.

 

#include<stdio.h>

int main()

{

    int i, s=0;

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

    {

        printf("%d  ",i);

        s=s+i;

   }

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

    return 0;

}

 

 

 

 

 

¯¯¯¯¯