Scribd
Upload
26 views1 page

SQL Mod: Views and Transactions Assignment

Uploaded by

Divya
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
26 views1 page

SQL Mod: Views and Transactions Assignment

Uploaded by

Divya
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

Module-6 Assignment

Problem Statement:
You have successfully cleared your 5th semester. In the final semester you will work with views,
transactions and exception handling

Tasks to be done:

1. Create a view named ‘customer_san_jose’ which comprises of only those customers who are
from san jose
2. Inside a transaction, update the first name of the customer to Francis, where the last name is
Jordan
a. Rollback the transaction
b. Set the first name of customer to Alex, where the last name is Jordan
3. Inside a try catch block, divide 100 with 0, print the default error message

You might also like