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;
SQL
SQL Quiz
Start Quiz

or Read more about SQL Quiz

Follow CodeGalaxy

Mobile Beta

Get it on Google Play
Send Feedback