SEE Computer 2073 solved

1. Answer the following questions.

a) Write any two advantages of BUS topology.

Ans: The advantages of bus topology are:

It is easy to set up computers and other devices in bus topology, because all the devices are connected through a single wire.

It requires fewer cable media, so it is cheaper than other topologies.

b) Define computer security.

Ans: The security given to the computer for the protection of hardware, software and data from being lost or damaged due to accidental or intentional harm is known as computer security.

c) Write any two preventive measures to protect computer system from computer virus.

Ans: Any two preventive measures are:

i) Do not install pirated software, especially computer games

ii) Scan the mail or unknown files of internet before opening in your computers.

d) What is multimedia?

Ans: Multimedia is the integration of multiple forms of media, which presents information in more interesting and understandable way.

e) Write the use/function of File Transfer Protocol.

Ans: The use of File Transfer Protocol is to transfer the file from one computer to another computer. It helps to upload and download the files.

2. a) Perform the conversion as per the direction:

            i) (BAD)₁₆ into binary

            Solⁿ:

            Converting Hexadecimal to Binary

            B = 1011

            A = 1010

            D = 1101

            (BAD)₁₆ = (101110101101)₂

ii) (1111001)₂ into octal

Solⁿ:

Converting Binary to octal

001 = 1

111 = 7

001 = 1

(1111001)₂ = (171)₈

           

b) Perform the binary calculations:

            i) 11 × 10 + 11

	1	1
×	1	0
	0	0
1	1	×
1	1	0

Now, Adding with 11

		1	0
	+	1	1
1	0	0	1

                       

 11 × 10 + 11 = 1001

                       

            ii) 110  ¸ 10

10)	110 (	11
	-10
	10
	10
	00

            Quotient = 11

            Remainder = 00

3. Match the following:

a) Malicious software                        i) UPS

b) Primary storage device                  ii) virus

c) Power protection Device                iii) copyright

d) Intellectual property law                iv) RAM

                                                            v) CD-ROM

Answer

a) Malicious software            virus

b) Primary storage device      RAM

c) Power protection Device    UPS

d) Intellectual property law    copyright

4. State whether the following statements are true or false:

a) Computer Network reduces the cost. True

b) WWW is an organization which controls Internet. False

c) Microwave transmission is an example of bound media. False

d) The parts of the computer which can be seen and touched are called hardware. True

5. Write the appropriate technical terms of the following:

a) A type of network in which every computer works as both client and server.

Ans: Peer-to-peer network

b) Protocol used to receive email from the mail server.

Ans: POP( post office protocol)

c) The moving graphics images.

Ans: Animation

d) The law that controls cyber crimes.

Ans: Cyber Law

6. Write the full forms:

a) LAN: Local Area Network.

b)ROM: Read Only Memory.

c) SMTP: Simple Mail Transfer Protocol.

d)NOS: Network Operating System.

7. Answer the following questions.

a) Define data and database.

Ans: Data can be numbers, letters or symbols representing facts and figures which may or may not give any sense. Database is a collection of related and organized information that can be used for different purpose.

b) What is primary key? Write its importance.

Ans: Primary key is a field that uniquely identifies the record. It is needed because it neither accepts duplicate values nor  permit null values.

The importance of Primary key are:
i) To reduce and control duplication of record in a table.
ii) To set the relationship between tables.

c) Name any four data types used in MS-Access.

Ans: Any four data types of MS-Access are:
i) Text
ii) Number
iii) Memo
iv) Currency

8. Select the correct answer:

a) The columns in a database table are called………………………

Ans: Field

b) Which is the suitable data type to store video?

Ans: OLE object

c) …………… object of MS-Access is used to print formatted data.

Ans: Report

d) Which is not a type of query?

Ans: Search

9. Match the following:

a) Query                     i) Printed format

b) Form                       ii) Stores data

c) Table                       iii) Allows view, edit, input data

d) Report                    iv) Extracts selected record for view

                                    v) DBMS

Answer

a) Query                     Extracts selected record for view

b) Form                       Allows view, edit, input data

c) Table                       Stores data

d) Report                    Printed format

10.

a) What is a loop?

Ans: Loop can de defined as repeating the statement of statement blocks for a number of times.

b) Write the functions of  NAME and CLOSE statements.

Ans: The function of NAME statement is to  renames a file on a diskette.  The function of CLOSE statement is to close one or all open files.

c) What is variable?

Ans: The data item whose value changes during the execution of a program is called variable.

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

DECLARE SUB SUM(N)

INPUT “Any Number”; N

PRINT SUM(N)

END

SUB SUM (N)

S=0

WHILE N=0

R= R MOD 10

S=S+R

