ch 4 Flashcards
1
Q
What kind of data model is most commonly used today in ERPs and why?
A
Relational data models
2
Q
What is a DBMS?
A
Database management System: rates modification and queries; manages database storage and retrieval of information
3
Q
What does SELECT do in a SQL
A
- Begin query
- Tells the query which column should be included
4
Q
What does the WHERE clause do in a SQL SELECT
A
The clause states the criteria that MUST be met to be shown in the results
5
Q
How are aggregation and GROUP BY used in a SQL SELECT statement?
A
Used with aggregate on the results based on one or more columns
6
Q
Order by
A
- Used to sort
1. * ASC ascending
1. * DESC descending
7
Q
Between
A
Can be used to specify the endpoints of a range
8
Q
From
A
- Added to the SELECT statement
- Indicates the name of tables from which to retrieve data
