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

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

1 Answer

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 area within the record reserved for a specific piece of data.A record refers to a row in the table.A field refers to a column in the table.The record is also known as a tuple.Field is also known as attribute.e.g. if Employee is a table, then entire information of an employee is called a record.e.g. if Employeeis a table, then empId, empName, department, salary arethe fields.
by

Related questions

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.

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.

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.

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

How can you add a record in the table in Datasheet View? -Technology

Description : How can you add a record in the table in Datasheet View? -Technology

Last Answer : Insert a RecordSteps to insert a record in a Datasheet View are as follows:Step 1When you create a table, a new blank record automatically appears in the second row of the table or If you enter ... into the fields.Step 3When you have finished adding records in the datasheet, save it and close it.

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.

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.

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.

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.

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

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.

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.

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.

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.

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.

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

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.

What is the use of <tr> tag in an HTML table? Give a suitable example. -Technology

Description : What is the use of tag in an HTML table? Give a suitable example. -Technology

Last Answer : The tag creates a table row in an HTML table. A table must have atleast one row and also, it can have as many table rows as you want. A table row is divided into table cells. A table must have atleast one table cell per table row.e.g.CheadXtitle> TR Tag

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.

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.

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.

Technology: What is the best way to record a lecture/class?

Description : Technology: What is the best way to record a lecture/class?

Last Answer : Your phone is probably the best tool for the job. But if you don’t have one (or have one of those old flip-phones), you can get a recorder. My wife uses this to record lectures.

A Web page is located using a (a) Universal Record Linking (b) Uniform Resource Locator -Technology

Description : A Web page is located using a (a) Universal Record Linking (b) Uniform Resource Locator -Technology

Last Answer : (b) URL (Uniform Resource Locator) specifies the location of a specific Web page on the Internet.

A computer is a mechanical machine, which is used only for record keeping. -Technology

Description : A computer is a mechanical machine, which is used only for record keeping. -Technology

Last Answer : FalseComputer is an electronic device that has the ability to store, retrieve and process data.

Computer based record keeping system is known as (a) Data Manipulation System -Technology

Description : Computer based record keeping system is known as (a) Data Manipulation System -Technology

Last Answer : (d) DBMS is a collection of programs that enable the user to create and maintain the database. Also, it is a computer-based record keeping system.

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.

Primary key is used to …………….. identify the record. -Technology

Description : Primary key is used to …………….. identify the record. -Technology

Last Answer : Primary key is used to uniquelyidentify the record.

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

Write the relationship between a database and a table. -Technology

Description : Write the relationship between a database and a table. -Technology

Last Answer : A database contains multiple tables whereas, a table cannot exist outside a database.

Name two possible primary keys for an Employee table. -Technology

Description : Name two possible primary keys for an Employee table. -Technology

Last Answer : Possible primary keys for an Employee table are emp code, emp phone number.

What is the difference between ‘Rows’ and ‘Columns’ in a table? -Technology

Description : What is the difference between ‘Rows’ and ‘Columns’ in a table? -Technology

Last Answer : Distinguish between data and information are as follows:DataInformationIt is a raw fact.It is a process form of data.It considers facts symbols, images for reference or analysis.It considers knowledge derived from study, experience or instruction.e.g. 23 is data.e.g age = 23 is information

A table named School (containing data of students of the whole school) is created -Technology

Description : A table named School (containing data of students of the whole school) is created -Technology

Last Answer : AdmissionNo should be set as the primary key because admission numbers are unique for each and every student of the school, which is not possible in the case with RollNo and Name.

Consider the following table: Employee EmpNo EmpName Designation -Technology

Description : Consider the following table: Employee EmpNo EmpName Designation -Technology

Last Answer : 1. EmpNo can be selected as a primary key.2. EmpName is having unique values, but there is no guarantee that if more employees are included then there would not be multiple people with similar names.So, in future, its values may be duplicate. Thus, it cannot be made as a primary key.

Sanchita is working for a nationalized bank and is in the process of creating a table to store the details of customers of the bank. -Technology

Description : Sanchita is working for a nationalized bank and is in the process of creating a table to store the details of customers of the bank. -Technology

Last Answer : Primary key AccountNoCandidate key AccountNo and PAN NumberAlternate key PAN Number

Data is stored in RDBMS in the form of (a) table (b) query -Technology

Description : Data is stored in RDBMS in the form of (a) table (b) query -Technology

Last Answer : (a) Relational Database Management System stores data in the form of relation. As we know, relations are known as table.

Table is also known as ………… . -Technology

Description : Table is also known as ………… . -Technology

Last Answer : Table is also known asrelation.

………….. is the smallest part of a table in which one data item can be kept. -Technology

Description : ………….. is the smallest part of a table in which one data item can be kept. -Technology

Last Answer : Fieldis the smallest part of a table in which one data item can be kept.

A foreign key is a reference of the ………….. key in another table. -Technology

Description : A foreign key is a reference of the ………….. key in another table. -Technology

Last Answer : A foreign key is a reference of the primary keyin another table.

A relationship cannot be created with the help of a table. -Technology

Description : A relationship cannot be created with the help of a table. -Technology

Last Answer : False A relationship is a connection between two tables of data.

A database can have only one table. -Technology

Description : A database can have only one table. -Technology

Last Answer : False No, database does not have a limit on the number of tables. It depends on the disk space.

A table can have multiple primary keys. -Technology

Description : A table can have multiple primary keys. -Technology

Last Answer : False If we create multiple primary keys in a table, the primary key will be unable to find the unique key value.