Consider the following student table

Choose the correct SQL query to create a
composite index on age and sex

Question

Consider the following student table

Choose the correct SQL query to create a
composite index on age and sex

Answer

CREATE composite INDEX age_gender ON Student ( Sex, Age);

Answer

CREATE INDEX age_gender ON TABLE Student ( Age, Sex);

Answer

CREATE INDEX age_gender ON Student (Sex, Age);

Answer

CREATE INDEXES age_gender ON Student (Sex, Age);

Crowdly