Explain field length with its types. -Technology

Explain field length with its types. -Technology
by

1 Answer

Answer :

It refers to the maximum number of characters that a field can contain. Each character requires one byte for its storage.Field length is of two types which are as follows:1. Fixed length field It is a type of field length in which the number of characters you enter in a field is fixed. These are present in Format option in Data Type Formatting group (in Datasheet tab) such as Currency, Euro, Percent etc.2. Variable length field In this type of field length, the number of characters is not fixed. Actually, the number of characters of the data entered in the field decide the field length.The field length or field size of each data type are as follows:Data TypeField length or Field sizeData TypeField length or Field sizeText0-255 charactersMemo0-65,536 charactersNumber1,2,4,8 or 16 bytesDate/Time8 bytesCurrency8 bytesAutoNumber4 or 16 bytesYes/No1 bit(0 or 1)OLE ObjectUpto 2 GBHyperlinkEach part contains upto2048 charactersLookup Wizard4 bytes
by

Related questions

What is Fixed Field Length? -Technology

Description : What is Fixed Field Length? -Technology

Last Answer : It refers to a type of field length in which the number of characters you enter will be fixed.

How are field types Text and Memo different from each other? -Technology

Description : How are field types Text and Memo different from each other? -Technology

Last Answer : Distinguishing between Text and Memo are as follows:TextMemoIt is used for relatively short entries.It is used for long text paragraphs.It can storeupto255 characters only.It can storeupto65536 characters. ... number of characters.It does not use field size property.e.g. Emp_namee.g. Emp_description

If the data type of a field is set to Text, what will be its number range? -Technology

Description : If the data type of a field is set to Text, what will be its number range? -Technology

Last Answer : Its range will be 0 to 255.

When a field name has a space in its title, such as Last Name, how is the merge field displayed in the mail merge document? -Technology

Description : When a field name has a space in its title, such as Last Name, how is the merge field displayed in the mail merge document? -Technology

Last Answer : (c) When a field name has a space in its title, such as Last Name, Last_Name is the merge field displayed in the mail merge document.

Explain the concept of cell referencing along with its various types. -Technology

Description : Explain the concept of cell referencing along with its various types. -Technology

Last Answer : Excel supports three types of cell referencing, which are as follows:1. Relative Every relative cell reference in formula automatically changes when the formula is copied down a column or across a ... from one cell to another, the absolute reference stays the same but the relative reference changes.

How multiple E_mail addresses are defined in To, Cc, Bcc field? -Technology

Description : How multiple E_mail addresses are defined in To, Cc, Bcc field? -Technology

Last Answer : By using a comma between E-mail addresses.

How multiple E_mail addresses are defined in To, Cc, Bcc field? -Technology

Description : How multiple E_mail addresses are defined in To, Cc, Bcc field? -Technology

Last Answer : By using a comma between E-mail addresses.

Bcc field contains the list of recipients. Bcc stands for (a) Basic carbon copy (b) Blind carbon copy -Technology

Description : Bcc field contains the list of recipients. Bcc stands for (a) Basic carbon copy (b) Blind carbon copy -Technology

Last Answer : (b) Bcc denotes the Blind carbon copy.

What is field in database? Give an example. -Technology

Description : What is field in database? Give an example. -Technology

Last Answer : A field is an area, reserved for a specific piece of data. It is also known as an attribute, e.g. Customer_Name.

Distinguish between a record and a field in a table, with an example. -Technology

Description : Distinguish between a record and a field in a table, with an example. -Technology

Last Answer : Distinguish between a record and a field in a table are as follows:RecordFieldIt is a collection of data items, which represent a complete unit of information about a thing or a person.It is an ... called a record.e.g. if Employeeis a table, then empId, empName, department, salary arethe fields.

Out of the following, which one is the most appropriate data field in context of employee table, if only one of these is required? -Technology

Description : Out of the following, which one is the most appropriate data field in context of employee table, if only one of these is required? -Technology

Last Answer : (b) Date of birth is the most appropriate data field in the context of the employee table.

Key field is a unique identifier for each record. It is defined in the form of (a) rows (b) columns -Technology

Description : Key field is a unique identifier for each record. It is defined in the form of (a) rows (b) columns -Technology

Last Answer : (b) Key is a data item that allows you to uniquely identify individual occurrences which is defined as the column or set of columns.

A field in a table is also called as ………………… . -Technology

Description : A field in a table is also called as ………………… . -Technology

Last Answer : A field in a table is also called ascolumn.

Field contains set of characters. -Technology

Description : Field contains set of characters. -Technology

Last Answer : True It is the individual sub-component of one record. It contains set of characters, which have a proper meaning.

If a piece of data (field value) is stored in two places in the database, then storage space -Technology

