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

1 Answer

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 to store.e.g. if Employee is a table and Emp_No, Name and Description are fields, then name will be a Text field. Because, name is a character entry field.2. Memo data type It allows long blocks of text that uses text formatting, e.g. in the Employee table, the field Description will be of Memo data type, because the length of description of employee may be large.

Related questions

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

Last Answer : Numbers are accepted as a text value.

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.

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.

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.

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.

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.

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.

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

Last Answer : txtNetFee.setEditable(false);

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

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

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.

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.

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

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

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.

Description : The avg() function in MySql is an example of ..... (a) Math function (b) Text function (c) Date Function (d) Aggregate Function -Technology

Last Answer : (d)Aggregate Function

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.

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

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.

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.

Description : Write the HTML code to set the bgcolor as pink, heading level 2, text -Technology

Last Answer :

Description : Write the HTML code to create a paragraph whose text color is blue. -Technology

Last Answer : or

Description : Write the steps to make the text bold. -Technology

Last Answer : Steps to make a text bold are as follows:(a) Step 1: Select the text.(b) Step 2: Click the Bold button in the Font group on the Home tab.

Description : Write the shortcut keys to format the text style bold, italic and underline. -Technology

Last Answer : Bold – Ctrl+B, Italic – Ctrl+I, Underline – Ctrl+U

Description : Write the advantages of using Unicode to represent text. -Technology

Last Answer : Unicode encoding standard provides the basis for processing, storage and interchange of text data in any language in all modern software and information technology protocols.

Description : Write the CSS code to: (i) Apply 50px indentation to all text paragraphs marked with . -Technology

Last Answer : P{text-indent: 50px;font-style: italic;}

Description : Write the advantages of using Unicode to represent text. -Technology

Last Answer : Advantages of using Unicode to represent text are as follows :1. Allows for multilingual text using any or all the languages that you desire.2. Text in any language can be exchanged worldwide

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

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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

Last Answer : Required property.

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.

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.

Description : Write the data type of variables that should be used to store : 1. Marks of students 2. Grades of students (Grade can be ‘A or ‘B’ or ‘C’) -Technology

Last Answer : (i) int data type(ii) char data type

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.

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.

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.

Description : Write an simple HTML code to show an example of internal linking. -Technology

Last Answer : Internal LinkingIt is top of the page Top

Description : Write the DTD for the following XML document: -Technology

Last Answer : ]>

Description : Why we cannot use a text editor as a picture editing tool? -Technology

Last Answer : Text editor is a editing program which does not support the editing of graphical images because it works only on text.

Description : Which tag do we use to change the size and style (face) of the text of an HTML file viewed on a Web browser? -Technology

Last Answer : tag is used to change the size and style (face) of the text of an HTML file displayed on a Web browser. Two attributes of tag are as follows:size: It specifies the size of the text inside a tag.Syntaxface: It specifies the font name of the text inside a tag.Syntax

Description : Ram wants to create a text file to store name and roll number of his students. Suggest, which program he should use. -Technology

Last Answer : He can create a text file using Notepad or WordPad. Follow these steps to create a file using Notepad:(a) Step 1:Click Start.(b) Step 2:Choose All Programs -> Accessories -> Notepad.(c) Step 3: ... dialog box will appear.(g) Step 7:Give file name with extension.(h) Step 8: Click Save button.