When I tried to answer the QOD, the question had been changed for two part query and the answer "none of the above" was there .
Because I know almost nothing about index, I was trying the answers on one of my data, but I only had to tried the first one (CREATE CLUSTERED INDEX ) because the server gave me an error and told me what was the good way to do it: "Cannot create nonunique clustered index on view 'allo' because only unique clustered indexes are allowed. Consider creating unique clustered index instead."
So, I got the wright answer, but what is special is that I learned more than just the purpose of that question. I always create my views with the manager. So, I learned today how easy it is to create a view with a query . And it is not all: because I always thought that the word "go" in a query window is not really a command for SQL, I never use it. So I was surprised to see an error message while creating the view: "'CREATE VIEW' must be the first statement in a query batch."
Finaly I found the problem: I had "use myDataBase;" at the beginning of the query, and for the first time since I write queries, I had to put a "Go" after it and before the query!
Learned a lot today! Thank you very much!
Would that be too much if I ask what would be the query to see the name of indexes on a view? I am asking that because I tried the wizard "Full-text index\Define full text index" on my view (the view is called "allo") and it gave me the error "A unique column must be defined on this table/view.", but if I tried again the command CREATE UNIQUE CLUSTERED INDEX etc. , it gives the error "The operation failed because an index or statistics with name 'idx_blabla' already exists on view 'allo'" and that proves that there is an index...
A unique clustered index is not a unique column?