N=N/10

WEND

PRINT “Sum of digits”;S

END

Debugged Program

DECLARE SUB SUM(N)

INPUT “Any Number”; N

CALL SUM(N)

END

SUB SUM (N)

S=0

WHILE N< >0

R= N MOD 10

S=S + R

N=N \ 10

WEND

PRINT “Sum of digits”;S

END

12. Write the output of the following program.

DECLARE FUNCTION AREA (L, B)

CLS

LET L = 50

LET B = 10

LET ans = “; ans

PRINT “The area=”; ans

END

FUNCTION AREA (L, B)

Ar=L*B

AREA=ar

END FUNCTION

Output

The area = 500

13. State the following program and answer the given questions:

DECLARE FUNCTION Diff(A, B)

CLS

INPUT “Enter first number”; A

INPUT “Enter second number”; B

PRINT “The difference”; Diff(A, B)

END

FUNCTION Diff(A, B)

Difference= A – B

Diff = difference

END FUNCTION

List all the numeric variables used in the above program.

Ans: The numeric variables used in the above program are A, B and Difference

List the local variables used in the above program.

Ans: The local variables used in the above program is A, B and Difference

14

a) Write a program to calculate the area of four walls using Sub….End Sub. [Hint: Area=2H(L+B)

DECLARE SUB AREA (L, B, H)

CLS

INPUT “ENTER LENGTH”; L

INPUT “ENTER BREADTH”; B

INPUT “ENTER HEIGHT”; H

CALL AREA (L, B, H)

END

SUB AREA (L, B, H)

A = 2 * H * (L + B)

PRINT “AREA OF FOUR WALLS”; A

END SUB

b) Write a program to input a word in the main module and count the total number of vowel characters present in the word using FUNCTION…END FUNCTION.

DECLARE FUNCTION COUNT (S$)

CLS

INPUT "ENTER ANY STRING"; S$

PRINT "TOTAL NO. OF VOWELS= "; COUNT(S$)

END

FUNCTION COUNT (S$)

VC = 0

FOR I = 1 TO LEN(S$)

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

C$ = UCASE$(B$)

IF C$ = "A" OR C$ = "E" OR C$ = "I" OR C$ = "O" OR C$ = "U" THEN

VC = VC + 1

END IF

NEXT I

COUNT = VC

END FUNCTION

c) Create a data file to store the records of few employees having Name, Address, Post, Gender and Salary fields.

            OPEN “std.rec” FOR OUTPUT AS #1

            DO

CLS

            INPUT “Enter Name”; N$

            INPUT “Enter Address”; A$

            INPUT “Enter Post”; P$

            INPUT “Enter gender”; G$

            INPUT “Enter Salary”; S

            WRITE #1, N$, A$, P$, G$, S

            INPUT “Do you want to continue”; CH$

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

            CLOSE #1

            END

Database Management System Q/A 40 Questions

1)     What is database? Give two examples.

Ans: Database is a collection of related and organized information that can be used for different purpose.
Two examples of database are:
i) Dictionary
ii) Telephone Directory

2)     Differentiate between data and table.
Ans:

Data	Table
i)    Data can be numbers, letters or symbols representing facts and figures which may or may not give any sense.	i)     Table is an object of database that stores large volume of data in the form of rows and columns.

3)     State the advantages of managing database information in access.
Ans:The advantages of managing database information in access are:
i) It controls data redundancy which means duplication of data.
ii) It allows sharing the existing data by different programs.
iii) Large volume of data can be stored and updated easily.
iv) It provides high security of data as well as maintains accurate database.

4)     Differentiate between database and database management system
Ans:

Database	Database Management System
i)    Database is a collection of related and organized information that can be used for different purposes	i)      DBMS is software which is used to manage data in an organized way.
ii)   E.g.: Telephone directory, Dictionary, etc.	iii) E.g.: MS-Access, Oracle

5)     Differentiate between computerized and non-computerized database.
Ans:

Computerized	Non-Computerized
i)     It can store large volume of data.	i) It is limited by physical storage available.
ii)   It is very fast to find a specific record.	ii) It can take a while to manually search through all of the records.
iii) Data can be sorted into ascending or descending order on multiple criteria.	iii) Difficult to sort data on more than one criteria
iv) The database can be kept secure by use of passwords.	iv) The only security would be locking up the records.

6)     What is data? Write with examples.
Ans:Data can be numbers, letters or symbols representing facts and figures which may or may not give any sense.
E.g.: Ram, student, 20, etc.

7)     What is information?

Ans: Information is an organized collection of related data, which gives a complete sense. For example: “He is a boy.” , etc.

8)     Differentiate between data and information.
Ans:

