SET 1

 Group 'A'

1. Answer the following questions in one sentence: [ 6x1=6]

a What is analog signal?

Ans: An analog signal refers to a continuous electrical signal that varies over time and represents data as a continuous waveform. trical sign

b. What is cyber Law?

Ans: The law which governs the legal issues in the cyber space regarding the internet or WWW for digital data processing and transaction is called cyber law.

c. What is information security?

Ans: Information security is the practice of preventing unauthorized access, use, disclosure, modification, recording or destruction of information.

d. What is online payment?

Ans: Online payment refers to the payment for buying goods or services through the Internet using different online payment gateway.

What is primary key?

Ans: A primary key is a field or combination of fields in a table that uniquely identifies each record, and is used to establish relationships between tables and enforce data integrity.

f. Define validation text.

Ans: Validation Text is a field property which displays an error message that appears if the data entered is invalid according to the specified validation rule.

2. Write appropriate technical term for the following: [2x1=2]

a. It is the process of converting plain text to cipher text. Encryption

b. Software require for browsing and surfing content on the WWW. Web Browser

3. Write the full form of the following:

a VOIP-Voice Over Internet Protocol

b. IOT-Internet of Things

Group 'B'[9x2=18]

4. Answer the following questions:[2x1=2]

a. What is computer network? Write any two advantages advantages of it.

Ans: 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 advantages of Computer Network are

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

2. It can communicate and share information all over the world through Internet.

b. Define social media with its any two opportunities.

Ans: Social Media is an online tool that helps us to stay connected with the whole world.

Any two opportunities of using social media

a) It creates awareness and innovate the way people live

b) Social media let us share anything with others around the world.

C What is E-commerce? Explain in short.

Ans: E-commerce refers to the buying and selling of goods or services using the internet. E.g. Amazon, Flipkart, eBay, sastodeal, daraz etc. The main goal of e- commerce is to reduce cost, faster customer response and deliver the better quality service. It makes buying/selling possible 24/7. There are no geographical boundaries for e-business. Anyone can order anything from anywhere at any time.

d. What is firewall? Write its any two uses.

A firewall is the network security systems that monitors and controls the traffic flow between the Internet and private network on the basis of a set of user- defined rules.

Any two uses of firewall are:

Firewalls act as a barrier between an internal network and external networks (like the internet). By filtering traffic, they help safeguard sensitive data and critical resources within the network.

Firewalls enforce access control policies by allowing or denying specific types of traffic based on criteria such as IP addresses, ports, protocols, and packet contents.

e Define virtual reality with its characteristics.

An artificial environment created with computer hardware and software and presented to the user in such a way that it appears and feels like a real environment.

The characteristics of virtual reality are:

VR Gaming allows players to immerse (dip) themselves in virtual world and interact with environment and characters

VR can help students learn by making the content more engaging and memorable.

f. Differentiate between database and DBMS.

database

DBMS

A collection of systematically organized inter-related data is called a database. The purpose of data base is to store, organize and retrieve data.

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

E.g. Dictionary, Marks Ledger, Telephone Directory, Attendance Register etc.

E.g. MS-Access, Oracle, MySQL, Fox Pro etc.

g. What is data type? List any four types of data types used in MS-Access. Data type is an attribute for a field that determines the type of data that can be stored in that field.

any four types of data types used in MS-Access are Text, Date/Time, Currency, Yes/No

h. Define term sorting and filtering.

The process of arranging all the records in a table either ascending or descending order based on field or fields is known as sorting.

Filtering is the process of viewing required record of a table that matches the specifies criteria.

i. Define Table. Why caption field property is used in MS-Access?

Tables are the primary building block of database which stores and manages large volume of data into rows and column.

Caption is a field property which gives alternative name given for any field. The maximum size for this is 2048 characters.

5. Write down the output of the given program. Show with dry run in table: [2]

DECLARE SUB SERIES(X)

CLS X=7 CALL SERIES(X) END

SUB SERIES(X) FOR M1 TO 10 PRINT X:

IF X MOD 2-0 THEN X=X/2

6. Re-write the given program after correcting the bugs:

CREATE FUNCTION SQUARE(N)

CLS REM TO PRINT SQUARE OF A NUMBER GET "ENTER ANY NUMBER"; N CALL SQUARE(N) END

FUNCTION SQUARE(N) ANS=A^2 SQUARE = ANS END SQUARE(N)

Debugged Program

DECLARE FUNCTION SQUARE(N)

CLS REM TO PRINT SQUARE OF A NUMBER INPUT "ENTER ANY NUMBER"; N PRINT SQUARE(N)

END

By : D

FUNCTION SQUARE(N)

ANS-N^2 SQUARE ANS

END FUNCTION epared

7. Study the following program and answer the given questions: [2]

DECLARE FUNCTION OUTPUTS(WS)

CLS

WS="CYBER CRIME"

PRINT OUTPUTS (WS)

END

FUNCTION OUTPUTS (WS) FOR M= LEN(WS) TO 1 STEP-2

MS-MS+MIDS(WS, M, 1)

NEXT M

OUTPUTS-MS

END FUNCTION

a Why is $ sign is followed by function name?

Ans: The $ sign is followed by function name because the function returns string value.

b. List the library function used in the above program.

Ans: The library function used in the above program are LEN() )and MID$().

Group 'C'

8. Convert/calculate as per the instruction: [4x1=4]

a (ABC)16 into (2)10

b (143) into (?)2

c. (1010)+(1100)x(1011)

d. (110111001)+(101)

9. Write a program to define a sub procedure to display the reverse of string input by user. And define function procedure to find out volume of cylinder where the necessary data has to be fed in main module. [Hint volume of Cylinder-RH] [4]

DECLARE SUB REV(AS)

DECLARE FUNCTION VOL(R, H)

CLS

INPUT "Enter any string"; AS

INPUT "Enter radius"; R INPUT "Enter Height"; H

CALL REV(AS)

PRINT "Volume of Cylinder="; VOL(R, H)

END

SUB REV(AS)

FOR I=LEN(AS) TO 1 STEP-1 BS-MIDS(AS, I, 1)

CS-CS+BS

NEXT I

PRINT "Reversed String is"; CS

END SUB

FUNCTION VOL(R, H)

VOL-22/7*R^2*H

END FUNCTION

10. A sequential data file "INFO.INF" has numerous records with name, address and telephone number in each record. Write a program to scan all the records from that file and display only the records whose address is "TANSEN" [4]

OPEN "INFO.INF" FOR INPUT AS #1

CLS

WHILE NOT EOF(1)

INPUT #1, N$, AS, T

IF UCASES(AS)="TANSEN" THEN PRINT NS, AS, T

WEND

CLOSE #1

END

11. Write a program in c language to ask a number and check whether it is odd or even.

#include<stdio.h>

#include<conio.h>

int main()

{

int n;

printf("Enter any number: ");

scanf("%d", &n);

if(n%2-0)

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

else

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

return 0;

}

Write a program in c language to display series 1,1,2,3,5 up to 13 terms [4] 

OR

#include<stdio.h>

#include<conio.h>

int main()

{

int a,b,c,i;

a=1;

b=1:

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

{

printf("%d \n", a);

c=a+b;

a=b;

b-c;

return 0;

}

}