SOLVED 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.com and ask.com

 

b) What is social media?

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

 

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 is the protection of computer systems and applications from threats, such as hacking, virus attacks, and unauthorized access, to ensure their confidentiality, integrity, and availability.

Any two protection measures for software security are:

1.    Backup

2.    Password

 

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

Ans: Search engine is the communication program that searches documents on the basis of specified keywords and returns a list of the web links that matches the keywords.

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

 

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

Ans: E-Commerce refers to electronic transactions such as buying, selling and exchanging of goods, services and information over computer communication network such as 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 ant 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.    Large volume of data can be stored and updated easily.

2.    Provides data integrity and security. 

 

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

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

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: The parameters are used in the above program is one.

 

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)₂

 

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;

}

 

 

 

***