Week 9 Flashcards
1
Q
What do the arithmetics all perform in sql
A
operations within parentheses
power operations
multiplications and divisions
additions and subtraction
2
Q
What are some number data types?
A
NUMBER, BIGINT, INT, SMALLINT, TINYINT, BIT
•REAL, FLOAT, DECIMAL – differ in precision•MONEY
3
Q
What are character types?
A
CHAR(20)– fixed length
VARCHAR(40)– variable length
4
Q
Like operator contains two special symbols which are:
A
% = any sequence of characters _ = any single character
5
Q
Types of aggregation operations:
A
sum, count, min, max, avg
6
Q
What are aggregation functions
A
aggregate functions perform a calculation on a set of values and return a single value. use Group By and Select
