DML

SQL is

• Structured Query Language

• Simple Query Language

• Structured Question Language

• Structure Quality Language

DML

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

• Remove

• Cancel

• Delete

• Eradicate

Which statement is used to extract data from a database?

• Extract

• Get

• Open

• Select

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

• Add To

• Update To

• Add Into

• Insert Into

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')

It is a DML command that is used to display record.

• DISPLAY

• STRUCTURE

• WHERE

• SELECT

______________ constraint prevents NULL values

• UNIQUE

• NOT NULL

• NULL

• FOREIGN KEY

A primary key can be NULL in the table? TRUE or FALSE

• TRUE

• FALSE