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: -A record is a collection of fields, possibly of different data types, typically in a fixed number and sequence. The fields of a record may also be called members, particularly in object-oriented programming; fields may also be called elements, though this risks confusion with the elements of a collection.
Detailed explanation-2: -A record in a database is an object that can contain one or more values. Groups of records are then saved in a table; the table defines the data that each record may contain. In a given database, there are multiple tables, each containing multiple records.
Detailed explanation-3: -Often, a record collects related information that is treated as a unit, such as one item in a database or personnel data about one member of a department. The term field refers to a specific portion of a record used for a particular category of data, such as an employee’s name or department.
Detailed explanation-4: -Primary key A table can have only one primary key. A primary key consists of one or more fields that uniquely identify each record that you store in the table.
Detailed explanation-5: -A table is used to store data records or entities along with their attributes in form of rows and columns.