General Knowledge - Technology - Discussion

A table contains rows (tuple or record) and columns (fields). Now let us assume that we have a salary table that contains the names of the employees and their salary. So in that table (assume 2*2 matrix) we can give the headings as names and salary.

In the 1st row the 1st data heading is name and beside that 1st data of the 1st row we put salary as the 2nd data of the 1st row. So from here we can say that a row contains 2 different types of fields- the characters (name) and the numeric (salary).

So rows can be said as the collection of various info's, or in one word row is a record. Again in the 2nd row 1st data we put a X (i.e name is X below the name heading) and we put rs 2000 as a 2nd data of the 2nd row (i.e below the salary heading).

So from the point of column we can say that name heading is containing only characters (names can not be in 1000 or 2k format) and salary heading is contain only numeric (salary can not be in X or Y format). So the conclusion is that columns (field) contain only same type of data.

Field is a column in any record (RECORD-that contain information about any subject like record of employees,students etc having various rows for one person ,various columns for various categories like sr.no. , name ,salary ,fees etc.) ,having only one type of data like name or address or fees.and also a row is for full information of a perticular person and contain different data like name, address, fee, years, etc only for one person.

Fields are the specific columns of a tables that contain only one type of data .

Eg: Table of Employee


EmpNo Name
1 sujit
2 ajit
3 nitin

Here 1,2,3 are the employee numbers they will be only numbers.
sujit, ajit, nitin are names they will always be characters.

A field is nothing but an attribute, which describes about the entity. An entity may consist more than one field (Attribute). Each field explains about single characteristic of that entity, So it holds the same type of information.

Report cant be of single datatype, record is collection of different fields. Mostly, file comprising of heterogeneous data fields. So field is the only one which points to single data type.

Report contains so many records. Record contains so many fields. i.e it contians diff data types. File is nothing but a group of stmts. So field only holds one type of data.

Fields are specific place in a file (r) database to save. Then each fields explains about single characteristic of that entity, same types of information holds.

As a field is a column and a single column contain only one type of data hence field contains only one type of information like name or a group of characters.

A field can be easily explained by a simple example i.e when we enter a name in the log in form, in that box we can enter only a name i.e nothing but a field.

Report contains only one type of information that one is willing to know about a particular thing or event occurred. So correct answer is option A.