SQL quiz. Which of the following queries are correct? Select

Which of the following queries are correct? Select all that apply.

```
ALTER TABLE CITIES
ADD COLUMN REGION;
```


ALTER TABLE NEIGHBORHOOD
ADD PRIMARY KEY (ID_CITY, NEIGHBORHOOD);


CREATE TABLE STREETS(
    ID_STREET INTEGER(5), 
    NM_STREET CHAR (50), 
    ID_CITY INTEGER(5), 
    ID_NEIGHBORHOOD INTEGER(5), 
    OBS CHAR (50)
);


CREATE INDEX ON STREETS (ID_NEIGHBORHOOD);

```
ALTER TABLE STREETS
DROP COLUMN OBS;
```

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;

Like

Login in to like
Comment

Login in to comment
Share

Tweet

SQL
Quiz

or Read more about SQL Quizzes

Follow CodeGalaxy

Mobile Beta

Send Feedback