Chapter 7 Flashcards
Intro to SQL
1
Q
tansaction
A
A logical unit of work composed of one or more SQL statements
2
Q
Three basic types of Data
A
- Character
- numeric
- date
3
Q
Character data
A
is composed of nay printable characters such as alphabetic values, digits, punctuation and special characters
4
Q
Numeric data
A
is composed of digits, such that the data has a specific numeric value
5
Q
Date data
A
is composed of date and occasionally time values
6
Q
a query
A
a SQL statement that must be executed
7
Q
set-oriented
A
SQL operators are set-oriented because they operate over entire sets of rows and columns at once