Data	Information
i) Data can be numbers, letters or symbols representing facts and figures which may or may not give any sense.	i) Information is an organized collection of related data which gives a complete sense.
ii) E.g.: Ram, student, 20, etc.	ii) E.g.: Ram is a student. He is 20 years old., etc.

9)     Differentiate between record and table.
Ans:

Record	Table
i) Record is a collection of multiple related fields in a row which gives complete information about a person or thing.	i) Table is an object of database that stores large volume of data in the form of rows and columns.

10)  What is MS-Access?
Ans:MS-Access is a relational database management system developed by Microsoft Corporation which is used to store and manipulates large volume of data in the form of table.

11)  Define DBMS with example.
Ans:DBMS is a software which is used to manage data in an organized way.
E.g.: MS-Access, Oracle, etc.

12)  11. Define RDBMS with example.
Ans: It is a database management system that is based on the relation model in which data is stored in the form of tables and the relationship among the data is also stored in the form of tables.
E.g.: SQL, MS-Access, Oracle, etc.

13)  List any four featured of DBMS.
Ans: The four features of DBMS are:
i) It controls data redundancy which means duplication of data.
ii) It allows sharing the existing database by different programs.
iii) Large volume of data can be stored and updated easily.
iv) It provides high security of data as well as maintains accurate database.

14)   List any four features of MS-Access?
Ans: The four features of MS-Access are:
i) It provides the flexible ways to add, edit, delete and display the related data.
ii) Queries help to view, change and analyse the data indifferent ways.
iii) Forms are used for viewing and editing the information.
iv) Reports are used for summarizing and printing the data.

15)  Define the term of input mask and relationship.
Ans:
Input mask: It is a field property that controls the value of a record and sets in a specific format.
Relationship: It is an association among several entities (table).

16)  What is caption?
Ans: Caption is a field property which displays an alternate name for the field to make the field name more explanatory. It can contain up to 2048 characters.

17)  What are the different objects of MS-Access?
Ans: The different objects of MS-Access are:
i)Table
ii)Form
iii)Query
iv)Report

18)  What is data type?
Ans: It is an attribute for a field that determines what type of data it can contain.

19)  Write any four data types of MS-Access.
Ans: Any four data types of MS-Access are:
i)Text
ii)Number
iii)Memo
iv)Currency

20)  List any four types of field properties used by MS-Access.
Ans: The four types of field properties of MS-Access are:
i)Caption
ii)Format
iii)Validation rule
iv)Input mask

21)  What is validation rule? Define validation text.
Ans:
Validation rule: A field property which enables to limit values that can be accepted into a field is known as validation rule.
Validation text: A field property which allows type text to be displayed if the user input value is prohibited by the validation rule is known as validation text.

22)  Differentiate between text and memo.
Ans:

Text	Memo
i) It is used for storing text or combination of text and numbers.	i) It is used for storing lengthy text and numbers.
ii) It can store up to 2055 characters.	ii) It can store up to 65,535 characters.

23)  What is field size? What is the use of ‘Format’ field property?
Ans: Field size is a field property that specifies the maximum number of characters allowed in the field.
The use of ‘Format’ field property is to display data in a different format.

24)  Write down the use of Lookup Wizard and Hyperlink data types.
Ans: The use of Lookup Wizard is that it creates a field that allows choosing a value from another table or from a list of values by using a list box or combo box.
The use of Hyperlink is that it stores hyper like addresses like email addresses, websites, database objects or other field.

25)  Define indexing. Mention its types.
Ans: Indexing is one of the important properties of database that speed up searching and storing of records using on the field.
Its types are:

·        Primary indexing

·        Secondary indexing

·        Clustering indexing

26)  What is referential integrity?
Ans: Referential integrity is a set of rules used by RDBMS to make sure that the relationships between tables are valid and that the related data is not accidentally changed or deleted.

27)  Define field.
Ans: A column in a table is called field, and it contains a specific piece of information within a record.

28)  Differentiate between field and record.
Ans:

Field	Record
i) A column in a table is called field, and it contains a specific piece of information within a record.	i) Record is a collection of multiple related fields in a row which gives complete information about a person or thing.
ii) E.g.: Name, Address, Telephone	ii)E.g.: Ram Chabahil 4468790

29)  While designing table structure which data types are suitable to store information about teacher’s name, address, salary and date of birth.
Ans:
Teacher’s name - Text
Address – Text
Salary – Currency
Date of birth – Date/Time

30)  What happens when we enter text in a numeric field?
Ans: If we enter text in a numeric field then it displays the errors.

31)  What is Primary key? Why is it needed?
Ans: Primary key is a field that uniquely identifies the record. It is needed because it neither accepts duplicate values now null values.

