John has created the following table in SQL Server:

CREATE TABLE Trainee (
TraineeId INT CONSTRAINT pk_TraineeId PRIMARY KEY, 
Name VARCHAR(20) NOT NULL ) 

He now wants to create a clustered index on the column Name.

 

Jack says, it is currently not possible as there is already a clustered index in the table.

Jill says, it is possible, only if the clustered index is created after the Primary Key Constraint is dropped.

 

Which of the following statements is true?

To get all Infosys Certified MS SQL Server Developer Exam questions Join Telegram Group https://bit.ly/infy_premium_group