COMPUTER SCIENCE AND ENGINEERING
SQL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Uniquely identifies any record in a table
|
|
|
It is always a number
|
|
|
Used to store all of the data about each specific item
|
|
|
Used to store a category (e.g. Names / Gender / Mobile Num)
|
Detailed explanation-1: -Fields are the components that provide structure for a table. You can’t have a table without fields. For instance, you can create an empty table that has fields defined but no rows (records). In databases, fields are used to maintain relationships between tables.
Detailed explanation-2: -Think of a field’s data type as a set of qualities that applies to all the values that are contained in the field. For example, values that are stored in a Text field can contain only letters, numbers, and a limited set of punctuation characters, and a Text field can only contain a maximum of 255 characters.
Detailed explanation-3: -The datasheet view of a table is used to enter the field names, their data types, properties and descriptions.
Detailed explanation-4: -Simple examples of data fields include weight, color, date, sales, averages, member ID, promotional code, status, file type, keyword, and rainfall. Any piece of information that can be used to describe an object, event, or idea can be a data field.