COMPUTER SCIENCE AND ENGINEERING
SQL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
table name and a database
|
|
|
command and an argument
|
|
|
goal and a purpose
|
|
|
name and a data type
|
Detailed explanation-1: -Expert-Verified Answer The datasheet view of a table is used to enter the field names, their data types, properties and descriptions.
Detailed explanation-2: -Field names in the same table must be unique; for instance, you can’t have two columns with the name ObjectID. Field names must also start with a letter and cannot contain spaces or reserved words.
Detailed explanation-3: -Every table in Access is made up of fields. The properties of a field describe the characteristics and behavior of data added to that field. A field’s data type is the most important property because it determines what kind of data the field can store.
Detailed explanation-4: -A row, or record, is also known as a tuple. The columns in a table is a field and is also referred to as an attribute. You can also think of it this way: an attribute is used to define the record and a record contains a set of attributes.