BCA 5th Sem DBMS ASSIGNMENT QUESTIONS

IMPORTANT QUESTIONS FROM 5th UNIT

* Explain ORDER BY, GROUP BY and HAVING clause with example.

* Explain different DBMS languages such as DDL(create,alter,drop),                    
   DML(insert,update,delete),DRL(select), DCL(commit,rollback),TCS(grant,revoke) 
   commands with example.

* Explain datatypes in SQL.

* Explain SQL constraints with example.

* Explain aggregate functions in SQL.

* Define transaction. Explain transaction processing system and its ACID properties.

* Explain views in SQL.

Important note : Digital copies are also accepted. Create word or pdf copy of the assignment and mail at assignbca@gmail.com with subject of mail as "Name-Regno-DBMS" (This decision taken based on unavailability of assignment books)
OR
Write and submit the assignment before 10/10/2018.
Content may be web based.