Question: Data Manipulation Language (DML) and Transactions Management: For any operation, if it doesn't work, then: 1. write the command, 2. the error, and (not

Data Manipulation Language (DML) and Transactions Management: For any operation, if it doesn't work, then: 1. 

Data Manipulation Language (DML) and Transactions Management: For any operation, if it doesn't work, then: 1. write the command, 2. the error, and (not mandatory) 3. mention the reasons. 1. Insert the following rows to the bank table. (4 marks) Bank_id Street 1 12 13 11 122 Name Bank1 Bank1 Bank3 Bank4 Bank4 33 44 55 St1 St2 St3 St1 City City1 City2 City1 City2 2. Insert the following rows to the Account table. (4.5 marks) id Name Balance Creation_date Bank_id 1 11 1-2-1990 Account1 10 Account2 20 11 2-6-1998 Account3 10 3-5-1988 3 Account4 20 2-11-1992 2 Account5 -10 3 Account6 20 1-1-1970 PostCode 13 11 22 33 44 55 MobileNumber 0791234567 0787654321 0781234567 3. Save the changes to the database. (0.5 mark) 4. Double the balance of the accounts whose mobileNumber is not null. (1 mark) 5. Change the balance of Account1 to be the same as Account2. (1 mark) 6. Create a save point call it A. (0.5 mark) 7. Disable the primary key constraint of the account table, the a_pk constraint. (1 mark) 8. Change the name of street 'St1' to 'street1'. (1 mark) 9. Change the PostCode of City 1 to be 666. (1 mark) 10. Rollback to the created save point in question 6 (Please list the command even if it doesn't work). If you can't do that, then explain why. (1.5 marks) 11. Delete the rows of the bank table using the truncate statement (Please list the command even if it doesn't work). If you can't do that, then explain why. (1.5 marks)

Step by Step Solution

3.49 Rating (146 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!