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

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

1 Answer

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

Related questions

What is the default extension of a MS_Access database? -Technology

Description : What is the default extension of a MS_Access database? -Technology

Last Answer : The default extension of an MS-Access database is .accdb.

Give five names of database templates used in MS_Access 2007. -Technology

Description : Give five names of database templates used in MS_Access 2007. -Technology

Last Answer : Assets, Contacts, Events, Faculty and Issues.

How will you create a blank database in MS_Access 2007? -Technology

Description : How will you create a blank database in MS_Access 2007? -Technology

Last Answer : Creating a Blank DatabaseTo create a new blank database, you need to perform the steps which are as follows:Step 1 Start Microsoft Access 2007, then Getting Started with Microsoft Office Access page will ... in the first empty cell in the Add New Field column as shown in the following figure:

In a MS_Access database, which component is not present? (a) Formula Bar (b) Tables -Technology

Description : In a MS_Access database, which component is not present? (a) Formula Bar (b) Tables -Technology

Last Answer : (a) MS-Access contains various components, i.e. Tables, Queries, Forms, Reports, Macros and Modules.

When you open a database, the Ribbon appears on the left side of the MS_Access 2007 window. -Technology

Description : When you open a database, the Ribbon appears on the left side of the MS_Access 2007 window. -Technology

Last Answer : False Because ribbon appears on the top of the window.

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.

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

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.

Group of attributes/field in a database is known as a: a) Data Entry b) Record c) File d) None of These

Description : Group of attributes/field in a database is known as a: a) Data Entry b) Record c) File d) None of These

Last Answer : b) Record

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.

Give the names of five data types used in MS_Access. -Technology

Description : Give the names of five data types used in MS_Access. -Technology

Last Answer : Text, Memo, Date/Time, Yes/No and Currency.

What are the views in which fields can be deleted in MS_Access? -Technology

Description : What are the views in which fields can be deleted in MS_Access? -Technology

Last Answer : Datasheet View and Design View.

Explain MS_Access Ribbon. -Technology

Description : Explain MS_Access Ribbon. -Technology

Last Answer : The Ribbon contains a series of command tabs. In MS-Access 2007, the main command tabs are as follows: Home Create External Data Database Tools DatasheetCommand TabCommon Things You ... columns of the table.Set the data type and formatting.Create table relationships and object dependencies.

Define primary key. How do you set it in MS_Access? -Technology

Description : Define primary key. How do you set it in MS_Access? -Technology

Last Answer : Primary key is the key which is used to uniquely identify the records into the table. To set the primary key you have to follow the steps given below:Step 1 Select the field that you want ... 2 Click Primary Key button from the Design tab.orRight click on the selected field and select Primary Key.

The different objects supported by MS_Access are tables, queries, ………… and reports. -Technology

Description : The different objects supported by MS_Access are tables, queries, ………… and reports. -Technology

Last Answer : The different objects supported by MS-Access are tables, queries, forms, and reports.

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.

RDBMS provides relational operators to manipulate the data. Here, RDBMS refers to (a) Record Database Management System -Technology

Description : RDBMS provides relational operators to manipulate the data. Here, RDBMS refers to (a) Record Database Management System -Technology

Last Answer : (b) RDBMS stands for Relational Database Management System, which provides the operator to manipulate the data stored in the database table.

In a school, a database named “school” is created in mysql whose password is “cbse”. Smith is trying to add a new record of a student having details -Technology

Description : In a school, a database named “school” is created in mysql whose password is “cbse”. Smith is trying to add a new record of a student having details -Technology

Last Answer : import mysql.connectormydb = mysql.connector.connect{host='localhost',user='root',passwd='cbse',database='school'}mycursor = mydb.cursor()mycursor.execute('INSERT INTO student values(3,'Michelle', 'Agartala');')mydb.commit()

The value for alt attribute is a text string of upto ………….. characters. -Technology

Description : The value for alt attribute is a text string of upto ………….. characters. -Technology

Last Answer : The value for alt attribute is a text string of upto1024characters.

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.

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.

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.

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.

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.

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.

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.

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.

…………. 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 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 of the following is the largest unit? A) data B) field C) record D) database file

Description : Which of the following is the largest unit? A) data B) field C) record D) database file

Last Answer : Answer : D

Set of related records in a database is known as a: a) File b) Field c) Record Group d) None of These

Description : Set of related records in a database is known as a: a) File b) Field c) Record Group d) None of These

Last Answer : a) File

The ascending order of a data hierarchy is: a) Bit - Bytes - Field - Record - File - Database b) Bit - Bytes - Record - Field - File - Database c) Bytes - Bit - Record - Field - File - Database d) None of The Above

Description : The ascending order of a data hierarchy is: a) Bit - Bytes - Field - Record - File - Database b) Bit - Bytes - Record - Field - File - Database c) Bytes - Bit - Record - Field - File - Database d) None of The Above

Last Answer : a) Bit - Bytes - Field - Record - File - Database

