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

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

1 Answer

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

Related questions

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

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

For what, Memo data type is used? (a) To add table (b) To store objects created in other programs -Technology

Description : For what, Memo data type is used? (a) To add table (b) To store objects created in other programs -Technology

Last Answer : (c) As we know, Memo provides character upto 65536 so, it is used for long text entries.

Memo data type allows you to store character type values in a table. -Technology

Description : Memo data type allows you to store character type values in a table. -Technology

Last Answer : True Memo data type allows upto 65536 characters.

Memo data type allows you to store only 255 characters in the table. -Technology

Description : Memo data type allows you to store only 255 characters in the table. -Technology

Last Answer : False Memo data type is used when character size is more than 255.

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.

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.

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.

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.

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.

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.

Can a voice memo be used as a ringtone on the iPhone 3GS?

Description : Can a voice memo be used as a ringtone on the iPhone 3GS?

Last Answer : answer:Take the recording and put it into itunes, then, right click and click Create AAC version. Then, drag the new file onto the desktop. Rename it from .m4a to .m4r , and you have a ... straight forward., although I am a major techy. I don't get why itunes doesn't have this feature.

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

Memo ”Why is data type used ?

Description : Memo ”Why is data type used ?

Last Answer : Data type ( Memo) is used for descriptive writing or description . 65536 characters (letters , numbers , symbols , dates, etc.) can be written for this field . Usually the do type memo of that field is used for writing comments.

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

A Text data type cannot allow number entry. -Technology

Description : A Text data type cannot allow number entry. -Technology

Last Answer : False As, it can include both text as well as numbers.

Encrypted data is referred as cipher text. -Technology

Description : Encrypted data is referred as cipher text. -Technology

Last Answer : TrueEncrypted data is presented in coded form. So, it is known as cipher text.

Interactive combination of text, graphics, images, audio, video etc., is known as (a) Data (b) Information (c) Multimedia (d) Internet -Technology

Description : Interactive combination of text, graphics, images, audio, video etc., is known as (a) Data (b) Information (c) Multimedia (d) Internet -Technology

Last Answer : (c) Multimedia is a interactive combination of text, animations, sounds, images etc.

In Excel chart, text displayed at data points to indicate the specific category is called …………….. -Technology

Description : In Excel chart, text displayed at data points to indicate the specific category is called …………….. -Technology

Last Answer : (c) Text displayed at data points to indicate the specific category is called data label.

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.

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.

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.

Plain text (txt) E_mail messages can be read by any type of E_mail application. -Technology

Description : Plain text (txt) E_mail messages can be read by any type of E_mail application. -Technology

Last Answer : True Plain text E-mail contains plain text without any formatting options such as bold, italic, colored fonts etc., so these can be read by any type of E-mail application.

To display the text in italics, ………. tag is used and to display in type writer font, ……… tag is used. -Technology

Description : To display the text in italics, ………. tag is used and to display in type writer font, ……… tag is used. -Technology

Last Answer : To display the text in italics,tag is used and to display in typewriterfont, tag is used.

Automatic formatting that the user wants? (a) Replace text As You Type (b) AutoFormat As You Type -Technology

Description : Automatic formatting that the user wants? (a) Replace text As You Type (b) AutoFormat As You Type -Technology

Last Answer : (b) For turning Automatic formatting On or Off, AutoFormat As You Type tab under Proofing is used.

AutoFormat settings are applied in a document (a) as we type text (b) after we finish typing (c) Both (a) and (b) (d) None of the above -Technology

Description : AutoFormat settings are applied in a document (a) as we type text (b) after we finish typing (c) Both (a) and (b) (d) None of the above -Technology

Last Answer : (c) AutoFormat settings are applied in a document as we type text or after we finish typing.

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.

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.

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.

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.

What will happen if I attempt to swap chips in two identical voice memo recorders?

Description : What will happen if I attempt to swap chips in two identical voice memo recorders?

