SQL

Front

SQL is

Back

Structured Query Language

Front

DDL means

Back

Data Definition Language, data definition language

Front

DML

Back

Data Manipulation Language, data manipulation language

Front

To remove a record from a table which SQL statement would you use?

Back

Delete

Front

In order to modify data in a database we would use which SQL statement?

Back

Update

Front

Which statement is used to extract data from a database? Options: Extract, Get, Open, Select

Back

Select

Front

Which statement allows us to add a record to a table? Options: Add To, Update To, Add Into, Insert Into

Back

Insert Into

Front

Less than or equal to?

Back

<=

Front

Which word is missing from the following SQL statement? Select * table_name

Back

From

Front

Which SQL statement would add a record to the database? Options: 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')

Back

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