New DBMS Practical List (2011-12) for CSE Vth sem

Write SQL syntax and statement for the following(Two example for each)
1) Create
2) Insert
3) Select
4) Alter
5) Update
6) Delete
7) Drop
8) Order By clause
9) Aggregate Functions
10) Group By and Having Clause
11) Inner Join
12) Outer join and its type
13) Natural Join
14) Cartesian Product
15) View
16) Rollback
17) Commit
18)Grant
19) Revoke
20) Distinct
21)Trigger
22) Cursor

Submission Date-  22-11-2010