Which of the following places the common data elements in order from smallest to largest? a) Character, file, record, field, database b) Character, record, field, file, database c) Character, field, record, file, database d) Bit, byte, character, record, field, file, database

Description : Which of the following places the common data elements in order from smallest to largest? a) Character, file, record, field, database b) Character, record, field, file, database c) Character, field, record, file, database d) Bit, byte, character, record, field, file, database

Last Answer : d) Bit, byte, character, record, field, file, database

Which of the following places the common data elements in order from smallest to largest? 1) Character, file, record, field, database 2) Character, record, field, file, database 3) Character, field, record, file, database 4) Bit, byte, character, record, field, file, database

Description : Which of the following places the common data elements in order from smallest to largest? 1) Character, file, record, field, database 2) Character, record, field, file, database 3) Character, field, record, file, database 4) Bit, byte, character, record, field, file, database

Last Answer : 3) Character, field, record, file, database

The ascending order or a data Hierarchy is a. bit - bytes - fields - record - file - database b. bit - bytes - record - field - file - database c. bytes - bit- field - record - file - database d. bytes -bit - record - field - file - database

Description : The ascending order or a data Hierarchy is a. bit - bytes - fields - record - file - database b. bit - bytes - record - field - file - database c. bytes - bit- field - record - file - database d. bytes -bit - record - field - file - database

Last Answer : a. bit - bytes - fields - record - file - database

Which of the following is in the ascending order of Data hierarchy? (1) Byte–Bit–File–Record–Database–Field (2) Field–Byte–Bit–Record–File– Database (3) Bit–Byte–Record–Field–Database–File (4) Bit–Byte–Field–Record–File– Database

Description : Which of the following is in the ascending order of Data hierarchy? (1) Byte–Bit–File–Record–Database–Field (2) Field–Byte–Bit–Record–File– Database (3) Bit–Byte–Record–Field–Database–File (4) Bit–Byte–Field–Record–File– Database

Last Answer : Bit–Byte–Field–Record–File– Database

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

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

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

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.

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 term that is used in spreadsheet which forces a line break in a cell when the cell entry is too large to fit in the cell. -Technology

Description : A term that is used in spreadsheet which forces a line break in a cell when the cell entry is too large to fit in the cell. -Technology

Last Answer : (a) A term that is used in spreadsheet which forces a line break in a cell when the cell entry is too large to fit in the cellWrap.

A cell entry can be edited either in the cell or in the formula bar. -Technology

Description : A cell entry can be edited either in the cell or in the formula bar. -Technology

Last Answer : True There are two ways to edit the data which has entered in the cell, i.e. in the cell or in the formula bar.

A solid metallic block weighing 5 kg has an initial temperature of 500°C. 40 kg of water initially at 25°C is contained in a perfectly insulated tank. The metallic block is brought into contact with water. Both of them come to equilibrium. Specific heat of block material is 0.4 kJ.kg-1. K-1. Ignoring the effect of expansion and contraction and also the heat capacity to tank, the total entropy change in kJ.kg-1, K-1is (A) -1.87 (B) 0 (C) 1.26 (D) 3.91

Description : A solid metallic block weighing 5 kg has an initial temperature of 500°C. 40 kg of water initially at 25°C is contained in a perfectly insulated tank. The metallic block is brought into contact with water. Both of them come to equilibrium. ... .kg-1, K-1is (A) -1.87 (B) 0 (C) 1.26 (D) 3.91

Last Answer : (B) 0

For the irreversible reaction, Ca+ 2C = Ca C2, Δ H°298 = - 60000 J . mole-1. If a system initially containing 2 moles of calcium, 3 moles of carbon and 1 mole of calcium carbide is allowed to react to completion, the heat evolved at 298 K will be (A) 30,000 J (B) 60,000 J (C) 90,000 J (D) 2,40,000 J

Description : For the irreversible reaction, Ca+ 2C = Ca C2, Δ H°298 = - 60000 J . mole-1. If a system initially containing 2 moles of calcium, 3 moles of carbon and 1 mole of calcium carbide is allowed to react to completion, the heat evolved ... will be (A) 30,000 J (B) 60,000 J (C) 90,000 J (D) 2,40,000 J

Last Answer : (C) 90,000 J

A vessel contains milk and water in the ratio of 4:3. If 14 litres of the mixture is drawn and filled with water, the ratio changes to 3:4. How much milk was there in the vessel initially? a) 24 b) 32 c) 40 d) 48 e) None of these

Description : A vessel contains milk and water in the ratio of 4:3. If 14 litres of the mixture is drawn and filled with water, the ratio changes to 3:4. How much milk was there in the vessel initially? a) 24 b) 32 c) 40 d) 48 e) None of these

Last Answer : Answer: B milk = 4x and water = 3x milk = 4x – 14*4/7 and water = 3x – 14*3/7 + 14 4x – 8: 3x + 8 = 3:4 X = 8, so milk = 8*4 = 32 litres