(Solved) : Please Select Best Possible Answer Possible Explain Thank Question 3 1 Point Query Get Nu Q31281633 . . . .

Please select the best possible answer and if possible explainwhy? Thank you.

Question 3 (1 point) A query to get the number of indexes aswell as the index names of each table in a specified database couldbe:

a SELECT DISTINCT t.* FROM INFORMATION_SCHEMA.STATISTICS s LEFTOUTER JOIN INFORMATION_SCHEMA.TABLE_CONSTRAINTS t ON t.TABLE_SCHEMA= s.TABLE_SCHEMA AND t.TABLE_NAME = s.TABLE_NAME AND s.INDEX_NAME =t.CONSTRAINT_NAME WHERE 0 = 0 AND t.CONSTRAINT_NAME IS NULL ANDs.TABLE_SCHEMA = ‘YOUR_SCHEMA_SAMPLE’;

b SELECT DISTINCT s.* FROM INFORMATION_SCHEMA.STATISTICS s LEFTOUTER JOIN INFORMATION_SCHEMA.TABLE_CONSTRAINTS t ON t.TABLE_SCHEMA= s.TABLE_SCHEMA AND t.TABLE_NAME = s.TABLE_NAME AND s.INDEX_NAME =t.CONSTRAINT_NAME WHERE 0 = 0 AND t.CONSTRAINT_NAME IS NULL ANDs.TABLE_SCHEMA = ‘YOUR_SCHEMA_SAMPLE’;

c SELECT DISTINCT