Week 9

Question 1

What do the arithmetics all perform in sql

Answer 1

operations within parentheses
power operations
multiplications and divisions
additions and subtraction

Question 2

What are some number data types?

Answer 2

NUMBER, BIGINT, INT, SMALLINT, TINYINT, BIT

•REAL, FLOAT, DECIMAL – differ in precision•MONEY

Question 3

What are character types?

Answer 3

CHAR(20)– fixed length

VARCHAR(40)– variable length

Question 4

Like operator contains two special symbols which are:

Answer 4

%  = any sequence of characters
_   = any single character

Question 5

Types of aggregation operations:

Answer 5

sum, count, min, max, avg

Question 6

What are aggregation functions

Answer 6

aggregate functions perform a calculation on a set of values and return a single value. use Group By and Select