a) Consider the following table structure that exists in an certain COLLEGE database: STUDENT (Stu_ld, Stu_Name, City, Contact_No, Specialization_Id)

Write the SQL commands for the following Crente index i) Create an index on the Stu_Name column

i) Drop the index created in Question 1.a.i.

iii) Create a composite index on two columns; Stu_Name and City

iv) Display the indexes created on the STUDENT table

b) Briefly discuss five advantages of distributed databases compared with centralized databases.

c) Write an SQL command to create a database link between a database and a remote database in a distributed database environment. Briefly elaborate the components of the SQL command.