Join: A join is established a connection and creating a relation. Command: sel…
Count: We use count command to compute number of t…
Sum: we use sum command to show the sum of numbers or value…
Average: We use average command to show average…
Min: we use min command to find minimum value from attribu…
Max: we use max command to find maximum value from attribute.…
Update. They are used to updating the record. Command: update sql …
Drop They remove data with structure. Command: drop table sql.
Truncate They remove data without structure. Command : truncate…
DBMS stands for Database Management System . It is the collection of logicall…