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

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

1 Answer

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 length of this datatype is 1,2, 4, 8 or 16 bytes.The field length of this datatype is 4 bytes.It does not support fieldproperty New values.It supports the field propertyNew values.e.g. in a table Employee, Salaryis a Number type field.e.g. in a table Bank, theAccountNo is a AutoNumberfield as, for every newcustomer, this field willautomatically increase and willprovide a new number.
by

Related questions

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.

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.

When is AutoNumber data type preferred over Number data type? -Technology

Description : When is AutoNumber data type preferred over Number data type? -Technology

Last Answer : When you want to increment the number automatically as you add or delete the records. AutoNumber data type is preferred. Also, if the table does not have a primary key, then AutoNumber uniquely identifies the record.

Define the AutoNumber data type in MS_ Access. -Technology

Description : Define the AutoNumber data type 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.

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.

Distinguish between <BASEFONT> tag and <FONT> tag with the help of an example of each. -Technology

Description : Distinguish between tag and tag with the help of an example of each. -Technology

Last Answer : tag is used to specify the default setting of the text. It takes the same attributes as tag. The only difference is that the tag affects all the text that follows until a new tag affect that is encountered. tag affects the text that comes upto its closing tag.e.g.

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 <P> tag and <BR> tag with the help of an example. -Technology

Description : Distinguish between tag and tag with the help of an example. -Technology

Last Answer : Distinguishing between tag and tag are as follows: tag tagIt is a container element.It is an empty element.It is used to define a paragraph ofthe text on the Web page.It is used to insert line break.It ... no attribute.e.g. This ts a paragraph.e.g.This is a 1 line break into the Web document.

Distinguish between <sup> and <sub> tags with example. -Technology

Description : Distinguish between and tags with example. -Technology

Last Answer : Distinguishes between and tags are as follows: Tag TagThe tag is known assuperscript tag.The tag is known assubscript tag.It is used to definesuperscripted text.It is used to define subscripted text.Tags that are ... to display(a+ b)2is(a+ b) 2e.g. HTML command to displaylog2+log x islog 2+logx

Distinguish between Text and Memo data types. -Technology

Description : Distinguish between Text and Memo data types. -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 store upto 255 characters only.It can store upto 65536 ... the number of characters.It does not use field size property.e.g. Emp_namee.g. Emp_description

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

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.

Distinguish between FTP and Telnet. -Technology

Description : Distinguish between FTP and Telnet. -Technology

Last Answer : FTP (File Transfer Protocol) facilitates the transfer of files from one point to another while Telnet is a connection protocol that allows a user to connect to a remote server.

Distinguish between compiler and interpreters. -Technology

Description : Distinguish between compiler and interpreters. -Technology

Last Answer : CompilerInterpreter1. Compiler takes entire program as input.1. Interpreter takes single instruction as input.2. Conditional control statements execute faster.2. Conditional control statements execute slower.3 ... .6. Intermediate object code is generated.6. No intermediate object code is generated.

Distinguish between container and empty tags. -Technology

Description : Distinguish between container and empty tags. -Technology

Last Answer : Container elements HTML container elements require a starting as well as an ending tags.e-g , , .They affect the text appearing between their starting and ending tags.Empty elements HTML empty elements require just a ... and not an ending tag.e.g. , , .They just carry out the job assigned to them.

How will you distinguish hypermedia from hypertext? -Technology

Description : How will you distinguish hypermedia from hypertext? -Technology

Last Answer : Hypertext includes only plain text and links while hypermedia is a logical extension of hypertext, which includes graphics, audio, video, alongwith plain text and links.

Write the purpose of HTML. Distinguish between <p>tag and <BR>tag. -Technology

Description : Write the purpose of HTML. Distinguish between tag and tag. -Technology

Last Answer : HTML is used to represent page, data on website with proper manner and attractive look to get maximum users.Difference between tag and tagtag is a block level element, and is mainly used to add content, whereas the tag is used to force a line break within the element.

Distinguish between ComboBox and ListBox. When would you prefer using them over Radiobutton and Checkbox? -Technology

Description : Distinguish between ComboBox and ListBox. When would you prefer using them over Radiobutton and Checkbox? -Technology

Last Answer : Differences between ComboBox and ListBox are as follows :ComboBox ListBoxIt occupies less space but show only one value for visbility.It occupies more space but shows more than one value.Multiple select ... you need to select only one option then you would prefer using ComboBox over Radio Button.

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.

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.

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.

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.

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.

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.