32)  Write any two uses of Primary key?
Ans: The uses of Primary key are:
i) To reduce and control duplication of record in a table.
ii) To set the relationship between tables.

33)  What is composite and foreign key?
Ans: The group of primary key that consists of two or more attributes is called composite key.
Foreign key is a unique field or combination of fields in linked table whose value matches with a primary key in another table.

34)  Define sorting and filtering in MS-Access
Ans: Sorting means grouping all the records in a table either in ascending or descending order based on a key field of the record
Filtering is an option that selects the required records and displays the result.

35)  How is sorting different from filtering?
Ans: Sorting arranges the record either in ascending or descending order whereas filtering selects the required records and displays the result.

36)  What are the advantages of sorting?
Ans: The advantages of sorting are:
i) It helps to find specific information quickly.
ii) It helps to arrange data in alphabetical order.

37)  What are the advantages of form over table?
Ans: The advantages of form over a table are:
i) It allows to design the layout of field on screen in any arrangement.
ii) It shows only the information we want to see.
iii) It can display one complete record at a time.

38)  How can data redundancy be controlled in MS-Access?
Ans: Data redundancy can be controlled in MS-Access by the use of “Primary Key”.

39)  Define table. Write different ways to create a table.
Ans: Table is an object of database that stores large volume of data in the form of rows and columns.
The different ways to create table are:
i) Using design view
ii) Using wizard

40)  Write down the importance of table.

Ans: The importance of table are:

·        Different properties of a field can be set in a table.

·        It provides options for primary key which helps to make data consistent.

41)  What is form? Mention the methods to create a form
Ans: Form is an object of database which provides graphical interface to enter data into the tables or multiple linked tables.
Methods to create a form are:
i) By using auto forms features.
ii) By using the form wizard features.
iii) By using your own in design view.

42)  Write down the importance of form.

Ans: The importances of form are:

·        It provides an interactive platform for input of data into the database.

·        It helps to display data in more presentable form than a datasheet.

43)  Define query. Mention different types of query.
Ans: Query is an object of a database which extracts and arranges information from a table.
The different types of query are:
i) Select query
ii) Action query
In action query, we have update query, append query, delete query and make-table query.

44)  What are the advantages of query?
Ans: The advantages of query are:
i) We can filer, perform calculations and summarize data.
ii) Large volume of records can be updated or deleted at a same time.
iii) It retrieves and display records including some fields or all the fields of a table or multiple linked tables.

45)  What are the purposes of query in MS-Access?
Ans: The purpose of query in MS-Access are:
i) To view records including some fields or all the fields of a table or multiple linked tables.
ii) To perform mathematical calculation of a data.
iii) To sort the records on the basis of one or more key fields.
iv) To perform mass update, delete or append new records to a table.

46)   What is select query? For what it can be used?
Ans: A select query is the most common categories and is used for extracting specific information from one or more tables in a database.
We use select query to group records and calculate sums, counts and average, minimum and maximum.

47)  What is update query?
Ans: Update query is a type of action query which make global changes in data of a table or more linked tables.

48)  Write the append query?
Ans: The use of append query is to add a group of records from one or more tables to the end of one or more tables.

49)  Write down the importance of query?

Ans: The importances of query are:

·        It allows user to make calculations and change data in automated fashion.

·        It provides option to delete all the unwanted data matching certain criteria.

50)  Differentiate between select query and action query.

Ans:

Select query	Action query
i) It is a query which extracts specific information from one or more tables.	i) It is a query which makes changes to many records in just one operation.
ii) It cannot make changes in tales.	ii) It can do changes in tables by update, append.

51)  What is report? List any two methods to create report.
Ans: Report is an object of database which displays the output in an effective way to present the data in a printed format.
The methods are:
i) Using design view
ii) Using report wizard

52)  What is the importance of report?
Ans: The importance of report are:
i) It displays the information the way we want to view it.
ii) It presents the information retrieved through queries or tables.
iii) It presents the information in designed layouts by adding necessary titles, setting font colour or font size, etc.

53)  Why is report created?
Ans: Report is created to print documents according to users specifications of the summarized information through query or table.

54)  What is the data source for report?
Ans: The data sources for report are table and query.

55)  Differentiate between form and report.
Ans:

Forms	Report
i) Forms are used to enter, view, and edit information.	i) Reports are used only to view information.
ii) Forms are usually displayed on the screen.	ii) Reports can be previewed on the screen, but they are usually printed.
iii) Forms generally provide a detailed took at records and usually for the people who actually work with the database.	iii) Reports are often used to group and summarize data, and are often for the people who don’t work with the database but who use its information for other business task.