Last Answer : 90% sure that swapping the chips would be effective. Chips are solid state and your thoughts are stored digitally. When your voice recorder went into the wash, it died because the electronics (battery to chip ... in the new device, you will be successful. It would be a great experiment. Let us know.

Thoughts on the Nunes memo?

Description : Thoughts on the Nunes memo?

Last Answer : I will reserve judgment until the material omissions of fact are also disclosed. I agree with Senator John McCain, that release of the memo is meant to deflect attention from the FBI’s discovery of the extent of Russian interference in the US political process.

Can I listen to a voice memo on my ipad that was sent from an iphone?

Description : Can I listen to a voice memo on my ipad that was sent from an iphone?

Last Answer : It should have played as long as it was sent in an email….. There are apps for converting audio files, so if he still hasn’t been able to figure out how to play it at this point, I’d just try converting before you send it.

IPhone 3GS voice memo deletion?

Description : IPhone 3GS voice memo deletion?

Last Answer : Do you have mobileme? It might be pushing the memo right back to your phone.

Looking at my phone i found a memo , does the date and time mean anything to you ?

Description : Looking at my phone i found a memo , does the date and time mean anything to you ?

Last Answer : Boy, can’t help you here but I feel for you. I’m always writing notes to myself using all kinds of little shorthand, and then later down the road I have no idea what the notes mean, and I wrote them!

How do you write Simple memo notification on public holiday?

Description : How do you write Simple memo notification on public holiday?

Last Answer : What is the answer ?

How can I make my own memo board?

Description : How can I make my own memo board?

Last Answer : You can get sheets of cork at craft stores. You can attach it directly to your wall, if you're allowed to. Or you can put magnets on the back and attach it to a fridge or other metal item.

) One of the initial project documents, issued by senior management, which outlines the authority of the project manager, is called Project charter. As a seller, what other document can be used in this place: 1. Work breakdown structure 2. Project scope 3. Contract 4. Internal memo

Description : ) One of the initial project documents, issued by senior management, which outlines the  authority of the project manager, is called Project charter. As a seller, what other document can  be used in this place: 1. Work breakdown structure  2. Project scope  3. Contract  4. Internal memo

Last Answer : 3. Contract

When will issue memo of Admission of Payment ? a) Warrant of payment is lost before its submission b) The amount of withdrawal more than 50000/- c) Both the A and B d) None of these

Description : When will issue memo of Admission of Payment ? a) Warrant of payment is lost before its submission b) The amount of withdrawal more than 50000/- c) Both the A and B d) None of these

Last Answer : a) Warrant of payment is lost before its submission

An account bag from the SO to HO contain a) The SO daily A/c, MO issue journal, MO paid list. b) List of SB transactions/List of SB documents c) Memo of IPO, Certificate, issued and discharged d) A rolls, daily list of PLI premia collected and paid e) All the above

Description : An account bag from the SO to HO contain a) The SO daily A/c, MO issue journal, MO paid list. b) List of SB transactions/List of SB documents c) Memo of IPO, Certificate, issued and discharged d) A rolls, daily list of PLI premia collected and paid e) All the above

Last Answer : e) All the above

Memo admission of payment in form MO 10(a) is prepared a) When a MO loss after payment b) When a MO loss before payment c) Either A or B d) Neither A nor B

Description : Memo admission of payment in form MO 10(a) is prepared a) When a MO loss after payment b) When a MO loss before payment c) Either A or B d) Neither A nor B

Last Answer : a) When a MO loss after payment

Memo of admission of payment is obtained a) When duplicate money order are issued b) When a money order is lost before payment c) When a money order is lost after payment d) When money order was paid to a person other than the payee

Description : Memo of admission of payment is obtained a) When duplicate money order are issued b) When a money order is lost before payment c) When a money order is lost after payment d) When money order was paid to a person other than the payee

Last Answer : c) When a money order is lost after payment

If a MO is lost after payment a) Duplicate MO will be prepared by office of issue b) Duplicate mo will be prepared by office of payment c) Certificate of payment will be prepared by office of payment d) Memo of admission of payment will be prepared by office of issue and on receipt, the office of payment will get the signature of the payee in the memo and forward it to the Audit Office.

Description : If a MO is lost after payment a) Duplicate MO will be prepared by office of issue b) Duplicate mo will be prepared by office of payment c) Certificate of payment will be prepared by office of payment ... of payment will get the signature of the payee in the memo and forward it to the Audit Office.

Last Answer : d) Memo of admission of payment will be prepared by office of issue and on receipt, the office of payment will get the signature of the payee in the memo and forward it to the Audit Office.

Each Inspector will be supplied with a similar memo. showing the authorized balances etc. for a) All the sub and branch offices in his sub-division b) All sub offices c) All branch offices d) None of these

Description : Each Inspector will be supplied with a similar memo. showing the authorized balances etc. for a) All the sub and branch offices in his sub-division b) All sub offices c) All branch offices d) None of these

Last Answer : a) All the sub and branch offices in his sub-division