Which of the following queries are correct? Select all that apply.
Explanation
Following queries are incorrect:
ALTER TABLE CITIES
ADD COLUMN REGION;
misses a column datattype and should be rewritten as follows:
ALTER TABLE CITIES
ADD REGION column_datatype;

CREATE INDEX ON STREETS (ID_NEIGHBORHOOD);
should be rewritten as
CREATE INDEX ID_NEIGHBORHOOD ON STREETS;

Follow CodeGalaxy

Mobile Beta

Get it on Google Play
Send Feedback
Keep exploring
SQL quizzes
Cosmo
Sign Up Now
or Subscribe for future quizzes