ISC S2 Flashcards
1
Q
What is a reasonableness test?
A
Offset transaction amount exceeds original amount.
2
Q
What is a size test?
A
Comparison with a predetermined threshold.
3
Q
What is a check digit test?
A
Valid format for number entered
4
Q
What is a field check
A
Compares attributed entered to field requirements and format restrictions.
5
Q
What does the SQL command SELECT mean?
A
1st clause - attributes to view
6
Q
What does the SQL command FROM mean?
A
Attribute location of SELECT request
7
Q
What does the SQL command WHERE mean?
A
Filter results
8
Q
What does the SQL command GROUP BY mean?
A
Subtotals
9
Q
What does the SQL command HAVING mean?
A
Filter aggregated data
10
Q
What does the SQL command JOIN, ON?
A
Retrieve data from multiple tables
(2nd table & relation)
