Q: What is Transaction and how could we manage, Explain the ACID properties of Transaction with Suitable Examples, Implement Transaction Management Commands like COMMIT, ROLLBACK, LOCK, Explain the...

Q: What is Transaction and how could we manage, Explain the ACID properties of Transaction with Suitable Examples, Implement Transaction Management Commands like COMMIT, ROLLBACK, LOCK, Explain the procedure with commands and examples with output screen shots of SQL Scripts/Queries.