Question: In a database, there is the following table with its index? Index Ahmed Saadeq Shams Zahraa ID 1 2 3 4 5 6 Name
In a database, there is the following table with its index? Index Ahmed Saadeq Shams Zahraa ID 1 2 3 4 5 6 Name Address Ahmed Baghdad Ahmed Basrah Saadeq Mousel Shams Basrah Shams Baghdad Zahraa Baghdad Age 24 23 30 12 30 26 How the index will change after executing each the following step by step: 1. Delete from table where age = 30 2. Insert into table values (7, 'Shams', 'Najaf", 31) 3. Update table set ID = 10 where ID = 2 4. Update table name = 'Hudaa' where ID = 1 5. Insert into table values (10, 'Bilal', 'Samara', 24) ocess
Step by Step Solution
3.49 Rating (149 Votes )
There are 3 Steps involved in it
import copy Define the initial table and index table ID 1 2 3 4 5 6 Name Ahmed Ahmed Saadeq Shams Shams Zahraa Address Baghdad Basrah Mousel Basrah Ba... View full answer
Get step-by-step solutions from verified subject matter experts
