Tag: databases

WHERE

SEARCH

FROM

WHILE

Determines if a value matches any of the values in a list or a sub-query.

Defines the tables we are selecting or deleting data from.

Is used with the DISTINCT SQL keyword only.

Is used to select data from a view

a special type of table

a special type of store procedure, executed when certain event occurs

a special type of view

an event

LEFT

LEN

AVG

JOIN

DML

MDL

DDL

All the above

True

False

Delete

Truncate

Remove

Drop

Alter table Tbl_Test Insert column New_Column varchar 20

Alter table Tbl_Test Alter column New_Column varchar 20

Alter table Tbl_Test add New_Column varchar 20

Either a or b could be used

True

False

Truncate

Create

Alter

All the above