Description : If a piece of data (field value) is stored in two places in the database, then storage space -Technology

Last Answer : False If a piece of data is stored in two places in the database, then storage space is wasted and changing the data in one spot will cause data inconsistency.

Primary key field gives us permission to record duplicate entry. -Technology

Description : Primary key field gives us permission to record duplicate entry. -Technology

Last Answer : False A primary key is a key which identifies records uniquely in a table so it does not give us permission to record duplicate entry.

A primary key field does not allow numbers. -Technology

Description : A primary key field does not allow numbers. -Technology

Last Answer : False Primary key has to identify a unique value which can be present in a table, in a number form also. It means primary key field allow number too.

What happens when you enter numbers in a Text data type field? -Technology

Description : What happens when you enter numbers in a Text data type field? -Technology

Last Answer : Numbers are accepted as a text value.

What happens when text is entered in a Number type field? -Technology

Description : What happens when text is entered in a Number type field? -Technology

Last Answer : When we enter text in a Number field and press Enter or press Tab key, MS-Access displays a message that “The value you entered does not match the Number data type in this column.”

Is it necessary to define a field type for a field in MS_Access? -Technology

Description : Is it necessary to define a field type for a field in MS_Access? -Technology

Last Answer : Yes, it is necessary to define a type of a field while entering data into a field.

Which field property sets limits on the data that is entered? -Technology

Description : Which field property sets limits on the data that is entered? -Technology

Last Answer : Fixed Field Length or Field Size property sets the limits on the data entered.

For which type of field, “Default Value” property is not applicable? -Technology

Description : For which type of field, “Default Value” property is not applicable? -Technology

Last Answer : Attachment, AutoNumber, OLE Object.

What is the use of AutoNumber type field used in MS_Access? -Technology

Description : What is the use of AutoNumber type field used in MS_Access? -Technology

Last Answer : AutoNumber data type starts with a number for the first record and it automatically increases the number by a set of amount for each record.

Which field property specifies whether the field can be left empty when entering data into a record? -Technology

Description : Which field property specifies whether the field can be left empty when entering data into a record? -Technology

Last Answer : Required property.

What happens, if you do not enter a caption for a field? -Technology

Description : What happens, if you do not enter a caption for a field? -Technology

Last Answer : In this case, Field Name is used as a label.

When Memo data type is preferred over Text type for a field? -Technology

Description : When Memo data type is preferred over Text type for a field? -Technology

Last Answer : When the length of the field is more than 255 characters. Text data type is not capable to store the project description because its length cannot be more than 255 characters so, Memo data type is preferred over the Text data type.

A text field is initially 40 characters long and one record has an entry in this field in MS_Access database. -Technology

Description : A text field is initially 40 characters long and one record has an entry in this field in MS_Access database. -Technology

Last Answer : Since the new field length is 20 characters long. So, this field will contain only left 20 characters including spaces and the remaining data will be discarded. Thus, the data from the right side of the field will be lost.

Write one example of data field for which you would set the Required property to Yes? -Technology

Description : Write one example of data field for which you would set the Required property to Yes? -Technology

Last Answer : In a table, when we declare a field as a primary key, then the field’s Required property must be set to Yes because, in a primary key field, we need to enter data always.

What is the purpose of Default Value field property? -Technology

Description : What is the purpose of Default Value field property? -Technology

Last Answer : If there is a situation when you want to enter the same value for all records. Then, to avoid typing the same thing many times, you can set as a Default Value property.

What do you mean by the Entry Required field information? -Technology

Description : What do you mean by the Entry Required field information? -Technology

Last Answer : Entry Required field decides whether entering data in the field is necessary or not. So, if Entry Required is set to Yes, then that field must have some value in it. By default, Entry Required is set to Yes.

Give any one difference between freezing a field and hiding a field. -Technology

Description : Give any one difference between freezing a field and hiding a field. -Technology

Last Answer : When you freeze a field, then no matter how far you scroll down in a datasheet, you will always see the frozen field. But, when you hide a field, then it means that the field is not displayed on the screen.

Write one example of each field, for which you would use 1. Text data type -Technology

Description : Write one example of each field, for which you would use 1. Text data type -Technology

Last Answer : 1. Text data type It allows to store text or combination of text and numbers as well as numbers that don't require calculations such as phone number. This data type allows maximum 255 characters ... Description will be of Memo data type, because the length of description of employee may be large.

Distinguish between Number and AutoNumber data type field. Give example of each. -Technology

Description : Distinguish between Number and AutoNumber data type field. Give example of each. -Technology

Last Answer : Distinguishing between Number and AutoNumber dataNumberAutoNumberIt holds numeric values whichare used for calculations.It allows to store numbers thatare automatically generatedfor each record.The field ... for every newcustomer, this field willautomatically increase and willprovide a new number.

