Question: Client_Data Table 3.7 Add the following data to the Client_Data table. Use the Client_Data_ID_Seq sequence to populate the member_id column. (5 marks) 3.8. Make a


Client_Data Table 3.7 Add the following data to the Client_Data table. Use the Client_Data_ID_Seq sequence to populate the member_id column. (5 marks) 3.8. Make a modification to the Client_Data table by adding the column "Next of kin". (4 marks) 3.9 Drop the Next_Of_Kin column from the Client_Data table. (4 marks) 3.10 Create a private synonym that enables you to reference Client_Data_ID_Seq object as CLIENTDET. (4 marks) 3.11 Create a B-tree index on the client's Last_name column. Verify that the index exists by querying the data dictionary. Remove the index from data dictionary
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
