SQL Flashcards
1
Q
Select
A
the field names that follow the SELECT determine which fields will be returned in the results
2
Q
FROM
A
the table name that follows the keyword FROM specifies the table that will be queried
3
Q
WHERE
A
the WHERE clause (optional) specifies which data values or rows will be returned or displayed
4
Q
character
A
one byte
-numbers, letters, space, punctuation marks, or other symbols
5
Q
field
A
combination of one or more related characters
- field name
- field size
- data type
(column)
6
Q
record
A
group of related fields
table rows
7
Q
primary key
A
field that uniquely identifies each row in a table(each record)
8
Q
table (data file)
A
collection of related records
9
Q
attribute
A
characteristic or quality describing an entity