Cognizant Interview Question

Full SQL queries - grant and transaction also