Which field properties are used in Office Access 2007? Give the purpose of each field property. -Technology

Description : Which field properties are used in Office Access 2007? Give the purpose of each field property. -Technology

Last Answer : Field PropertiesAfter you create a field and set its data types, you can also set additional field properties. Setting field properties can give the database extra flexibility and functionality.Some ... control.Text, Memo, Number,Date/Time, Currency,AutoNumber, Yes/No, OLEObject, Hyperlink.

Which of the following is not a part of a table structure in MS_Access? (a) Field Name (b) Field Type -Technology

Description : Which of the following is not a part of a table structure in MS_Access? (a) Field Name (b) Field Type -Technology

Last Answer : (d) From the given options Field Name, Field Type Primary Key are the part of a table.

What data type should you choose for a zipcode field in a table? (a) Text (b) Number -Technology

Description : What data type should you choose for a zipcode field in a table? (a) Text (b) Number -Technology

Last Answer : (b) Number data type should be chosen for a zip code field in a table.

The default data type for a field is (a) Number (b) AutoNumber -Technology

Description : The default data type for a field is (a) Number (b) AutoNumber -Technology

Last Answer : (d) The default data type for a field is Text.

Which property is used to add a label to the field to assist the user? (a) Default value (b) Caption (c) Format -Technology

Description : Which property is used to add a label to the field to assist the user? (a) Default value (b) Caption (c) Format -Technology

Last Answer : (b) Caption is used to add a label to the field for assisting to the user.

Which field property helps in setting data validation in a table? -Technology

Description : Which field property helps in setting data validation in a table? -Technology

Last Answer : (d) Validation Rule property specifies a condition that must be met before the data is accepted into the database.

When you define a field for a table, which of the following parameters do Access always consider optional? -Technology

Description : When you define a field for a table, which of the following parameters do Access always consider optional? -Technology

Last Answer : (d) Description field of the table is optional, as it depends on the databasedesigner that he/she wants to describe a field or not.

The ………….. field property makes data entry compulsory, so that the field cannot be left blank. -Technology

Description : The ………….. field property makes data entry compulsory, so that the field cannot be left blank. -Technology

Last Answer : TheRequired field property makes data entry compulsory so that the field cannot be left blank.

To store object like image, you need to create a field in a table, having field type as …………. . -Technology

Description : To store object like image, you need to create a field in a table, having field type as …………. . -Technology

Last Answer : To store object like image, you need to create a field in a table, having field type as OLE Object.

…………. is a field which is used as a primary key and numbers each record sequentially. -Technology

Description : …………. is a field which is used as a primary key and numbers each record sequentially. -Technology

Last Answer : AutoNumberis a field which is used as a primary key and numbers each record sequentially.

For storing lengthy information in a field ………….. data type is used. -Technology

Description : For storing lengthy information in a field ………….. data type is used. -Technology

Last Answer : For storing lengthy information in a field Memodata type is used.

In a Text type data field, we can enter a maximum of ………….. characters. -Technology

Description : In a Text type data field, we can enter a maximum of ………….. characters. -Technology

Last Answer : In a Text type data field, we can enter a maximum of 255characters.

What do you understand by merge field while performing Mail Merge? -Technology

Description : What do you understand by merge field while performing Mail Merge? -Technology

Last Answer : Merge field is a placeholder that you insert in the main document, e.g. insert the merge field insert a city name, such as “Paris” that is stored in the city data field.

What is the name of the column heading for each category in a data source? (a) Data field (b) Field (c) Field name (d) Record -Technology

Description : What is the name of the column heading for each category in a data source? (a) Data field (b) Field (c) Field name (d) Record -Technology

Last Answer : (c) Field name is the name of the column heading for each category in a data source.

Which field has been benefitted using the Information and Communication Technology Tools? (a) Education (b) Health -Technology

Description : Which field has been benefitted using the Information and Communication Technology Tools? (a) Education (b) Health -Technology

Last Answer : (d) Information and Communication Technology tools are benefitted in various fields such as Education, Governance and Health etc.

Write java statement to make the Net Fee text field named txtNetFee un_editable at run time. -Technology

Description : Write java statement to make the Net Fee text field named txtNetFee un_editable at run time. -Technology

Last Answer : txtNetFee.setEditable(false);

Explain the two types of memory management techniques, which are used for allocating memory. -Technology

Description : Explain the two types of memory management techniques, which are used for allocating memory. -Technology

Last Answer : Memory ManagementIt is the act of managing computer's primary memory or main memory. Main memory is a large array of words or bytes where each ward or byte has its ... your system configuration and requirement. Partitioned allocation divides primary memory of computer into multiple memory.