Write one example of data for which Memo data type is used. -Technology

Description : Write one example of data for which Memo data type is used. -Technology

Last Answer : To store resume of an employee in Employee table is an example of Memo data type.

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.

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.

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.

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.

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.

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.

Distinguish between acquired and inherited traits by giving one example of each. Why are traits acquired during the lifetime of an individual not inherited? -Biology

Description : Distinguish between acquired and inherited traits by giving one example of each. Why are traits acquired during the lifetime of an individual not inherited? -Biology

Last Answer : Acquired trait is a particular characteristic that is developed during the lifetime of an individual. Such characteristics are not genetically controlled and cannot be passed on to the next ... , the acquired traits cannot be inherited over generations during the lifetime of an individual.

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.

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

…………. 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.

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.”

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.

How are fields, record and a table related to each other? Explain with the help of an example. -Technology

Description : How are fields, record and a table related to each other? Explain with the help of an example. -Technology

Last Answer : Fields are one type of information. A record contains logically related fields. A table Emp name contains logically related records.Emp NoNameSalary1.Shridhar200002.Raghav40000Here EmpNo, Name, and Salary are three different fields. 1, Shridhar, 20000 represents one complete record.

Write one example each of URL and IP address. -Technology

Description : Write one example each of URL and IP address. -Technology

Last Answer : Example of URL → http: // www. microsoft. com Example of IP address → 192.168.0.0

Differentiate between Web sites and Web pages with suitable example of each. -Technology

Description : Differentiate between Web sites and Web pages with suitable example of each. -Technology

Last Answer : Thedifference between awebsiteand aweb pageis that awebsiteis a collection ofwebpages with information on a subject, and aweb pageis a smaller part of a largerwebsiteusually containing more specific information. If awebsitewere a book, then awebpagewould be a chapter in that book.

Differentiate between Websites and Webpages with suitable example of each. -Technology

Description : Differentiate between Websites and Webpages with suitable example of each. -Technology

Last Answer : Using the same book analogy, while awebpageis apagefrom a book, awebsiteis the book itself. It is a collection of thepagesthat share a common thread. Similarly, all thewebpagesof yourwebsitecome together to form yourwebsite.

Distinguish between agro based and mineral based industries. Also give two examples of each. -SST 10th

Description : Distinguish between agro based and mineral based industries. Also give two examples of each. -SST 10th

Last Answer : This is self explanatory. Agro based industries depend upon Agricultural products while mineral based industries depends upon mineral resources. Cotton and jute are the example of agro based industry while Iron and steel, alluminium are mineral based.

What is a search engine? Give example of any one search engine. -Technology

Description : What is a search engine? Give example of any one search engine. -Technology

Last Answer : A search engine is a Website that lets you search the Internet for Websites on specific topics. Search engines turn the Web into a powerful tool for finding information on any topic. There are ... A search engine provides a wealth of information for professional and personal use. e.g. Google

What is search engine? What is its usage? Give example. -Technology

Description : What is search engine? What is its usage? Give example. -Technology

Last Answer : A search engine is a Website that lets you search the Internet for Websites on specific topics. Search engines turn the Web into a powerful tool for finding information on any topic. There are ... The search engine provides a wealth of information for professional and personal use. e.g. Google

What are HLLs? Give example of some HLLs. -Technology

Description : What are HLLs? Give example of some HLLs. -Technology

Last Answer : It is an advanced computer programming language that is not limited to one computer, designed for a specific job and is easier to understand. The main advantage of high level languages over low level languages is ... are easier to read, write and understand, e.g. BASIC, C, FORTRAN, Java and Pascal.

What is database? Give example. -Technology

Description : What is database? Give example. -Technology

Last Answer : A collection of related information organized as tables is known as the database, e.g. INGRES, MySQL etc.

What is primary key? Give an example. -Technology

Description : What is primary key? Give an example. -Technology

Last Answer : A field which uniquely identifies each record in a table is known as the primary key. e.g. emp id is the primary key of the Employee table.

What is a primary key in database? Give an example. -Technology

Description : What is a primary key in database? Give an example. -Technology

Last Answer : A field which uniquely identifies each record in a table is known as the primary key. e.g. emp id is the primary key of the Employee table.