A data element which is used to distinguish between different records is called ______________.
A data element which is used to distinguish between different records is called Test data
Database testing is a very important aspect of software testing. A database testing is necessary to ensure that the values that an application is retrieving or storing into the database are accurate or not. In order to test a database it is necessary that the tester should have sound knowledge of SQL.
Fields, Records and Files. You can think of a traditional database as an electronic filing system, organized by fields, records, and files. A field is a single piece of information; a record is one complete set of fields; and a file is a collection of records. For example, a telephone book is analogous to a file.
As a guideline, a database field refers to the columns, or data categories, that are used by all entries/rows. ... A database record is, basically, a row that contains unique data in each of the fields. A database will usually contain a large number of records but only a small number of fields.