DBMS Home Assignment

 

DBMS Home Assignment

Q1.

What are Aggregate Functions in MySQL? Explain any five aggregate functions (avg, count, min, max, sum) with proper syntax and suitable examples.

Q2.

Explain the following String Functions in MySQL with syntax and suitable examples:
concat, instr, mid, length, strcmp, trim, ltrim, rtrim

Q3.

Describe various Mathematical Functions in MySQL. Explain the use of abs, ceil, floor, mod, pow, sqrt with appropriate examples.

Q4.

Write short notes on Date and Time Functions in MySQL. Explain the functions adddate, datediff, day, month, year, hour, minute, second with proper examples.