SOLVED SEE (Grade Promotion) 2079 (2023) ऐच्छिक द्वितीय कम्प्युटर विज्ञान

 

SEE COMPUTER SCIENCE 2078

 

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

 

a) Write the name of any two search engines.

Ans: The name of any two search engines is google and bing.

 

b) What is social media?

Ans: Social media refers to online platforms like Facebook and Instagram that allow people to connect, share information, and interact with each other.

 

c) Which data type is suitable to store photographs of students in MS-Access?

Ans: The suitable data type to store photographs of students in MS-Access is OLE object.

 

d) Which view is used to modify a table structure in MS-Access?

Ans: Design View is used to modify a table structure in MS-Access.

 

e) Which statement is used to call sub-procedure?

Ans: CALL statement is used to call sub-procedure.

 

f) Write any two data types used in C language.

Ans: Any two data types used in C language are int and char.

 

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

 

a) A system of copying data and information reading in computer into another

location. Backup

 

b) A company which provides services of Internet. Internet Service Provider (ISP)

 

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

 

a) FTP: File Transfer Protocol

 

b) MAN: Metropolitan Area Network

 

4. Answer the following questions.          9x2=18

 

a) What is computer network? Write any two 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. Networking also provides the facility of data and software backup system.

 

b) Define software security. Write any two protection measures for it.

Ans: Software security means protecting software from being hacked or misused which ensures the software works properly and keeps data safe.

Any two protection measures for software security are: Backup and Password

 

c) What is search engine? Write any two popular search engines.

Ans: A search engine is an online tool that helps users find information on the internet using keywords or phrases and provide relevant results.

The name of any two popular search engines is google and bing.

 

d) Define e-commerce. Write any two benefits of it.

Ans: E-commerce is the buying and selling of goods and services over the internet.

Any two benefits of e-commerce are:

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

2.     There are no geographical limitations, can deliver service globally.

 

e) Write any two advantages and disadvantages of social media.

Ans: Any two advantages of social media are:

1.     It creates awareness and innovate the way people live.

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

Any two disadvantages of social media are:

1.     Personal data and privacy can be easily hacked and shared on the internet.

2.     More chances of creating fake accounts.

 

f) What is DBMS? Write any two advantages of it.

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

Any two advantages of DBMS are:

1.     It reduces data redundancy which means duplication of data.

2.     Large volume of data can be stored and updated easily. 

 

g) What is primary key? Write any two features of it.

Ans: A primary key is a unique field in a database table that identifies each record uniquely.

Any two features of primary key are:

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

2.     To set the relationship between tables.

 

h) Define field and record.

Ans: 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.

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

 

i) Define form. Write any two uses of it.

Ans: Form is one of the MS-Access database objects that is primarily used to create an interface for entering data in a table or multiple linked tables.

Any two uses of form are:

1.     Form displays complete record one at a time, so we can view and modify records using the form.

2.     Forms provides  GUI (Graphical Users Interface) using which users interact with MS-Access database.

 

5. Write the output of the given program: (Workout with a dry run).  2

DECLARE SUB ABC(A)

CLS

A=2

CALL ABC(A)

END

SUB ABC(A)

FOR J= 1 TO 5

PRINT A;

A=A+3;

NEXT J

END SUB

 Dry run

A	J=1 TO 5	PRINT A;	A=A+3
2	1 to 5 Yes	2	2+3=5
5	2 to 5 Yes	5	5+3=8
8	3 to 5 Yes	8	8+3=11
11	4 to 5 Yes	11	11+3=14
14	5 to 5 Yes	14	14+3=17
17	6 to 5 No (loop exits)

The output of the program is

2  5  8  11  14

 

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

DECLARE SUB Series ( )

CLS

EXECUTE Series

END

SUB Series( )

REM Program to generate 1 1 2 3 5 .....upto the 20^th terms

A=1

B=1

FOR ctr=10 to 1

DISPLAY A:B:

A=A+B

B=A+B

NEXT ctr

END Series ( )

 

Debugged Program

DECLARE SUB Series ( )

CLS

CALL Series

END

 SUB Series( )

REM Program to generate 1 1 2 3 5 .....upto the 20^th terms

A=1

B=1

FOR ctr=1 TO 10

PRINT  A; B;

A=A+B

B=A+B

NEXT ctr

END SUB

 

7. Study the following program and answer the given questions.          2x1=2

DECLARE FUNCTION TEST(X)

X=100

Z=TEST(X)

PRINT Z

END

 

FUNCTION TEST(X)

FOR R=1 TO X

S=S+I

NEXT R

TEST=S

END FUNCTION

 

a) How many parameters are used in the above program?

Ans: One parameters is used in the above program.

b) How many times does the statement S=S+I execute in the above program?

The statement S=S+I will execute 100 times in the above program

 

8. Convert / Calculate as per the instruction.     4x1=4

i) (11111101)₂ = (?)₁₆

Soln:

Paired Binary Digit	1111	1101
Binary Equivalent value	F	D

 

(11111101)₂ = (FD)₁₆

 

ii) (245)₁₀ = (?)₂

Soln:

2	245	Remainder
2	122	1
2	61	0
2	30	1
2	15	0
2	7	1
2	3	1
2	1	1
	0	1

 

  (245)₁₀ = (11110101)₂

 

iv) (101110) ₂ ¸ (110) ₂

110)	101110(	0111
	000
	1011
	-110
	1011
	-110
	1010
	-110
	100

 

            Quotient = 111

            Remainder = 100

iii) (1010) ₂ x (101) ₂ =(?)₂

 

		1	0	1	0
		x	1	0	1
		1	0	1	0
	0	0	0	0	x
1	0	1	0	x	x
1	1	0	0	1	0

 

 (1010) ₂ x (101) ₂ =(110010)₂

 

 9 a) Write a program in QBASIC that asks length, breadth of a room and calculate its area and perimeter. Create a user defined function to calculate area and sub program to calculate perimeter.

[Hint: [Area=LxB], [p=2(L+B]]

 

DECLARE FUNCTION AREA (L,B)

DECLARE SUB PER(L,B)

CLS

INPUT “Enter Length”; L

INPUT “Enter Breadth”; B

PRINT “Area of rectangle=”; AREA(L,B)

CALL PER(L,B)

END

FUNCTION AREA(L,B)

AREA = L*B

END FUNCTION

 

SUB PER(L,B)

P=2*(L+B)

PRINT “Perimeter of rectangle=”; P

END SUB

 

 

 

b) Write a program to create a sequential data file “salary.dat” to store programmer’s name, salary and post according to the need of the user.

 

OPEN “salary.dat” FOR OUTPUT AS #1

DO

CLS
INPUT “Enter name”; N$

INPUT “Enter Salary”; S

INPUT “Enter Post”; P$

WRITE #1, N$, S, P$

INPUT “Do you want to continue(Y/N)”; CH$

LOOP WHILE UCASE$(CH$)=”Y”

CLOSE #1

END

 

 

10.  Write a C program that asks a number and check whether it is negative, positive or zero.

 

 #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 first 10 odd numbers.

#include<stdio.h>

#include<conio.h>

int main()

{

int i, a;

i=1;

a=1;

while(i<=10)

{

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

    a=a+2;

    i++;

}

return 0;

}

  

 

***