SQL quiz

What does SQL stand for?

• a) Structured Question Language

• b) Strong Question Language

• c) Structured Query Language

• d) Structured Query Layout

Which SQL statement is used to extract data from a database?

• a) OPEN

• b) SELECT

• c) EXTRACT

• d) GET

Which SQL statement is used to update data in a database?

• a) SAVE

• b) MODIFY

• c) UPDATE

• d) SAVE AS

Which SQL statement is used to delete data from a database?

• a) REMOVE

• b) COLLAPSE

• c) DELETE

• d) DROP

Which SQL statement is used to insert new data in a database?

• a) INSERT NEW

• b) ADD RECORD

• c) INSERT INTO

• d) ADD NEW

With SQL, how do you select all the columns from a table named "Persons"?

• a) SELECT Persons

• b) SELECT [all] FROM Persons

• c) SELECT * FROM Persons

• d) SELECT *.Persons

Which operator is used to select values within a range?

• a) RANGE

• b) WITHIN

• c) BETWEEN

• D) None

Which operator is used to search for a specified pattern in a column?

• a) FROM

• b) LIKE

• c) GET

• d) Such as

Which SQL statement is used to create a table in a database?

• a) CREATE TABLE

• b) CREATE DATABASE TAB

• c) CREATE DB

• d) CREATE DATABASE TABLE

Which of the following is NOT an example of Data Manipulation Language?

• SELECT

• INSERT

• UPDATE

• CREATE