SQL QUIZ

SQL is a

• Structured Query Language

• Simple Query Language

• Structured Question Language

• Structure Quality Language

Which statement is used to extract data from a database?

• Extract

• Open

• Get

• Select

Which statement allows us to add a record to a table?

• Add To

• Insert Into

• Add Into

• Update To

Which word is missing from the following SQL statement?

Select * table_name

• With

• Where

• From

• And

Which SQL statement would add a record to the database?

• INSERT INTO Designer VALUES ('SMI01', 'M Smith', '[e-mail]', '01224123456')

• INSERT VALUES ('SMI01', 'M Smith', '[e-mail]', 01224123456') INTO Designer

• INSERT ('SMI01', 'M Smith', '[e-mail]', '01224123456') INTO Designer

• INSERT Designer INTO VALUES (''SMI01', 'M Smith', '[e-mail]', '01224123456')

SQL query to find all the cities whose humidity is 95 from Weather table.

• SELECT city WHERE humidity = 95

• SELECT city FROM weather WHERE humidity = 95

• SELECT humidity = 95 FROM weather

• SELECT city FROM weather

SQL query to display city names from weather table where temperature is not equal to 30.

select city

from Weather

where temperature______ 30

• !=

• not equal to

• not=

• ! equal to

Logical operator to be used to display city names from weather table where temperature is greater than 30 and humidity is less than 50.

• OR

• TOGETHER

• AND

• BOTH

The command to remove all rows from a table ‘Weather’ is __________________

• DROP FROM WEATHER

• DELETE FROM WEATHER

• DROP ALL FROM WEATHER

• DELETE ALL FROM WEATHER

SQL command to delete a table from a database.

• DELETE TABLE WEATHER

• DROP TABLE WEATHER

• DELETE WEATHER

• DROP WEATHER